BILLING_MR_SHORTFALL (Historical table)

BILLING_MR_SHORTFALL shows aggregate MR shortfall payments (or recovery charges) to each participant in the region for the 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
PARTICIPANTID	varchar(10)	varchar(10)	Unique Participant Identifier
AGE	numeric(16, 6)	numeric(16, 6)	The adjusted gross energy for the market customer in the restricted region for the duration of the mandatory restriction event (MWh)
RSA	numeric(16, 6)	numeric(16, 6)	Restriction Shortfall amount payable to AEMO for a mandatory restriction period
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_SHORTFALL_LCX	nonclustered	LASTCHANGED
BILLING_MR_SHORTFALL_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLING_MR_SHORTFALL_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLING_MR_SHORTFALL	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLING_MR_SHORTFALL_LCX	nonclustered	LASTCHANGED
BILLING_MR_SHORTFALL_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID, PARTICIPANTID