1. Gas Distribution Management
  2. Data model
Reference

The tables behind Gas Distribution Management

Gas Distribution Management 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
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Organization

Organizations, service areas and team members establish scope.

Operations

Service cases carry incidents; service evidence and meter readings add measured facts.

Review and evidence

Review decisions, record attachments and operation receipts retain decisions, files and operation results.

Access

Users are linked to team members.

Every table, by feature

Service cases

4 tablesAbout this feature
  • Service cases

    Gas distribution service incidents and restoration cases.

    Linked to Organizations, Team members, Service areas
  • Team members

    Organization-scoped operational and review memberships.

    Linked to Organizations, Users
  • Service areas

    Active service territories and counterparties.

    Linked to Organizations
  • Organizations

    Authorized utility organizations and reporting scope.

Organizations and service areas

3 tablesAbout this feature
  • Organizations

    Authorized utility organizations and reporting scope.

  • Service areas

    Active service territories and counterparties.

    Linked to Organizations
  • Team members

    Organization-scoped operational and review memberships.

    Linked to Organizations, Users

Operational evidence

3 tablesAbout this feature
  • Service evidence

    Source-identified operational evidence linked to cases.

    Linked to Service cases
  • Service cases

    Gas distribution service incidents and restoration cases.

    Linked to Organizations, Team members, Service areas
  • Record attachments

    Scoped evidence files attached to service cases.

    Linked to Service cases, Team members

Review decisions

4 tablesAbout this feature
  • Review decisions

    Independent review decisions on operational revisions.

    Linked to Service cases, Team members
  • Service evidence

    Source-identified operational evidence linked to cases.

    Linked to Service cases
  • Service cases

    Gas distribution service incidents and restoration cases.

    Linked to Organizations, Team members, Service areas
  • Team members

    Organization-scoped operational and review memberships.

    Linked to Organizations, Users

Meter readings

4 tablesAbout this feature
  • Meter readings

    Meter reading extensions submitted for validation.

    Linked to Service cases, Organizations
  • Service cases

    Gas distribution service incidents and restoration cases.

    Linked to Organizations, Team members, Service areas
  • Service evidence

    Source-identified operational evidence linked to cases.

    Linked to Service cases
  • Review decisions

    Independent review decisions on operational revisions.

    Linked to Service cases, Team members

Operation receipts

4 tablesAbout this feature
  • Operation receipts

    Idempotent receipts for authorized operations and reconciliation.

    Linked to Service cases
  • Service cases

    Gas distribution service incidents and restoration cases.

    Linked to Organizations, Team members, Service areas
  • Service evidence

    Source-identified operational evidence linked to cases.

    Linked to Service cases
  • Record attachments

    Scoped evidence files attached to service cases.

    Linked to Service cases, Team members

Case attachments

3 tablesAbout this feature
  • Record attachments

    Scoped evidence files attached to service cases.

    Linked to Service cases, Team members
  • Service cases

    Gas distribution service incidents and restoration cases.

    Linked to Organizations, Team members, Service areas
  • Team members

    Organization-scoped operational and review memberships.

    Linked to Organizations, Users

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Service cases uses record number for the human case identity and Revision for change control. Related records point to the case through Parent. Operation receipts uses operation key with expected revision to recognize a repeat request. Review decisions uses source revision to bind a decision to the case version.

Migration order

  1. Import Organizations and Users.
  2. Import service areas and team members with their organization references.
  3. Import service cases with owners and counterparties.
  4. Bring in service evidence, meter readings and record attachments for those cases.
  5. Import review decisions and operation receipts only with traceable case and source identities.

Set up Gas Distribution Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started