SETFCASCOMP (Historical table)

SETFCASCOMP shows the compensation details for Frequency Controlled Ancillary Services (FCAS). These compensation values are calculated by a separate \"what if\" run of the LP Solver and entered as an unconstrained MW value into settlements.

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 Identifier
DUID	varchar(10)	varchar(10)	Dispatchable Unit ID
PERIODID	numeric(3, 0)	smallint	Period Identifier
REGIONID	varchar(10)	varchar(10)	Region Identifier
CCPRICE	numeric(15, 5)	numeric(15, 5)	Compensation Cap
CLEAREDMW	numeric(15, 5)	numeric(15, 5)	Cleared MW of Unit in First Dispatch period in Trading Interval
UNCONSTRAINEDMW	numeric(15, 5)	numeric(15, 5)	Initial MW of Unit in First Dispatch period in Trading Interval
EBP	numeric(15, 5)	numeric(15, 5)	Eligible Bid Price
TLF	numeric(7, 5)	numeric(7, 5)	Transmission Loss Factor of Unit
RRP	numeric(15, 5)	numeric(15, 5)	Regional Reference Price
EXCESSGEN	numeric(15, 5)	numeric(15, 5)	Excess Generation Payment in trading interval
FCASCOMP	numeric(15, 5)	numeric(15, 5)	Frequency Control AS Compensation payment to Generator
LASTCHANGED	datetime(3)	datetime2(0)	-

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETFCASCOMP_LCX	nonclustered	LASTCHANGED
SETFCASCOMP_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, DUID, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETFCASCOMP_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETFCASCOMP	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, DUID, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETFCASCOMP_LCX	nonclustered	LASTCHANGED
SETFCASCOMP_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, DUID, PERIODID