The tables behind Smart Building Management

Use stable record identities for references. Meter number and sensor ID help people identify sources, while Meter and Sensor determine which records receive the reading or observation. A sensor’s site context resolves through operational record to operational events.Site.

Maintenance tasks has Site and assigned to references. Review site work alongside operating events using the actual process evidence; preserve the model’s declared relationships. People.User establishes the account mapping used for personal work. Retain the published Users.User self-reference during identity setup.

Meter readings.quality flag includes Estimated, while sensor observations.quality flag uses Valid, Missing and Invalid. Keep those vocabularies distinct. Energy interval Status records the review decision separately from the original reading quality.

1. Resolve Users and People identities and the agreed active-responder convention.
2. Load Sites with recognized names, locations and timezone values.
3. Load Meters and Tariffs against the correct sites, preserving units and effective periods.
4. Load meter readings, then process or import energy intervals under the reviewed reset and overlap rules.
5. Load operational events and maintenance tasks with valid site and responder references, retaining their distinct dates and states.
6. Load building sensors against the intended operational record, then sensor observations against the correct Sensor. Verify saved identities and quality before using imported observations in the operating review.