BILLINGSMELTERREDUCTION (Historical table)

BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points).

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(22, 0)	smallint	AEMO Contract Year number starting in week containing 1st January
WEEKNO	numeric(22, 0)	tinyint	Week no within the contract year. Week no 1 is the week containing 1st January
BILLRUNNO	numeric(22, 0)	smallint	Unique run no within a given contract year and week no
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
RATE1	numeric(15, 6)	numeric(15, 6)	Rate in $/MWh
RA1	numeric(15, 6)	numeric(15, 6)	Payment
RATE2	numeric(15, 6)	numeric(15, 6)	Rate in $/MWh
RA2	numeric(15, 6)	numeric(15, 6)	Payment
TE	numeric(15, 6)	numeric(15, 6)	Tabulated Energy
PCSD	numeric(15, 6)	numeric(15, 6)	Victorian Demand as defined by Code Chapter 9 definitions
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGSMELTERREDUCT_NDX2	nonclustered	PARTICIPANTID
BILLINGSMELTERREDUCTION_LCX	nonclustered	LASTCHANGED
BILLINGSMELTERREDUCTION_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGSMELTERREDUCTION_LASTCHANGED	nonclustered	LASTCHANGED
IX_BILLINGSMELTERREDUCTION_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_BILLINGSMELTERREDUCTION	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGSMELTERREDUCT_NDX2	nonclustered	PARTICIPANTID
BILLINGSMELTERREDUCTION_LCX	nonclustered	LASTCHANGED
BILLINGSMELTERREDUCTION_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID