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.
- Smart Meter Data Platform
- Data Model
The tables behind Smart Meter Data Platform
Smart Meter Data Platform ships with 10 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
- 10
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Meter Interval Acceptance
Interval readings references service cases through Parent and Organizations through Organization. Meter and quality flag are text; interval end, energy K wh and Revision describe the submitted reading.
Quality and Source Evidence
Service evidence references service cases and retains line number, Revision, evidence type, occurred at, measured value, Unit, source reference and verified at. Record attachments holds case-linked supporting files.
Service Case Coordination
Service cases references Organization, Owner and Counterparty, with Counterparty pointing to service areas. External incident ID and asset reference remain text source identifiers.
Restoration Review
Service cases carries reported at, affected units and restored at. Review decisions retains the reviewer, source revision, Decision and Reason under the case.
Service Areas and Access
Service areas and team members reference Organizations. Team members.User maps staff membership to Users. Active is boolean on Organizations, service areas and team members.
Corrections and Reconciliation
Operation receipts references service cases and retains operation key, Action, expected revision, result state and effect or external references for comparison.
Every table, by feature
- Meter Interval Acceptance6
- Quality and Source Evidence5
- Service Case Coordination7
- Restoration Review5
- Service Areas and Access5
- Corrections and Reconciliation6
- Interval readings
Verified meter interval readings submitted for acceptance.
Linked to Service cases, Organizations - Service cases
Operational service cases with lifecycle, affected scope and restoration.
Linked to Organizations, Team members, Service areas - Organizations
Utility organizations operating the smart meter data platform.
- Service evidence
Source-identified evidence lines supporting a service case.
Linked to Service cases - Review decisions
Independent reviewer decisions on a source revision.
Linked to Service cases, Team members - Operation receipts
Stable operation keys and persisted results for guarded actions.
Linked to Service cases
- Service evidence
Source-identified evidence lines supporting a service case.
Linked to Service cases - Interval readings
Verified meter interval readings submitted for acceptance.
Linked to Service cases, Organizations - Record attachments
Uploaded evidence files linked to a service case.
Linked to Service cases, Team members - Service cases
Operational service cases with lifecycle, affected scope and restoration.
Linked to Organizations, Team members, Service areas - Review decisions
Independent reviewer decisions on a source revision.
Linked to Service cases, Team members
- Service cases
Operational service cases with lifecycle, affected scope and restoration.
Linked to Organizations, Team members, Service areas - Service areas
Eligible service areas and counterparties within an organization.
Linked to Organizations - Organizations
Utility organizations operating the smart meter data platform.
- Team members
Utility staff with platform identity, role and time zone.
Linked to Organizations, Users - Service evidence
Source-identified evidence lines supporting a service case.
Linked to Service cases - Interval readings
Verified meter interval readings submitted for acceptance.
Linked to Service cases, Organizations - Operation receipts
Stable operation keys and persisted results for guarded actions.
Linked to Service cases
- Service cases
Operational service cases with lifecycle, affected scope and restoration.
Linked to Organizations, Team members, Service areas - Service evidence
Source-identified evidence lines supporting a service case.
Linked to Service cases - Review decisions
Independent reviewer decisions on a source revision.
Linked to Service cases, Team members - Operation receipts
Stable operation keys and persisted results for guarded actions.
Linked to Service cases - Record attachments
Uploaded evidence files linked to a service case.
Linked to Service cases, Team members
- Service areas
Eligible service areas and counterparties within an organization.
Linked to Organizations - Organizations
Utility organizations operating the smart meter data platform.
- Team members
Utility staff with platform identity, role and time zone.
Linked to Organizations, Users - Users
Users
Linked to Users - Service cases
Operational service cases with lifecycle, affected scope and restoration.
Linked to Organizations, Team members, Service areas
- Operation receipts
Stable operation keys and persisted results for guarded actions.
Linked to Service cases - Service cases
Operational service cases with lifecycle, affected scope and restoration.
Linked to Organizations, Team members, Service areas - Service evidence
Source-identified evidence lines supporting a service case.
Linked to Service cases - Review decisions
Independent reviewer decisions on a source revision.
Linked to Service cases, Team members - Interval readings
Verified meter interval readings submitted for acceptance.
Linked to Service cases, Organizations - Record attachments
Uploaded evidence files linked to a service case.
Linked to Service cases, Team members
Keys and references
Preserve record identifiers and business codes such as service cases.record number, Organizations.Code and service areas.Code. Use the source register to resolve Meter consistently. Agree its normalization and the meaning and precision of interval end before validating duplicate detection.
Intervals, evidence, attachments, decisions and receipts can share the same service case. Resolve the actual interval or evidence subject through the action’s verified identity and reference convention. Source revision and expected revision must refer to the intended source type and record. A shared Parent alone cannot associate a decision with the correct interval.
Team members.User resolves the authenticated user for My Service Cases before comparing service cases.Owner. Users.User is a self-reference and must retain its identity mapping. Keep organization references aligned between the case, interval, service area and staff authorization.
Quality flag and Unit preserve source vocabulary. Agree the interval duration and time interpretation with the source before analyzing energy over a period. Keep original and corrective records traceable through their evidence and operation references. For Accepted Energy Review, select the effective accepted result within each Organization and source interval using the verified correction evidence; retain superseded records for history.
Migration order
- Establish Organizations and Users, preserving user identity and self-reference mappings.
- Link team members and service areas to the intended organization and verify active membership.
- Load service cases with the actual reported time, affected scope and resolved owner and area.
- Bring in service evidence through the authorized source path, preserving original references, units and revisions.
- Load interval readings with correct parent and organization, retaining meter identity, end time and quality designation.
- Attach files and preserve decisions and receipts with their exact subject, revision and operation identities.
Set up Smart Meter Data Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.