METERDATA_INDIVIDUAL_READS
Publishes metering data associated with individual metering points 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 |
| METER_ID |
varchar(20) |
varchar(20) |
The National Metering Identifier (NMI) |
| METER_ID_SUFFIX |
varchar(20) |
varchar(20) |
The National Metering Identifier (NMI) data stream |
| PERIODID |
numeric(3, 0) |
smallint |
Trading Interval. |
| FRMP |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
The financially responsible market participantid |
| LR |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
The local retailer at the connection point id |
| CONNECTIONPOINTID |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
Connection Point ID |
| METER_TYPE |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
The meter type for the read, one of: CUSTOMER; GENERATOR; EMBEDDED_GENERATOR |
| 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_INDIVIDUAL_READS_PK |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, METER_ID, METER_ID_SUFFIX, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_INDIVIDUAL_READS |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, METER_ID, METER_ID_SUFFIX, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_INDIVIDUAL_READS |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, METER_ID, METER_ID_SUFFIX, PERIODID |