1. Ambulance Fleet Management
  2. Data model
Reference

The tables behind Ambulance Fleet Management

Ambulance Fleet Management ships with 15 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
15
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Transport Planning

Transports references Organizations, team members through Owner, and receiving facilities. Transport stops uses Parent to attach ordered stops and planned windows.

Crew Readiness

Crew readiness checks links Parent to Transports and Vehicle to Vehicles, with Organization, Revision and equipment status retained on the check.

Dispatch Assignments

Transport assignments links Load to Transports, Driver to Drivers and Vehicle to Vehicles. Starts at and ends at describe the assignment interval.

Unit Maintenance

Vehicle defects links to Vehicles and carries Severity, Status, repair evidence and released at. Vehicles.Readiness remains a separate value.

Transport Completion

Transports carries actual pickup at and actual delivery at; transport stops carries actual arrival at, actual departure at and proof reference.

Review and Evidence

Review decisions references crew readiness checks and team members through Reviewer, with an optional Transport reference. Operation receipts and record attachments belong to Transports through Parent. Team members.User links membership to Users; exchange rates holds read-only effective currency rates.

Every table, by feature

Transport Planning

5 tablesAbout this feature
  • Transports

    Plan and track ambulance patient transports from Draft through Delivered, with promised delivery, transport charge and linked evidence.

    Linked to Organizations, Team members, Receiving facilities
  • Transport stops

    Pickup, receiving-facility and transfer stops for ambulance transports.

    Linked to Transports
  • Receiving facilities

    Hospitals and other receiving facilities eligible for ambulance transports.

    Linked to Organizations
  • Organizations

    Operating organizations that own ambulance fleet records

  • Team members

    Named members of an organization with role scope

    Linked to Organizations, Users

Crew Readiness

5 tablesAbout this feature
  • Crew readiness checks

    Crew and equipment readiness checks supporting ambulance unit release

    Linked to Transports, Organizations, Vehicles
  • Vehicles

    Ambulance units with equipment class and readiness

    Linked to Organizations
  • Transports

    Plan and track ambulance patient transports from Draft through Delivered, with promised delivery, transport charge and linked evidence.

    Linked to Organizations, Team members, Receiving facilities
  • Review decisions

    Independent approval decisions on frozen revisions

    Linked to Transports, Team members, Crew readiness checks
  • Operation receipts

    Stable receipts for every guarded operation

    Linked to Transports

Dispatch Assignments

5 tablesAbout this feature
  • Transport assignments

    Driver and vehicle assignments for ambulance transports.

    Linked to Transports, Drivers, Vehicles
  • Drivers

    Driver eligibility and external authority evidence

    Linked to Organizations
  • Vehicles

    Ambulance units with equipment class and readiness

    Linked to Organizations
  • Transports

    Plan and track ambulance patient transports from Draft through Delivered, with promised delivery, transport charge and linked evidence.

    Linked to Organizations, Team members, Receiving facilities
  • Crew readiness checks

    Crew and equipment readiness checks supporting ambulance unit release

    Linked to Transports, Organizations, Vehicles

Unit Maintenance

4 tablesAbout this feature
  • Vehicle defects

    Reported vehicle defects with repair evidence

    Linked to Vehicles
  • Vehicles

    Ambulance units with equipment class and readiness

    Linked to Organizations
  • Record attachments

    Uploaded evidence files linked to loads

    Linked to Transports, Team members
  • Crew readiness checks

    Crew and equipment readiness checks supporting ambulance unit release

    Linked to Transports, Organizations, Vehicles

Transport Completion

4 tablesAbout this feature
  • Transports

    Plan and track ambulance patient transports from Draft through Delivered, with promised delivery, transport charge and linked evidence.

    Linked to Organizations, Team members, Receiving facilities
  • Transport stops

    Pickup, receiving-facility and transfer stops for ambulance transports.

    Linked to Transports
  • Transport assignments

    Driver and vehicle assignments for ambulance transports.

    Linked to Transports, Drivers, Vehicles
  • Record attachments

    Uploaded evidence files linked to loads

    Linked to Transports, Team members

Review and Evidence

5 tablesAbout this feature
  • Review decisions

    Independent approval decisions on frozen revisions

    Linked to Transports, Team members, Crew readiness checks
  • Operation receipts

    Stable receipts for every guarded operation

    Linked to Transports
  • Record attachments

    Uploaded evidence files linked to loads

    Linked to Transports, Team members
  • Crew readiness checks

    Crew and equipment readiness checks supporting ambulance unit release

    Linked to Transports, Organizations, Vehicles
  • Transports

    Plan and track ambulance patient transports from Draft through Delivered, with promised delivery, transport charge and linked evidence.

    Linked to Organizations, Team members, Receiving facilities

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Preserve record identifiers during import. Transport number, driver code, vehicle code and facility Code help the team recognize business records, while reference fields connect the actual records. The assignment field Load points to Transports; keep that existing relationship even though the operating language is ambulance transport.

Use crew readiness checks.Vehicle as the vehicle reference. Vehicle legacy label remains historical text. Organizations and team members use their time zone select fields; keep time zone legacy separate. Resolve Users.User against the existing user records during account setup.

Keep review source revision, check Revision and receipt expected revision attached to their correct context. A decision requires crew readiness check even when Transport is also provided. Agree which record revision each action records in expected revision during setup, keeping transport and readiness-check revisions distinct.

Migration order

  1. Prepare Organizations and Users with the supported time-zone settings and identity references.
  2. Create team members with Organization and User resolved, then receiving facilities with organization ownership.
  3. Import Drivers and Vehicles, preserving eligibility evidence and external fleet ID. Load vehicle defects against their actual Vehicle references.
  4. Prepare Transports with Owner and receiving facility, then transport stops and transport assignments with their parent, driver and vehicle references.
  5. Add crew readiness checks, followed by genuine historical review decisions, record attachments and operation receipts. Preserve original revisions and dates; keep exchange rates read-only.

Set up Ambulance Fleet Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started