Asset ImpExp Template-simple 7-22-16 (with RKT Edits 6-27-17).xlsx
XLSX spreadsheet 158 KB Posted
- Solicitation number
- 47PC0319N0001
About this file
This document contains a solicitation notice for construction services for the Bankruptcy and Probation Courts Consolidation Project at the Conrad B. Duberstein U.S. Courthouse. The General Services Administration (GSA) is seeking proposals for general construction services at the courthouse located at 271 Cadman Plaza in Brooklyn, New York. This is a total small business set-aside where the applicable NAICS code is 236220 with an annual revenue size standard of $39.5 million or less to qualify as a small business. Interested offerors should review the attached solicitation files, which include some documents that are Sensitive But Unclassified and require access through beta.sam.gov. A pre-proposal conference and site visit is scheduled for December 19, 2019 at 9:00am EST at the courthouse. Proposals are due by the date and time stated in the solicitation. All offerors must be registered in the System for Award Management, and proposals must be submitted in paper and electronic format as detailed in the solicitation. Questions should be directed to the point of contact provided.
View the file
Other files
Show all 38
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
| TABS | INSTRUCTIONS |
| Asset Import Export Template | This 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 Temp | This tab is an exmple for creating new assets |
| SAMPLE Update Asset ImpExp Temp | This tab is for updating assets. Notice that the first colum is now ASSETNUM |
| FIELD | DESCRIPTION | Required? | Further Notes |
| ASSET.ASSETTAG | This is the original Equipment or Asset ID coming from the originating system. This will be used as reference to the old system going forward. | This is optional and not recommended to be used with an up to date asset list | |
| ASSET.ASSETTYPE | This is the predefined type of this asset | ALWAYS | Can't move to PMs without this |
| ASSET.DESCRIPTION | This describes the asset | ALWAYS, EXCEPT WHEN ADDING A CLASSIFICATION |
: ALWAYS for new listings.
Optional for changes to a listing.
-Dan Lewis - 7PMB Make sure that this is what you call the asset.
: I ask that the Asset Description match building plans or the BAS description. And then UNIQUELY describe the function of the equipment.
| -Dan Lewis - 7PMB | ||
| ASSET.DESCRIPTION_LONGDESCRIPTION | This is the long description for the asset | This is optional, this is an expanded description of the asset. |
: In R-7 the long description is for the physical characteristics of the equipment and Maintenance notes like: describing where is the disconnect and special considerations like notifying a tenant before shut down.
| -Dan Lewis - 7PMB | ||
| ASSET.GSALEGACYLOC | This is the GSA legacy location | This is optional, we do not need this as we are using a new up to date location table |
| ASSET.GSAMAKE | This is the make | *** |
| ASSET.GSAMANUFACTURERYEAR | This is the manufacturer year | *** |
| ASSET.GSAMODELNO | This is the manufacturer's model name or model number for the asset | *** |
| ASSET.GSAQUANTITY | This is the quantity | Do Not Use |
| ASSET.GSASERVICECENTER | This is the service center | Don't Worry About this -This will populate with correct location # selected. |
| ASSET.INSTALLDATE |
: This is the date we should be using.
Because:
Warranty starts with GSA acceptance.
It is most definitive.
The Install Date can usually be found on the project acceptance letter.
-Dan Lewis - 7PMB : ALWAYS for new listings.
Optional for changes to a listing.
-Dan Lewis - 7PMB : I ask that the Asset Description match building plans or the BAS description. And then UNIQUELY describe the function of the equipment.
-Dan Lewis - 7PMB : In R-7 the long description is for the physical characteristics of the equipment and Maintenance notes like: describing where is the disconnect and special considerations like notifying a tenant before shut down.
| -Dan Lewis - 7PMB | This is the installation date. CCYY-MM-DDTHH:mm:ss.ff | *** | |
| ASSET.LOCATION | This is the Maximo location code of the asset | ALWAYS | MANDITORY AT UPLOAD - Select from location table within NCMMS, ask GSA COR/ES if you have any questions |
| ASSET.MANUFACTURER | This is the manufacturer number of the asset | *** | |
| ASSET.PARENT | This 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 | MANDITORY AT UPLOAD - See footnote ### below | |
| ASSET.PRIORITY | This is the asset priority - copied to work order when entered. | ALWAYS | This is optional (and not very well understood) |
| ASSET.SADDRESSCODE | This identifies a service address. It must be unique by site for each service address | Don't Worry About this -This will populate with correct location # selected. | |
| ASSET.SERIALNUM | This is the asset serial number | *** |
| FOOTNOTES: | |
| *** | At the COR's discression, this is optional at initial upload (However, the initial upload may be the most efficient means to perform this effort to capture his information). If this information is not captured at upload, it may be done at time of annual PM, with a record by record modification. |
| ### | MANDITORY AT UPLOAD - Everything should have a parent unless it’s at the very top of the system Heiarch (EX- FACP, BAS Supervisor, etc), NOTE: multiple uploads may need to occour to capture proper heiarch if there are multiple levels |
Asset Import Export Template
| ASSETTAG | ASSETTYPE | DESCRIPTION | DESCRIPTION_LONGDESCRIPTION | GSALEGACYLOC | GSAMANUFACTURERYEAR | GSAMAKE | GSAMODELNO | GSAQUANTITY | GSASERVICECENTER | INSTALLDATE | LOCATION | MANUFACTURER | MODELID | PARENT | PRIORITY | SADDRESSCODE | SERIALNUM |
| AHU | AHU-01 | Air Handling Unit | Floor 02 Mechanical Room | 1 | 447874 | AAON | NJ-11/HW/CW/HW/HV | 1649502 | CN-4190 | ||||||||
| AHU | AHU-02 | Air Handling Unit | Floor 02 Mechanical Room | 1 | 447874 | AAON | NJ-15/HW/CW/HW/HV | 1649502 | CN-4190 | ||||||||
| AHU | AHU-03 | Air Handling Unit | Floor 02 Mechanical Room | 1 | 447874 | AAON | NJ-11/HW/CW/HW/HV | 1649502 | CN-4190 | ||||||||
| AHU | AHU-04 | Air Handling Unit | Floor 02 Mechanical Room | 1 | 447874 | AAON | NJ-13/HW/CW/HW/HV | 1649502 | CN-4190 | ||||||||
| AHU | AHU-05 | Air Handling Unit | Floor 02 Mechanical Room | 1 | 447874 | AAON | NJ-6/HW/CW/HW/HV | 1649502 | CN-4190 |
SAMPLE Asset ImpExp Temp
| ASSETTAG | ASSETTYPE | DESCRIPTION | DESCRIPTION_LONGDESCRIPTION | GSALEGACYLOC | GSAMANUFACTURERYEAR | GSAMAKE | GSAMODELNO | GSAQUANTITY | GSASERVICECENTER | INSTALLDATE | MANUFACTURER | PARENT | PRIORITY | SADDRESSCODE | SERIALNUM |
| AIR COMPRESSOR NO.1 | ACP | Air Compressor | Air Compressor | Floor 1 in the maintenance room | 2005 | AD-010-322 | 1 | 5100 - Boston Service Center | 8/7/08 | Johnson Controls | 4 | MA0011ZZ | G7893726482684720 |
File details come from the government source that posted it. Updated .