SETGENDATAREGION

SETGENDATAREGION sets out summary settlement data for generation within the specified region. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_REGION_SUMMARY replace SETGENDATAREGION.

Package

SETTLEMENT_DATA

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Calendar Settlement Date
VERSIONNO	numeric(22, 10)	smallint	Settlement run no
PERIODID	numeric(22, 10)	smallint	Settlements Trading Interval.
REGIONID	varchar(10)	varchar(10)	Region Identifier
GENERGY	numeric(22, 0)	int	Generated energy - Not used in MMS Data Model
AENERGY	numeric(22, 0)	int	Purchased Energy - Not used in MMS Data Model
GPOWER	numeric(22, 0)	int	Not used in MMS Data Model
APOWER	numeric(22, 0)	int	Not used in MMS Data Model
NETENERGY	numeric(27, 5)	numeric(27, 5)	Net energy MW/hours
ENERGYCOST	numeric(27, 5)	numeric(27, 5)	Cost of net energy $
EXCESSENERGYCOST	numeric(27, 5)	numeric(27, 5)	Cost of excess energy $
EXPENERGY	numeric(27, 6)	numeric(27, 6)	Export Energy (Generator Purchases)
EXPENERGYCOST	numeric(27, 6)	numeric(27, 6)	Export Energy Cost
LASTCHANGED	datetime(3)	datetime2(0)	current system date, to enable automatic replication

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETGENDATAREGION_LCX	nonclustered	LASTCHANGED
SETGENDATAREGION_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETGENDATAREGION_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETGENDATAREGION	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETGENDATAREGION_LCX	nonclustered	LASTCHANGED
SETGENDATAREGION_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID