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.
- Power Plant Operations
- Data model
The tables behind Power Plant Operations
Power Plant Operations 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
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Site context
Sites anchor Meters, operational events, maintenance tasks and Tariffs.
Generation
Generating units belong to operational events, and generation intervals belong to generating units.
Metering
Meter readings and energy intervals each refer to Meters.
People and work
People connect to Users and receive maintenance tasks.
Every table, by feature
- Sites and personnel3
- Generating units3
- Generation intervals3
- Metering and energy4
- Operational events4
- Maintenance work4
- Tariffs and rates3
- Sites
Generating sites and their operating status.
- People
Plant personnel referenced by operational work and resolved to authenticated users.
Linked to Users - Users
Users
Linked to Users
- Generating units
Generating units attached to an operational record, with rated capacity and fuel type.
Linked to Operational events - Operational events
Outages, maintenance, alarms and curtailments with response and recovery.
Linked to Sites - Generation intervals
Generation output and fuel consumption intervals for a generating unit.
Linked to Generating units
- Generation intervals
Generation output and fuel consumption intervals for a generating unit.
Linked to Generating units - Generating units
Generating units attached to an operational record, with rated capacity and fuel type.
Linked to Operational events - Operational events
Outages, maintenance, alarms and curtailments with response and recovery.
Linked to Sites
- Meters
Metering devices installed at a site, with energy type, unit and reading mode.
Linked to Sites - Meter readings
Source meter observations with quality flags.
Linked to Meters - Energy intervals
Non-overlapping energy intervals derived from eligible meter observations.
Linked to Meters - Sites
Generating sites and their operating status.
- Operational events
Outages, maintenance, alarms and curtailments with response and recovery.
Linked to Sites - Sites
Generating sites and their operating status.
- Generating units
Generating units attached to an operational record, with rated capacity and fuel type.
Linked to Operational events - Maintenance tasks
Assigned maintenance work arising from operational events.
Linked to Sites, People
- Maintenance tasks
Assigned maintenance work arising from operational events.
Linked to Sites, People - People
Plant personnel referenced by operational work and resolved to authenticated users.
Linked to Users - Sites
Generating sites and their operating status.
- Operational events
Outages, maintenance, alarms and curtailments with response and recovery.
Linked to Sites
- Tariffs
Effective rate per unit for a site over a date range.
Linked to Sites - Sites
Generating sites and their operating status.
- Energy intervals
Non-overlapping energy intervals derived from eligible meter observations.
Linked to Meters
Keys and references
Each record has its own identifier or account reference. Follow the explicit reference columns when tracing a period to its meter or unit. A generating unit’s operational record supplies its event context. A maintenance task identifies both its site and assigned person. The model has 11 tables; saved list screens remain views on those records.
Migration order
- Create Users and People, then enter Sites.
- Add Meters for the correct sites and operational events for plant context.
- Add generating units against their operational records.
- Bring in meter readings and generation intervals with their references and time boundaries.
- Add energy intervals, maintenance tasks and Tariffs after the referenced records exist.
Set up Power Plant Operations your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.