Table: BILLING_MR_SUMMARY

BILLING_MR_SUMMARY

Name

BILLING_MR_SUMMARY

Comment

BILLING_MR_SUMMARY shows aggregate payment/recovery and shortfall figures for an MR Event.


Description

BILLING_MR_SUMMARY data is public to all participants.

Source

Ad hoc - MR events only.

Volume

200 rows per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

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

TOTAL_PAYMENTS

NUMBER(16,6)

 

Total payments by AEMO

TOTAL_RECOVERY

NUMBER(16,6)

 

Total payments to AEMO

TOTAL_RSA

NUMBER(16,6)

 

Total Restriction Shortfall Amount

AAGE

NUMBER(16,6)

 

The aggregate of then adjusted gross energy of all the market customer in the restricted region for the duration of the mandatory restriction period (MWh)

LASTCHANGED

DATE

 

Date/Time record inserted/modified