Column Glossary

EntityID: The unique identifier of the asset
Description: The type of asset (primary asset class)
Category: The secondary or functional use of the asset
Community: The name of the community the asset belongs to
Name: The common name of the asset
Material: The type of material the asset is made of
Replacement Year: The year at end of service life
Future Aggregate Replacement Cost: The replacement cost (inclusive of components and contained assets (ie facility equipment)) of the asset at the replacement year.

Asset:Actual Historical Cost: The invoice cost of the asset.
Asset:Asset Type: The third level of asset hierarchy, providing further aggregation of similar assets into specific groups within each defined functional area.

Asset:Category: The highest level of asset hierarchy, providing aggregation of similar assets into specific groups.

Asset:Class: The class of the asset (in reference to a provincial or federal standard)
Asset:Client ID: The identifier of the asset from the original data set
Asset:Closest Street: The name of the closest street to the asset
Asset:Comments: General comments regarding the asset
Asset:Construction Date: The date of construction, installation or purchase of the asset
Asset:Entity ID: The unique identifier of the asset
Asset:From Z: The height (or depth) of the asset

Asset:Functional Area: The secondary level of asset hierarchy, providing further aggregation of similar assets into specific groups within each defined category.
Asset:Latitude: The latitude coordinate of the asset (not projected)
Asset:Length: The length of the asset
Asset:Longitude: The longtitude coordinate of the asset (not projected)
Asset:Material: The material the asset is made of
Asset:Other Reference: An additional reference to the asset
Asset:Overall Condition: The aggregate condition rating of the asset
Asset:Owner/Authority: The owner or authority responsible for the asset
Asset:Ownership: The owner of the asset
Asset:Parent ID: The parent entity of the asset (most common in facilities)
Asset:Projected Latitude: The projected latitude coordinate of the asset
Asset:ProjectedLongitude: The projected longtitude coordinate of the asset
Asset:Status: The current status of the asset (ie In Service, Out of Service)
Asset:Sub District: Further detail regarding the location of the asset
Asset:Sub System: Further detail regarding the type of the asset
Asset:System: The type of the asset
Asset:To Z: The height (or depth) of the asset

Culvert:Barrel Condition: The condition of the barrel of the culvert
Culvert:Barrel Diam: The diameter of the barrel of the culvert
Culvert:Barrel Width: The width of the barrel of the culvert
Culvert:Downstream Condition: The condition of the downstream of the culvert
Culvert:Length: The length of the culvert
Culvert:Other: An additional reference to the asset
Culvert:Upstream Condition: The condition of the upstream of the culvert
Culvert:Usage (Condition):

Financial: Net Book Value: The remaining net book value of the asset. This is the historical cost minus the accumulated amortization
Financial:Accumulated Ammortization: The total amortization accumulated over the life of the asset including the current year.
Financial:Age: The current age of the asset
Financial:Current Aggregate Replacement Cost: The current replacement cost of the asset inclusive of components and equipment
Financial:Current Replacement Cost: The current replacement cost of the asset
Financial:Estimated Repair Year: The estimated repair year of the asset, based on service life
Financial:Future Aggregate Replacement Cost: The replacement cost of the asset at the end of service life, inclusive of components and equipment
Financial:Future Replacement Cost: The replacement cost of the asset at the end of service life.
Financial:Historical Cost: The estimated original (deflated) or invoice cost of the asset.
Financial:Remaining Life: The remaining life of the asset, based on service life
Financial:Service Life: The estimated life of the asset

Road:AADT: The annual average daily traffic on the road
Road:Lane Width: The width of the lanes of the road
Road:Number of Lanes: The number of lanes on the road
Road:Ride Rating: The condition of the asset based on the effect it has on the users of the road
Road:Road Type: The type of road, ie Highway
Road:Shoulder Type: The type of shoulder, ie Gravel
Road:Shoulder Width: The width of the shoulder
Road:Speed Limit: The speed limit of the road
Road:Street Name: The name of the road
Road:Surface Rating: The surface rating of the road, often a standard such as PCI
Road:Surface Type: The type of surface, ie Asphalt
Road:TAADT: The annual average daily truck traffic
Road:Traffic Operation: The type of traffic operation (ie One way)
Road:Truck Route: Whether the road is a truck route

Sewer:Diameter: The diameter of the asset
Sewer:Height: The height of the asset (if non circular)
Sewer:Number Serviced: The number of people service by the asset
Sewer:QA: The actual flow of the asset
Sewer:QD: The designed flow of the asset
Sewer:Shape: The shape of the asset
Sewer:Structure Type: The type of structure (ie Pipe)
Sewer:Width: The width of the asset (if non circular)
Sewer:WRC Operating: The operating condition of the asset based on the Water Research Council rating system
Sewer:WRC Structural: The structural condition of the asset based on the Water Research Council rating system

Vehicle:Manufacturer: The manufacturer of the asset
Vehicle:Model Number: The model number of the asset (ie SL)
Vehicle:Model Year: The year of the model of the asset (ie 1997 for a 1997 Chevy Impala)
Vehicle:Serial Number: The serial or vin of the asset