J-0200000-08 Specification Information.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- N40085-20-R-3006
About this file
This document provides specifications for submitting asset attribute data to the Navy's MAXIMO asset management system. It includes a template for a pipe-delimited file with seven required fields: asset number, site ID, class structure ID, attribute name, numeric value, alphanumeric value, and unit of measure. Sample data rows and field definitions are provided. The related federal contract opportunity is solicitation N40085-20-R-3006 for testing, calibrating, adjusting and repairing cathodic protection, automatic tank gauging and fuel management systems on above-ground and underground tanks at the Naval Submarine Base New London in Groton, Connecticut. The work includes all labor, materials, equipment, supervision, transportation and management to perform the required services. The contracting agency is the Department of the Navy Naval Facilities Engineering Command.
View the file
Other files
Show all 28
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-Asset Specification Info
ATTACHMENT J-0200000-07
ASSET SPECIFICATION
| 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. |
&"Times New Roman,Regular"N44255-18-D-5009 &A Page &P of &N
2-Asset Specification FieldList
ATTACHMENT J-0200000-07
SERVICE PROVIDER 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 |
&A Page &P of &N
3-Asset Specification-Template
ATTACHMENT J-0200000-07
ASSET SPECIFICATION
| 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 |
&A Page &P of &N
NOTES:
• 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
| 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| |
&A Page &P of &N
File details come from the government source that posted it. Updated .