J-0200000-14 - ASSET INFORMATION.xlsx

This is an asset information template and data specification document for submitting asset data to a MAXIMO asset management system in support of Base Operation Services (BOS) at MCAS Beaufort and Laurel Bay in South Carolina and Georgia.

The document provides a standardized Excel-based interface (Version 2, current as of April 26, 2017) for uploading asset information with 35 defined data fields. Required fields for new assets include Asset Number, Description, Master System, System, Sub-System, Location, Site ID, Work Center, Asset Type, Inventory Category, Replacement Cost, Installation Date, and Asset Status. Optional fields capture supplementary information such as serial numbers, manufacturer details, model numbers, warranty expiration dates, contract references, and preventive maintenance program assignments. All data must be submitted in pipe-delimited flat-file format (.txt) with exactly 35 pipes per row, containing only populated rows and columns 1-35. The template accommodates both new asset creation and updates to existing assets in a single submission, though individual assets cannot be both created and updated simultaneously. Data entries must reference and align with existing MAXIMO value lists, with particular emphasis on maintaining hierarchical relationships for Master System, System, and Sub-System classifications using UNIFORMAT coding standards (D30, D3010, D3010100, etc.). The specification clarifies that parent-child asset relationships require the parent asset to be created prior to submission of dependent assets within the same file.