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.
- Factory Energy Management
- Factory energy data model
The tables behind Factory Energy Management
Factory Energy 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
- Change it
- Add fields and tables in Proto
How the model is organised
Metering and Readings
Sites defines operating locations; Meters links each meter through Site. Meter readings stores read at, Value, quality flag and validation details. People links each staff record to Users through User.
Energy Intervals
Energy intervals links to Meters through Meter and records starts at, ends at, energy quantity, Unit and Status.
Operating Events and Maintenance
Operational events links to Sites. Maintenance tasks links to Sites and People through assigned to; its Status and completed at describe the task's progress.
Tariffs and Cost Review
Tariffs links to Sites and records effective from, effective to, rate per unit and Unit. Cost comparisons follow energy intervals.Meter to Meters.Site.
Production Allocations
Production allocations links to Meters and stores work order reference, starts at, ends at, allocated K wh and allocation method with validation details.
Emission Factors
Emission factors links to operational events through operational record and records energy type, Region, effective from, KgC o2e per K wh and source citation.
Every table, by feature
- Metering and Readings5
- Energy Intervals4
- Operating Events and Maintenance5
- Tariffs and Cost Review4
- Production Allocations4
- Emission Factors5
- Sites
Physical plant sites whose energy consumption is monitored.
- Meters
Energy meters installed at a site, with their energy type, unit and reading mode.
Linked to Sites - Meter readings
Raw meter observations captured from the site meter, including estimated and invalid reads.
Linked to Meters - People
Factory Energy Management staff and their application user account and role title.
Linked to Users - Users
Users
Linked to Users
- Energy intervals
Validated non-overlapping energy intervals derived from meter observations for consumption and cost.
Linked to Meters - Meters
Energy meters installed at a site, with their energy type, unit and reading mode.
Linked to Sites - Sites
Physical plant sites whose energy consumption is monitored.
- Meter readings
Raw meter observations captured from the site meter, including estimated and invalid reads.
Linked to Meters
- Operational events
Outages, alarms, maintenance windows and curtailments that affect site energy availability.
Linked to Sites - Maintenance tasks
Maintenance work raised for a site and assigned to a responsible person.
Linked to Sites, People - Sites
Physical plant sites whose energy consumption is monitored.
- People
Factory Energy Management staff and their application user account and role title.
Linked to Users - Users
Users
Linked to Users
- Tariffs
Effective energy tariff rates per site and unit used for consumption cost.
Linked to Sites - Energy intervals
Validated non-overlapping energy intervals derived from meter observations for consumption and cost.
Linked to Meters - Meters
Energy meters installed at a site, with their energy type, unit and reading mode.
Linked to Sites - Sites
Physical plant sites whose energy consumption is monitored.
- Production allocations
Energy attributed to a specific meter and work order for production cost allocation.
Linked to Meters - Meters
Energy meters installed at a site, with their energy type, unit and reading mode.
Linked to Sites - Energy intervals
Validated non-overlapping energy intervals derived from meter observations for consumption and cost.
Linked to Meters - Sites
Physical plant sites whose energy consumption is monitored.
- Emission factors
Emission factors applied to operational records to derive carbon for consumed energy.
Linked to Operational events - Operational events
Outages, alarms, maintenance windows and curtailments that affect site energy availability.
Linked to Sites - Sites
Physical plant sites whose energy consumption is monitored.
- Energy intervals
Validated non-overlapping energy intervals derived from meter observations for consumption and cost.
Linked to Meters - Meters
Energy meters installed at a site, with their energy type, unit and reading mode.
Linked to Sites
Keys and references
Use Id to reconcile operational records and meter number to identify the physical meter during setup. Confirm the actual source identifier mapping before importing observations. Work order reference is a text identifier owned by the production reference convention. Resolve it against the production source when configuring a connection.
For personal task views, resolve maintenance tasks.assigned to through People.User to the signed-in account. Users also contains a User reference to Users; retain that account relationship when mapping existing identities. Validation status describes evidence validation, while the Status on intervals, events and tasks describes each record’s own lifecycle.
Migration order
- Establish Users identities and their account references; map People to the correct User.
- Create Sites with the location, Timezone and Status used by the operating team.
- Link Meters and Tariffs to Sites, retaining reading mode, units and effective periods.
- Load meter readings and energy intervals with their actual dates and meter links.
- Load operational events and maintenance tasks with site and assigned-person references.
- Load production allocations after meters are mapped, then emission factors after the referenced events exist.
Set up Factory Energy Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.