J-0200000-10- CHARACTERISTIC METER READING INFORMATION v2 - 2016-09-30.xlsx

XLSX spreadsheet 30 KB Posted

Attached to
Maintenance and Repair of Railroad Trackage at the Naval Weapon Station (NWS) Earle, Colts Neck, New Jersey and Other Areas of Responsibility (AOR)
Solicitation number
N40085_23_R_2526
Issued by

About this file

This document provides guidance for submitting characteristic meter reading information to the Naval Facilities Engineering Command (NAVFAC) Maximo asset management system. It includes details on the required data fields and file format for meter reading records. Position fields must include the site, asset, meter, observation value from an approved list, measurement date, and inspector. Records must be in pipe-delimited format with seven pipes per row. Observation values for facilities are letter codes like A for amber, while utility values range from 1 to 5. The related federal contract opportunity is solicitation number N40085_23_R_2526 for maintenance and repair of railroad trackage at Naval Weapon Station Earle and other areas. Services include repair, inspection, and maintenance of track infrastructure.

View the file

Other files

Show all 13

On GovTribe

Work with this file

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

Text version

1-Characteristic Meter Info

ATTACHMENT J-0200000-10

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 relect Utilities (DI) values only range from 1 to 5, not 10 (Sept 30, 2016)
TABS
1-Characteristic Meter Reading InfoThis Sheet
2-Characteristic Meter Reading Field ListCharacteristic Meter Reading Template Data Format Information
3-Characteristic Meter Reading - TemplateSample Excel Format
4-Observation ValuesValid Observation values as of 9/2016

2-Characteristic Meter Fields

ATTACHMENT J-0200000-XX

CHARACTERISTIC METER READING INFORMATION

Interface: Characteristic Meter Reading
VERSION #: v2
Current as of: 30 Sept 2016
PositionNameRequiredLength
LimitData Format NoteField DefinitionContent 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

(MEASUMENT / ASSETMETER)

See Note Below

1SiteY8UPPERMust match Value List in MaximoValue list in REFERENCE SPREADSHEET -or-
For this contract only: XXXXXSITEID / SITEID
2AssetY25Must match an existing ASSETNUM in MaximoThe asset number used must exist in NAVFAC MAXIMO prior to submission, or the record will be rejected.Value list in REFERENCE SPREADSHEET
ASSETNUM / ASSETNUM
3MeterY15UPPERThe 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 SPREADSHEETMETER NAME /

METER NAME

4ObservationY254ALNLast Reading/Observation value. Must be a valid value in MAXIMOValue must match existing value in Maximo list. Current value list included on
Tab 4 - Observation ValuesOBSERVATION / LASTREADING
5Measurement DateY10MM/DD/YYYY hh:mm:ssDate Observation was recordedMEASUREDATE / LASTREADINGDATE
6InspectorY30Must match Value List in MaximoIdentifies the person reporting the observationValue list in REFERENCE SPREADSHEET -or-

For this contract:

- use the following identifier "XXXX" INSPECTOR / LASTREADINGINSPCTR

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

CHARACTERISTIC METER READING INFORMATION

Interface: Characteristic Meter Reading
VERSION #: v2
Current as of: 30 Sept 2016
Position123456
NameSiteAssetMeterObservationMeasurement DateInspector
Required Field(s)YYYYYY

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

4-Observation Values

ATTACHMENT J-0200000-XX
CHARACTERISTIC METER READING INFORMATIONATTACHMENT 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)

File details come from the government source that posted it. Updated .