|
Name |
|
|
Comment |
BILLINGREGIONFIGURES sets out additional summary region details including ancillary service amounts for each billing run. |
|
BILLINGREGIONFIGURES is public data, and is available to all participants. Source BILLINGREGIONFIGURES is populated by the posting of a billing run. Volume Five records inserted per billing run, or 55 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
REGIONID |
VARCHAR2(10) |
X |
Unique region identifier |
|
ENERGYOUT |
NUMBER(16,6) |
|
MWh Energy output in the region during the billing period |
|
VALUEOUT |
NUMBER(16,6) |
|
$ Value of energy output in region during billing period |
|
ENERGYPURCHASED |
NUMBER(16,6) |
|
MWh Amount of energy purchased in region during billing period |
|
VALUEPURCHASED |
NUMBER(16,6) |
|
$ Value of energy purchased during billing period |
|
EXCESSGEN |
NUMBER(16,6) |
|
This field is populated with 0 |
|
RESERVETRADING |
NUMBER(16,6) |
|
This field is populated with 0 |
|
INTCOMPO |
NUMBER(16,6) |
|
This field is populated with 0 |
|
ADMINPRICECOMPO |
NUMBER(16,6) |
|
This field is populated with 0 |
|
SETTSURPLUS |
NUMBER(16,6) |
|
Intraregional residues in $ |
|
ASPAYMENT |
NUMBER(16,6) |
|
Ancillary service payments in $ |
|
POOLFEES |
NUMBER(16,6) |
|
This field is populated with 0 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|