J-0200000-07 - Asset Information.xlsx
XLSX spreadsheet 31 KB Posted
- Solicitation number
- N4019224R6000
About this file
This document contains an asset information template and details for a federal contract opportunity for facility management and investment services on Guam. The asset information template outlines 35 data fields required for new and updated asset records in MAXIMO, including asset numbers, descriptions, locations, quantities, costs, and status. It provides instructions for proper formatting in a pipe-delimited text file.
The solicitation is for facility management services under Annex 1501 and facility investment services under Annex 1502 to support the Marine Corps Base Camp Blaz in Guam. The contractor shall provide all labor, management, tools, and equipment for maintenance, repair, and capital improvements of facilities located at Finegayan, Andersen Air Force Base, Skaggs, Harmon, and future locations on Guam and other Mariana Islands. The period of performance and pricing terms are not specified. The solicitation number is N4019224R6000 and was issued by the Naval Facilities Engineering Command on behalf of the Department of the Navy.
View the file
Other files
Show 40 more
Latest 50 of 59 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 File Into
ATTACHMENT J-0200000-07
ASSET INFORMATION
| Interface: Asset File | |
| VERSION #: | V2 |
| Current as of: | 26 April 2017 |
| Version History |
| V1 - Updated to reflect current interface in MAXIMO |
| V2 - Added 3 additional fields (OPT): Asset Comment, PM Program & PM Plan |
| TABS | |
| 1-Asset File Info | This Sheet |
| 2-Asset File Field List | Asset Template Data Format Information |
| 3-Asset File - Template | Sample Excel Format |
2-Asset File Field List
ATTACHMENT J-0200000-07
ASSET INFORMATION
| Interface: Asset File |
| VERSION #:V2 |
| Current as of: 26 April 2017 |
| Position | Name | Required | Length | ||||
| Limit | Data Format Note | Content Notes | |||||
| MAXIMO Field Name | |||||||
| 1 | AssetNum | Y | 25 | ASSETNUM | |||
| 2 | Changed Date | N | MM/DD/YYYY | CHANGEDATE | |||
| 3 | Description | Y | 100 | DESCRIPTION | |||
| 4 | Long Description | N | 1,000 | LONGDESCRIPTION | |||
| 5 | Master System | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET. |
| POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc… | MASTERSYSTEM | ||||
| 6 | System | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET. |
| POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc… | SYSTEM | ||||
| 7 | Sub-System | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET. |
| POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc… | SUBSYSTEM | |||||
| 8 | Location | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET | LOCATION | |
| 9 | Site ID | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET -or- | ||
| For this contract only: XXXXX | SITEID | |||||
| 10 | Work Center (Person Group) | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET -or- |
For this contract:
| - use the following identifier "XXXX" | PERSONGROUP | ||||||
| 11 | Asset Type | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET | ASSETTYPE | ||
| 12 | Asset Quantity | N | Integer | QUANTITY | |||
| 13 | Inventory Category | Y | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET | INVENTORYCATEGORY | ||
| 14 | Purchase Price | N | Integer | PURCHASEPRICE | |||
| 15 | Budgeted Cost | N | Integer | BUDGETCOST | |||
| 16 | Replacement Cost | Y | Integer | REPLACECOST | |||
| 17 | Meter Group | N | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET | GROUPNAME | ||
| 18 | Belongs To (Parent) | N | Must match an existing ASSETNUM in Maximo. | Asset Number of Parent. The asset and its parent can't be created in the same file | PARENT | ||
| 19 | Contract Number | N | 25 | Appended to LONGDESCRIPTION | |||
| 20 | Task/Delivery Order Number | N | 25 | Appended to LONGDESCRIPTION | |||
| 21 | Drawing Reference ID | N | 25 | Appended to LONGDESCRIPTION | |||
| 22 | Warranty Expiration Date | N | MM/DD/YYYY | Appended to LONGDESCRIPTION | |||
| 23 | Status Date | N | LEAVE BLANK | Leave blank/Do Not Use | STATUSDATE | ||
| 24 | Installation Date | Y | MM/DD/YYYY | INSTALLDATE | |||
| 25 | Asset Status | N | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET -or- | |||
| "Operating" for NEW and "Decommissioned or DEA" for removed equipment | STATUS | ||||||
| 26 | CLASSSTRUCTUREID | N | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET | CLASSSTRUCTUREID | ||
| 27 | Job Plan Code | N | 25 | Appended to LONGDESCRIPTION | |||
| 28 | Equipment Tag Number | N | 25 | Appended to LONGDESCRIPTION | |||
| 29 | Additional Loc Info | N | 250 | ADDLOCINFO | |||
| 30 | Manufacturer | N | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET | MANUFACTURER | ||
| 31 | Model Number | N | 25 | MODEL | |||
| 32 | Serial Number | N | 25 | SERIALNUM | |||
| 33 | Asset Comment | N | 100 | ASSETCOMMENT | |||
| 34 | Standard Eval Results | ||||||
| (PM Plan) | N | 15 | Values Depend on Asset Type (i.e. UTILITIES, FACILITIES) | Not required, but will default to N/A or NTE if left blank. Valid values determined by Asset Type (Position 11) | STANDARDEVAL | ||
| 35 | PM Standard Applies | ||||||
| (PM Program) | N | 15 | Values Depend on Asset Type (i.e. UTILITIES, FACILITIES) | Not required, but will default to N/A or NTE if left blank. Valid values determined by Asset Type (Position 11) | PMSTANDARD | ||
| N/A |
3-Asset File Template
| ATTACHMENT J-0200000-07 | ||
| ASSET INFORMATION | ATTACHMENT J-0200000-07 |
ASSET INFORMATION
| Interface: Asset File | ||||||||||||||||||||||||||||||||||||
| VERSION #: V2 | ||||||||||||||||||||||||||||||||||||
| Current as of: 26 April 2017 | ||||||||||||||||||||||||||||||||||||
| Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | |
| Name | AssetNum | Changed Date | Description | Long Description | Master System | System | Sub-System | Location | Site ID | Work Center (Person Group) | Asset Type | Asset Quantity | Inventory Category | Purchase Price | Budgeted Cost | Replacement Cost | Meter Group | Belongs To (Parent) | Contract Number | Task/Delivery Order Number | Drawing Reference ID | Warranty Expiration Date | Status Date | Installation Date | Asset Status | CLASSSTRUCTUREID | Job Plan Code | Equipment Tag Number | Additional Loc Info | Manufacturer | Model | Serial # | Asset Comment | PM Plan | PM Program | |
| Required Field(s) | ||||||||||||||||||||||||||||||||||||
| (on new Asset) | Y | N | Y | N | Y | Y | Y | Y | Y | Y | Y | N | Y | N | N | Y | N | N | N | N | N | N | N | Y | N | N | N | N | N | N | N | N | N | N | N |
NOTES:
• ONLY COLUMNs 1-35, and rows containing data should be be included in the FLAT-FILE SUBMISSION;
• Pipe Delimited (.txt) - | (Pipe is at the end of the column, before the return. Must have 35 PIPEs per row.)
• New assets & asset updates (to different assets) can be completed at the same time. An asset can't be created and updated at the same time.
File details come from the government source that posted it. Updated .