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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


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