SETVICBOUNDARYENERGY (Historical table)

SETVICBOUNDARYENERGY is as requested by Participants for the settlement of Victorian Vesting contracts.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Settlement and date
VERSIONNO	numeric(3, 0)	smallint	Version number
PARTICIPANTID	varchar(10)	varchar(10)	Participant Identifier
PERIODID	numeric(3, 0)	smallint	Period Identifier
BOUNDARYENERGY	numeric(15, 5)	numeric(15, 5)	Interval energy purchases in Victoria when host distributor = Pool (in MWh)
LASTCHANGED	datetime(3)	datetime2(0)	Last changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETVICBOUNDARYENERGY_LCX	nonclustered	LASTCHANGED
SETVICBOUNDARYENERGY_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETVICBOUNDARYENERGY_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETVICBOUNDARYENERGY	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETVICBOUNDARYENERGY_LCX	nonclustered	LASTCHANGED
SETVICBOUNDARYENERGY_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID