BILLINGREGIONFIGURES sets out additional summary region details including ancillary service amounts for each billing run.
Package
BILLING_RUN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
AEMO Contract Year number starting in week containing 1st January |
| WEEKNO |
numeric(3, 0) |
smallint |
Week no within the contract year. Week no 1 is the week containing 1st January |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Unique run no within a given contract year and week no |
| REGIONID |
varchar(10) |
varchar(10) |
Unique region identifier |
| ENERGYOUT |
numeric(16, 6) |
numeric(16, 6) |
MWh Energy output in the region during the billing period |
| VALUEOUT |
numeric(16, 6) |
numeric(16, 6) |
$ Value of energy output in region during billing period |
| ENERGYPURCHASED |
numeric(16, 6) |
numeric(16, 6) |
MWh Amount of energy purchased in region during billing period |
| VALUEPURCHASED |
numeric(16, 6) |
numeric(16, 6) |
$ Value of energy purchased during billing period |
| EXCESSGEN |
numeric(16, 6) |
numeric(16, 6) |
This field is populated with 0 |
| RESERVETRADING |
numeric(16, 6) |
numeric(16, 6) |
This field is populated with 0 |
| INTCOMPO |
numeric(16, 6) |
numeric(16, 6) |
This field is populated with 0 |
| ADMINPRICECOMPO |
numeric(16, 6) |
numeric(16, 6) |
This field is populated with 0 |
| SETTSURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Intraregional residues in $ |
| ASPAYMENT |
numeric(16, 6) |
numeric(16, 6) |
Ancillary service payments in $ |
| POOLFEES |
numeric(16, 6) |
numeric(16, 6) |
This field is populated with 0 |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| WDRSQ |
numeric(18, 8) |
numeric(18, 8) |
WDR Settlement Quantity Capped in MWh |
| WDRTA |
numeric(18, 8) |
numeric(18, 8) |
WDR transaction amount in $ |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGREGIONFIGURES_LCX |
nonclustered |
LASTCHANGED |
| BILLINGREGIONFIGURES_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGREGIONFIGURES_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLINGREGIONFIGURES |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGREGIONFIGURES_LCX |
nonclustered |
LASTCHANGED |
| BILLINGREGIONFIGURES_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, REGIONID |