47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 PWS Exhibit 16 NCMMS Asset Audit Tool Murphy 2023 12 12.xlsx

XLSX spreadsheet 5 MB Posted

Attached to
Murphy Federal Records Center, Waltham, MA, O&M RFQ, Amendment #6
Solicitation number
47PB0024Q0001
Issued by

About this file

Written by GovTribe AI ·

This is a request for quotation (RFQ) amendment for operations and maintenance (O&M) services at the Murphy Federal Records Center in Waltham, Massachusetts. The General Services Administration Public Buildings Service Region 1 is seeking these services. The RFQ requires the contractor to provide facility operations and maintenance, including asset inventory and preventative maintenance auditing, for the records center. The contractor will be responsible for facility operations and maintenance services, maintaining accurate asset and preventative maintenance records in the NCMMS system, and conducting monthly audits to evaluate data accuracy and completeness. Pricing terms, response dates, and other contract details are not provided in this file.

View the file

Other files

File Type Posted
47PB0024Q0001 RFQ Amendment 06 Attach 01 Solicitation Changes Summary 2024 01 02.docx DOCX document
47PB0024Q0001 RFQ Amendment 06 Attach 03 SF1449 Contract Form 2024 01 02.pdf PDF
47PB0024Q0001 RFQ Amendment 06 2024 01 02.pdf PDF
47PB0024Q0001 RFQ Amendment 06 Attach 04 Performance Work Statement 2024 01 02.pdf PDF
47PB0024Q0001 RFQ Amendment 06 Attach 02 Request for Quote 2024 01 02.docx DOCX document
47PB0024Q0001 RFQ Amendment 06 Attach 04 Performance Work Statement 2024 01 02.docx DOCX document
47PB0024Q0001 RFQ Amendment 05 SF30 Amendment Form 2023 12 24.pdf PDF
47PB0024Q0001 RFQ Amendment 04 SF30 Amendment Form 2023 12 23.pdf PDF
47PB0024Q0001 RFQ Amendment 04 Attach 01 Solicitation Changes Summary 2023 12 23.docx DOCX document
47PB0024Q0001 RFQ Amendment 04 Attach 02 Request for Quote 2023 12 23.docx DOCX document
47PB0024Q0001 RFQ Amendment 04 Attach 04 Electronic Offer Sheet 2023 12 23 Protected.xlsx XLSX spreadsheet
47PB0024Q0001 RFQ Amendment 04 Attach 03 SF1449 2023 12 23.pdf PDF
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 Performance Work Statement 2023 12 22.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 Pre-Quote Conference and Site Visit Minutes 2023 11 21.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 Questions and Answers 2023 12 22.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 SF30 Amendment Form 2023 12 22.pdf PDF
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 PWS Exhibit 17 GSA Order PBS 1000.7A Drinking Water Quality Management.pdf PDF
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 PWS Exhibit 19 Water Sampling and Flushing Record Keeping Template.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 PWS Exhibit 18 PBS Guidance to Maintain or Restore Water Quality.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 Request for Quote 2023 12 22.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 Performance Work Statement 2023 12 22.pdf PDF
47PB0024Q0001 RFQ Amendment 03 PWS Changes Summary 2023 12 22.docx DOCX document
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 PWS Exhibit 15 NCMMS Asset Audit Tool Presentation.pptx PPTX presentation
47PB0024Q0001 RFQ Amendment 03 Pre-Quote Conference Presentation 2023 11 20.pptx PPTX presentation
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 05 Electronic Offer Sheet 2023 12 22 Protected.xlsx XLSX spreadsheet
47PB0024Q0001 RFQ Amendment 03 Pre-Quote Conference Sign-in Sheet 2023 11 21 Signed.pdf PDF
47PB0024Q0001 RFQ Amendment 03 RFQ Attach 07 PWS Exhibit 20 KPI Calculations Sample 2023 12 15.xlsx XLSX spreadsheet
47PB0024Q0001 RFQ Amendment 02 2023 12 15.pdf PDF
47PB0024Q0001 RFQ Amendment 02 Attach 01 Request For Quote 2023 12 15.docx DOCX document
47PB0024Q0001 RFQ Amendment 02 Attach 02 SF1449 2023 12 15.pdf PDF
47PB0024Q0001 RFQ Amendment 02 Attach 01 Request For Quote 2023 12 15.pdf PDF
47PB0024Q0001 RFQ Amendment 01 Attach 01 RFQ Attach 04 SF1449 Contract Form 2023 11 16.pdf PDF
47PB0024Q0001 RFQ Amendment 01 SF-30 Amendment Form 2023 11 16.pdf PDF
47PB0024Q0001 Request For Quote Attach 06 GSA Form 527 2021 10.pdf PDF
47PB0024Q0001 Request For Quote Attach 04 SF1449 Contract Form.pdf PDF
47PB0024Q0001 Request For Quote Attach 07 Performance Work Statement 2023 11 15.pdf PDF
47PB0024Q0001 Request For Quote 2023 11 15.docx DOCX document
47PB0024Q0001 Request For Quote Attach 03 Wage Determination 2015-4017 Revision 20 2023 06 30.pdf PDF
47PB0024Q0001 Request For Quote 2023 11 15.pdf PDF
47PB0024Q0001 Request For Quote Appendix A - Past Performance Questionnaire 2023 11 15.docx DOCX document
47PB0024Q0001 Request For Quote Attach 02 FAR GSAM Provisions 2023 11 15.docx DOCX document
47PB0024Q0001 Request For Quote Attach 01 Quote Checklist Coversheet 2023 11 15.docx DOCX document
47PB0024Q0001 Request For Quote Appendix B - Self-Certification Statement 2023 11 15.docx DOCX document
47PB0024Q0001 Request For Quote Attach 05 Electronic Offer Sheet 2023 11 15 Protected.xlsx XLSX spreadsheet
47PB0024Q0001 Request For Quote Attach 07 Performance Work Statement 2023 11 15.docx DOCX document
Show all 45

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

R5 Level 1 Asset Inventory & PM Audit - BackgroundAudit Summary TabSelf Audit Instructions
"Background - In order to ensure compliance with existing asset inventory data management service contract and GSA policy requirements, the R5 NCMMS Support Team has developed an R5 Asset Inventory Audit Program. This program assists property management field offices, contracting officers, etc. by providing a standardized process for evaluating the accuracy and completeness of asset inventories, preventive maintenance plans/schedules, and work orders. It also helps with managing/organizing the data, as well track progress and improvement made over time (performance periods).

A Level 1 Asset Inventory & PM Audit is a building specific desk audit of contract required asset & preventive maintenance information within NCMMS. The audit evaluates the accuracy and completeness of asset records in the system and highlights basic data discrepancies, such as omissions, and or duplications. The audit also evaluates the preventive maintenance program, assessing whether or not preventive maintenance is required for an asset, and if job plans are set up properly so that work orders may be generated.

Audit Scope - Level 1 Audits are limited in nature and consist of an evaluation of the data in NCMMS at the time of the audit. The Audits are conducted by downloading four specific reports from NCMMS and copy and pasting the data onto this tool. This tool performs a series of queries and calculations and then provides a summary within the Audit Summary Tab. Level 1 Audits do not have an on-site visual verification or validation component.

Applicability - All GSA owned buildings with maintainable and repairable assets are subject to audit.

Frequency - Audits are run on the 1st Monday every month via an automated process. Level 1 audits are recommended at the start of each new contract in order to establish a baseline to measure contractor progress at key milestone dates, such as contract anniversary, and contract close outs.

Record Keeping/Documentation - It is recommended that a copy of the baseline Asset Inventory Report and baseline Level 1 Audit be accepted by the contractor (signed and dated) and filed in the COR file for the record. It is also recommended that a copy be shared with the Contracting Officer.

Audit Data FieldsDescriptionA link to instructions for downloading required reports can be found below.
Asset TotalCount of all asset records.Instructions
Unique Asset TypesCount of unique asset types included in building inventory.
Latest UpdateDate any asset record was modified as of the date of the report.
Assets in "Operating" StatusCount of asset records in Operating status.
Assets in "Non-Operating" StatusCount of asset records not in Operating status
Excluded AssetsCount of asset records in Excluded status (typically BAS equipment)Asset List Score
Quantity Field = ZeroCount of asset records with a quantity of zero. Listed assets must have a value greater than 1.The Asset List score is an average of the minimally required fields and asset type review scores and rounded to the nearest whole number. Fractions more than .5 are rounded up; fractions less than .5 are rounded down. For the purposes of this audit, each mininally required data point is weighted the same.

Manufacturer Field Blank Count of asset records without Manufacturer data provided. Manufacturer data is listed as minimally required. If not available at contract start contractors must collect and update during the period of performance.

Model No. Field BlankCount of asset records without Model Number data provided. Model Number data is listed as minimally required. If not available at contract start contractors must collect and update during the period of performance.PM Schedule/Plan Score
The PM Schedule/Plan score is a sum of four values that represent a count of Operating Assets either linked to a Route, set as Run to Fail, or linked to at least one Active PM Record with a current Estimated Next Due Date, or Extended Date relative to audit date. Fractions more than .5 are rounded up; fractions less than .5 are rounded down. For the purposes of this audit, each minimally required data point is weighted the same.
Serial No. Field BlankCount of asset records without Serial Number data provided. Serial Number data is listed as minimally required. If not available at contract start contractors must collect and update during the period of performance.

Serial No. Not Unique Count of assets with duplicate serial numbers. Serial numbers should be unique.

Asset Type Review Tab
Minimally Required Asset Types ListedCount of typical equipment found in commercial real estate buildings by asset type.
Asset Year Field BlankCount of asset records with no Asset Year (yyyy format) data provided. The asset year is the year the asset was manufactured.The Asset Type Review compares the asset inventory against an established listing of asset type categories typically found in GSA properties. This review is intended to highlight omissions of entire asset types or categories. The asset type review score (C22) is the percentage of asset types listed out of the ~40 asset types identified as typically found in GSA Properties.

Field Offices should review column C in the Asset Type Review tab to determine whether any of the 40 asset types do not apply for a given building. Removing asset types that don't apply improves Asset Score. Contact the NCMMS team to have your building specific audit tool updated.

Manufacturer Year Field BlankCount of asset records with no Manufacture Date provided. The Manufacturer Year is the date (mm/dd/yyyy format) the asset was manufactured. Required by GSA Usage Policy.
Installation Date Field BlankCount of assets with no Installation date (mm/dd/yyyy format) provided. Required by GSA Usage Policy.
Warranty Expiration Date Field BlankCount of assets with no Warranty Expiration date (mm/dd/yyyy format) provided. Required in R5 for new construction assets. Required by GSA Usage Policy.
Estimated End of Life Field BlankCount of assets with no Estimated End of Life date (mm/dd/yyyy format) provided. Required in R5 for new construction assets. Required by GSA Usage Policy.

https://docs.google.com/presentation/d/1cAlXzdYQEmNwndiaOUk13zkT32Au_hOseq-eiFX4zOg/edit Audit Summary

- R5 Level 1 Asset Inventory & PM Plan Audit Tool - 12/12/2023
Asset List ScorePM Plan/Schedule Score
61%94%
Basic Asset Inventory InfoOperating Assets w/ Active & Current PMs, Routes, or Run to FailCountScore
Audit Date12/12/2023Total PM/Asset Record Lines339-
Unique Asset Lines221Operating Assets w/ Active PMs w/ Current Next Due Dates or RTF19594.20%Percentage equals sub categories
Unique Asset Types69Operating Assets w/Active PMs (no routes, no RTF)13665.70%94.20%
Latest Update to Asset Record11/21/2023Operating Assets marked RTF without Active PMs83.86%
Auditor Name:Jean PierreOperating Assets on only Routes (no Active Asset PMs or RTF)5124.64%
Operating Assets w/Active PM and on Route w/ Active PM00.00%
Assets by Status
Assets in "Operating" Status207Assets with PMs that Require Corrective ActionCorrective ActionCountAsset listModifiedOriginal
Assets in Non Operating Status14Operating Assets without PM, no Route, nor RTFb.5LinkAll Operating Assets Accounted For10
Excluded Assets0Operating Assets not on Routes with Active PM Dates in the Pastc.020710
Operating Asset, on Route, and Route has no Active PMb.7Link0216
Minimally Required FieldsCountScoreCorrective ActionAsset ListOperating Assets with Active PM and Marked RTFd.000
Quantity Field = Zero598%a.LinkOperating Assets with route and RTFd.051
Manufacturer Field Blank11644%b. f.LinkOperating Assets with Correct Route PM but Asset PM in the Pastb.0
Model No. Field Blank13336%c. f.LinkAssets with PMs that May Require Corrective ActionCorrective ActionCountAsset listTypes PresentMissing?
Serial No. Field Blank14829%d. f.LinkOperating Assets w/ Active PM and on Route w/ Active PMa.0Air Compressors0
Serial No. Not Unique1991%e.LinkAir Handlers0
Missing Typical Asset Categories1171%g.See TablePM Corrective ActionBackflows0
Installation Date Field Blank1984%h.a. Review stand alone PM records and Routes and verify if both are needed.BAS Devices0
Warranty Expiration Date Field Blank2051%i.b. Link Assets to Active PM records, add to a Route with an Active PM, or identify as Run to Fail.Boilers0
Estimated End of Life Field Blank15426%j.c. Ensure PM Record has a current Estimated Next Due Date or Extended Date.Child Care - Changing Stations1
Manufacturer Date Field Blank2060%k.d. Either make the PM inactive or uncheck the RTF box on the asset.Chillers0
Doors0
Asset Corrective ActionMissing Typical Asset TypesElec - Circuit Breakers1
a. Update asset records within NCMMS to reflect accurate Quantities.Child Care - Changing StationsElec - Motor Control Centers0
b. Select Manufacturer from directory in NCMMS, if not listed, submit request to add manufacturer.Elec - Circuit BreakersElec - Motors0
c. Enter Model number within NCMMS.Elec - Switches/DisconnectsElec - Switches/Disconnects1
d. Enter Serial number within NCMMS.Elec - TransformersElec - Switchgear and Panels0
e. Ensure asset serial numbers are unique for similar types of assets.Elec - VFDs (>5HP)Elec - Transformers1
f. Enter either "No Data Plate", "Not Accessible", "Not Legible" as appropriate.Exit SignsElec - VFDs (>5HP)1
g. Review Asset Type Review Tab, update Column C to No if an asset does not apply to building.Eye Wash/Shower UnitEmergency Lighting0
h. Enter date asset was originally installed. If exact date unknown, use 1/01/YYYY format.Flag PolesExit Signs1
i. Enter date that the asset warranty expires.IrrigationExpansion Tanks0
j. Enter estimated date that the asset will have exceed its useful life.Water FiltersEye Wash/Shower Unit1
k. Enter year that the asset was manufactured.Water SoftenerFans0
Filters (Air)0
Fire Alarms0
Fire and Smoke Dampers0
Fire Doors0
Fire Extinguishers0
Fire Suppression0
Flag Poles1
Irrigation1
Lighting0
Manholes0
Pumps0
Roof0
Roof Drains0
Sump Pumps0
Water Filters1
Water Heaters0
Water Softener1
Water Treatment0

Control

Region >>>>>>>>>>>>>>>>>>01Do Not Edit These Columns
MA0136ZZQuantity 0 URLhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=STATUS%3D%27OPERATING%27%20AND%20SADDRESSCODE%20LIKE%20%27%27%20AND%20GSAQUANTITY%3C1&forcereload=true
Inventory Level >>>>>>>>>>>>Where ClauseSTATUS='OPERATING' and SADDRESSCODE like '' and GSAQUANTITY<1
Enter Audit Date Here >>>>>>>12/12/2023URL ConversionSTATUS%3D%27OPERATING%27%20and%20SADDRESSCODE%20like%20%27%27%20and%20GSAQUANTITY%3C1
Enter Auditor's Name Here >>>Jean PierreNo Manufacturer URLhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=STATUS%3D%27OPERATING%27%20AND%20SADDRESSCODE%20LIKE%20%27%27%20AND%20MANUFACTURER%20IS%20NULL&forcereload=true
Where ClauseSTATUS='OPERATING' and SADDRESSCODE like '' and MANUFACTURER is null
URL ConversionSTATUS%3D%27OPERATING%27%20and%20SADDRESSCODE%20like%20%27%27%20and%20MANUFACTURER%20is%20null
No Model URLhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=STATUS%3D%27OPERATING%27%20AND%20SADDRESSCODE%20LIKE%20%27%27%20AND%20GSAMODELNO%20IS%20NULL&forcereload=true
Where ClauseSTATUS='OPERATING' and SADDRESSCODE like '' and GSAMODELNO is null
URL ConversionSTATUS%3D%27OPERATING%27%20and%20SADDRESSCODE%20like%20%27%27%20and%20GSAMODELNO%20is%20null
No Serial Number URLhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=STATUS%3D%27OPERATING%27%20AND%20SADDRESSCODE%20LIKE%20%27%27%20AND%20SERIALNUM%20IS%20NULL&forcereload=true
Where ClauseSTATUS='OPERATING' and SADDRESSCODE like '' and SERIALNUM is null
URL ConversionSTATUS%3D%27OPERATING%27%20and%20SADDRESSCODE%20like%20%27%27%20and%20SERIALNUM%20is%20null
Serial Number Not Unique URLhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=SADDRESSCODE%20LIKE%20%27%27%20AND%20STATUS%3D%27OPERATING%27%20AND%20SERIALNUM%20IS%20NOT%20NULL%20AND%20UPPER%28SERIALNUM%29%20NOT%20IN%20%28%27NO%20DATA%20PLATE%27,%27NOT%20ACCESSIBLE%27,%27NOT%20LEGIBLE%27%29%20AND%20SERIALNUM%20IN%20%28SELECT%20SERIALNUM%20FROM%20ASSET%20GROUP%20BY%20SERIALNUM,%20SADDRESSCODE%20HAVING%20COUNT%28*%29%20%3E%201%29&forcereload=true
Where ClauseSADDRESSCODE like '' and STATUS='OPERATING' and serialnum is not null and upper(serialnum) not in ('NO DATA PLATE','NOT ACCESSIBLE','NOT LEGIBLE') and serialnum in (select serialnum from asset group by serialnum, saddresscode having count(*) > 1)
URL ConversionSADDRESSCODE%20like%20%27%27%20and%20STATUS%3D%27OPERATING%27%20and%20serialnum%20is%20not%20null%20and%20upper%28serialnum%29%20not%20in%20%28%27NO%20DATA%20PLATE%27,%27NOT%20ACCESSIBLE%27,%27NOT%20LEGIBLE%27%29%20and%20serialnum%20in%20%28select%20serialnum%20from%20asset%20group%20by%20serialnum,%20saddresscode%20having%20count%28*%29%20%3E%201%29
Operating Assets without PM, no Route, nor RTFhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=%28%28%28%28ASSET.STATUS%20%3D%20%27OPERATING%27%29%20AND%20ASSET.GSARCMRUNTOFAIL%20%3D%200%20AND%20SADDRESSCODE%20LIKE%20%27%27%29%20AND%20%28%20ASSET.ASSETNUM%20NOT%20IN%20%28SELECT%20ASSETNUM%20FROM%20PM%20WHERE%20STATUS%3D%27ACTIVE%27%20AND%20ASSETNUM%20IS%20NOT%20NULL%29%20AND%20ASSET.ASSETNUM%20NOT%20IN%20%28SELECT%20ASSETNUM%20FROM%20ROUTE_STOP%20WHERE%20ASSETNUM%20IS%20NOT%20NULL%29%29%29%29%20AND%20ASSETTYPE%20NOT%20LIKE%20%27ELV%25%27%20AND%20ASSETTYPE%20NOT%20LIKE%20%20%27ESC%25%27%20AND%20ASSETTYPE%20NOT%20LIKE%20%27WLF%25%27&forcereload=true
Where Clause((((asset.status = 'OPERATING') and asset.gsarcmruntofail = 0 and SADDRESSCODE like '') and ( asset.assetnum not in (select assetnum from pm where status='ACTIVE' and assetnum is not null) and asset.assetnum not in (select assetnum from route_stop where assetnum is not null)))) and assettype not like 'elv%' and assettype not like 'esc%' and assettype not like 'wlf%'
URL Conversion%28%28%28%28asset.status%20%3D%20%27OPERATING%27%29%20and%20asset.gsarcmruntofail%20%3D%200%20and%20SADDRESSCODE%20like%20%27%27%29%20and%20%28%20asset.assetnum%20not%20in%20%28select%20assetnum%20from%20pm%20where%20status%3D%27ACTIVE%27%20and%20assetnum%20is%20not%20null%29%20and%20asset.assetnum%20not%20in%20%28select%20assetnum%20from%20route_stop%20where%20assetnum%20is%20not%20null%29%29%29%29%20and%20assettype%20not%20like%20%27elv%25%27%20and%20assettype%20not%20like%20%20%27esc%25%27%20and%20assettype%20not%20like%20%27wlf%25%27
Operating Assets not on Routes with Active PM Dates in the Pasthttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=SADDRESSCODE%20LIKE%20%27%27%20AND%20ASSET.STATUS%20%3D%20%27OPERATING%27%20AND%20ASSET.GSARCMRUNTOFAIL%20%3D%200%20AND%20ASSETTYPE%20NOT%20LIKE%20%27%25ELV%25%27%20AND%20ASSETTYPE%20NOT%20LIKE%20%27ESC%25%27%20AND%20ASSETTYPE%20NOT%20LIKE%20%27WLF%25%27%20AND%20ASSETNUM%20IN%20%28SELECT%20ASSETNUM%20FROM%20PM%20WHERE%20ASSETNUM%20IS%20NOT%20NULL%20AND%20STATUS%3D%27ACTIVE%27%20AND%20%28%28PM.NEXTDATE%20%3C%20SYSDATE%20AND%20EXTDATE%20IS%20NULL%29%20OR%20%28PM.EXTDATE%20%3C%20SYSDATE%20AND%20ADJNEXTDUE%20%3D1%29%29%20AND%20PMNUM%20NOT%20IN%20%28SELECT%20PMNUM%20FROM%20PMSEASONS%20WHERE%20PMNUM%20IS%20NOT%20NULL%20AND%20SITEID%3D%2701%27%29%29%20AND%20ASSETNUM%20NOT%20IN%20%28SELECT%20ASSETNUM%20FROM%20ROUTE_STOP%20WHERE%20ASSETNUM%20IS%20NOT%20NULL%29&forcereload=true
Where ClauseSADDRESSCODE like '' and asset.status = 'OPERATING' and asset.gsarcmruntofail = 0 and assettype not like '%ELV%' and assettype not like 'ESC%' and assettype not like 'WLF%' and assetnum in (select assetnum from pm where assetnum is not null and status='ACTIVE' and ((pm.nextdate < sysdate and extdate is null) or (pm.extdate < sysdate and adjnextdue =1)) and pmnum not in (select pmnum from pmseasons where pmnum is not null and siteid='01')) and assetnum not in (select assetnum from route_stop where assetnum is not null)
URL ConversionSADDRESSCODE%20like%20%27%27%20and%20asset.status%20%3D%20%27OPERATING%27%20and%20asset.gsarcmruntofail%20%3D%200%20and%20assettype%20not%20like%20%27%25ELV%25%27%20and%20assettype%20not%20like%20%27ESC%25%27%20and%20assettype%20not%20like%20%27WLF%25%27%20and%20assetnum%20in%20%28select%20assetnum%20from%20pm%20where%20assetnum%20is%20not%20null%20and%20status%3D%27ACTIVE%27%20and%20%28%28pm.nextdate%20%3C%20sysdate%20and%20extdate%20is%20null%29%20or%20%28pm.extdate%20%3C%20sysdate%20and%20adjnextdue%20%3D1%29%29%20and%20pmnum%20not%20in%20%28select%20pmnum%20from%20pmseasons%20where%20pmnum%20is%20not%20null%20and%20siteid%3D%2701%27%29%29%20and%20assetnum%20not%20in%20%28select%20assetnum%20from%20route_stop%20where%20assetnum%20is%20not%20null%29
Operating Asset, on Route, and Route has no Active PMhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=%28ASSET.STATUS%20%3D%20%27OPERATING%27%20AND%20SADDRESSCODE%20LIKE%20%27%27%20AND%20ASSET.GSARCMRUNTOFAIL%20%3D%20%270%27%20AND%20%28ASSETTYPE%20NOT%20LIKE%20%27%25ELV%25%27%29%20AND%20%28ASSETTYPE%20NOT%20LIKE%20%27%25ESC%25%27%29%20AND%20%28ASSETTYPE%20NOT%20LIKE%20%27%25WLF%25%27%29%29%20%20AND%20%28%28ASSET.ASSETNUM%20IN%20%28SELECT%20ROUTE_STOP.ASSETNUM%20FROM%20ROUTE_STOP%20WHERE%20ASSETNUM%20IS%20NOT%20NULL%20AND%20SITEID%3D%2701%27%29%29%20AND%20%28ASSET.ASSETNUM%20NOT%20IN%20%28SELECT%20ROUTE_STOP.ASSETNUM%20FROM%20PM%20INNER%20JOIN%20ROUTE_STOP%20ON%20PM.ROUTE%20%3D%20ROUTE_STOP.ROUTE%20WHERE%20PM.STATUS%20%3D%20%27ACTIVE%27%20AND%20ROUTE_STOP.ASSETNUM%20IS%20NOT%20NULL%29%29%29&forcereload=true
Where Clause(asset.status = 'OPERATING' and saddresscode like '' and asset.gsarcmruntofail = '0' and (assettype not like '%ELV%') and (assettype not like '%ESC%') and (assettype not like '%WLF%')) and ((asset.assetnum in (select route_stop.assetnum from route_stop where assetnum is not null and siteid='01')) and (asset.assetnum not in (select route_stop.assetnum from pm inner join route_stop on pm.route = route_stop.route where pm.status = 'ACTIVE' and route_stop.assetnum is not null)))
URL Conversion%28asset.status%20%3D%20%27OPERATING%27%20and%20saddresscode%20like%20%27%27%20and%20asset.gsarcmruntofail%20%3D%20%270%27%20and%20%28assettype%20not%20like%20%27%25ELV%25%27%29%20and%20%28assettype%20not%20like%20%27%25ESC%25%27%29%20and%20%28assettype%20not%20like%20%27%25WLF%25%27%29%29%20%20and%20%28%28asset.assetnum%20in%20%28select%20route_stop.assetnum%20from%20route_stop%20where%20assetnum%20is%20not%20null%20and%20siteid%3D%2701%27%29%29%20and%20%28asset.assetnum%20not%20in%20%28select%20route_stop.assetnum%20from%20pm%20inner%20join%20route_stop%20on%20pm.route%20%3D%20route_stop.route%20where%20pm.status%20%3D%20%27ACTIVE%27%20and%20route_stop.assetnum%20is%20not%20null%29%29%29
Operating Assets with Active PM and Marked RTFhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=ASSET.STATUS%20%3D%20%27OPERATING%27%20AND%20SADDRESSCODE%20LIKE%20%27%27%20AND%20GSARCMRUNTOFAIL%3D1%20AND%20%28ASSETNUM%20%20IN%20%28SELECT%20ASSETNUM%20FROM%20PM%20WHERE%20STATUS%3D%27ACTIVE%27%20AND%20ASSETNUM%20IS%20NOT%20NULL%20AND%20PM.SITEID%3D%2701%27%29%29&forcereload=true
Where Clauseasset.status = 'OPERATING' and saddresscode like '' and gsarcmruntofail=1 and (assetnum in (select assetnum from pm where status='ACTIVE' and assetnum is not null and pm.siteid='01'))
URL Conversionasset.status%20%3D%20%27OPERATING%27%20and%20saddresscode%20like%20%27%27%20and%20gsarcmruntofail%3D1%20and%20%28assetnum%20%20in%20%28select%20assetnum%20from%20pm%20where%20status%3D%27ACTIVE%27%20and%20assetnum%20is%20not%20null%20and%20pm.siteid%3D%2701%27%29%29
Operating Assets with route and RTFhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=%28ASSET.STATUS%20%3D%20%27OPERATING%27%20AND%20ASSET.GSARCMRUNTOFAIL%20%3D%201%20AND%20SADDRESSCODE%20LIKE%20%27%27%29%20AND%20%28ASSET.ASSETNUM%20IN%20%28SELECT%20ASSETNUM%20FROM%20ROUTE_STOP%20WHERE%20ASSETNUM%20IS%20NOT%20NULL%20AND%20ROUTE_STOP.SITEID%3D%2701%27%29%29%20AND%20UPPER%28ASSETTYPE%29%20NOT%20LIKE%20%27ELV%25%27%20AND%20ASSETTYPE%20NOT%20LIKE%20%27ESC%25%27%20AND%20ASSETTYPE%20NOT%20LIKE%20%27WLF%25%27&forcereload=true
Where Clause(asset.status = 'OPERATING' and asset.gsarcmruntofail = 1 and SADDRESSCODE like '') and (asset.assetnum in (select assetnum from route_stop where assetnum is not null and route_stop.siteid='01')) and upper(assettype) not like 'ELV%' and assettype not like 'ESC%' and assettype not like 'WLF%'
URL Conversion%28asset.status%20%3D%20%27OPERATING%27%20and%20asset.gsarcmruntofail%20%3D%201%20and%20SADDRESSCODE%20like%20%27%27%29%20and%20%28asset.assetnum%20in%20%28select%20assetnum%20from%20route_stop%20where%20assetnum%20is%20not%20null%20and%20route_stop.siteid%3D%2701%27%29%29%20and%20upper%28assettype%29%20not%20like%20%27ELV%25%27%20and%20assettype%20not%20like%20%27ESC%25%27%20and%20assettype%20not%20like%20%27WLF%25%27
Operating Assets with Correct Route PM but Asset PM in the Pasthttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=%28SADDRESSCODE%20LIKE%20%27%27%29%20AND%20%28ASSET.STATUS%20%3D%20%27OPERATING%27%20AND%20ASSET.GSARCMRUNTOFAIL%20%3D%20%270%27%29%20AND%20%28ASSETTYPE%20NOT%20LIKE%20%27%25ELV%25%27%29%20AND%20%28ASSETTYPE%20NOT%20LIKE%20%27%25ESC%25%27%29%20AND%20%28ASSETTYPE%20NOT%20LIKE%20%27%25WLF%25%27%29%20AND%20%28%28ASSET.ASSETNUM%20IN%20%28SELECT%20PM.ASSETNUM%20FROM%20PM%20WHERE%20PM.ASSETNUM%20IS%20NOT%20NULL%20AND%20PM.SITEID%3D%2701%27%20AND%20PM.STATUS%3D%27ACTIVE%27%20AND%20%28%28PM.NEXTDATE%20%3C%3D%20SYSDATE%20AND%20ADJNEXTDUE%20%3D%200%29%20OR%20PM.EXTDATE%20%3C%3D%20SYSDATE%20AND%20ADJNEXTDUE%20%3D%201%29%29%29%20AND%20%28ASSET.ASSETNUM%20IN%20%28SELECT%20ROUTE_STOP.ASSETNUM%20FROM%20PM%20INNER%20JOIN%20ROUTE_STOP%20ON%20PM.ROUTE%20%3D%20ROUTE_STOP.ROUTE%20WHERE%20PM.STATUS%20%3D%20%27ACTIVE%27%20AND%20PM.SITEID%3D%2701%27%20AND%20ROUTE_STOP.ASSETNUM%20IS%20NOT%20NULL%20AND%20%28PM.NEXTDATE%20%3E%20SYSDATE%20OR%20PM.EXTDATE%20%3E%20SYSDATE%29%29%29%29&forcereload=true
Where Clause(SADDRESSCODE like '') and (asset.status = 'OPERATING' and asset.gsarcmruntofail = '0') and (assettype not like '%ELV%') and (assettype not like '%ESC%') and (assettype not like '%WLF%') and ((asset.assetnum in (select pm.assetnum from pm where pm.assetnum is not null and pm.siteid='01' and pm.status='ACTIVE' and ((pm.nextdate <= sysdate and adjnextdue = 0) or pm.extdate <= sysdate and adjnextdue = 1))) and (asset.assetnum in (select route_stop.assetnum from pm inner join route_stop on pm.route = route_stop.route where pm.status = 'ACTIVE' and pm.siteid='01' and route_stop.assetnum is not null and (pm.nextdate > sysdate or pm.extdate > sysdate))))
URL Conversion%28SADDRESSCODE%20like%20%27%27%29%20and%20%28asset.status%20%3D%20%27OPERATING%27%20and%20asset.gsarcmruntofail%20%3D%20%270%27%29%20and%20%28assettype%20not%20like%20%27%25ELV%25%27%29%20and%20%28assettype%20not%20like%20%27%25ESC%25%27%29%20and%20%28assettype%20not%20like%20%27%25WLF%25%27%29%20and%20%28%28asset.assetnum%20in%20%28select%20pm.assetnum%20from%20pm%20where%20pm.assetnum%20is%20not%20null%20and%20pm.siteid%3D%2701%27%20and%20pm.status%3D%27ACTIVE%27%20and%20%28%28pm.nextdate%20%3C%3D%20sysdate%20and%20adjnextdue%20%3D%200%29%20or%20pm.extdate%20%3C%3D%20sysdate%20and%20adjnextdue%20%3D%201%29%29%29%20and%20%28asset.assetnum%20in%20%28select%20route_stop.assetnum%20from%20pm%20inner%20join%20route_stop%20on%20pm.route%20%3D%20route_stop.route%20where%20pm.status%20%3D%20%27ACTIVE%27%20and%20pm.siteid%3D%2701%27%20and%20route_stop.assetnum%20is%20not%20null%20and%20%28pm.nextdate%20%3E%20sysdate%20or%20pm.extdate%20%3E%20sysdate%29%29%29%29
Operating Assets w/ Active PM and on Route w/ Active PMhttps://gsa.ncmms.com/maximo/ui/?event=loadapp&value=asset&additionalevent=sqlwhere&additionaleventvalue=%28ASSET.STATUS%20%20%3D%20%20%27OPERATING%27%20AND%20ASSET.SITEID%20%3D%20%2701%27%20AND%20ASSET.GSARCMRUNTOFAIL%3D0%20AND%20SADDRESSCODE%20%3D%20%29%20AND%20%28ASSET.ASSETNUM%20IN%20%28SELECT%20ASSETNUM%20FROM%20PM%20WHERE%20STATUS%3D%27ACTIVE%27%20AND%20ASSETNUM%20IS%20NOT%20NULL%29%29%20AND%20%28ASSET.ASSETNUM%20IN%20%28SELECT%20ASSETNUM%20FROM%20ROUTE_STOP%20WHERE%20ASSETNUM%20IS%20NOT%20NULL%20AND%20ROUTE%20IN%20%28SELECT%20ROUTE%20FROM%20MAXIMO.PM%20WHERE%20STATUS%3D%27ACTIVE%27%20AND%20ROUTE%20IS%20NOT%20NULL%29%29%29&forcereload=true
Where Clause(asset.status = 'OPERATING' and asset.siteid = '01' and asset.gsarcmruntofail=0 and saddresscode = ) and (asset.assetnum in (select assetnum from pm where status='ACTIVE' and assetnum is not null)) and (asset.assetnum in (select assetnum from route_stop where assetnum is not null and route in (select route from maximo.pm where status='ACTIVE' and route is not null)))
URL Conversion%28asset.status%20%20%3D%20%20%27OPERATING%27%20and%20asset.siteid%20%3D%20%2701%27%20and%20asset.gsarcmruntofail%3D0%20and%20saddresscode%20%3D%20%29%20and%20%28asset.assetnum%20in%20%28select%20assetnum%20from%20pm%20where%20status%3D%27ACTIVE%27%20and%20assetnum%20is%20not%20null%29%29%20and%20%28asset.assetnum%20in%20%28select%20assetnum%20from%20route_stop%20where%20assetnum%20is%20not%20null%20and%20route%20in%20%28select%20route%20from%20maximo.pm%20where%20status%3D%27ACTIVE%27%20and%20route%20is%20not%20null%29%29%29

Asset Report

Asset NumberAsset DescriptionEquipment IDQuantityAsset TagAsset TypeManufacturerModelSerial #Asset YearManufacture YearInstallation DateWarranty Expiration DateExpected LifeESPC?Service CenterService AddressStatusLast Changed DateChanged ByRun To Fail?Duplicate Serial #Count of "Not Accessible" or "No Data Plate", "Not Legible"Asset has Correct PMAsset Has Correct Route PMAsset Marked RTF CorrectlyOperating Asset has an Active PM in the pastOperating Asset, on route, and route has no active PM.Operating Asset with Active PM and Marked RTFOperating Assets on route w/Active PM and RTF
111249AIR DRYERMA0136ZZ-ADR-1112491No tagADRHANKISONPR100351-IT-9312-1272GN5100 - Boston Service CenterMA0136ZZOPERATING6/17/222:12:18 PMMXINTADMN101
111254AIR HANDLER UNIT, CARRIER Mod-AMA0136ZZ-AHU-01-1112541A-11AHU-01CARRIER27CB 10A5-18177-225N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:52 PMMXINTADMN201
111256REFRIGERATION MACHINE, RECIPROCATING, CARRIER, 60 TONS, 4 COMPRESSORSMA0136ZZ-CHL-W2-1112561Chiller 2CHL-W2CARRIER30HH0656304300073N5100 - Boston Service CenterMA0136ZZABANDONED IN PLACE3/30/1811:48:35 AMRICHARDBMOREHEADN10
111259AIR HANDLER UNIT, MCQUAY Mod-BMA0136ZZ-AHU-01-1112591A-11AHU-01MCQUAYLSL 237BH987229-01025N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:52 PMMXINTADMN101
111261AIR COMPRESSOR, HONEYWELL, 3 HPMA0136ZZ-CMP-1112611A-4-1CMPHONEYWELL240G501C2C40-10-9107529/1/759/30/75N5100 - Boston Service CenterMA0136ZZOPERATING12/7/2211:37:56 AMJOSEPHRBOUCHARDN101
111264AIR HANDLER UNIT, CARRIER Mod-C OOS-AIPMA0136ZZ-AHU-01-1112641A-11AHU-01CARRIER27CB-8A5-181771N5100 - Boston Service CenterMA0136ZZABANDONED IN PLACE3/17/211:51:36 PMJOELMDUNBARN10
111265HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, WESTINGHOUSE, 30 KVA, DESIGN # 6E4397, 480 VOLTMA0136ZZ-DTT-1112651E-33-6DTTWESTINGHOUSE6E4397N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:20 AMRICHARDBMOREHEADN002
111266COOLING TOWER, MARLEY, MODEL 4862 STAINLESS STEELMA0136ZZ-CTR-11126611CTRMARLEY4862123306-1/B27149A25N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:53 PMMXINTADMN201
111268AIR CONDITIONING MACHINE PACKAGE UNIT - 25 tonMA0136ZZ-ACU-1112681A-6-1ACUJOHNSON CONTROLSV32AW24A51AZAM0001AN1K029669620N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:52 PMMXINTADMN101
111269AIR HANDLER UNIT, MCQUAY Mod-DMA0136ZZ-AHU-01-1112691A-11AHU-01MCQUAYLSL137P.O. 86-020125N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:52 PMMXINTADMN101
111270HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, WESTINGHOUSE, 45 KVA, SERIAL # J92-B0045, 480 VOLMA0136ZZ-DTT-11127017DTTWESTINGHOUSEJ92-B0045N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:20 AMRICHARDBMOREHEADN102
111271COOLING TOWER, MARLEY, MODEL 4862 STAINLESS STEELMA0136ZZ-CTR-11127112CTRMARLEY4862123306-1/B27149A25N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:55 PMMXINTADMN201
111273Packaged Units,Air Conditioners, R-410A, 22.4 lb, 11.0 lb, 11.4 lb, YES, 15.0 TONMA0136ZZ-ACU-1112731A-6-2ACUCARRIER50TC-D14E3A6A1F0A03112G2019620N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:51 PMMXINTADMN101
111275HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, GNERAL SIGNAL, 30 KVA, CATALOG # T2H30, 480 VOLTMA0136ZZ-DTT-1112751T #10DTTGENERAL SIGNALT2H30N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:20 AMRICHARDBMOREHEADN002
111276HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, NIAGARA, 15 KVAMA0136ZZ-DTT-1112761E-33-4DTT32245N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:20 AMRICHARDBMOREHEADN102
111278AIR CONDITIONING MACHINE PACKAGE UNIT, 5 TONSMA0136ZZ-ACU-1112781A-6-3ACUTRANETCD060C400BCK47101173D20N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:51 PMMXINTADMN101
111279BACKFLOW PREVENTER, WATTS, 1 -1/2"MA0136ZZ-VLV-05-1112791V-9-1VLV-05WATTSLF009M2QT71811N5100 - Boston Service CenterMA0136ZZOPERATING1/6/231:25:19 PMJOELMDUNBARN101
111280HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, FEDERAL PACIFIC, 15 KVA, CATALOG # 50340-M, 480 VMA0136ZZ-DTT-1112801E-33-9DTTFPE50340-MN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:20 AMRICHARDBMOREHEADN002
111281HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, NIAGARAMA0136ZZ-DTT-1112811E-33-2DTT32635N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN102
111282AIR CONDITIONING MACHINE PACKAGE UNIT, YORK 5 TONSMA0136ZZ-ACU-1112821A-6-4ACUYORKD2CE060A46CNNYM07295220N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:52 PMMXINTADMN101
111284BOILER, GAS, DUEL FUEL, 3600 MBHMA0136ZZ-BLR-HW1-1112841B-1BLR-HW1SMITH28A-10N98-82225N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:53 PMMXINTADMN101
111285HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, GE, 45 KVA, MODEL # 9T23B3837, 480 VOLTMA0136ZZ-DTT-1112851T-11DTTGENERAL ELECTRIC9T23B3873900521N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN102
111286HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, NIAGARA, 45 KVA, SERIAL # 32576, 480 VOLTMA0136ZZ-DTT-1112861E-33-3DTT32576N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN102
111287AIR CONDITIONING MACHINR PACKAGE UNIT, YORK 5 TONSMA0136ZZ-ACU-1112871A-6-5ACUYORKD2CE060A46CNNYM07295720N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:51 PMMXINTADMN101
111289BOILER, GAS, DUEL FUEL, 3600 MBHMA0136ZZ-BLR-HW1-1112891B-2BLR-HW1SMITH28A-10N98-82325N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:53 PMMXINTADMN101
111290HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, GE, 45 KVA, MODEL # 9T23B3837, 480 VOLTMA0136ZZ-DTT-1112901T-10DTTGENERAL ELECTRIC9T23B3873N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN002
111291HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, NIAGARA, 45 KVA, SERIAL # 32577, 480 VOLTMA0136ZZ-DTT-1112911E-33-5DTT32577N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN102
111292FAN, PROPELLER in Module D AHUMA0136ZZ-FAN-02-1112921F-36-2FAN-02ATLASR 42N5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:17 PMDONNAABROCKN001
111293MOTOR CONTROL CENTER, CUTLER-HAMMER, 19 MOTOR STARTERSMA0136ZZ-MCC-01-1112931E-35-1MCC-01CUTLER HAMMERUNITROLN5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:17 PMDONNAABROCKN001
111294HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, SQUARE D, 10 KVA, MINI POWER ZONEMA0136ZZ-DTT-1112941MPZDTTSQUARE DMPZ10S140FN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN002
111296HIGH VOLTAGE NETWORK & POWER DRY TYPE TRANSFORMER, NIAGARA, 15 KVA, SERIAL # 32244, 480 VOLTMA0136ZZ-DTT-1112961E-33-1DTT32244N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:21 AMRICHARDBMOREHEADN102
111297FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1112971F-27-1FAN-01CARNESN5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:17 PMDONNAABROCKN001
111298PUMP, CENTRIFUGAL, CHILLED WATER PUMP, 15 HP, VFDMA0136ZZ-PMP-02-1112981CHW P-4-2PMP-02BELL & GOSSETT4BC9.125BFW2094492N5100 - Boston Service CenterMA0136ZZOPERATING1/15/2110:08:06 AMJOELMDUNBARN101
111300PUMP, CENTRIFUGAL, HOT WATER CIRCULATING PUMPMA0136ZZ-PMP-HW-1113001Pump P-4-7PMP-HWBELL & GOSSETT1-1/4ACBFK69201399915N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:59 PMMXINTADMN101
111301HOT WATER HEATER, ELECTRIC, 30 GALLONMA0136ZZ-WHT-01-1113011H-3-2WHT-01VANGUARD3WAGG1110B00087N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:26 AMRICHARDBMOREHEADN101
111302PUMP, CENTRIFUGAL WATER, STANDBY FOR CHW/CW 15 HPMA0136ZZ-PMP-02-1113021CW P-4-3PMP-02BELL & GOSSETT4BC9.125BFW2094493N5100 - Boston Service CenterMA0136ZZOPERATING1/15/2110:08:21 AMJOELMDUNBARN101
111303FAN, CENTRIFUGAL, CARRIERMA0136ZZ-FAN-01-1113031F-27-1FAN-01CARRIER27CB-8A5-18177-1N5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:17 PMDONNAABROCKN101
111304LOW VOLTAGE, MOLDED CASE CIRCUIT BREAKER, MAIN INCOMING BREAKERMA0136ZZ-EPB-1113041E-26-1EPBWESTINGHOUSEN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:20 AMRICHARDBMOREHEADN001
111305PUMP, CENTRIFUGAL, HOT WATER CIRCULATING PUMP FOR MODULE DMA0136ZZ-PMP-HW-1113051P-4-15PMP-HWTACO1636C2N3-6415N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:58 PMMXINTADMN001
111306WATER TREATMENT FOR COOLING SYSTEMS, CHILLED WATER SYSTEM, 35% GLYCOLMA0136ZZ-WTM-01-1113061W-8-1WTM-01N5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:17 PMDONNAABROCKN001
111307CONDENSATE PUMPMA0136ZZ-PMP-03-11130713PMP-03TEEL2P1073210N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN101
111308FAN, CENTRIFUGAL, CARRIERMA0136ZZ-FAN-01-1113081FAN-01CARRIER27CB-8A5-18177-2N5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN201
111309FAN, PROPELLER in Module D AHUMA0136ZZ-FAN-02-1113091F-36-1FAN-02ATLASR 42N5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN001
111310SWITCHBOARDS, LOW VOLTAGE, EMERGENCY PANEL, 9 BREAKERSMA0136ZZ-SWB-01-1113101EUH-1SWB-01GOULD PUMPTYPE FC-115-00940-50EFC25N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:58 PMMXINTADMN101
111311WATER TREATMENT FOR COOLING SYSTEMS, CONDENSER WATER SYSTEMMA0136ZZ-WTM-01-1113111CWWTM-01NEPTUNEFTF-2N5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:17 PMDONNAABROCKN001
111312CONDENSATE PUMPMA0136ZZ-PMP-03-11131214PMP-03DAYTONPP2LTA3282N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN101
111313FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1113131F-27-4FAN-01JENN AIR362BCRENN5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN001
111315SWITCHBOARDS, LOW VOLTAGE, WESTINGHOUSE, MAIN PANEL, S.O. # BSDA81880, 480/277 VOLTS, 1600 AMPS, 15MA0136ZZ-SWB-01-1113151E-30-2SWB-01WESTINGHOUSEBSDA8188025N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:59 PMMXINTADMN001
111316WATER TREATMENT FOR HEATING SYSTEMMA0136ZZ-WTM-01-1113161WTM-01NEPTUNEVTF-5N5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:18 PMDONNAABROCKN001
111317PUMP, CENTRIFUGAL, CONDENSER WATER PUMP, 15 HPMA0136ZZ-PMP-06-1113171CHW P-4-1PMP-06BELL & GOSSETT3E10.250BFW209560015N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:57 PMMXINTADMN101
111318FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1113181F-27-5FAN-01JENN AIR362BCRENN5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN001
111320UNIT HEATER, HOT WATER, 1/3 HPMA0136ZZ-UHT-02-1113201U-1-3UHT-02N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:36 AMRICHARDBMOREHEADN001
111321WATER TREATMENT FOR HEATING SYSTEM, HUMIDIFICATIONMA0136ZZ-WTM-01-1113211W-9-2WTM-01PS 221VN5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:18 PMDONNAABROCKN001
111322PUMP, CENTRIFUGAL, OIL PUMPMA0136ZZ-PMP-07-1113221Pump 1PMP-07HAYS CLEVELANDFH432I-56095-0N5100 - Boston Service CenterMA0136ZZABANDONED IN PLACE3/17/212:01:14 PMJOELMDUNBARN20
111323FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1113231F-27-6FAN-01YORKN5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN001
111325UNIT HEATER, HOT WATER, 1/3 HPMA0136ZZ-UHT-02-1113251U-1-4UHT-02MARKELP5P5125 R1N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:37 AMRICHARDBMOREHEADN00
111326CHEMICAL FEEDER, HYDAC, CHILLED WATER SYSTEMMA0136ZZ-WTM-03-1113261X-29-1WTM-03LMIDC4500-111A980000000N5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:19 PMDONNAABROCKN101
111327PUMP, CENTRIFUGAL, OIL PUMPMA0136ZZ-PMP-07-1113271Pump 2PMP-07HAYS CLEVELANDFH432I-56095-0N5100 - Boston Service CenterMA0136ZZABANDONED IN PLACE3/17/212:01:26 PMJOELMDUNBARN20
111329FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1113291F-27-7FAN-01ACMEP16DEM9525N5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN10
111330UNIT HEATER, HOT WATER, 1/3 HPMA0136ZZ-UHT-02-1113301U-1-7UHT-02BERKOHUHAA1048N5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:37 AMRICHARDBMOREHEADN001
111332PUMP, CENTRIFUGAL, HOT WATER CIRCULATING PUMP FOR MODULE D, HPMA0136ZZ-PMP-HW-0021CIRC PUMP 2PMP-HWTACO15N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:58 PMMXINTADMN001
111334UNIT HEATER, HOT WATER, 1/3 HPMA0136ZZ-UHT-02-1113341U-1-8UHT-02CARRIERN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:37 AMRICHARDBMOREHEADN001
111335FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1113351F-27-8FAN-01CARNESN5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:18 PMDONNAABROCKN00
111337PUMP, CENTRIFUGAL, HOT WATER CIRCULATING PUMPMA0136ZZ-PMP-HW-1113371Pump P-6PMP-HWBELL & GOSSETT1-1/4ACBF6.75211249115N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:58 PMMXINTADMN101
111339VALVE, SAFETY RELIEF, BOILER # 1, HOT WATERMA0136ZZ-VLV-01-1113391V-2-1VLV-01WATTSMN5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:19 PMDONNAABROCKN001
111341FAN, CENTRIFUGAL-ExhaustMA0136ZZ-FAN-01-1113411F-27-3FAN-01JENN AIR363BCREN EN5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:16:19 PMDONNAABROCKN001
111344VALVE, SAFETY RELIEF, BOILER # 2, HOT WATERMA0136ZZ-VLV-01-1113441V-2-2VLV-01WATTSMN5100 - Boston Service CenterMA0136ZZOPERATING12/14/201:02:19 PMDONNAABROCKN001
1722952Distribution Systems,Air Handling Units,Heating and Ventilating UnitsMA0136ZZ-AHU-01-17229521A-11AHU-01STULZSDS-16000-122-IG950000125N5100 - Boston Service CenterMA0136ZZOPERATING11/21/233:54:53 PMMXINTADMN101
1722954Helical-rotary ChillerMA0136ZZ-CLR-02-17229541MA0136ZZ-CHL-CW1-172954CLR-02TRANERTHD UB2F XJ0UU13L07874201311/27/131/1/1312/2/1515N5100 - Boston Service CenterMA0136ZZOPERATING6/17/225:35:14 PMMXINTADMN201
1855323BAS ControllerMA0136ZZ-DDC-06-18553231192.168.231.34DDC-06JOHNSON CONTROLSMS-NCE2510-08/21/180N5100 - Boston Service CenterMA0136ZZBMCOPERATING1/5/231:13:17 PMDONNAABROCKN00
1855324BAS ControllerMA0136ZZ-DDC-06-18553241192.168.231.35DDC-06JOHNSON CONTROLSMS-NCE2560-08/21/180N5100 - Boston Service CenterMA0136ZZBMCOPERATING1/5/231:13:17 PMDONNAABROCKN00
1855325BAS ControllerMA0136ZZ-DDC-06-18553251192.168.231.37DDC-06JOHNSON CONTROLSMS-NCE2560-08/21/180N5100 - Boston Service CenterMA0136ZZBMCOPERATING1/5/231:13:17 PMDONNAABROCKN00
1855326MeteringMA0136ZZ-MTR-02-18553261192.168.231.36MTR-02SCHNEIDER-ELECTRICION76508/21/180N5100 - Boston Service CenterMA0136ZZBMCOPERATING9/8/222:10:31 PMDONNAABROCKN00
1855327BSN ConsoleMA0136ZZ-DDC-02-18553271192.168.231.38DDC-02DELLOptiplex 70102J1KZ128/21/180N5100 - Boston Service CenterMA0136ZZBMCOPERATING1/5/231:13:17 PMDONNAABROCKN10
2491623BOILER, STEAM, OIL/GAS/COMB, 120 MBH TO 500 MBHMA0136ZZ-BLR-ST2-24916230B-4BLR-ST2COLUMBIA BOILERSCT-1016524611/16/190N5100 - Boston Service CenterMA0136ZZOPERATING9/24/2110:57:28 AMJOELMDUNBARN101
2491624BOILER, STEAM, OIL/GAS/COMB, 120 MBH TO 500 MBHMA0136ZZ-BLR-ST2-24916240B-3BLR-ST2COLUMBIA BOILERSCT-101645202/25/200N5100 - Boston Service CenterMA0136ZZOPERATING9/24/2110:58:12 AMJOELMDUNBARN101
2753195Emergency Power Generation,G409003.01MA0136ZZ-EMG-01-27531951EMG-01KOHLER150REOZJF3379GMJL001512/23/2112/23/220N5100 - Boston Service CenterMA0136ZZOPERATING12/8/2211:36:47 AMJOELMDUNBARN101
2763771Sewage Ejector CompressorMA0136ZZ-CMP-R-27637710Compressor #2CMP-RATLAS545AC9810656-A12/20/220N5100 - Boston Service CenterMA0136ZZOPERATING12/22/2210:54:07 AMJOELMDUNBARN101
2763772Sewage Ejector CompressorMA0136ZZ-CMP-R-27637720Compressor #1CMP-RATLAS545AC9810656-B12/20/220N5100 - Boston Service CenterMA0136ZZOPERATING12/22/2210:54:07 AMJOELMDUNBARN101
2764341Backflow Preventer, Watts, .75 InchMA0136ZZ-VLV-05-PLMB-27643410VLV-05-PLMBWATTS909QTRP6364641/1/220N5100 - Boston Service CenterMA0136ZZOPERATING1/6/231:32:50 PMJOELMDUNBARN101
42875CONTROLS, CENTRAL SYSTEM, HVAC, JOHNSON METASYS CONTROLS 134 POINTSMA0136ZZ-BAS-01-428751C-6-1BAS-01JOHNSON CONTROLSN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42885BURNER, GAS, DUEL FUEL W/MOTORMA0136ZZ-BNG-428851.00B-3-1BNGN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:18 AMRICHARDBMOREHEADN001
42889COILS, REHEAT, 16 SFMA0136ZZ-COL-428891C-3-5COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42891BURNER, GAS, DUEL FUEL W/MOTORMA0136ZZ-BNG-428911B-3-2BNGN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:18 AMRICHARDBMOREHEADN001
42894COILS, REHEAT, 4 SFMA0136ZZ-COL-428941C-3-6COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42896RADIATION BASEBOARD/CONVECTORS, 350 LINEAR FEETMA0136ZZ-BSB-428961R-9-1BSBN5100 - Boston Service CenterMA0136ZZOPERATING7/31/1810:12:16 AMREBECCAJALLDREDGEN001
42898DRAINS, STORMMA0136ZZ-DRN-428981D-6-1DRNNONAMEPLATEN/AN/AN5100 - Boston Service CenterMA0136ZZOPERATING3/23/236:47:53 PMMXINTADMN1301
42899COILS, REHEAT, 8 SFMA0136ZZ-COL-428991C-3-7COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42903LOADING RAMP, ADJUSTABLE, HRK, 2 TONSMA0136ZZ-DKL-429031L-2-1DKLN5100 - Boston Service CenterMA0136ZZABANDONED IN PLACE2/11/202:29:56 PMJOELMDUNBARN00
42904DRAINS, STORMMA0136ZZ-DRN-429041D-6-2DRNNONAMEPLATEN/AN/AN5100 - Boston Service CenterMA0136ZZOPERATING3/23/236:47:53 PMMXINTADMN1301
42906COILS, HEAT, 32 SFMA0136ZZ-COL-429061C-3-1COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42908DRAINS, STORMMA0136ZZ-DRN-429081D-6-3DRNNONAMEPLATEN/AN/AN5100 - Boston Service CenterMA0136ZZOPERATING3/23/236:47:53 PMMXINTADMN1301
42909LOADING RAMP, ADJUSTABLE, HRK, 2 TONSMA0136ZZ-DKL-429091L-2-2DKLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:30 AMRICHARDBMOREHEADN001
42910EMERGENCY LIGHTS, CLOSED SYSTEMMA0136ZZ-ELT-429101E-19-4ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:39 PMRICHARDBMOREHEADN001
42911COILS HEAT, 32 SFMA0136ZZ-COL-429111C-3-2COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42913EMERGENCY LIGHTS, WET CELLMA0136ZZ-ELT-429134E-18-(1-4)ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:40 PMRICHARDBMOREHEADN001
42914DOORS, MAIN ENTRANCEMA0136ZZ-DOR-429141D-5-1DORN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:38 PMRICHARDBMOREHEADN001
42915EMERGENCY LIGHTS, CLOSED SYSTEMMA0136ZZ-ELT-429151E-19-5ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:40 PMRICHARDBMOREHEADN001
42916COILS HEAT, 48 SFMA0136ZZ-COL-429161C-3-3COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42918REMOTE AIR INTAKE DAMPERS, 48 SFMA0136ZZ-DPP-429181C-2-1DPPN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:39 PMRICHARDBMOREHEADN001
42919EMERGENCY LIGHTS, WET CELLMA0136ZZ-ELT-429193E-18-(5-7)ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:40 PMRICHARDBMOREHEADN001
42920EMERGENCY LIGHTS, CLOSED SYSTEMMA0136ZZ-ELT-429203E-19-(6-8)ELTN5100 - Boston Service CenterMA0136ZZOPERATING1/8/197:56:05 AMRONALDEDWARDSN001
42921COILS HEAT, 25 SFMA0136ZZ-COL-429211C-3-4COLN5100 - Boston Service CenterMA0136ZZOPERATING3/30/1811:48:19 AMRICHARDBMOREHEADN001
42922FAN, EXHAUST, 3000 CFM, W/1/2 HP MOTORMA0136ZZ-FAN-01-429221F-27-10FAN-01N5100 - Boston Service CenterMA0136ZZOPERATING1/14/229:18:28 PMDONNAABROCKN001
42923EMERGENCY LIGHTS, CLOSED SYSTEMMA0136ZZ-ELT-429231E-19-3ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:39 PMRICHARDBMOREHEADN001
42924REMOTE AIR INTAKE DAMPERS, 48 SFMA0136ZZ-DPP-429241C-2-2DPPN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:39 PMRICHARDBMOREHEADN001
42925EMERGENCY LIGHTS, WET CELLMA0136ZZ-ELT-429253E-18-(14-16)ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:40 PMRICHARDBMOREHEADN001
42926FIRE EXTINGUISHER, STORED PRESSURE WITH GUAGE & NON STAINLESS STEEL SHELL, 52 FIRE EXTINGUISHERSMA0136ZZ-FEX-01-4292652F-22/24/25-(1-52)FEX-01N5100 - Boston Service CenterMA0136ZZOPERATING8/13/204:32:53 PMDONNAABROCKN001
42927FIRE DOORS, EXITWAYS, SWINGING, 6 SINGLE LEAF AND 8 DOUBLE LEAF *NOTE 4 DOUBLE LEAF DOORS INSTALLEDMA0136ZZ-FDR-01-4292714F-11-(1-14)FDR-01N5100 - Boston Service CenterMA0136ZZOPERATING10/15/189:34:35 AMRONALDEDWARDSN001
42928EMERGENCY LIGHTS, WET CELLMA0136ZZ-ELT-429283E-18-(11-13)ELTN5100 - Boston Service CenterMA0136ZZOPERATING5/7/181:20:40 PMRICHARDBMOREHEADN001

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 .