A five-minute scorecard for facility teams, by Tim Shirley, CHFM, CHSP
Most CMMS problems get blamed on the software. In my experience, they usually start with the data. This scorecard checks your data against five tests: complete, consistent, located, structured and owned.
How to score it. Answer each question yes or no. Be strict: if the honest answer is "mostly", "at some sites" or "I'd have to ask someone", choose no. The point isn't a high score. It's knowing where you stand.
Test 1: Complete
Everything in scope is in the register, and nothing else is.
1Is every piece of equipment that gets a PM, inspection or test in your CMMS as its own asset?
2Are your life safety and utility components in the register, such as fire dampers, fire pumps, generators and transfer switches, so you could hand an inspector or surveyor their records?
3When equipment is removed, is its record marked inactive or archived, so it stops getting PMs but keeps its history?
4Do you have a written rule for what counts as an asset, one a new hire could apply without asking?
Complete score0 of 4
Test 2: Consistent
Each kind of asset is named and described alike at every site.
5Is your asset naming rule written down, and does every site follow it? (Not AHU-1 at one site, AH01 at another and a plain description at a third.)
6If you searched for any one pump or air handler, would you find exactly one record, not two or three?
7Pick five of your most critical assets. Do all five have manufacturer, model, serial number and install date filled in?
8Are condition ratings, failure codes and close codes picklists, not free text?
Consistent score0 of 4
Test 3: Located
Every asset sits in a real place a tech can walk to.
9Is every asset tied to a room or area, not just a building?
10Could a tech who's new to the building find any asset from its CMMS record alone, without calling someone?
11Do your assets carry tags that match their ID in the CMMS?
12Are most of your work orders written against a specific asset, not against the building or a "misc" record?
Located score0 of 4
Test 4: Structured
Assets roll up by classification, system, building and site.
13Are locations and assets separate records, so when you replace a unit, the room keeps its history and the new unit starts its own?
14Does every asset have a classification and subclassification, such as HVAC: air handling units?
15Can you pull the full PM and repair history for every chiller you own in under a minute?
16Do your CMMS and your facility condition assessment use the same asset IDs, so your capital plan and your maintenance program work from one list?
Structured score0 of 4
Test 5: Owned
Keeping the data current is someone's actual job after go-live. This is the test most organizations skip, and it decides whether the other four last.
17Is one named person or role responsible for adding, changing and retiring assets?
18Do capital projects and equipment replacements have to update the CMMS before they close out?
19Does someone review your asset data on a set schedule, at least once a quarter?
20If your CMMS lead left tomorrow, are your naming rule, hierarchy and picklists written down for the next person?