SETFCASRECOVERY (Historical table)

SETFCASERECOVERY shows reimbursements for the Frequency Control Ancillary Services compensation.

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
PARTICIPANTID	varchar(10)	varchar(10)	Participant to pay recovery
REGIONID	varchar(10)	varchar(10)	Region Identifier
PERIODID	numeric(3, 0)	smallint	Settlement Period identifier
DUID	varchar(10)	varchar(10)	Dispatchable Unit identifier
FCASCOMP	numeric(15, 5)	numeric(15, 5)	Frequency Control Ancillary Service Compensation Payment
PARTICIPANTDEMAND	numeric(15, 5)	numeric(15, 5)	Participant Demand in Region
REGIONDEMAND	numeric(15, 5)	numeric(15, 5)	Total Regional demand
FCASRECOVERY	numeric(15, 5)	numeric(15, 5)	Frequency Control Ancillary Service recovery amount.
LASTCHANGED	datetime(3)	datetime2(0)	Date and Time last changed
FCASRECOVERY_GEN	numeric(15, 5)	numeric(15, 5)	Frequency Control Ancillary Service recovery amount 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)
SETFCASRECOVERY_LCX	nonclustered	LASTCHANGED
SETFCASRECOVERY_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, REGIONID, PERIODID

GR-MMS data model indexes

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

Historical-MMS data model indexes

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