SETVICENERGYFLOW (Historical table)

SETVICENERGYFLOW is used in settlement of Victorian Vesting contracts.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Settlement date
VERSIONNO	numeric(3, 0)	smallint	Version number
PERIODID	numeric(3, 0)	smallint	Settlement period
NETFLOW	numeric(15, 5)	numeric(15, 5)	Net metered energy flowing across the V-SN and V-SA interconnectors
LASTCHANGED	datetime(3)	datetime2(0)	Last changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETVICENERGYFLOW_LCX	nonclustered	LASTCHANGED
SETVICENERGYFLOW_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETVICENERGYFLOW_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETVICENERGYFLOW	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETVICENERGYFLOW_LCX	nonclustered	LASTCHANGED
SETVICENERGYFLOW_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PERIODID