J-0200000-10 - ASSET SPECIFICATION.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- Regional HVAC Chemical Treatment Services
- Solicitation number
- N4008523R2685
About this file
This document provides a template and guidance for submitting asset specification data to the Naval Facilities Engineering Command (NAVFAC) through their MAXIMO asset management system. The template includes seven required fields for asset identification number, site ID, classification ID, attribute name, numeric or alphanumeric value, units of measure, and change information to be populated. Only columns one through seven with data need be included in the pipe-delimited flat file submission. Sample data rows are provided using the 3-440-EPN-007 asset number for elements like UAMETERDEVICEID, AMRINDICATOR, and PTRATIO, with relevant values in the proper columns. This asset specification template appears to be related to the Regional HVAC Chemical Treatment Services solicitation from NAVFAC seeking chemical treatment for heating, ventilation, and air conditioning systems across multiple facilities.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| P0003 J-1502000-03 Facility Inventory.xlsx | XLSX spreadsheet | |
| N4008523R2685 P0003.pdf | ||
| N4008523R2685 P0002.pdf | ||
| J-0200000-13 ELINs Facility Investment.xlsx | XLSX spreadsheet | |
| N4008523R2685 P0001.pdf | ||
| PIEE Vendor Access Instructions.pdf | ||
| ATTACHMENT J-0200000-04 INVOICE FORM.pdf | ||
| N4008523R2685.pdf | ||
| N4008523R2685 SECTION C ANNEXES.pdf | ||
| J-0200000-08- SERVICE PROVIDER INFORMATION.xlsx | XLSX spreadsheet | |
| J-0200000-09 - ASSET INFORMATION.xlsx | XLSX spreadsheet | |
| J-0200000-13 ELINs Facility Investment.xlsx | XLSX spreadsheet | |
| N4008523R2685 SECTION J ANNEXES.pdf | ||
| ATTACHMENT J-0200000-05-17 - Leak Rate Calculation Information.pdf | ||
| J-1502000-03 Facility Inventory.xlsx | XLSX spreadsheet |
Show all 15
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-10
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 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-10
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 .