FCAS_REGU_USAGE_FACTORS
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 with respect to effective date |
| REGIONID |
varchar(20) |
varchar(20) |
Unique RegionID |
| BIDTYPE |
varchar(20) |
varchar(20) |
The type of regulation FCAS service [RAISEREG,LOWERREG] |
| PERIODID |
numeric(3, 0) |
smallint |
The Period ID (1 - 48) within the calendar day to which this usage factor applies |
| USAGE_FACTOR |
numeric(8, 3) |
numeric(8, 3) |
The proportion of cleared regulation FCAS that is assumed to be used within a dispatch interval. Expressed as a fractional amount between 0 and 1 |
| 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_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, REGIONID, BIDTYPE, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FCAS_REGU_USAGE_FACTORS |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, REGIONID, BIDTYPE, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FCAS_REGU_USAGE_FACTORS_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, REGIONID, BIDTYPE, PERIODID |