SETAGCRECOVERY (Historical table)

SETAGCRECOVERY shows reimbursements for Automatic Generation Control (AGC) Ancillary Services to be recovered from participants.

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	Settlement Run No.
PARTICIPANTID	varchar(10)	varchar(10)	Participant to pay recovery
PERIODID	numeric(3, 0)	smallint	Trading Interval
REGIONID	varchar(10)	varchar(10)	Region Identifier
CONTRACTID	varchar(10)	varchar(10)	-
ENABLINGPAYMENT	numeric(15, 5)	numeric(15, 5)	Enabling Payment
PARTICIPANTDEMAND	numeric(15, 5)	numeric(15, 5)	Participant Demand in Region
REGIONDEMAND	numeric(15, 5)	numeric(15, 5)	Total Regional Demand
ENABLINGRECOVERY	numeric(15, 5)	numeric(15, 5)	Enabling Recovery
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
ENABLINGRECOVERY_GEN	numeric(15, 5)	numeric(15, 5)	Enabling Recovery for Generator
PARTICIPANTDEMAND_GEN	numeric(15, 5)	numeric(15, 5)	Participant Demand in Region for Generator
REGIONDEMAND_GEN	numeric(15, 5)	numeric(15, 5)	Total Regional Demand for Generator

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETAGCRECOVERY_LCX	nonclustered	LASTCHANGED
SETAGCRECOVERY_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID, REGIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETAGCRECOVERY_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETAGCRECOVERY	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID, REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETAGCRECOVERY_LCX	nonclustered	LASTCHANGED
SETAGCRECOVERY_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID, REGIONID