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.
- Campus Facility Management
- Data model
The tables behind Campus Facility Management
Campus Facility Management 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
Equipment
Assets holds identity, location and service state; building meters and preventive maintenance plans each link to the maintained asset.
Work
Work orders links the asset to an assignee in People. Work logs records technician activity; safety permits records authorization for the order.
Material and history
Part usage connects a work order to spare parts. Service history connects completed work back to the asset and order.
People
People links staff entries to Users and supports assignee, issuer and technician references.
Every table, by feature
- Assets5
- Work orders7
- Safety permits4
- Preventive maintenance5
- Building meters4
- Parts and service5
- Shared and settings1
- Assets
Campus asset registry
- Work orders
Maintenance work orders through their lifecycle
Linked to Assets, People - Building meters
Building meter readings per asset: measurement point, value, unit and action limit.
Linked to Assets - Preventive maintenance plans
Preventive maintenance intervals per asset: last completion and next due date.
Linked to Assets - Service history
Completed maintenance history per asset
Linked to Assets, Work orders
- Work orders
Maintenance work orders through their lifecycle
Linked to Assets, People - Assets
Campus asset registry
- People
Maintenance staff directory
Linked to Users - Safety permits
Safety permits authorizing work
Linked to People, Work orders - Work logs
Technician work performed against a work order
Linked to People, Work orders - Service history
Completed maintenance history per asset
Linked to Assets, Work orders - Part usage
Parts consumed on work orders
Linked to Spare parts, Work orders
- Safety permits
Safety permits authorizing work
Linked to People, Work orders - Work orders
Maintenance work orders through their lifecycle
Linked to Assets, People - People
Maintenance staff directory
Linked to Users - Assets
Campus asset registry
- Preventive maintenance plans
Preventive maintenance intervals per asset: last completion and next due date.
Linked to Assets - Assets
Campus asset registry
- Work orders
Maintenance work orders through their lifecycle
Linked to Assets, People - Safety permits
Safety permits authorizing work
Linked to People, Work orders - Service history
Completed maintenance history per asset
Linked to Assets, Work orders
- Building meters
Building meter readings per asset: measurement point, value, unit and action limit.
Linked to Assets - Assets
Campus asset registry
- Work orders
Maintenance work orders through their lifecycle
Linked to Assets, People - Service history
Completed maintenance history per asset
Linked to Assets, Work orders
- Spare parts
Spare part inventory catalog
- Part usage
Parts consumed on work orders
Linked to Spare parts, Work orders - Work orders
Maintenance work orders through their lifecycle
Linked to Assets, People - Assets
Campus asset registry
- Service history
Completed maintenance history per asset
Linked to Assets, Work orders
Keys and references
Use asset tags and serial numbers to confirm the physical equipment, but preserve the record references for work and history. A permit’s work order must identify the exact job it authorizes. The work log’s Technician and the order’s assigned to both refer to People. Part usage needs both its Part and work order references. Service history retains both Asset and work order links.
Migration order
- Load Users and People, then confirm the names used for assignments and permit issue.
- Load Assets and spare parts with verified physical identity and stock units.
- Add preventive maintenance plans and building meters to the correct assets.
- Bring in open work orders and their safety permits, then work logs and part usage where applicable.
- Reconcile service history against the asset and completed order before daily use.
Set up Campus Facility Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.