METERDATA_AGGREGATE_READS
Publishes aggregated metering data associated with a wholesale connection point for a given CASE_ID.
Package
METER_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CASE_ID |
numeric(15, 0)  |
int |
Case Identifier |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Settlement date within the case |
| CONNECTIONPOINTID |
varchar(20) |
varchar(20) |
Connection Point ID |
| METER_TYPE |
varchar(20) |
varchar(20) |
The meter type for the read, one of: CUSTOMER; GENERATOR; EMBEDDED_GENERATOR |
| FRMP |
varchar(20) |
varchar(20) |
The financially responsible market participantid |
| LR |
varchar(20) |
varchar(20) |
The local retailer at the connection point id |
| PERIODID |
numeric(3, 0) |
smallint |
Trading Interval. |
| IMPORTVALUE |
numeric(18, 8) (not nullable) |
numeric(18, 8) (not nullable) |
The import(pool-centric) value for the meter read (MWh) |
| EXPORTVALUE |
numeric(18, 8) (not nullable) |
numeric(18, 8) (not nullable) |
The export(pool-centric) value for the meter read (MWh) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_AGGREGATE_READS_PK |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINTID, METER_TYPE, FRMP, LR, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_AGGREGATE_READS |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINTID, METER_TYPE, FRMP, LR, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_AGGREGATE_READS |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINTID, METER_TYPE, FRMP, LR, PERIODID |