BILLINGRESERVETRADERREGION (Historical table)

BILLINGRESERVETRADERREGION shows Billing Region Reserve Trader payment details.

Package

HISTORICAL_TABLES

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
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
REGIONID	varchar(10)	varchar(10)	Region Identifier
REGIONRESERVE	numeric(15, 5)	numeric(15, 5)	Reserve Trader Amounts paid to Generator for Region Recovery
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

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

GR-MMS data model indexes

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

Historical-MMS data model indexes

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