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.
- Asset Tracking
- Data model
The tables behind Asset Tracking
Asset Tracking ships with 11 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
- 11
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Asset Register
Tracked assets holds asset tag, Name, home location, Manufacturer, serial number, commissioned at and Status. It is the shared equipment reference for the operational records.
Preventive Maintenance
Maintenance schedules links to tracked assets and retains interval days, interval hours, last serviced at and next due at.
Condition Monitoring
Asset usage meters links each Reading to the asset, with reading at, meter type, Unit and action limit.
Maintenance Work
Maintenance tickets links the asset and Technician. Maintenance logs links each work entry to maintenance ticket and Technician, with started at, ended at and work performed.
Parts and Reorder
Part usage joins maintenance tickets and spare parts with Quantity and used at. Spare parts holds the catalog unit, quantity on hand and reorder point.
Warranty and Service History
Warranty information links its validity dates and issuer to maintenance tickets; the asset resolves through that ticket. Calibration certificates links directly to both tracked assets and maintenance tickets with the service date, result and next due date.
Identity
Employees links to Users through User. Preserve the published Users.User self-reference when mapping existing identities.
Every table, by feature
- Asset Register3
- Preventive Maintenance3
- Condition Monitoring2
- Maintenance Work5
- Parts and Reorder3
- Warranty and Service History5
- Shared and settings1
- Tracked assets
Asset master: one row per physical asset under operational tracking, with tag, location, custodian and status detail.
- Maintenance tickets
Maintenance work record for preventive or corrective work, tracked through an approval-to-close lifecycle.
Linked to Tracked assets, Employees - Calibration certificates
Per-asset certification record with performed date, outcome and next due date, linked to its maintenance ticket.
Linked to Tracked assets, Maintenance tickets
- Maintenance schedules
Preventive maintenance schedule per asset with interval days or hours, last serviced date and next due date.
Linked to Tracked assets - Tracked assets
Asset master: one row per physical asset under operational tracking, with tag, location, custodian and status detail.
- Maintenance tickets
Maintenance work record for preventive or corrective work, tracked through an approval-to-close lifecycle.
Linked to Tracked assets, Employees
- Asset usage meters
Time-series asset usage-meter readings with meter type, reading, unit and action limit.
Linked to Tracked assets - Tracked assets
Asset master: one row per physical asset under operational tracking, with tag, location, custodian and status detail.
- Maintenance tickets
Maintenance work record for preventive or corrective work, tracked through an approval-to-close lifecycle.
Linked to Tracked assets, Employees - Maintenance logs
Log of work performed against a maintenance ticket, with technician, start, end and work description.
Linked to Employees, Maintenance tickets - Tracked assets
Asset master: one row per physical asset under operational tracking, with tag, location, custodian and status detail.
- Employees
Employee directory used for ticket assignment, issuing, and technician and custodian references.
Linked to Users - Calibration certificates
Per-asset certification record with performed date, outcome and next due date, linked to its maintenance ticket.
Linked to Tracked assets, Maintenance tickets
- Spare parts
Spare-part catalog with stock on hand, unit of measure and reorder point.
- Part usage
Spare parts consumed against a maintenance ticket, with quantity and usage date.
Linked to Spare parts, Maintenance tickets - Maintenance tickets
Maintenance work record for preventive or corrective work, tracked through an approval-to-close lifecycle.
Linked to Tracked assets, Employees
- Warranty information
Per-asset warranty and coverage record with type, validity window, issuer and status, linked to its maintenance ticket.
Linked to Employees, Maintenance tickets - Calibration certificates
Per-asset certification record with performed date, outcome and next due date, linked to its maintenance ticket.
Linked to Tracked assets, Maintenance tickets - Maintenance tickets
Maintenance work record for preventive or corrective work, tracked through an approval-to-close lifecycle.
Linked to Tracked assets, Employees - Tracked assets
Asset master: one row per physical asset under operational tracking, with tag, location, custodian and status detail.
- Employees
Employee directory used for ticket assignment, issuing, and technician and custodian references.
Linked to Users
Keys and references
Use stable record identities for links. Asset tag and serial number help staff identify equipment, but the record reference determines which asset receives the reading or maintenance effect. Check that the certificate’s asset agrees with the asset on its linked maintenance ticket.
Resolve personal work through Employees.User before applying a current-user filter to Technician. Follow warranty information.maintenance ticket to that ticket’s tracked asset when checking coverage eligibility. Keep part usage attached to the posting’s intended ticket and part so a stock reduction remains explainable.
Migration order
- Resolve Users and Employees identities, including employee status and user mappings.
- Load tracked assets and spare parts with agreed equipment identities, catalog units and opening balances.
- Load maintenance schedules and asset usage meters against the correct assets, distinguishing historical readings from new command execution.
- Load maintenance tickets with valid asset and technician references, then warranty information against those tickets and issuers.
- Load maintenance logs and calibration certificates with consistent ticket, asset and employee references.
- Reconcile historical part usage with opening stock before any live posting; importing history must not decrement stock a second time.
Set up Asset Tracking your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.