NCMMS Blank New Asset Template.xlsx

XLSX spreadsheet 641 KB Posted

Attached to
Consolidated Facilities Management
Solicitation number
47PF0021R0078
Issued by

View the file

Other files

File Type Posted
47PF0021R0078 Austin Fergus Falls CFM Q and A.pdf PDF
47PF0021R0078 Austin Fergus Falls CFM Q and A.pdf PDF
Site Visit List 5 17 21.xlsx XLSX spreadsheet
Amendment 02 SCA POC Change.pdf PDF
Pre-Proposal Agenda Call In 5 18 21.docx DOCX document
Amendment 01 Site Visit Change 05 12 21.pdf PDF
R5 Level 1 Asset Inventory PM Plan Audit Tool V2.pdf PDF
Austin SSA Equipment Inventory.xls XLS spreadsheet
EJ Devitt FB CTHSE Asbestos Notification Letter.pdf PDF
Fergus Falls Equipment Inventory.xls XLS spreadsheet
SF24-16d.pdf PDF
J.11 MechCCP.xls XLS spreadsheet
R5 NCMMS Work Order Required Fields For Custodial Contract.pdf PDF
R5 NCMMS Work Order Required Fields For OM Contract.pdf PDF
J.10 O and M CCP.xls XLS spreadsheet
SSA Building Austin Asbestos Notification Letter.pdf PDF
J.10 O&M CCP.xls XLS spreadsheet
RFP 47PF0021R0078 CFM Fergus Falls Austin.pdf PDF
Show all 18

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions Use the Asset Uploader tab (Red) to capture new assets/equipment for import into NCMMS. The template consists of a total of 66 unique data fields. Only about 1/3 of the fields are required (highlighted in blue), the remaining fields are informational, optional or not applicable. Refer to the legend below. The table below provides specific instructions for what to enter in each field.

Some fields are free-form data entry and others have drop down lists to pick from. The drop down pick lists are provided in the reference tabs (Green).

Note: For the purposes of this tool the terms Asset and Equipment are used interchangeably.

Legend
Reference only, do not edit
Required
Not Required - (Hidden Rows)
Optional
Field NameField DescriptionField Action/Instructions
ASSETNUMUnique NCMMS Auto Genarated/Assigned Asset NumberTemporary Asset Number provided, do not edit this field.
ASSETTAGOriginal/Legacy Equipment ID NumberAsset Tag field is currently used to capture legacy equipment ID number. Not Applicable for New Assets.
ASSETTYPEAsset Type CodeSelect an Asset Type from the drop down. If not listed select XXX Unknown and type in asset type description in Colum F.
CLASSSTRUCTUREIDClass Structure IDField hidden leave blank.
ASSETTYPE_DESCRIPTIONAsset Type DescriptionField hidden. To be completed by NCMMS Team
DESCRIPTION_LONGDESCRIPTIONAsset Long Description field is free form field that is used to house additional asset information such as attributes like amparage, voltage, etc. Or additional description information on the asset.The Long Description field is free form field that is used to house additional asset information such as attributes like amparage, voltage, CFM, Gallons, HP, PSI, BTUs, etc. Or additional asset description information on the asset.
EQ1Not Required Leave BlankField hidden leave blank.
FAILURECODENot Required Leave BlankField hidden leave blank.
GLACCOUNTNot Required Leave BlankField hidden leave blank.
GSAASSET1Not Required Leave BlankField hidden leave blank.
GSAASSETYEARNot Required Leave BlankField hidden leave blank.
GSABARCODENot Required Leave BlankField hidden leave blank.
GSACRITICALITYCLASSIFICATIONNot Required Leave BlankField hidden leave blank.
GSACSIMF2004Not Required Leave BlankField hidden leave blank.
GSADATEENERGIZEDNot Required Leave BlankField hidden leave blank.
GSADATERETIREDNot Required Leave BlankField hidden leave blank.
GSAEQUIPMENTIDNCMMS Auto Generated Equipment ID number.Field hidden leave blank.
GSAEQUIPMENTOWNEREquipment OwnerFor new assets select GSA or Not GSA Owned.
GSAFACTSNot Required Leave BlankField hidden leave blank.
GSAGSACLASSNot Required Leave BlankField hidden leave blank.
GSALEGACYLOCLegacy LocationEnter a new Location in "Floor ## - Room ### - Room /Name or Description" format. Include additional location information i.e. cardinal direction or column number or quadrant as applicable.
GSALIFECYCLEENDDATELife Cycle End DateEnter the asset life cycle end date in MM/DD/YYYY format
GSALINKINITIALSPARKDATENot Required Leave BlankField hidden leave blank.
GSALINKMOSTRECENTEVENTDATENot Required Leave BlankField hidden leave blank.
GSALINKTOTALESTIMATEDCOSTNot Required Leave BlankField hidden leave blank.
GSAMAINTENANCERESPONSIBILITYMaintenance ResponsibilitySelect Party responsible for performing Maintenance from drop down. If neither choice applys select "Other"
GSAMAKEAsset MakeIf applicable provide asset or manufacturer make, if not leave blank.
GSAMANUFACTUREYEARManufacturer YearEnter year asset was manufactured in MM/DD/YYY.
GSAMODELNOAsset Model NumberEnter model number
GSAOMNICLASSTABLE21Not Required Leave BlankNot Required Leave Blank
GSAOMNICLASSTABLE23Not Required Leave BlankNot Required Leave Blank
GSAQUANTITYQuantityEnter quanity
GSARCMCRITICALITYNot Required Leave BlankNot Required Leave Blank
GSARCMFAILURECONSEQUENCENot Required Leave BlankNot Required Leave Blank
GSARCMFAILUREPROBABILITYNot Required Leave BlankNot Required Leave Blank
GSARCMFUNCTIONNot Required Leave BlankNot Required Leave Blank
GSARCMMACNot Required Leave BlankNot Required Leave Blank
GSARCMRUNTOFAILNot Required Leave BlankNot Required Leave Blank
GSARCMTASKREFERENCENot Required Leave BlankNot Required Leave Blank
GSAREVIEWCOMMENTSNot Required Leave BlankNot Required Leave Blank
GSAREVIEWDATENot Required Leave BlankNot Required Leave Blank
GSAREVIEWFLAGNot Required Leave BlankNot Required Leave Blank
GSARSMPMCODENot Required Leave BlankNot Required Leave Blank
GSASKYSPARKASSETDESCRIPTIONNot Required Leave BlankNot Required Leave Blank
GSASKYSPARKEQUIPMENTIDNot Required Leave BlankNot Required Leave Blank
GSATENANTNot Required Leave BlankNot Required Leave Blank
GSATENANTSYSTEMIDNot Required Leave BlankNot Required Leave Blank
GSATESTTYPENot Required Leave BlankNot Required Leave Blank
GSAUNIFORMATDESCRIPTIONNot Required Leave BlankNot Required Leave Blank
GSAUNIFORMATIINot Required Leave BlankNot Required Leave Blank
INSTALLDATEInstallation dateEnter asset installation date in MM/DD/YYYY format
LOCATIONLocation Code To be completed by NCMMS Team. Leave BlankLeave blank
MANUFACTURERManufacturerSelect a manufacturer using the drop down.
MOBRFIDTAGNot Required Leave BlankNot Required Leave Blank
MODELIDNot Required Leave BlankNot Required Leave Blank
ORGIDOrganization IDThis field is pre-populated with "GSA".
PARENTParentUse this field to establish/identify Parent/Child relationship between assets. Enter Temporary Asset Number from Column A of 'Asset Uploader' tab to Identify an assets Parent
PRIORITYNot Required Leave BlankNot Required Leave Blank
PRODUCTIDNot Required Leave BlankNot Required Leave Blank
PURCHASEPRICEAsset purchase priceEnter asset purchase price
REPLACECOSTNot Required Leave BlankNot Required Leave Blank
SADDRESSCODEGSA Building NumberEnter GSA Building Number
SERIALNUMAsset serial numberEnter asset serial number
SITEIDRegion Code (01-11)Select region code (05).
STATUSAsset Status CodeFor new assets select Add Pending.
GSA PM GUIDE2012 GSA PM Maintenance StandardSelect corresponding 2012 GSA PM Maintenance Standard using drop down.

Asset Uploader Temporary Asset Number, do not edit. Original/Legacy Equipment ID Number. If new leave blank. Select an Asset Type from the drop down. If not listed enter type asset description. Not Required Leave Blank Leave Blank - To be completed by NCMMS Team The Long Description field is free form field that is used to house additional asset information such as attributes like Amps, Volts, Hp, CFM, Gallons etc. Or additional description information on the asset. Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Auto Generated Equipment ID. Leave Blank Select equipment owner from drop down GSA or Agency Name. Use Not GSA Owned if Agency name not listed. Not Required Leave Blank Not Required Leave Blank Enter a new Location in "Floor ## - Room ### - Room /Name or Description" format. Include additional location information i.e. cardinal direction or column number or quadrant as applicable. Enter asset life cycle end date in MM/DD/YYYY format Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank To be completed by NCMMS Team. Leave Blank Asset Make, where applicable Enter Year asset was manucatured in MM/DD/YYYY format Asset Model Number Not Required Leave Blank Not Required Leave Blank Quantity Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not required leave blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Not Required Leave Blank Enter asset installation date in MM/DD/YYYY format Location Code To be completed by NCMMS Team. Leave Blank Select a manufacturer using the drop down. Not Required Leave Blank Not Required Leave Blank Always enter "GSA" Use this field to establish/identify Parent/Child relationship between assets. Enter Temporary Asset Number from Column A of 'Asset Uploader' tab to Identify an assets Parent Not Required Leave Blank Not Required Leave Blank Enter asset purchase price Not Required Leave Blank GSA Building Number Enter asset serial number Site ID refers to region code 05 Select a status from from the drop down. Select "Add Pending" for new equipment. Optional Select corresponding 2012 GSA PM Maintenance Standard using drop down.

ASSETNUMASSETTAGASSETTYPECLASSSTRUCTUREIDASSETTYPE_DESCRIPTIONDESCRIPTION_LONGDESCRIPTIONEQ1FAILURECODEGLACCOUNTGSAASSET1GSAASSETYEARGSABARCODEGSACRITICALITYCLASSIFICATIONGSACSIMF2004GSADATEENERGIZEDGSADATERETIREDGSAEQUIPMENTIDGSAEQUIPMENTOWNERGSAFACTSGSAGSACLASSGSALEGACYLOCGSALIFECYCLEENDDATEGSALINKINITIALSPARKDATEGSALINKMOSTRECENTEVENTDATEGSALINKTOTALESTIMATEDCOSTGSAMAINTENANCERESPONSIBILITYGSAMAKEGSAMANUFACTUREYEARGSAMODELNOGSAOMNICLASSTABLE21GSAOMNICLASSTABLE23GSAQUANTITYGSARCMCRITICALITYGSARCMFAILURECONSEQUENCEGSARCMFAILUREPROBABILITYGSARCMFUNCTIONGSARCMMACGSARCMRUNTOFAILGSARCMTASKREFERENCEGSAREVIEWCOMMENTSGSAREVIEWDATEGSAREVIEWFLAGGSARSMPMCODEGSASKYSPARKASSETDESCRIPTIONGSASKYSPARKEQUIPMENTIDGSATENANTGSATENANTSYSTEMIDGSATESTTYPEGSAUNIFORMATDESCRIPTIONGSAUNIFORMATII
SAMPLEAHU-01: Air Handling Unit, 3 ton thru 24 tonGSAFloor 01 - Room 101 - Electrical Closet - North1/1/35X-1122331
SAMPLEWHT-01: Water Heater, Electric
NEW-1
NEW-2
NEW-3
NEW-4
NEW-5
NEW-6
NEW-7
NEW-8
NEW-9
NEW-10
NEW-11
NEW-12
NEW-13
NEW-14
NEW-15
NEW-16
NEW-17
NEW-18
NEW-19
NEW-20
NEW-21
NEW-22
NEW-23
NEW-24
NEW-25
NEW-26
NEW-27
NEW-28
NEW-29
NEW-30
NEW-31
NEW-32
NEW-33
NEW-34
NEW-35
NEW-36
NEW-37
NEW-38
NEW-39
NEW-40
NEW-41
NEW-42
NEW-43
NEW-44
NEW-45
NEW-46
NEW-47
NEW-48
NEW-49
NEW-50
NEW-51
NEW-52
NEW-53
NEW-54
NEW-55
NEW-56
NEW-57
NEW-58
NEW-59
NEW-60
NEW-61
NEW-62
NEW-63
NEW-64
NEW-65
NEW-66
NEW-67
NEW-68
NEW-69
NEW-70
NEW-71
NEW-72
NEW-73
NEW-74
NEW-75
NEW-76
NEW-77
NEW-78
NEW-79
NEW-80
NEW-81
NEW-82
NEW-83
NEW-84
NEW-85
NEW-86
NEW-87
NEW-88
NEW-89
NEW-90
NEW-91
NEW-92
NEW-93
NEW-94
NEW-95
NEW-96
NEW-97
NEW-98
NEW-99
NEW-100
NEW-101
NEW-102
NEW-103
NEW-104
NEW-105
NEW-106
NEW-107
NEW-108
NEW-109
NEW-110
NEW-111
NEW-112
NEW-113
NEW-114
NEW-115
NEW-116
NEW-117
NEW-118
NEW-119
NEW-120
NEW-121
NEW-122
NEW-123
NEW-124
NEW-125
NEW-126
NEW-127
NEW-128
NEW-129
NEW-130
NEW-131
NEW-132
NEW-133
NEW-134
NEW-135
NEW-136
NEW-137
NEW-138
NEW-139
NEW-140
NEW-141
NEW-142
NEW-143
NEW-144
NEW-145
NEW-146
NEW-147
NEW-148
NEW-149
NEW-150
NEW-151
NEW-152
NEW-153
NEW-154
NEW-155
NEW-156
NEW-157
NEW-158
NEW-159
NEW-160
NEW-161
NEW-162
NEW-163
NEW-164
NEW-165
NEW-166
NEW-167
NEW-168
NEW-169
NEW-170
NEW-171
NEW-172
NEW-173
NEW-174
NEW-175
NEW-176
NEW-177
NEW-178
NEW-179
NEW-180
NEW-181
NEW-182
NEW-183
NEW-184
NEW-185
NEW-186
NEW-187
NEW-188
NEW-189
NEW-190
NEW-191
NEW-192
NEW-193
NEW-194
NEW-195
NEW-196
NEW-197
NEW-198
NEW-199
NEW-200
NEW-201
NEW-202
NEW-203
NEW-204
NEW-205
NEW-206
NEW-207
NEW-208
NEW-209
NEW-210
NEW-211
NEW-212
NEW-213
NEW-214
NEW-215
NEW-216
NEW-217
NEW-218
NEW-219
NEW-220
NEW-221
NEW-222
NEW-223
NEW-224
NEW-225
NEW-226
NEW-227
NEW-228
NEW-229
NEW-230
NEW-231
NEW-232
NEW-233
NEW-234
NEW-235
NEW-236
NEW-237
NEW-238
NEW-239
NEW-240
NEW-241
NEW-242
NEW-243
NEW-244
NEW-245
NEW-246
NEW-247
NEW-248
NEW-249
NEW-250
NEW-251
NEW-252
NEW-253
NEW-254
NEW-255
NEW-256
NEW-257
NEW-258
NEW-259
NEW-260
NEW-261
NEW-262
NEW-263
NEW-264
NEW-265
NEW-266
NEW-267
NEW-268
NEW-269
NEW-270
NEW-271
NEW-272
NEW-273
NEW-274
NEW-275
NEW-276
NEW-277
NEW-278
NEW-279
NEW-280
NEW-281
NEW-282
NEW-283
NEW-284
NEW-285
NEW-286
NEW-287
NEW-288
NEW-289
NEW-290
NEW-291
NEW-292
NEW-293
NEW-294
NEW-295
NEW-296
NEW-297
NEW-298
NEW-299
NEW-300
NEW-301
NEW-302
NEW-303
NEW-304
NEW-305
NEW-306
NEW-307
NEW-308
NEW-309
NEW-310
NEW-311
NEW-312
NEW-313
NEW-314
NEW-315
NEW-316
NEW-317
NEW-318
NEW-319
NEW-320
NEW-321
NEW-322
NEW-323
NEW-324
NEW-325
NEW-326
NEW-327
NEW-328
NEW-329
NEW-330
NEW-331
NEW-332
NEW-333
NEW-334
NEW-335
NEW-336
NEW-337
NEW-338
NEW-339
NEW-340
NEW-341
NEW-342
NEW-343
NEW-344
NEW-345
NEW-346
NEW-347
NEW-348
NEW-349
NEW-350
NEW-351
NEW-352
NEW-353
NEW-354
NEW-355
NEW-356
NEW-357
NEW-358
NEW-359
NEW-360
NEW-361
NEW-362
NEW-363
NEW-364
NEW-365
NEW-366
NEW-367
NEW-368
NEW-369
NEW-370
NEW-371
NEW-372
NEW-373
NEW-374
NEW-375
NEW-376
NEW-377
NEW-378
NEW-379
NEW-380
NEW-381
NEW-382
NEW-383
NEW-384
NEW-385
NEW-386
NEW-387
NEW-388
NEW-389
NEW-390
NEW-391
NEW-392
NEW-393
NEW-394
NEW-395
NEW-396
NEW-397
NEW-398
NEW-399
NEW-400
NEW-401
NEW-402
NEW-403
NEW-404
NEW-405
NEW-406
NEW-407
NEW-408
NEW-409
NEW-410
NEW-411
NEW-412
NEW-413
NEW-414
NEW-415
NEW-416
NEW-417
NEW-418
NEW-419
NEW-420
NEW-421
NEW-422
NEW-423
NEW-424
NEW-425
NEW-426
NEW-427
NEW-428
NEW-429
NEW-430
NEW-431
NEW-432
NEW-433
NEW-434
NEW-435
NEW-436
NEW-437
NEW-438
NEW-439
NEW-440
NEW-441
NEW-442
NEW-443
NEW-444
NEW-445
NEW-446
NEW-447
NEW-448
NEW-449
NEW-450
NEW-451
NEW-452
NEW-453
NEW-454
NEW-455
NEW-456
NEW-457
NEW-458
NEW-459
NEW-460
NEW-461
NEW-462
NEW-463
NEW-464
NEW-465
NEW-466
NEW-467
NEW-468
NEW-469
NEW-470
NEW-471
NEW-472
NEW-473
NEW-474
NEW-475
NEW-476
NEW-477
NEW-478
NEW-479
NEW-480
NEW-481
NEW-482
NEW-483
NEW-484
NEW-485
NEW-486
NEW-487
NEW-488
NEW-489
NEW-490
NEW-491
NEW-492
NEW-493
NEW-494
NEW-495
NEW-496
NEW-497
NEW-498
NEW-499
NEW-500
NEW-501
NEW-502
NEW-503
NEW-504
NEW-505
NEW-506
NEW-507
NEW-508
NEW-509
NEW-510
NEW-511
NEW-512
NEW-513
NEW-514
NEW-515
NEW-516
NEW-517
NEW-518
NEW-519
NEW-520
NEW-521
NEW-522
NEW-523
NEW-524
NEW-525
NEW-526
NEW-527
NEW-528
NEW-529
NEW-530
NEW-531
NEW-532
NEW-533
NEW-534
NEW-535
NEW-536
NEW-537
NEW-538
NEW-539
NEW-540
NEW-541
NEW-542
NEW-543
NEW-544
NEW-545
NEW-546
NEW-547
NEW-548
NEW-549
NEW-550
NEW-551
NEW-552
NEW-553
NEW-554
NEW-555
NEW-556
NEW-557
NEW-558
NEW-559
NEW-560
NEW-561
NEW-562
NEW-563
NEW-564
NEW-565
NEW-566
NEW-567
NEW-568
NEW-569
NEW-570
NEW-571
NEW-572
NEW-573
NEW-574
NEW-575
NEW-576
NEW-577
NEW-578
NEW-579
NEW-580
NEW-581
NEW-582
NEW-583
NEW-584
NEW-585
NEW-586
NEW-587
NEW-588
NEW-589
NEW-590
NEW-591
NEW-592
NEW-593
NEW-594
NEW-595
NEW-596
NEW-597
NEW-598
NEW-599
NEW-600
NEW-601
NEW-602
NEW-603
NEW-604
NEW-605
NEW-606
NEW-607
NEW-608
NEW-609
NEW-610
NEW-611
NEW-612
NEW-613
NEW-614
NEW-615
NEW-616
NEW-617
NEW-618
NEW-619
NEW-620
NEW-621
NEW-622
NEW-623
NEW-624
NEW-625
NEW-626
NEW-627
NEW-628
NEW-629
NEW-630
NEW-631
NEW-632
NEW-633
NEW-634
NEW-635
NEW-636
NEW-637
NEW-638
NEW-639
NEW-640
NEW-641
NEW-642
NEW-643
NEW-644
NEW-645
NEW-646
NEW-647
NEW-648
NEW-649
NEW-650
NEW-651
NEW-652
NEW-653
NEW-654
NEW-655
NEW-656
NEW-657
NEW-658
NEW-659
NEW-660
NEW-661
NEW-662
NEW-663
NEW-664
NEW-665
NEW-666
NEW-667
NEW-668
NEW-669
NEW-670
NEW-671
NEW-672
NEW-673
NEW-674
NEW-675
NEW-676
NEW-677
NEW-678
NEW-679
NEW-680
NEW-681
NEW-682
NEW-683
NEW-684
NEW-685
NEW-686
NEW-687
NEW-688
NEW-689
NEW-690
NEW-691
NEW-692
NEW-693
NEW-694
NEW-695
NEW-696
NEW-697
NEW-698
NEW-699
NEW-700
NEW-701
NEW-702
NEW-703
NEW-704
NEW-705
NEW-706
NEW-707
NEW-708
NEW-709
NEW-710
NEW-711
NEW-712
NEW-713
NEW-714
NEW-715
NEW-716
NEW-717
NEW-718

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .