RESIDUE_CON_FUNDS

RESIDUE_CON_FUNDS supports the Settlement Residue Auction, by holding the fund details for each contract.

Package

IRAUCTION

Public

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(30)	varchar(30)	SRA Contract unique identifier as specified by AEMO
INTERCONNECTORID	varchar(10)	varchar(10)	Identifier for the Contracted Interconnector
FROMREGIONID	varchar(10)	varchar(10)	Nominated source region for Interconnector
DEFAULTUNITS	numeric(5, 0)	smallint	Actual number of units allocated based on the auction default percentage for the tranche and the total number of units to be auctioned for this quarter
ROLLOVERUNITS	numeric(5, 0)	smallint	Units reallocated from the previous tranche of this quarter
REALLOCATEDUNITS	numeric(5, 0)	smallint	Units reallocated from the previous tranche of this quarter because they were not taken up by the participant
UNITSOFFERED	numeric(5, 0)	smallint	Total units offered for Contract
MEANRESERVEPRICE	numeric(9, 2)	numeric(9, 2)	Average reserve price calculated from the selected estimates
SCALEFACTOR	numeric(8, 5)	numeric(8, 5)	Scaling factor for regional Frequency control Ancillary Service requirement
ACTUALRESERVEPRICE	numeric(9, 2)	numeric(9, 2)	Actual reserve price
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Index name	Index type	Index columns (in order)
RESIDUE_CON_FUNDS_LCX	nonclustered	LASTCHANGED
RESIDUE_CON_FUNDS_PK	clustered, unique, primary key	CONTRACTID, INTERCONNECTORID, FROMREGIONID

Index name	Index type	Index columns (in order)
IX_RESIDUE_CON_FUNDS_LASTCHANGED	nonclustered	LASTCHANGED
PK_RESIDUE_CON_FUNDS	clustered, unique, primary key	CONTRACTID, INTERCONNECTORID, FROMREGIONID

Index name	Index type	Index columns (in order)
RESIDUE_CON_FUNDS_LCX	nonclustered	LASTCHANGED
RESIDUE_CON_FUNDS_PK	clustered, unique, primary key	CONTRACTID, INTERCONNECTORID, FROMREGIONID