SETINTERVENTION (Historical table)

SETINTERVENTION shows intervention settlement payment details by unit.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Calendar Settlement Date
VERSIONNO	numeric(3, 0)	smallint	Settlement Run No.
PERIODID	numeric(3, 0)	smallint	Settlement Period identifier
DUID	varchar(10)	varchar(10)	Dispatchable Unit ID
CONTRACTID	varchar(10)	varchar(10)	Intervention Contract Identifier
CONTRACTVERSION	numeric(3, 0)	smallint	Intervention Contract Version
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
REGIONID	varchar(10)	varchar(10)	Region Identifier
RCF	char(1)	char(1)	Regional Recovery Flag
INTERVENTIONPAYMENT	numeric(12, 5)	numeric(12, 5)	Payment to Generator for Intervention
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETINTERVENTION_LCX	nonclustered	LASTCHANGED
SETINTERVENTION_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, DUID, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETINTERVENTION_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETINTERVENTION	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, DUID, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETINTERVENTION_LCX	nonclustered	LASTCHANGED
SETINTERVENTION_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, DUID, PERIODID