These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Waste Management / Scrap
- Data model
The tables behind Waste Management / Scrap
Waste Management / Scrap ships with 10 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 10
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Work Planning
Work orders references Sites through Site and People through assigned to. Requested at, due date and completed at give the stored order its operating dates.
Field Evidence
Work logs references work orders and People. Recorded at, Description, Quantity and Unit describe the activity, while operation key is an internal workflow idempotency key.
Waste Streams
Waste streams references work orders through operational record. Stream name, material type, hazard class and Unit define the material context for the selected order.
Disposal Manifests
Disposal manifests references waste streams through Stream. Collected at, Quantity, Carrier, Destination and Certificate accompany its Draft, Collected, Transferred and Certified states.
Exception Resolution
Exceptions references work orders. Reason, opened at and resolved at describe issues moving through Open, Review and Resolved.
Service Charges
Service charges references work orders and Partners. Amount, charged at and Status describe the financial record associated with that work and partner.
Every table, by feature
- Work orders
Authorized waste collection, processing and disposal work orders.
Linked to Sites, People - Sites
Operating sites and facilities where waste work is performed.
- People
Staff and operators who perform and review waste operations work.
Linked to Users - Users
Users
Linked to Users
- Work logs
Field work log entries recorded against a work order.
Linked to Work orders, People - Work orders
Authorized waste collection, processing and disposal work orders.
Linked to Sites, People - People
Staff and operators who perform and review waste operations work.
Linked to Users - Users
Users
Linked to Users - Exceptions
Operational exceptions raised against work orders and their resolution.
Linked to Work orders
- Waste streams
Waste stream definitions captured against an operational work order.
Linked to Work orders - Work orders
Authorized waste collection, processing and disposal work orders.
Linked to Sites, People - Work logs
Field work log entries recorded against a work order.
Linked to Work orders, People - People
Staff and operators who perform and review waste operations work.
Linked to Users - Exceptions
Operational exceptions raised against work orders and their resolution.
Linked to Work orders - Disposal manifests
Disposal manifests tracking collection, transfer and certification of waste streams.
Linked to Waste streams
- Disposal manifests
Disposal manifests tracking collection, transfer and certification of waste streams.
Linked to Waste streams - Waste streams
Waste stream definitions captured against an operational work order.
Linked to Work orders - Work orders
Authorized waste collection, processing and disposal work orders.
Linked to Sites, People - Exceptions
Operational exceptions raised against work orders and their resolution.
Linked to Work orders - Partners
Haulers, carriers, recyclers and disposal partners.
- Exceptions
Operational exceptions raised against work orders and their resolution.
Linked to Work orders - Work orders
Authorized waste collection, processing and disposal work orders.
Linked to Sites, People - Work logs
Field work log entries recorded against a work order.
Linked to Work orders, People - People
Staff and operators who perform and review waste operations work.
Linked to Users - Waste streams
Waste stream definitions captured against an operational work order.
Linked to Work orders - Disposal manifests
Disposal manifests tracking collection, transfer and certification of waste streams.
Linked to Waste streams
- Service charges
Service charges billed against work orders by partners.
Linked to Work orders, Partners - Partners
Haulers, carriers, recyclers and disposal partners.
- Work orders
Authorized waste collection, processing and disposal work orders.
Linked to Sites, People - Work logs
Field work log entries recorded against a work order.
Linked to Work orders, People - Disposal manifests
Disposal manifests tracking collection, transfer and certification of waste streams.
Linked to Waste streams - Exceptions
Operational exceptions raised against work orders and their resolution.
Linked to Work orders
Keys and references
Preserve each record’s identifier, including work order ID, stream ID and manifest ID. Disposal manifests reaches its operating order through Stream and waste streams.operational record. Do not attach a manifest to a different work order by matching a similar material name.
People.User links to the authenticated Users identity. My Work Orders resolves the signed-in user through that relationship to work orders.assigned to. Users.User is a self-reference in the account model and must follow the platform’s identity setup. People.role title describes a job; permissions come from the configured role.
Disposal manifests.Carrier is text, while service charges.Partner is a reference to Partners. Retain that distinction during imports. A manifest’s quantity takes its unit context from the selected waste streams record. Keep work logs.Unit explicit when comparing field quantities, and preserve workflow-written operation key values when investigating repeated commands.
Migration order
- Establish valid platform Users and linked People, then confirm active operators and their role permissions.
- Prepare Sites and Partners with consistent names and operating contact details.
- Load work orders with actual Site and assigned to references. Preserve stored states and dates without treating imported status as fresh approval evidence.
- Add work logs and waste streams under their real work orders, retaining attribution, quantities and units.
- Load disposal manifests under their actual Stream with the source certificate attachments and movement details.
- Preserve Exceptions and service charges with their original work order and Partner relationships. Reconcile the imported evidence before relying on completion or financial states.
Set up Waste Management / Scrap your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.