|
Name |
|
|
Comment |
BILLING_MR_SUMMARY shows aggregate payment/recovery and shortfall figures for an MR Event. |
|
BILLING_MR_SUMMARY data is public to all participants. Source Ad hoc - MR events only. Volume 200 rows per year. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
MR_DATE |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|