Table: BILLING_MR_SHORTFALL

BILLING_MR_SHORTFALL

Name

BILLING_MR_SHORTFALL

Comment

BILLING_MR_SHORTFALL shows aggregate MR shortfall payments (or recovery charges) to each participant in the region for the MR event.


Description

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

Source

Ad hoc - MR events only.

Volume

400 rows per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

MR_DATE

PARTICIPANTID

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)

X

Unique Participant Identifier

AGE

NUMBER(16,6)

 

The adjusted gross energy for the market customer in the restricted region for the duration of the mandatory restriction event (MWh)

RSA

NUMBER(16,6)

 

Restriction Shortfall amount payable to AEMO for a mandatory restriction period

LASTCHANGED

DATE

 

Date/Time record inserted/modified