Construction Job Site Waste Hauling

Overview

This dataset tracks the movement of open-top construction dumpsters holding C&D (construction and demolition) debris. Every time a roll-off dumpster is moved (delivery, switchout, removal) a new ticket is created for said movement. Product and pricing data contained within a roll off ticket is used to generate the corresponding AR and AP invoices. Included within Roll-off are Ticket Rentals data, which tracks the rental of construction site equipment such as portable toilets, fencing, storage containers, job site trailers, etc, which have recurring billing.

Data Information	Value
Refresh Cadence	`Monthly`
Historical Coverage	`2018`-`Present`
Geographic Coverage	`United States`, `Canada`

Schema

Name	Description
CUSTOMER_ENVIRONMENT_CUSTOMER_ID	Internal customer designator
BP_PO_NUMBER	Internal purchase order number
DATE_FOR_ACTION	Date when product is serviced
CREATED_DATE	Date when ticket is created
FLAT_RATE_CUSTOMER	Base charge
CUSTOMER_HAUL	Customer charge to haul product
CUSTOMER_TONNAGE	Customer charge for product weight in Tons
CUSTOMER_MONTHLY_RENTAL	Customer charge for rental
BILLING_STATUS	Completion of billing status
ACTION_TIME	Time of day for product movement
DUMP_UNDER_BP_ACCT	Yes/No
QUANTITY	Number of products at dumpsite
UNIT_OF_MEASURE	Item quantity
TICKET_STATUS	Status of the ticket
TICKET_DISPLAY	Concatenated field for job location
PRODUCT_DESCRIPTION_ROLLOFF_LIST_OF_PRODUCT_DESCRIPTION_ROLLOFF_ID	Internal product designator
PRODUCT_DESC	Description of product
MOVEMENT_TYPE	Current stage of product lifecycle
JOB_SITE_ENVIRONMENT_JOB_SITE_ID	Internal job site identifier
JOB_TYPE_DESC	Type of service being used
JOB_NUMBER	Internal Job identifier
JOB_SITE_CITY	City of job site
JOB_SITE_STATE	State of job site
JOB_SITE_ZIP	Postal code of job site
JOB_SITE_COUNTY	County of job site
CUSTOMER_CITY	Customer city location
CUSTOMER_ZIP	Customer postal code location