BILLINGEXCESSGEN (Historical table)

BILLINGEXCESSGEN shows the excess generation cost by period for each participant.

Package

HISTORICAL_TABLES

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
SETTLEMENTDATE	datetime(3)	datetime2(0)	Calendar settlement date record becomes effective
PERIODID	numeric(3, 0)	smallint	Settlement interval within the settlement date (1-48) starting at 00:30
REGIONID	varchar(10)	varchar(10)	Region Identifier
EXCESSENERGYCOST	numeric(15, 5)	numeric(15, 5)	Cost of excess energy attributed to this customer
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Index name	Index type	Index columns (in order)
BILLINGEXCESSGEN_LCX	nonclustered	LASTCHANGED
BILLINGEXCESSGEN_NDX2	nonclustered	PARTICIPANTID
BILLINGEXCESSGEN_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID, SETTLEMENTDATE, PERIODID

Index name	Index type	Index columns (in order)
IX_BILLINGEXCESSGEN_LASTCHANGED	nonclustered	LASTCHANGED
IX_BILLINGEXCESSGEN_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_BILLINGEXCESSGEN	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID, SETTLEMENTDATE, PERIODID

Index name	Index type	Index columns (in order)
BILLINGEXCESSGEN_LCX	nonclustered	LASTCHANGED
BILLINGEXCESSGEN_NDX2	nonclustered	PARTICIPANTID
BILLINGEXCESSGEN_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID, SETTLEMENTDATE, PERIODID