| Account, Division & Site Information |
| Account Id |
ID for the customer account receiving services.
|
| Division Id |
ID for the operating division responsible for managing accounts and services. |
| Division Name |
Name of the operating division responsible for managing accounts and services. |
| Site Id |
ID for the customer physical location where the service is performed. |
| Site Name |
The name of the customer's physical location where services are needed.
|
| Site Service Id |
Unique identifier associated to the service for the site. This is also displayed in the site's Active Services. |
| Site Service External Id |
Optional identifier used to match the site service record with an external system. |
| Site Old Id |
Legacy site identifier retained for historical reference or system migration purposes. |
| Service Definition |
| Service Code Id |
ID of the service being provided.
|
| Service Code Name |
The name of the service being offered, such as trash collection, recycling, or regulated medical waste service. |
| Service Duration |
Length or term of the service arrangement, such as temporary, ongoing, or contract-based service. |
| Service Frequency |
Scheduled frequency at which the service is performed, such as once per week or twice per week. |
| Service Region Id |
ID for the geographic area responsible for the service.
|
| Service Region Name |
Name of the geographic area responsible for the service.
|
| Service Root Id |
Identifier linking related service records to a common service request, agreement, or original service setup. |
| Service Dates & Status |
| Start Date |
Date on which the service is scheduled to begin or becomes effective.
|
| End date |
Date on which the service is scheduled to end. A blank value generally indicates that no end date has been established. |
| Last Completed Date |
Date on which the service was most recently completed or recorded as completed. |
| Is temp |
Indicator showing whether the service is temporary rather than part of a permanent or recurring customer arrangement. |
| Billed Through Date |
Date through which the customer has been billed for the service.
|
| Service Location |
| Address Line 1 |
Primary street address where the servicing activity occurs.
|
| City |
City in which the service site is located.
|
| State |
State in which the service site is located.
|
| Zip |
Postal or ZIP code for the service site address.
|
| Quantity, Pricing & Billing |
| Quantity |
Number of containers or units associated with the service. |
| Rate |
Customer charge for the defined service unit, service period, or billing arrangement. |
| Rate Per Yard |
Price calculated for each cubic yard of container capacity or material volume.
|
| UOM |
Unit of measure used to define the service quantity.
|
| Work Order Minimum |
Minimum billable amount must be charged on a work order.
|
| Material & Line of Business |
| Material Type Id |
ID for the type of material collected, processed, transported, or disposed of. |
| Material Type Name |
Description of the material stream, such as municipal solid waste, recyclables, medical waste, or other regulated material. |
| Line of Business Id |
ID for the business category responsible for the service.
|
| Line of Business Name |
Business category under which the service is managed, such as commercial, roll-off, medical waste, or portable toilets. |
| Equipment & Container Details |
| Equipment Size |
Capacity or physical size of the container or equipment, generally expressed in cubic yards or equipment-specific units. |
| Equipment Type Id |
ID for the type of equipment used for the service.
|
| Equipment Type Name |
Name of the equipment, such as a four-yard front-load container, thirty-yard open-top container, or deluxe portable toilet. |
| Ownership |
Identifies who owns the equipment being serviced as either:
- Company - the hauler owns the equipment
- Owner - the customer owns the equipment
- Unknown - unidentified party owns the equipment
- Vendor
|
| Destination & Routing |
| Default Destination |
Default disposal, transfer, processing, recycling, treatment, or unloading facility assigned to the service. |
| Default Destination Id |
ID for the default disposal, transfer, processing, recycling, or treatment destination. |
| Route Names |
Names or codes of the collection routes assigned to perform the service.
|
| Routing Days |
Days of the week or routing schedule on which the service is planned to occur.
|
| Inactivity & Rental Charges |
| Inactivity Rental Free Days |
Number of days equipment may remain inactive or unused before an inactivity or rental charge begins. |
| Inactivity Rental Rate |
Rate charged when equipment remains on site beyond the permitted inactive or free-rental period. |
| Vendor Information |
| Vendor Name |
Name of the third-party hauler associated with the service. |
| Vendor Rate |
Cost paid or payable to the vendor for providing the service. |
| Vendor Site Id |
ID for the vendor facility or vendor service location used to fulfill the customer service. |
| Operational Notes & Reason Codes |
| Current Service Notes |
Instructions or warnings relevant to servicing the location, such as access restrictions, animals, placement details, or site hazards. |
| Reason Code |
Code explaining why the service record was created, changed, extended, replaced, suspended, or otherwise updated. |
