BILLING_MR_SUMMARY (Historical table)
BILLING_MR_SUMMARY shows aggregate payment / recovery and shortfall figures for an MR Event.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing Contract Year |
| WEEKNO |
numeric(3, 0) |
smallint |
Billing Week number |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing Run number |
| MR_DATE |
datetime(3) |
datetime2(0) |
Trading Date of Mandatory Restriction event; Mandatory Restriction imposition date |
| REGIONID |
varchar(10) |
varchar(10) |
Unique Region Identifier |
| TOTAL_PAYMENTS |
numeric(16, 6) |
numeric(16, 6) |
Total payments by AEMO |
| TOTAL_RECOVERY |
numeric(16, 6) |
numeric(16, 6) |
Total payments to AEMO |
| TOTAL_RSA |
numeric(16, 6) |
numeric(16, 6) |
Total Restriction Shortfall Amount |
| AAGE |
numeric(16, 6) |
numeric(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 |
datetime(3) |
datetime2(0) |
Date/Time record inserted/modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_MR_SUMMARY_LCX |
nonclustered |
LASTCHANGED |
| BILLING_MR_SUMMARY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLING_MR_SUMMARY_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLING_MR_SUMMARY |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_MR_SUMMARY_LCX |
nonclustered |
LASTCHANGED |
| BILLING_MR_SUMMARY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID |