Open Case
leafleafleafMan illustrationFlower illustration
Updated on March 7, 2025

Data Model

Estimated reading: 4 minutes 5 views

Metering & Consumption Data Architecture

In the Metering & Consumption module, the Metering object register all the information received directly from the meters and devices.

The Metering object is related to the Device object, which contains detailed information about the type, manufacturer, model, serial number, and current status of the device.

The Metering object could be related directly to Service Point or contract in case you don’t have Device information on your system.

Metering information could be used not only to calculate consumption, but can also be used for control purposes, to generate alerts, or to create reports.

Consumption could be calculated based on the difference between two metering records. The consumption calculation could be done in different ways depending on the business rules of the company.

You can also receive directly the consumption or usage information to aplpy to the Service Point or Contract.

Every calculated Consumption keeps traceability of the Metering records used to calculate it.

Entity Relationship Diagram

erDiagram
    "SERVICE POINT" ||--o{ INSTALLATION : installations
    INSTALLATION }o--|| DEVICE : "installed device"
    DEVICE ||--o{"METERING": "Meterings"
    "METERING" ||--o{ "CONSUMPTION" : "Consumptions"
    "METERING" ||--|| "SERVICE POINT" : "Service Point"
    "CONSUMPTION" ||--|| "SERVICE POINT" : "Service Point"
    "CONSUMPTION" ||--|| DEVICE : "Device"

 

Metering Data Model

Field Type Description Example
Device Lookup Device related to the metering. Id
Effective date Date Date of the metering source register. YYYY-MM-DD
Effective time Time Time of the metering source register. HH:MI:SS.000
Mode Picklist Mode of generation of the metering. ‘Real’, ‘Estimated’
Mode Type Picklist Type of metering dependent on the mode. ‘Auto’, ‘Manual’…
Status String Status of the metering. ‘Pending’
Validated Boolean Validation status of the metering. True
Validation Message String Validation message of the metering. ‘Validated’
Block String Block of the metering. ‘Block A’
Service Point Lookup Service Point where the Device was installed when the metering was received. Service Point Id
Consumption Lookup Id of the Consumption generated using this metering. Consumption Id
P01,P02,P03,P04,P05,P06 Decimal Main Values of the metering. ‘123.45’
R01,R02,R03,R04,R05,R06 Decimal Secondary set of metering values. ‘123.45’
M01,M02,M03,M04,M05,M06 Decimal Third set of metering values. ‘123.45’
PT,RT,MT Decimal Value fields recommendded user for Totalizers. ‘123.45’

 

Consumption Data Model

Field Type Description Example
Device Lookup Device related to the consumption. Id
Service Point Lookup Service Point where the Device was installed when the metering was received. Service Point Id
from Date Date Date of the initial metering source register used to calculate the consumption. YYYY-MM-DD
from Time Time Time of the initial metering source register used to calculate the consumption. HH:MI:SS.000
to Date Date Date of the final metering source register used to calculate the consumption. YYYY-MM-DD
to Time Time Time of the final metering source register used to calculate the consumption. HH:MI:SS.000
Metering From Lookup Id of the initial metering used to calculate consumption. Consumption Id
Metering To Lookup Id of the final metering used to calculate consumption. Consumption Id
Status String Status of the Consumption. ‘Pending’
Calculation mode Picklist Register the mode used to calculate or ingest the consumption. ‘DIFV’
Validated Boolean Validation status of the consumption. True
Validation Message String Validation message of the consumption. ‘Validated’
Block String Block of the consumption used to split or group. ‘Block A’
Source Consumption Lookup Id of the source Consumption used to generate splitted consumptions. Consumption Id
P01,P02,P03,P04,P05,P06 Decimal Main Values of the metering. ‘123.45’
R01,R02,R03,R04,R05,R06 Decimal Secondary set of metering values. ‘123.45’
M01,M02,M03,M04,M05,M06 Decimal Third set of metering values. ‘123.45’
PT,RT,MT Decimal Value fields recommendded user for Totalizers. ‘123.45’

Leave a Comment

       
Euphoria, forever till the end of times

Euphoria

Share this Doc

Data Model

Or copy link

CONTENTS

Powered By EazyDocs