NOSC ST J-0200000-08 - Characteristic Meter Reading Info.pdf

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 relect 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

ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

Current as of: 30 Sept 2016

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.>>

1 Site Y 8 UPPER Must match Value List in Maximo Value list in REFERENCE SPREADSHEET -or- For this contract only: XXXXX

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

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

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

5 Measurement Date Y 10

MM/DD/YYYY

hh:mm:ss Date Observation was recorded

6 Inspector Y 30 Must match Value List in

Maximo

Identifies the person reporting the observation

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

NOTE (NAVFAC 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 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.

NAVFAC

MAXIMO_FIELD

(MEASUMENT /

ASSETMETER)

See Note Below

SITEID / SITEID

ASSETNUM / ASSETNUM

METER NAME /

METER NAME

OBSERVATION /

LASTREADING

MEASUREDATE /

LASTREADINGDATE

INSPECTOR /

LASTREADINGINSPCTR

d is o

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

ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

NOTES:

• 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))

Current as of: 30 Sept 2016

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) 5 (Worst/Lowest CI Ranking)

ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

OBSERVATION VALUES