Creating Asset ID’s
In developing an asset inventory, it is critical to develop a unique asset identification number (Asset ID) for each asset in the inventory. This ID number can be anything, as long as it is unique. The Asset ID allows for easier asset identification, allows systems to search and query data more effectively, and makes valuable data more readily available. Some software programs may limit the number of characters allowed in a given data field. The system should be aware of these limitations when selecting software and/or determining how to number assets. The numbering system should be consistent throughout the system and should be easily and quickly recognized by all personnel.
There are several approaches to developing an asset numbering system. Each has advantages and disadvantages.
Sequential Number
Description | Advantages | Disadvantages |
Numbering system that adds a sequential number to each new asset |
|
|
Existing Internal Numbering System
Description | Advantages | Disadvantages |
If part of the organization already has an asset numbering system, such as accounting, you may choose to use it |
|
|
Existing External Numbering System
Description | Advantages | Disadvantages |
One example is the US DOD’s National Stock Number (NSN) |
|
|
Create a Number System
Description | Advantages | Disadvantages |
Build meaning into asset numbers by incorporating information such as location, asset type, asset function, manufacturer, model, building number, and more. |
|
|
Random Numbering System Created by Software
There are a few things to keep in mind when creating the Asset ID. The Asset IDs should: be logical, be consistent, be unique, avoid duplications, allow room for growth, allow for drilling down by using a hierarchical structure. Thinking ahead about the Asset ID may allow for an asset management software to create it automatically for any new assets added to the inventory. If the system plans to use (or already uses) a geospatial software, the Asset ID number can be a random number as the software will allow the system to look for assets by location. If the system creates Asset ID numbers, it can be helpful if the ID Number provides information on asset class or category, asset location, asset size, asset ownership or other unique identifiers such as its watershed location. When deciding on which type of numbering system to use, consider the time it will take to bring system personnel up to speed on the naming convention and weigh that against, the benefits of a smart numbering system.
An example of a potential numbering scheme is shown below.
Example 1:
A BCD EFG 1
A = Water (W) or Wastewater (WW)
BCD = facility name (i.e., abbreviation for pump station, well house, treatment building)
EFG = Equipment name (i.e., abbreviation for name of equipment)
1 = Equipment number (i.e., number for that particular piece of equipment)
For Example:
WMPSPMP1 = Water System Main Street Pump Station Pump 1
W = Water System
MPS = Main Street Pump Station
PMP = Pump
1 = Number 1 Pump
Any numbering system can work. The system chosen should be one that best fits the system. It is worthwhile to examine approaches used by other systems in selecting a numbering scheme, and then modify them to suit the individual needs of the system.
The system should consider putting Asset ID numbers on tags, especially tags that use either QR codes that can be read with phones or tablets or UPC codes that can be scanned by electronic devices and attaching the tag to the asset whenever the assets are visible and accessible. The tags should be durable and attached in a semi-permanent way. If tags become worn or knocked off the equipment, they should be replaced.
Asset ID system – Stacy Gallick, Asset Management Director, Johnson County Wastewater, Olathe, KS
Numbering system for hydrants – Bill Boulanger, Superintendent –Public Works and Utilities, Community Service Division, City of Dover, NH
When creating a numbering system, the numbering scheme should be developed by the individuals who will have to use it most, or at least should be developed with input from these individuals. The task of developing an asset ID numbering system can seem simple, but in practice can be quite complex. It may be necessary to revise the system a few times before it is satisfactory. The best approach is to think about what should be accomplished with the numbering system, discuss different approaches, select an approach, and then do a pilot project to see if it will work properly. The pilot project should include a small subset of the overall assets from different parts of the facility to determine if the numbering system that was selected will work. If the numbering scheme does not perform adequately, it can be modified to solve the issues and the pilot can be repeated.