METERDATA_WDR_READS
Metering Data WDR Readings.
Package
METER_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| MARKET_ID |
varchar(20)  |
varchar(20) |
Unique identifier for the market to which this metering record applies. Always equal to NEM in the current system. |
| CASE_ID |
numeric(15, 0) |
bigint |
Unique identifier for the metering case. |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
The settlement date for the metering record |
| METER_ID |
varchar(20) |
varchar(20) |
Unique identifier for the meter to which the metering record applies |
| PERIODID |
numeric(3, 0) |
smallint |
Trading interval identifier, with Period 1 being the first TI for the calendar day, i.e interval ending 00:05. |
| TNI |
varchar(20) |
varchar(20) |
Unique identifier for the transmission node to which this meter belongs on the settlement date |
| FRMP |
varchar(20) |
varchar(20) |
Unique identifier for the participant acting as the FRMP for this NMI on the settlement date |
| DRSP |
varchar(20) |
varchar(20) |
Unique identifier for the participant acting as the DRSP for this NMI on the settlement date |
| METEREDQUANTITYIMPORT |
numeric(18, 8) |
numeric(18, 8) |
Metered quantity Import in MWh for the NMI in the trading interval. A negative value indicates net consumption, while a positive value indicates net generation |
| METEREDQUANTITYEXPORT |
numeric(18, 8) |
numeric(18, 8) |
Metered quantity Export in MWh for the NMI in the trading interval. A negative value indicates net consumption, while a positive value indicates net generation |
| BASELINEQUANTITY |
numeric(18, 8) |
numeric(18, 8) |
Baseline quantity in MWh for the NMI in the trading interval. A negative value indicates net consumption, while a positive value indicates the net generation |
| QUALITYFLAG |
varchar(20) |
varchar(20) |
Quality flag for the meter read. Where multiple datastreams exist against the NMI with different quality flags for each read, the lowest quality flag will be published against the NMI for the interval. |
| ISNONCOMPLIANT |
numeric(1, 0) |
tinyint |
A value of TRUE (indicated by 1) for this column indicates that financial settlement of WDR transactions for this NMI should not proceed for the settlement date and trading interval. Possible values are 1 and 0. |
| BASELINECALCULATIONID |
varchar(100) |
varchar(100) |
A reference to the baseline run that produced the baseline quantity for this NMI and interval |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_WDR_READS_PK |
clustered, unique, primary key |
MARKET_ID, CASE_ID, SETTLEMENTDATE, METER_ID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_WDR_READS |
clustered, unique, primary key |
MARKET_ID, CASE_ID, SETTLEMENTDATE, METER_ID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_WDR_READS |
clustered, unique, primary key |
MARKET_ID, CASE_ID, SETTLEMENTDATE, METER_ID, PERIODID |