CMMS_Template_.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
Replace Glycol Cooling Tower
Solicitation number
EQ5P2SS1P-17-0084
Issued by

About this file

CMMS Template Referenced in RFP

View the file

Other files

File Type Posted
Amendment_06.pdf PDF
Amendment05.pdf PDF
Amendment_04.pdf PDF
Amendment_03.pdf PDF
SF24.pdf PDF
RFP_Glycol_Cooling_Tower.pdf PDF
Sign_In_Sheet.pdf PDF
Amendment_02.pdf PDF
Amendment_01.pdf PDF
RFP_Glycol_Cooling_Tower.pdf PDF

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

INSTRUCTIONS

TABSINSTRUCTIONS
Asset Import Export TemplateThis tab can be used for creating new assets. New assets will not have a ASSETNUM colum because the asset number is autogenerated. When using the import tool in Maximo, the object structure GSAASSETIMPEXP must be selected
SAMPLE Asset ImpExp TempThis tab is an exmple for creating new assets
SAMPLE Update Asset ImpExp TempThis tab is for updating assets. Notice that the first colum is now ASSETNUM
FIELDDESCRIPTIONRequired?
ASSET.ASSETTAGThis is the original Equipment or Asset ID coming from the originating system. This will be used as reference to the old system going forward.
ASSET.ASSETTYPEThis is the predefined type of this assetALWAYS
ASSET.DESCRIPTIONThis describes the assetALWAYS, EXCEPT WHEN ADDING A CLASSIFICATION
ASSET.DESCRIPTION_LONGDESCRIPTIONThis is the long description for the asset
ASSET.GSALEGACYLOCThis is the GSA legacy location
ASSET.GSAMAKEThis is the make
ASSET.GSAMANUFACTURERYEARThis is the manufacturer year
ASSET.GSAMODELNOThis is the manufacturer's model name or model number for the asset
ASSET.GSAQUANTITYThis is the quantity
ASSET.GSASERVICECENTERThis is the service center
ASSET.INSTALLDATEThis is the installation date. CCYY-MM-DDTHH:mm:ss.ff
ASSET.LOCATIONThis is the Maximo location code of the assetALWAYS
ASSET.MANUFACTURERThis is the manufacturer number of the asset
ASSET.PARENTThis is the parent asset number the asset field is for the Maximo asset identifier, the value Maximo uses to track the asset. Parent field can only be inserted for new location records. To update the parent of a location record go to the system user interface (front end) of the application and use the select action menu
ASSET.PRIORITYThis is the asset priority - copied to work order when entered.ALWAYS
ASSET.SADDRESSCODEThis identifies a service address. It must be unique by site for each service address
ASSET.SERIALNUMThis is the asset serial number

Asset Import Export Template ASSETTAG ASSETTYPE DESCRIPTION DESCRIPTION_LONGDESCRIPTION GSALEGACYLOC GSAMANUFACTURERYEAR GSAMAKE GSAMODELNO GSAQUANTITY GSASERVICECENTER INSTALLDATE LOCATION MANUFACTURER MODELID PARENT PRIORITY SADDRESSCODE SERIALNUM

SAMPLE Asset ImpExp Temp

ASSETTAGASSETTYPEDESCRIPTIONDESCRIPTION_LONGDESCRIPTIONGSALEGACYLOCGSAMANUFACTURERYEARGSAMAKEGSAMODELNOGSAQUANTITYGSASERVICECENTERINSTALLDATEMANUFACTURERPARENTPRIORITYSADDRESSCODESERIALNUM
AIR COMPRESSOR NO.1ACPAir CompressorAir CompressorFloor 1 in the maintenance room2005AD-010-32215100 - Boston Service Center8/7/08Johnson Controls4MA0011ZZG7893726482684720

File details come from the government source that posted it.