Table: METERDATA_WDR_READS

METERDATA_WDR_READS

Name

METERDATA_WDR_READS

Comment

Metering Data WDR Readings


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CASE_ID

MARKET_ID

METER_ID

PERIODID

SETTLEMENTDATE


Content

Name

Data Type

Mandatory

Comment

MARKET_ID

VARCHAR2(20)

X

Unique identifier for the market to which this metering record applies. Always equal to NEM in the current system.

CASE_ID

NUMBER(15,0)

X

Unique identifier for the metering case.

SETTLEMENTDATE

DATE

X

The settlement date for the metering record

METER_ID

VARCHAR2(20)

X

Unique identifier for the meter to which the metering record applies

TNI

VARCHAR2(20)

 

Unique identifier for the transmission node to which this meter 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, i.e interval ending 00:05.

METEREDQUANTITYIMPORT

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

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

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

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.

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.

BASELINECALCULATIONID

VARCHAR2(100)

 

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