J-0200000-09 - ASSET SPECIFICATION 20200727.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- FACILITY SERVICES FOR MAINTENANCE
- Solicitation number
- N4008520R0094
View the file
Other files
Show all 26
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-09
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. |
2-Asset Specification FieldList
ATTACHMENT J-0200000-09
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 | 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-09
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 |
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| |
File details come from the government source that posted it. Updated .