Table: SET_WDR_RECON_DETAIL

SET_WDR_RECON_DETAIL

Name

SET_WDR_RECON_DETAIL

Comment

Settlements WDR reconciliation details


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

NMI

PERIODID

SETTLEMENTDATE

SETTLEMENTRUNNO


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date

SETTLEMENTRUNNO

NUMBER(3,0)

X

Settlement run number

NMI

VARCHAR2(20)

X

Unique identifier for the meter to which the metering records applies

TNI

VARCHAR2(20)

 

Unique identifier for the transmission node to which this meter belongs on the settlement date

REGIONID

VARCHAR2(20)

 

Unique identifier for the region to which the TNI belongs on the settlement date

FRMP

VARCHAR2(20)

 

Unique identifier for the participant acting as the FRMP for this NMI on the settlement date

DRSP

VARCHAR2(20)

 

Unique identifier for the participant acting as the DRSP for this NMI on the settlement date

PERIODID

NUMBER(3,0)

X

Trading interval identifier with Period 1 being the first TI for the calendar day, that is the interval ending 00:05

WDRSQ_UNCAPPED

NUMBER(18,8)

 

WDR settlement quantity before any capping or flooring (MWh)

WDRSQ_CAPPED

NUMBER(18,8)

 

WDR settlement quantity after capping or flooring (MWh)

MRC

NUMBER(18,8)

 

Maximum responsive component for the NMI (MW)

MRCSQ

NUMBER(18,8)

 

Maximum responsive component settlement quantity for the NMI (MWh)

WDRRR

NUMBER(18,8)

 

WDR reimbursement rate for the region ($/MWh)

RRP

NUMBER(18,8)

 

Regional reference price for the region in the settlement interval ($/MWh)

TLF

NUMBER(18,8)

 

Transmission loss factor for the wholesale connection point associated with the NMI

ME_DLFADJUSTED

NUMBER(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

NUMBER(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

NUMBER(1,0)

 

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

VARCHAR2(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

NUMBER(18,8)

 

WDR transaction amount for this NMI in the settlement interval ($)

BASELINECALCULATIONID

VARCHAR2(100)

 

A reference to the baseline run that produced the baseline quantity for this NMI and interval