Skip to content

FCAS_REGU_USAGE_FACTORS_TRK

Stores the proportion of enabled regulation FCAS dispatch that is typically consumed for frequency regulation. Used to calculate the projected state of charge for energy storage systems.

Package

MARKET_CONFIG

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
EFFECTIVEDATE datetime(3) 🔑 datetime2(0) 🔑 The effective date for this regulation FCAS usage factor
VERSIONNO numeric(3, 0) 🔑 smallint 🔑 Version of the date with respect to effective date
AUTHORISEDDATE datetime(3) datetime2(0) The date time that this set of usage factors was authorised
LASTCHANGED datetime(3) datetime2(0) The last time the data has been changed/updated

Official MMS data model indexes

Index name Index type Index columns (in order)
FCAS_REGU_USAGE_FACTORS_TRK_PK clustered, unique, primary key EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_FCAS_REGU_USAGE_FACTORS_TRK clustered, unique, primary key EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
FCAS_REGU_USAGE_FACTORS_TRK_PK clustered, unique, primary key EFFECTIVEDATE, VERSIONNO