J-0200000-05-06-07-08-09 MAXIMO INFORMATION.XLSX

XLSX spreadsheet 116 KB Posted Dec 5, 2023

Attached to: Base Operations Support (BOS) Services at Naval Support Facility (NSF) Redzikowo, Poland
Solicitation number: N6247023R0010
Issued by: Department of the Navy Naval Facilities Engineering Command

About this file

Written by GovTribe AI · Dec 21, 2023

This document package includes templates and guidance for submitting work order, asset, and meter reading data to the Maximo CMMS system under the Base Operations Support (BOS) Services contract at Naval Support Facility Redzikowo, Poland.

The templates provide field definitions for work order, asset, asset specification, and characteristic meter reading records. The work order template includes over 40 fields covering details like location, asset, labor hours, and outage information. The asset template includes over 30 fields with asset details, inventory data, and specification information. The meter reading template outlines site, asset, meter, reading value and date fields. Additional documents provide sample record formats and valid code lists for fields.

The templates appear to be for ongoing data exchange between the BOS contractor and Navy to input maintenance management records into the Maximo CMMS system under the identified Poland facilities support contract. Proper use of the templates and code lists is required for record submission and updating under the contract.

View the file

Other files

File	Type	Posted
N6247023R0010 Poland BOS Amend 0007.pdf	PDF	Feb 13, 2024
J-10 DD254 Form (Fillable PDF) Solicitation N6247023R0010.pdf	PDF	Feb 13, 2024
N6247023R0010 Poland BOS Amend 0006.pdf	PDF	Feb 9, 2024
J-0200000-13 Exhibit Line Item Numbers (ELINs) (Amendment 0005).xlsx	XLSX spreadsheet	Feb 8, 2024
N6247023R0010 Poland BOS Amend 0005.pdf	PDF	Feb 8, 2024
J-1502000 Facilities Investment (Amendment 0004).pdf	PDF	Feb 1, 2024
J-1402000 Unaccompanied Housing (Amendment 0004).pdf	PDF	Feb 1, 2024
J-1700000 Transportation (Amendment 0004).pdf	PDF	Feb 1, 2024
J-0200000-04 Government Furnished Property Materials Services (Amendment 0004).xlsx	XLSX spreadsheet	Feb 1, 2024
J-1601000 Utility Management (Amendment 00004).pdf	PDF	Feb 1, 2024
N6247023R0010 Poland BOS Amend 0004.pdf	PDF	Feb 1, 2024
Attachment F - Section F Deliverables (Excel) (Amendment 0004).xlsx	XLSX spreadsheet	Feb 1, 2024
J-0403000 Emergency Management (Amendment 0004).pdf	PDF	Feb 1, 2024
J-1502001-03 AA MCSS Facility Investment Equipment and Systems Inventory (Amendment 0004).xlsx	XLSX spreadsheet	Feb 1, 2024
J-1501000-08 FRCS Inventory (Amendment 0004).xlsx	XLSX spreadsheet	Feb 1, 2024
J-1503010 Custodial (Amendment 0004).pdf	PDF	Feb 1, 2024
J-0200000-13 Exhibit Line Item Numbers (ELINs) (Amendment 0004).xlsx	XLSX spreadsheet	Feb 1, 2024
J-0200000 Management and Administration (Amendment 0004).pdf	PDF	Feb 1, 2024
J-1002000 Supply Services (Amendment 0004).pdf	PDF	Feb 1, 2024
J-1800000 Environmental (Amendment 0004).pdf	PDF	Feb 1, 2024
J-1503010-06 Custodial Inventory (Amendment 0004).xlsx	XLSX spreadsheet	Feb 1, 2024
J-3 Section B Supplies or Services and Prices (Amendment 0003).pdf	PDF	Jan 23, 2024
J-9 Pre-Proposal Conference NSF Redzikowo BOSC - Final.pptx	PPTX presentation	Jan 23, 2024
N6247023R0010 Poland BOS Amend 0003.pdf	PDF	Jan 23, 2024
J-8 Pre-Proposal Site Visit Sign-In Sheet.pdf	PDF	Jan 23, 2024
J-0200000-13 Exhibit Line Item Numbers (ELINs) Amendment 0003.xlsx	XLSX spreadsheet	Jan 23, 2024
Attachment J-6 SECNAV 5512_1-2021_ (Amend 0002).pdf	PDF	Dec 19, 2023
N6247023R0010 Poland BOS Amend 0002.pdf	PDF	Dec 19, 2023
N6247023R0010 Poland BOS Amend 0001.pdf	PDF	Dec 18, 2023
Attachment J-7 NSFR Poland Base Escort Request.xlsx	XLSX spreadsheet	Dec 18, 2023
Attachment J-6 SECNAV 5512_1-2021_.pdf	PDF	Dec 18, 2023
Attachment J-5 Polish Main Gate - Site Location.pdf	PDF	Dec 18, 2023
J-1601000-09 Utility Assets Requiring Condition Assessment.xlsx	XLSX spreadsheet	Dec 5, 2023
J-1601000-10 FRCS Inventory.xlsx	XLSX spreadsheet	Dec 5, 2023
J-1501000-04 BPMS Process Document.pdf	PDF	Dec 5, 2023
J-1700000 Transportation.pdf	PDF	Dec 5, 2023
J-1002000 Supply Services.pdf	PDF	Dec 5, 2023
J-0402000-05 Fire Extinguisher Inventory and Locations.xlsx	XLSX spreadsheet	Dec 5, 2023
J-1601000-03 Utility Map Attributes.xlsx	XLSX spreadsheet	Dec 5, 2023
J-4 Pre-Award Inquiry Form.xlsx	XLSX spreadsheet	Dec 5, 2023
J-0300000 Command Administration Support.pdf	PDF	Dec 5, 2023
J-1606001 Water.pdf	PDF	Dec 5, 2023
J-0401000 Force Protection.pdf	PDF	Dec 5, 2023
J-1300000 Galley.pdf	PDF	Dec 5, 2023
J-1200000-04 Artificial Turf Maintenance Guide.pdf	PDF	Dec 5, 2023
J-0402000-06 Patient Care Report.pdf	PDF	Dec 5, 2023
Attachment F - Section F Deliverables.pdf	PDF	Dec 5, 2023
J-0403000 Emergency Management.pdf	PDF	Dec 5, 2023
J-1402000 Unaccompanied Housing.pdf	PDF	Dec 5, 2023
J-1503050 Grounds Maintenance and Landscaping.pdf	PDF	Dec 5, 2023

Show 40 more

Latest 50 of 78 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1-Service Provider Info

ATTACHMENT J-0200000-05

SERVICE PROVIDER INFORMATION

Interface: Service Provider
VERSION #:	VQU1
Current as of:

Version History

VQU1 - Updated to reflect current interface in MAXIMO

TABS
1-Service Provider Info	This Sheet
2-Service Provider Field List	Service Provider Template Data Format Information
3-Service Provider - Template	Sample Excel Format

2-Service Provider Field List

ATTACHMENT J-0200000-05

SERVICE PROVIDER INFORMATION - FIELD LIST

	Interface: Service Provider
	VERSION #: VQU1
	Current as of:
	Service Provider (BOSC1) is a pipe delimited file.
	Position	Name	Required	Length
Limit	Data Format Note	Field Definition	Content Notes

USMCMAX_FIELD

1	Approved Date	Y	10	MM/DD/YYYY hh:mm:ss	The Date on which the Work Order was last approved. If the file contains an Approved Date, then this date will be pulled over to the record.
	APPROVEDDATE
2	Work Type	Y	15

Must match Value List in Maximo.

(Cross-walked field). Must match Crosswalk	Identifies the work order's type.
Example types are: preventive maintenance, corrective maintenance, emergency maintenance, capital project, and event report.	Value list in Maximo	WORKTYPE
	3	Customer Reference Number	Y	10		Contractors internal work order tracking number. Will update Record if Value is found in Maximo otherwise new record (Work order) will be created.		SERVPRVREFCODE
	4	Description	Y	150		Describes the work order.
		DESCRIPTION
	5	Location	Y	30	Must match Value List in Maximo	Identifies the work order's location. This is not necessarily the asset's location, however, if an asset is entered, its location will default here.
- If the Location is null, in the inbound file, then this field is defaulted to the site's base location.	Value list in REFERENCE SPREADSHEET	LOCATION
	6	Reported By	Y	62	Must match Value List in Maximo	Identifies the person reporting the work order.	Value list in REFERENCE SPREADSHEET	REPORTEDBY
	7	Master System	N	N/A	Not used			N/A
	8	Status	Y	16	(Cross-walked field.)
Must match Crosswalk	Status of the work order, for example, in progress, waiting on material, waiting for approval, completed, or closed.	Value list in REFERENCE SPREADSHEET	STATUS
	9	Status Date	Y	10	MM/DD/YYYY hh:mm:ss			STATUSDATE
	10	Priority	Y	12	(Cross-walked field.)
Must match Crosswalk	Identifies the importance of the work order, from 0-999, where 0 is the lowest priority and 999 is the highest. If the Priority is null, in the inbound file, then this field is defaulted.	Value list in REFERENCE SPREADSHEET	WOPRIORITY
	11	Actual Start	N	10	MM/DD/YYYY hh:mm:ss			ACTSTART
	12	Actual Finish	N	10	MM/DD/YYYY hh:mm:ss			ACTFINISH
	13	Supervisor	Y	30	Must match Value List in Maximo		Value list in Maximo	SUPERVISOR
	14	Labor Hours(Actual)	Y	8	Number (2 decimal places)			ACTLABHRS

15 Labor Cost(Actual) Y 10 Number (2 decimal places) ACTLABCOST

16 Material Cost(Actual) Y 10 Number (2 decimal places) ACTMATCOST

17	Duration	N	8	Number (2 decimal places)	Estimated remaining number of hours needed to complete the work.		ESTDUR
18	Asset	Y	25	Must match an existing ASSETNUM in Maximo	The asset number used must exist in USMCMAX prior to submission, or the record will be rejected.	Value list in REFERENCE SPREADSHEET

	ASSETNUM
	19	Target Finish	N	10	MM/DD/YYYY hh:mm:ss			TARGCOMPDATE
	20	Target Start	N	10	MM/DD/YYYY hh:mm:ss			TARGSTARTDATE
	21	Reported Date	Y	10	MM/DD/YYYY hh:mm:ss			REPORTDATE
	22	Lead	Y	30	Must match Value List in Maximo	Lead person responsible for the work.	Value list in Maximo	LEAD
	23	Scheduled Start	N	10	MM/DD/YYYY hh:mm:ss			SCHEDSTART
	24	Scheduled Finish	N	10	MM/DD/YYYY hh:mm:ss			SCHEDFINISH
	25	Modified Date	Y	10	LEAVE BLANK	Leave blank/Do Not Use	Leave blank/Do Not Use	CHANGEDATE
	26	Modified By	Y	30	LEAVE BLANK	Leave blank/Do Not Use	Leave blank/Do Not Use	CHANGEBY
	27	PMNEXTDUEDATE	N	4	MM/DD/YYYY hh:mm:ss			PMNEXTDUEDATE
	28	Is Task?	Y	1		Yes or No		ISTASK
	29	Parent WO	N	10	Length Limit: 250	Must exist in USMCMAX prior to submission or the record will be rejected.	Must exist in MAXIMO prior to submission or the record will be rejected.	PARENT
	30	Work Order	Y	10	Must match Value List in Maximo	Used in updating record status on existing records.		WONUM
	31	Detail Location	N	250				DETAILLOC
	32	CLIN	N	30		Contract Line Item Number		CLIN
	33	Customer Ref Code	N	8	Must match Value List in Maximo		Value list in REFERENCE SPREADSHEET	CUSTOMERCODE
	34	Sub Work Type	N	15	(Cross-walked field).
Must match Crosswalk	Defaulted field based on the value of worktype		SUBWORKTYPE
	35	Work Center	Y	8	Must match Value List in Maximo		Value list in Maximo	PERSONGROUP

3-Service Provider-Template

	ATTACHMENT J-0200000-05
SERVICE PROVIDER INFORMATION - TEMPLATE		ATTACHMENT J-0200000-07

SERVICE PROVIDER INFORMATION - TEMPLATE

Interface: Service Provider

VERSION #: VQU1

Current as of:

Position

Name

Approved Date

Work Type

Customer Reference Number

Description

Location

Reported By

Master System

Status

Status Date

Priority

Actual Start

Actual Finish

Supervisor

Labor Hours

(Actual)

Labor Cost

(Actual)

Material Cost

(Actual)

Duration

Asset

Target Finish

Target Start

Reported Date

Lead

Scheduled Start

Scheduled Finish

Modified Date

Modified By

PMNEXTDUEDATE

Is Task?

Parent WO

Work Order

Detail Location

CLIN

Customer Ref Code

Sub Work Type

Work Center

Required Field(s)

NOTES:

• ONLY COLUMNs 1-35, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 35 PIPEs per row.)

1-Asset File Info

ATTACHMENT J-0200000-06

ASSET INFORMATION

Interface: Asset File
VERSION #:	V2
Current as of:	26 April 2017

Version History

V1 - Updated to reflect current interface in MAXIMO

V2 - Added 3 additional fields (OPT): Asset Comment, PM Program & PM Plan

TABS
1-Asset File Info	This Sheet
2-Asset File Field List	Asset Template Data Format Information
3-Asset File - Template	Sample Excel Format

2-Asset File Field List

ATTACHMENT J-0200000-06

ASSET FILE FIELD LIST

Interface: Asset File

VERSION #:V2

Current as of: 26 April 2017

	Position	Name	Required	Length
Limit	Data Format Note	Content Notes
	MAXIMO Field Name
	1	AssetNum	Y	25			ASSETNUM
	2	Changed Date	N		MM/DD/YYYY		CHANGEDATE
	3	Description	Y	100			DESCRIPTION
	4	Long Description	N	1,000			LONGDESCRIPTION
	5	Master System	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…	MASTERSYSTEM
	6	System	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…	SYSTEM
	7	Sub-System	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…	SUBSYSTEM
	8	Location	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	LOCATION
	9	Site ID	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET -or-
For this contract only: XXXXX	SITEID
	10	Work Center (Person Group)	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET -or-

For this contract:

- use the following identifier "XXXX"	PERSONGROUP
	11	Asset Type	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	ASSETTYPE
	12	Asset Quantity	N		Integer		QUANTITY
	13	Inventory Category	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	INVENTORYCATEGORY
	14	Purchase Price	N		Integer		PURCHASEPRICE
	15	Budgeted Cost	N		Integer		BUDGETCOST
	16	Replacement Cost	Y		Integer		REPLACECOST
	17	Meter Group	N		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	GROUPNAME
	18	Belongs To (Parent)	N		Must match an existing ASSETNUM in Maximo.	Asset Number of Parent. The asset and its parent can't be created in the same file	PARENT
	19	Contract Number	N	25			Appended to LONGDESCRIPTION
	20	Task/Delivery Order Number	N	25			Appended to LONGDESCRIPTION
	21	Drawing Reference ID	N	25			Appended to LONGDESCRIPTION
	22	Warranty Expiration Date	N		MM/DD/YYYY		Appended to LONGDESCRIPTION
	23	Status Date	N		LEAVE BLANK	Leave blank/Do Not Use	STATUSDATE
	24	Installation Date	Y		MM/DD/YYYY		INSTALLDATE
	25	Asset Status	N		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET -or-
"Operating" for NEW and "Decommissioned or DEA" for removed equipment	STATUS
	26	CLASSSTRUCTUREID	N		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	CLASSSTRUCTUREID
	27	Job Plan Code	N	25			Appended to LONGDESCRIPTION
	28	Equipment Tag Number	N	25			Appended to LONGDESCRIPTION
	29	Additional Loc Info	N	250			ADDLOCINFO
	30	Manufacturer	N		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	MANUFACTURER
	31	Model Number	N	25			MODEL
	32	Serial Number	N	25			SERIALNUM
	33	Asset Comment	N	100			ASSETCOMMENT
	34	Standard Eval Results
(PM Plan)	N	15	Values Depend on Asset Type (i.e. UTILITIES, FACILITIES)	Not required, but will default to N/A or NTE if left blank. Valid values determined by Asset Type (Position 11)	STANDARDEVAL
	35	PM Standard Applies
(PM Program)	N	15	Values Depend on Asset Type (i.e. UTILITIES, FACILITIES)	Not required, but will default to N/A or NTE if left blank. Valid values determined by Asset Type (Position 11)	PMSTANDARD
	N/A

3-Asset File Template

	ATTACHMENT J-0200000-06
ASSET FILE TEMPLATE		ATTACHMENT J-0200000-XX

ASSET INFORMATION

Interface: Asset File

VERSION #: V2

Current as of: 26 April 2017

Position

Name

AssetNum

Changed Date

Description

Long Description

Master System

System

Sub-System

Location

Site ID

Work Center (Person Group)

Asset Type

Asset Quantity

Inventory Category

Purchase Price

Budgeted Cost

Replacement Cost

Meter Group

Belongs To (Parent)

Contract Number

Task/Delivery Order Number

Drawing Reference ID

Warranty Expiration Date

Status Date

Installation Date

Asset Status

CLASSSTRUCTUREID

Job Plan Code

Equipment Tag Number

Additional Loc Info

Manufacturer

Model

Serial #

Asset Comment

PM Plan

PM Program

Required Field(s)

(on new Asset)

• ONLY COLUMNs 1-35, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column, before the return. Must have 35 PIPEs per row.)

• New assets & asset updates (to different assets) can be completed at the same time. An asset can't be created and updated at the same time.

1-Asset Specification Info

ATTACHMENT J-0200000-07

ASSET SPECIFICATION INFORMATION

Interface: Asset Specification
VERSION #:	v1
Current as of:	17 May 2012

Version History

v1 - Updated to reflect current interface in MAXIMO

TABS
1-Asset Specification Info	This Sheet
2-Asset Specification Field List	Asset Specification Template Data Format Information
3-Asset Specification - Template	Sample Excel Format
4-Sample Data (Pipe Delimited)	Sample of file after exporting to a "\|" delimited file.

2-Asset Specification FieldList

ATTACHMENT J-0200000-07

ASSET SPECIFICATION INFORMATION

Interface: Asset Specification

VERSION #: v1

Current as of: 17 May 2012

	Position	Name	Required	Length
Limit	Data Format Note	Field Definition	Content Notes
<<Note to Spec Writer: Only the "Content Notes" field should be modified on this TAB, Delete this text box prior to publising, no other changes to this document should be made.>>	NAVFAC

MAXIMO_FIELD

(ASSETSPEC.)

1	Asset	Y	25	Asset identification number. Must match an existing value in Maximo.		ASSETNUM
2	SITEID	Y	8	FEC ID. Must match existing value list	If all work is done at a single FEC, recommend the correct SITEID be provided in the templay.	ASSETATTRID
3	CLASSSTRUCTUREID	Y	20	Key Value used in Maximo to identify the speciificaiton/attribute record. Value is not shown on the front end (visable to a user). Must match existing value in Maximo (example data a "1616" is an Electric Meter)		CLASSSTRUCTUREID
4	Attribute	Y	300	Attribute Name (example data - the PTRATIO is attribute being set)		ASSETATTRID
5	Numeric Value	N	40	Specification value with numeric value only.- only one value can be pased Numeric or AlphaNumeric; must match domain list if one exists.		NUMVALUE
6	Alphanumeric	N	254	Specitication value with mixed (alpha and numeric) content. Only one value can be pased Numeric or AlphaNumeric; must match domain list if one exists.		ALNVALUE
7	Unit of Measure	N	8	must match domain		MEASUREUNITID
N/A	Changed By			Value is inserted by the System User that is running the interface	Values are not incluled in the template, information provided to explain the source of the the value created by Maximo.	CHANGEBY
N/A	Change Date			System Date	Values are not incluled in the template, information provided to explain the source of the the value created by Maximo.	CHANGEDATE

3-Asset Specification-Template

ATTACHMENT J-0200000-07

ASSET SPECIFICATION INFORMATION

Interface: Asset Specification

VERSION #: v1

Current as of: 17 May 2012

Position	1	2	3	4	5	6	7
Name	Asset	SITEID	CLASSSTRUCTUREID	Attribute	Numeric Value	Alphanumeric	Unit of Measure
Required Field(s)	Y	Y	Y	Y	N	N	N

• ONLY POSITION/COLUMN 1-7, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 7 PIPEs per row.)

• If the column to the right of the last column is selected when saving (what would be the 8th position) this will provide the 7th PIPE

4-Sample Data

ATTACHMENT J-0200000-07

ASSET SPECIFICATION INFORMATION

Sample Data (provide in a TXT file extension)

3-440-EPN-007|11001|1616|UAMETERDEVICEID||A1234||

3-440-EPN-007|11001|1616|AMRINDICATOR||No||

3-440-EPN-007|11001|1616|PTRATIO|36||BA|

1-Characteristic Meter Info

ATTACHMENT J-0200000-08

CHARACTERISTIC METER READING INFORMATION

Interface: Characteristic Meter Reading
VERSION #:	v2
Current as of:	30 Sept 2016

Version History

v1 - Updated to reflect current interface in MAXIMO (December 12, 2012)

v2 - Updated to reflect Utilities (DI) values only range from 1 to 5, not 10 (Sept 30, 2016)

TABS
1-Characteristic Meter Reading Info	This Sheet
2-Characteristic Meter Reading Field List	Characteristic Meter Reading Template Data Format Information
3-Characteristic Meter Reading - Template	Sample Excel Format
4-Observation Values	Valid Observation values as of 9/2016

2-Characteristic Meter Fields

ATTACHMENT J-0200000-08

CHARACTERISTIC METER READING INFORMATION - METER FIELDS

Interface: Characteristic Meter Reading

VERSION #: v2

Current as of: 30 Sept 2016

	Position	Name	Required	Length
Limit	Data Format Note	Field Definition	Content Notes	NAVFAC

MAXIMO_FIELD

(MEASUMENT / ASSETMETER)

See Note Below 1 Site Y 8 UPPER Must match Value List in Maximo Value list in REFERENCE SPREADSHEET

SITEID / SITEID
2	Asset	Y	25	Must match an existing ASSETNUM in Maximo	The asset number used must exist in MAXIMO prior to submission, or the record will be rejected.	Value list in REFERENCE SPREADSHEET

ASSETNUM / ASSETNUM
3	Meter	Y	15	UPPER	The value listed in the third position must be an existing, valid Maximo DCR or UCR meter.	Value list in REFERENCE SPREADSHEET

METER NAME /

METER NAME

	4	Observation	Y	254	ALN	Last Reading/Observation value. Must be a valid value in MAXIMO	Value must match existing value in Maximo list. Current value list included on
Tab 4 - Observation Values	OBSERVATION / LASTREADING
	5	Measurement Date	Y	10	MM/DD/YYYY hh:mm:ss	Date Observation was recorded		MEASUREDATE / LASTREADINGDATE
	6	Inspector	Y	30	Must match Value List in Maximo	Identifies the person reporting the observation	Value list in REFERENCE SPREADSHEET

INSPECTOR / LASTREADINGINSPCTR

NOTE (MAXIMO/FIELD):

The observation information is filed in one of two locations. If the observation is the MOST CURRENT reading (by Measurement Date) - it is filed in the MEASUREMENT Table. If the data when received is not the most current, it is filed in the ASSETMETER Table. The filing location is irrelevant to the inteface use, but this information is provided to prevent confusion when reviewing the data in Maximo.

When reviewing the data in Maximo (after processing) - If the meter reading being imported is newer than the last reading applied to the Assets record, a new meter reading entry will also be added to the Assets record’s Meter tab. If the imported record is older than the last reading, it will only be visible in the (Select Action) “Manager Meter Reading History” dialog box, “Characteristic Meter Readings” tab.

3-Characteristic Meter Template

ATTACHMENT J-0200000-08

CHARACTERISTIC METER READING INFORMATION - TEMPLATE

Interface: Characteristic Meter Reading

VERSION #: v2

Current as of: 30 Sept 2016

Position	1	2	3	4	5	6
Name	Site	Asset	Meter	Observation	Measurement Date	Inspector
Required Field(s)	Y	Y	Y	Y	Y	Y

• ONLY POSITIONs 1-6, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 7 PIPEs per row. Last PIPE indicates end of line (EOL))

4-Observation Values

	ATTACHMENT J-0200000-08
CHARACTERISTIC METER READING INFORMATION - OBSERVATION VALUES		ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

Interface: Characteristic Meter Reading

VERSION #: v2

Current as of: 30 Sept 2016

OBSERVATION VALUES

FACILITIES (DCR):
A	(Amber)
A+	(Amber Plus)
A-	(Amber Minus)
G	(Green)
G+	(Green Plus)
G-	(Green Minus)
R	(Red)
R+	(Red Plus)
R-	(Red Minus)

UTILITIES (UCR):
1	(Best/Highest CI Ranking)
2
3
4
5	(Worst/Lowest CI Ranking)

1-Service Provider Field List

ATTACHMENT J-0200000-09

SERVICE PROVIDER INFORMATION

	Position	Name	Required	Length
Limit	Data Format Note	Field Definition	Content Notes
	NAVFAC

MAXIMO_FIELD

	1	Approved Date	Y	10	MM/DD/YYYY hh:mm:ss	The Date on which the Work Order was last approved. If the file contains an Approved Date, then this date will be pulled over to the record.
If the Approved Date in the file is null, then the Reported Date plus one minute will be displayed in the record.		APPROVEDDATE
	2	Work Type	Y	15

Must match Value List in Maximo.

(Cross-walked field.). Must match Crosswalk	Identifies the work order's type.
Example types are: preventive maintenance, corrective maintenance, emergency maintenance, capital project, and event report.	Value list in REFERENCE SPREADSHEET	WORKTYPE
	3	Customer Reference Number	Y	10		Contractors internal work order tracking number. Will update Record if Value is found in Maximo otherwise new record (Work order) will be created.		SERVPRVREFCODE
	4	Description	Y	150		Describes the work order.		DESCRIPTION
	5	Location	Y	30	Must match Value List in Maximo	Identifies the work order's location. This is not necessarily the asset's location, however, if an asset is entered, its location will default here.
- If the Location is null, in the inbound file, then this field is defaulted to the site's base location.	Value list in REFERENCE SPREADSHEET	LOCATION
	6	Reported By	Y	62	Must match Value List in Maximo	Identifies the person reporting the work order.	Value list in REFERENCE SPREADSHEET	REPORTEDBY
	7	Master System	N	N/A	Not used			N/A
	8	Status	Y	16	(Cross-walked field.)
Must match Crosswalk	Status of the work order, for example, in progress, waiting on material, waiting for approval, completed, or closed.	Value list in REFERENCE SPREADSHEET	STATUS
	9	Status Date	Y	10	MM/DD/YYYY hh:mm:ss			STATUSDATE
	10	Priority	Y	12	(Cross-walked field.)
Must match Crosswalk	Identifies the importance of the work order, from 0-999, where 0 is the lowest priority and 999 is the highest. If the Priority is null, in the inbound file, then this field is defaulted.	Value list in REFERENCE SPREADSHEET	WOPRIORITY
	11	Actual Start	Y	10	MM/DD/YYYY hh:mm:ss			ACTSTART
	12	Actual Finish	Y	10	MM/DD/YYYY hh:mm:ss			ACTFINISH
	13	Supervisor	N	30	Must match Value List in Maximo		Value list in REFERENCE SPREADSHEET -or-

For this contract:

- use the following identifier "XXXX"	SUPERVISOR
	14	Labor Hours(Actual)	Y	8	Number (2 decimal places)	ACTLABHRS

15 Labor Cost(Actual) Y 10 Number (2 decimal places) ACTLABCOST

16 Material Cost(Actual) Y 10 Number (2 decimal places) ACTMATCOST

17	Duration	N	8	Number (2 decimal places)	Estimated remaining number of hours needed to complete the work.		ESTDUR
18	Asset	Y	25	Must match an existing ASSETNUM in Maximo	The asset number used must exist in NAVFAC MAXIMO prior to submission, or the record will be rejected.	Value list in REFERENCE SPREADSHEET

	ASSETNUM
	19	Target Finish	Y	10	MM/DD/YYYY hh:mm:ss			TARGCOMPDATE
	20	Target Start	Y	10	MM/DD/YYYY hh:mm:ss			TARGSTARTDATE
	21	Reported Date	Y	10	MM/DD/YYYY hh:mm:ss			REPORTDATE
	22	Lead	N	30	Must match Value List in Maximo	Lead person responsible for the work.	Value list in REFERENCE SPREADSHEET	LEAD
	23	Scheduled Start	Y	10	MM/DD/YYYY hh:mm:ss			SCHEDSTART
	24	Scheduled Finish	Y	10	MM/DD/YYYY hh:mm:ss			SCHEDFINISH
	25	Modified Date	Y	10	LEAVE BLANK	Leave blank/Do Not Use	Leave blank/Do Not Use	CHANGEDATE
	26	Modified By	Y	30	LEAVE BLANK	Leave blank/Do Not Use	Leave blank/Do Not Use	CHANGEBY
	27	PMNEXTDUEDATE	N	4	MM/DD/YYYY hh:mm:ss			PMNEXTDUEDATE
	28	Is Task?	Y	1		Yes or No		ISTASK
	29	Parent WO	N	10	Length Limit: 250	Must exist in NAVFAC MAXIMO prior to submission or the record will be rejected.	Must exist in NAVFAC MAXIMO prior to submission or the record will be rejected.	PARENT
	30	Work Order	Y	10	Must match Value List in Maximo	Used in updating record status on existing records.		WONUM
	31	Detail Location	N	250				DETAILLOC
	32	CLIN	Y	30		Contract Line Item Number		CLIN
	33	Customer Ref Code	Y	8	Must match Value List in Maximo		Value list in REFERENCE SPREADSHEET	CUSTOMERCODE
	34	Sub Work Type	Y	15	(Cross-walked field).
Must match Crosswalk	Defaulted field based on the value of worktype		SUBWORKTYPE
	35	Work Center	Y	8	Must match Value List in Maximo		Value list in REFERENCE SPREADSHEET	PERSONGROUP
	36	GL Account	N	27				GLACCOUNT
	37	Outage Type	Y	50				OUTAGETYPE
	38	Outage Cause	Y	200	Must match Value List in Maximo		Value list in REFERENCE SPREADSHEET	OUTAGEREASON
	39	Num of Bldgs Affected	N		Integer			NUMBLDGSAFFECTED
	40	Outage Start Date	Y	10	MM/DD/YYYY hh:mm:ss			OUTAGESTARTDATE
	41	Outage End Date	Y	10	MM/DD/YYYY hh:mm:ss			OUTAGEENDATE
	42	Workorder Long Description	Y	150		Describes the work order.
		DESCRIPTION_LONGDESCRIPTION

2-TR Asset File Field List

ATTACHMENT J-0200000-09

ASSET INFORMATION

	Position	Name	Required	Length
Limit	Data Format Note	Content Notes
	MAXIMO Field Name
	1	AssetNum	Y	25			ASSETNUM
	2	Changed Date	Y		MM/DD/YYYY		CHANGEDATE
	3	Description	Y	100			DESCRIPTION
	4	Long Description	Y	1,000			LONGDESCRIPTION
	5	Master System	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…	MASTERSYSTEM
	6	System	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…	SYSTEM
	7	Sub-System	Y	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…	SUBSYSTEM
	8	Location	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	LOCATION
	9	Site ID	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	SITEID
	10	Work Center (Person Group)	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	PERSONGROUP
	11	Asset Type	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	ASSETTYPE
	12	Asset Quantity	Y		Integer		QUANTITY
	13	Inventory Category	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	INVENTORYCATEGORY
	14	Purchase Price	Y		Integer		PURCHASEPRICE
	15	Budgeted Cost	N		Integer		BUDGETCOST
	16	Replacement Cost	Y		Integer		REPLACECOST
	17	Meter Group	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	GROUPNAME
	18	Belongs To (Parent)	N		Must match an existing ASSETNUM in Maximo.	Asset Number of Parent. The asset and its parent can't be created in the same file	PARENT
	19	Contract Number	N	25			Appended to LONGDESCRIPTION
	20	Task/Delivery Order Number	N	25			Appended to LONGDESCRIPTION
	21	Drawing Reference ID	N	25			Appended to LONGDESCRIPTION
	22	Warranty Expiration Date	Y		MM/DD/YYYY		Appended to LONGDESCRIPTION
	23	Status Date	N		LEAVE BLANK	Leave blank/Do Not Use	STATUSDATE
	24	Installation Date	Y		MM/DD/YYYY		INSTALLDATE
	25	Asset Status	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET -or-
"Operating" for NEW and "Decommissioned or DEA" for removed equipment	STATUS
	26	CLASSSTRUCTUREID	N		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	CLASSSTRUCTUREID
	27	Job Plan Code	N	25			Appended to LONGDESCRIPTION
	28	Equipment Tag Number	N	25			Appended to LONGDESCRIPTION
	29	Additional Loc Info	Y	250			ADDLOCINFO
	30	Manufacturer	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	MANUFACTURER
	31	Model Number	Y	25			MODEL
	32	Serial Number	Y	25			SERIALNUM

3-Asset Specification FieldList

ATTACHMENT J-0200000-09

SERVICE PROVIDER INFORMATION

	Position	Name	Required	Length
Limit	Data Format Note	Field Definition	Content Notes	NAVFAC

MAXIMO_FIELD

(ASSETSPEC.)

1	Asset	Y	25	Asset identification number. Must match an existing value in Maximo.		ASSETNUM
2	SITEID	Y	8	FEC ID. Must match existing value list	If all work is done at a single FEC, recommend the correct SITEID be provided in the templay.	ASSETATTRID
3	CLASSSTRUCTUREID	Y	20	Key Value used in Maximo to identify the speciificaiton/attribute record. Value is not shown on the front end (visable to a user). Must match existing value in Maximo (example data a "1616" is an Electric Meter)		CLASSSTRUCTUREID
4	Attribute	Y	300	Attribute Name (example data - the PTRATIO is attribute being set)		ASSETATTRID
5	Numeric Value	N	40	Specification value with numeric value only.- only one value can be pased Numeric or AlphaNumeric; must match domain list if one exists.		NUMVALUE
6	Alphanumeric	N	254	Specitication value with mixed (alpha and numeric) content. Only one value can be pased Numeric or AlphaNumeric; must match domain list if one exists.		ALNVALUE
7	Unit of Measure	N	8	must match domain		MEASUREUNITID
8	Display Sequence	Y	10			N/A
9	Linear Asset Spec ID	Y	12			N/A

4-Characteristic Meter Fields

ATTACHMENT J-0200000-09

CHARACTERISTIC METER READING INFORMATION

	Position	Name	Required	Length
Limit	Data Format Note	Field Definition	Content Notes
	NAVFAC

MAXIMO_FIELD

(MEASUMENT / ASSETMETER)

See Note Below

1	Site	Y	8	UPPER	Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET	SITEID / SITEID
2	Asset	Y	25	Must match an existing ASSETNUM in Maximo	The asset number used must exist in NAVFAC MAXIMO prior to submission, or the record will be rejected.	Value list in REFERENCE SPREADSHEET

ASSETNUM / ASSETNUM
3	Meter	Y	15	UPPER	The value listed in the third position must be an existing, valid Maximo DCR or UCR meter.	Value must match existing value in Maximo. list in REFERENCE SPREADSHEET	METER NAME /

METER NAME

4	Observation	Y	254	ALN	Last Reading/Observation value. Must be a valid value in MAXIMO	Value must match existing value in Maximo list. Current value list included on "Observation Values" Tab.	OBSERVATION / LASTREADING
5	Measurement Date	Y	10	MM/DD/YYYY hh:mm:ss	Date Observation was recorded		MEASUREDATE / LASTREADINGDATE
6	Inspector	Y	30	Must match Value List in Maximo	Identifies the person reporting the observation	Value list in REFERENCE SPREADSHEET	INSPECTOR / LASTREADINGINSPCTR

NOTE (NAVFAC MAXIMO TR/FIELD):

5-Observation Values

	ATTACHMENT J-0200000-09
CHARACTERISTIC METER READING INFORMATION		ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

OBSERVATION VALUES

FACILITIES (DCR):
A	(Amber)
A+	(Amber Plus)
A-	(Amber Minus)
G	(Green)
G+	(Green Plus)
G-	(Green Minus)
R	(Red)
R+	(Red Plus)
R-	(Red Minus)

UTILITIES (UCR):
1	(Best/Highest CI Ranking)
2
3
4
5	(Worst/Lowest CI Ranking)

File details come from the government source that posted it. Updated Dec 5, 2023.