J-0200000-09 - ASSET SPECIFICATION.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- N4008523R2849
About this file
This document appears to be a template for an "Asset Specification" interface for the MAXIMO system. It provides a detailed field list with definitions for the required data elements, including asset number, site ID, class structure ID, attribute name, numeric value, alphanumeric value, and unit of measure. The template also includes sample data in a pipe-delimited format. This template is referenced in the related federal contract opportunity, which is a solicitation for HVAC services at the Philadelphia Navy Yard Annex and Naval Support Activity in Pennsylvania. The contract will have a base period with up to four one-year option periods, not to exceed 60 months in total. Prospective contractors must be registered in the System for Award Management (SAM) database at the time of proposal submission and throughout contract performance.
View the file
Other files
Show all 24
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-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 | 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 template. | 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 .