| Equipment Identification |
| Equipment Type Id |
The unique ID for the category of equipment. |
| Equipment Type Name |
The type of waste equipment (e.g., Front-load Container, Roll-off, or Compactor). |
| Equipment External Id |
An identifier used by an external system or third-party vendor. |
| License Plate |
The vehicle license plate number for mobile assets like haul trucks. |
| Rfid Tag |
The unique RFID identifier used for automated tracking and gate entry. |
| Owner Type Id |
The numerical code representing who owns the equipment. |
| Owner Type |
The entity that owns the asset (Company, Customer, or Vendor). |
| Quantity |
The number of identical units available at this location (e.g., number of 2-yard bins). |
| Serial Number |
The manufacturer's unique serial number for the piece of equipment. |
| Lob Id |
The unique ID for the Line of Business (e.g., Residential, Commercial, or Industrial). |
| Lob Name |
The name of the Line of Business associated with the asset. |
| Physical Specifications |
| Tare Weight |
The empty weight of the container or vehicle. |
| Tare Weight Uom Id |
The unique ID for the unit of measure used for tare weight. |
| Tare Weight Uom |
The unit of measure for weight (e.g., Pounds or Kilograms). |
| Location Information |
| Location Type |
The category of the site where the asset is held (e.g., Transfer Station, Landfill, or Maintenance Yard). |
| Location Id |
The unique identifier for the specific yard or site location. |
| Location Name |
The descriptive name of the facility or site. |
| Address Line1 |
The primary street address of the asset's current location. |
| Address Line2 |
The secondary address details (e.g., Suite or Gate number) for the location. |
| City |
The city where the waste management asset is located. |
| State |
The state or province of the asset's location. |
| Postal Code |
The ZIP or postal code of the facility. |
| Latitude |
The GPS latitude coordinate for precise asset tracking. |
| Longitude |
The GPS longitude coordinate for precise asset tracking. |
| Service Region Id |
The unique ID of the geographical region served by this inventory. |
| Service Region Name |
The name of the operational region (e.g., Northeast District). |
| Activity & Maintenance |
| Last Activity Time |
The timestamp of the most recent event involving this asset. |
| Last Activity Type |
The category of the most recent action taken with the asset. |
| Last Activity Event Type Id |
The numerical ID of the last event (e.g., 6 for Inbound). |
| Last Activity Event Type |
The description of the last single event (e.g., Swap/Exchange or Inbound). |
| Last Activity Work Type Id |
The unique ID of the work order type associated with the last activity. |
| Last Activity Work Type |
The type of work performed (e.g., Preventative Maintenance or Repair). |
| Days Since Last Activity |
Number of days since the asset was last moved or serviced. |
| Avg Days Between Activity |
The average cycle time for this asset's utilization. |
| Last Activity Service Record Id |
The unique ID of the service record linked to the last activity. |
| Last Activity Work Order Number |
The specific work order number for the last maintenance or move event. |
| Last Activity Completed By User Id |
The unique ID of the user who completed the last activity. |
Last Activity Completed By User
|
The full name of the user who performed the last action. |
