Table: BILLING_MR_RECOVERY

BILLING_MR_RECOVERY

Name

BILLING_MR_RECOVERY

Comment

BILLING_MR_RECOVERY shows aggregate recovery charges on a dispatchable unit / MR Event basis for spot market income from dispatch of MR capacity.


Description

BILLING_MR_RECOVERY data is confidential, and is available only to the relevant participant.

Source

Ad hoc - MR events only.

Volume

3500 rows per year


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

DUID

MR_DATE

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Billing Contract Year

WEEKNO

NUMBER(3,0)

X

Billing Week number

BILLRUNNO

NUMBER(3,0)

X

Billing Run number

MR_DATE

DATE

X

Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date

REGIONID

VARCHAR2(10)

X

Unique Region Identifier

PARTICIPANTID

VARCHAR2(10)

 

Unique Participant identifier

DUID

VARCHAR2(10)

X

Unique identifier for DUID / MNSP LinkID

MR_AMOUNT

NUMBER(16,6)

 

Payment amount to AEMO

LASTCHANGED

DATE

 

Date/Time record inserted/modified