BILLING_MR_PAYMENT (Historical table)

BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit / MR Event basis for accepted MR capacity.

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
DUID	varchar(10)	varchar(10)	Unique identifier for DUID / MNSP LinkID
PARTICIPANTID	varchar(10)	varchar(10)	Unique Participant identifier
MR_AMOUNT	numeric(16, 6)	numeric(16, 6)	Payment amount by AEMO
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_PAYMENT_LCX	nonclustered	LASTCHANGED
BILLING_MR_PAYMENT_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID, DUID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLING_MR_PAYMENT_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLING_MR_PAYMENT	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID, DUID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLING_MR_PAYMENT_LCX	nonclustered	LASTCHANGED
BILLING_MR_PAYMENT_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, MR_DATE, REGIONID, DUID