Table: BILLINGRESERVERECOVERY

BILLINGRESERVERECOVERY

Name

BILLINGRESERVERECOVERY

Comment

BILLINGRESERVERECOVERY shows Market Reserve recovery details for each participant in a bill run.


Description

BILLINGRESERVERECOVERY data is Confidential to participant.

Source

BILLINGRESERVERECOVERY updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. BILLINGRESERVERECOVERY is empty until such an event occurs.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

AEMO Contract Year number starting in week containing 1st January

WEEKNO

NUMBER(3,0)

X

Week no within the contract year. Week no 1 is the week containing 1st January

BILLRUNNO

NUMBER(3,0)

X

Unique run no within a given contract year and week no

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

MARKETRESERVE

NUMBER(15,5)

 

Amount Retailer pays for Reserve Trader Contracts with Market Recovery

LASTCHANGED

DATE

 

Last date and time record changed