J-0200000-15 - ASSET SPECIFICATION.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- N4008526R0033
About this file
This is an Asset Specification template and data format specification document for integrating asset information into the MAXIMO facilities management system. The document, current as of May 17, 2012, provides detailed instructions for service providers submitting asset specification data related to the MCAS Beaufort and Laurel Bay Base Operation Support contract (N4008526R0033).
The template requires seven data fields in pipe-delimited format: Asset (identification number matching existing MAXIMO records), SITEID (FEC facility code), CLASSSTRUCTUREID (key value identifying the specification/attribute type, such as "1616" for Electric Meters), Attribute (the specific attribute name being set, such as PTRATIO), Numeric Value (for numeric-only specifications), Alphanumeric Value (for mixed alpha-numeric content), and Unit of Measure (matching established domain lists). Only fields containing actual data should be included in the flat-file submission in .txt format with pipe delimiters. The document provides sample data entries demonstrating proper formatting, such as asset "3-440-EPN-007" at SITEID "11001" with CLASSSTRUCTUREID "1616" specifying meter attributes including device ID, AMR indicator status, and PT ratio values. Changed By and Change Date fields are system-generated and should not be included in submissions. This specification document serves as a technical guide for contractors to properly format and submit asset data to support facilities management operations across MCAS Beaufort, Laurel Bay, and associated installations.
View the file
Other files
Show 40 more
50 files 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
Text version
1-Asset Specification Info
ATTACHMENT J-0200000-15
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-XX
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 |
3-Asset Specification-Template
ATTACHMENT J-0200000-15
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 .