SET_WDR_RECON_DETAIL
Settlements WDR reconciliation details.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date |
| SETTLEMENTRUNNO |
numeric(3, 0) |
smallint |
Settlement run number |
| NMI |
varchar(20) |
varchar(20) |
Unique identifier for the meter to which the metering records applies |
| PERIODID |
numeric(3, 0) |
smallint |
Trading interval identifier with Period 1 being the first TI for the calendar day, that is the interval ending 00:05 |
| TNI |
varchar(20) |
varchar(20) |
Unique identifier for the transmission node to which this meter belongs on the settlement date |
| REGIONID |
varchar(20) |
varchar(20) |
Unique identifier for the region to which the TNI 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 |
| WDRSQ_UNCAPPED |
numeric(18, 8) |
numeric(18, 8) |
WDR settlement quantity before any capping or flooring (MWh) |
| WDRSQ_CAPPED |
numeric(18, 8) |
numeric(18, 8) |
WDR settlement quantity after capping or flooring (MWh) |
| MRC |
numeric(18, 8) |
numeric(18, 8) |
Maximum responsive component for the NMI (MW) |
| MRCSQ |
numeric(18, 8) |
numeric(18, 8) |
Maximum responsive component settlement quantity for the NMI (MWh) |
| WDRRR |
numeric(18, 8) |
numeric(18, 8) |
WDR reimbursement rate for the region ($/MWh) |
| RRP |
numeric(18, 8) |
numeric(18, 8) |
Regional reference price for the region in the settlement interval ($/MWh) |
| TLF |
numeric(18, 8) |
numeric(18, 8) |
Transmission loss factor for the wholesale connection point associated with the NMI |
| ME_DLFADJUSTED |
numeric(18, 8) |
numeric(18, 8) |
Metered quantity in MWh for the NMI trading interval. A negative value indicates net consumption and a positive value indicates net generation |
| BQ_DLFADJUSTED |
numeric(18, 8) |
numeric(18, 8) |
Baseline quantity in MWh for the NMI in the trading interval. A negative quantity indicates net consumption, while a positive value indicates net generation |
| 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. |
| 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 |
| TRANSACTIONAMOUNT |
numeric(18, 8) |
numeric(18, 8) |
WDR transaction amount for this NMI in the settlement interval ($) |
| 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) |
| SET_WDR_RECON_DETAIL_PK |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, NMI, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_WDR_RECON_DETAIL |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, NMI, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_WDR_RECON_DETAIL_PK |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, NMI, PERIODID |