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.
- School Bus Tracking
- Data model and import order
The tables behind School Bus Tracking
School Bus Tracking ships with 14 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
- 14
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Bus runs:
Loads connects the organization, owner, transport partner, promised delivery and actual pickup and delivery.
Stops and assignments:
Load stops orders the route; load assignments connects a dated interval to Drivers and Vehicles.
Student boarding:
Student boardings links an operational boarding observation to Loads and Organizations.
Resource readiness:
Vehicles and vehicle defects retain readiness, severity, repair evidence and release date.
Review and evidence:
Review decisions, record attachments and operation receipts remain linked to their parent Loads record.
Operating parties:
Organizations, team members, Users and transport partners identify who owns, serves and reviews work.
Every table, by feature
- Bus runs5
- Stops and windows3
- Assignments and readiness5
- Student boardings5
- Review and evidence5
- Organizations and partners5
- Loads
Planned and executed school bus runs.
Linked to Organizations, Team members, Transport partners - Load stops
Ordered pickup and drop-off stops on a bus run.
Linked to Loads - Load assignments
Driver and vehicle commitments for a bus run.
Linked to Loads, Drivers, Vehicles - Operation receipts
Durable receipts for each guarded operation attempt.
Linked to Loads - Review decisions
Independent approve, reject and return decisions.
Linked to Loads, Team members
- Load stops
Ordered pickup and drop-off stops on a bus run.
Linked to Loads - Loads
Planned and executed school bus runs.
Linked to Organizations, Team members, Transport partners - Student boardings
Verified student boarding records for a bus run.
Linked to Loads, Organizations
- Load assignments
Driver and vehicle commitments for a bus run.
Linked to Loads, Drivers, Vehicles - Drivers
Licensed bus drivers and their eligibility.
- Vehicles
School buses and their readiness.
- Vehicle defects
Reported bus defects and repair state.
Linked to Vehicles - Loads
Planned and executed school bus runs.
Linked to Organizations, Team members, Transport partners
- Student boardings
Verified student boarding records for a bus run.
Linked to Loads, Organizations - Loads
Planned and executed school bus runs.
Linked to Organizations, Team members, Transport partners - Load stops
Ordered pickup and drop-off stops on a bus run.
Linked to Loads - Record attachments
Files and evidence linked to a bus run.
Linked to Loads, Team members - Review decisions
Independent approve, reject and return decisions.
Linked to Loads, Team members
- Review decisions
Independent approve, reject and return decisions.
Linked to Loads, Team members - Operation receipts
Durable receipts for each guarded operation attempt.
Linked to Loads - Record attachments
Files and evidence linked to a bus run.
Linked to Loads, Team members - Loads
Planned and executed school bus runs.
Linked to Organizations, Team members, Transport partners - Team members
Dispatchers, supervisors and administrators with app access.
Linked to Organizations, Users
- Organizations
School districts and operators that own the transportation records.
- Team members
Dispatchers, supervisors and administrators with app access.
Linked to Organizations, Users - Users
Users
Linked to Users - Transport partners
Contracted bus operators and transport providers.
Linked to Organizations - Loads
Planned and executed school bus runs.
Linked to Organizations, Team members, Transport partners
Keys and references
Use stable organization, partner, driver, vehicle and run identifiers. Import child records through their exact parent reference, not a similar route label. Preserve run revisions, decision source revisions and operation keys when migrating history. A boarding entry’s Parent and Organization should agree with the run it describes. Keep times in the correct organization context.
The model contains 14 tables. Saved lists such as Run status list and Boardings awaiting review are views over their source tables. They do not introduce another storage record.
Migration order
- Load Organizations and Users, then team members with their organization and user links.
- Load transport partners, Drivers and Vehicles; attach vehicle defects to the correct Vehicles.
- Load Loads with stable numbers, organization, owner and counterparty references.
- Load ordered load stops, dated load assignments and student boardings against their parent Loads records.
- Load record attachments, review decisions and operation receipts with source revisions and keys intact; reconcile totals and permission boundaries before opening daily work.
Set up School Bus Tracking your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.