SET_FCAS_REGULATION_TRK
SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constraint tracking for Regional FCAS Regulation recovery.
Package
SETTLEMENT_DATA
Visibility
Public
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 |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
Dispatch Interval Date Time |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Generic Constraint ID |
| CMPF |
numeric(18, 8) |
numeric(18, 8) |
Constraint Market Participant Factor. This column is NULL for Settlement Dates past FPP Rule Effective Date |
| CRMPF |
numeric(18, 8) |
numeric(18, 8) |
Constraint Residual Market Participant Factor. This column is NULL for Settlement Dates past FPP Rule Effective Date |
| RECOVERY_FACTOR_CMPF |
numeric(18, 8) |
numeric(18, 8) |
Recovery factor for CMPF based recovery. This column is NULL for Settlement Dates past FPP Rule Effective Date |
| RECOVERY_FACTOR_CRMPF |
numeric(18, 8) |
numeric(18, 8) |
Recovery factor for CRMPF based recovery. This column is NULL for Settlement Dates past FPP Rule Effective Date. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| REQUIREMENTDEMAND |
numeric(18, 8) |
numeric(18, 8) |
the aggregate customer demand value used to recover the cost of this requirement |
| USESUBSTITUTEDEMAND |
numeric(1, 0) |
tinyint |
Flag to indication that substitute demand was used to recover this requirement |
| FPP_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total FPP Amount from Eligible Units for the Constraint Id |
| FPP_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total FPP Residual Amount for the Constraint Id |
| USED_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total Reg Used Amount from Eligible Units for the Constraint Id |
| USED_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total Reg Used Residual Amount for the Constraint Id |
| UNUSED_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total Reg Unused Amount from Eligible Units for the Constraint Id |
| UNUSED_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total Reg Unused Residual Amount for the Constraint Id |
| P_REGULATION |
numeric(18, 8) |
numeric(18, 8) |
The PRegulation Value from Constraints FCAS Requirement data |
| TSFCAS |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Cost Value from Constraints FCAS Requirement data |
| RCR |
numeric(18, 8) |
numeric(18, 8) |
The RCR Value from the FPP Inputs for the Constraint Id used to calculate FPP Amount |
| USAGE_VALUE |
numeric(18, 8) |
numeric(18, 8) |
The Usage Value from the FPP Inputs for the Constraint Id used to calculate Used Amount |
| RCF |
numeric(18, 8) |
numeric(18, 8) |
The RCF Value from the FPP Inputs for the Constraint Id used to calculate FPP Residual |
| NRCF |
numeric(18, 8) |
numeric(18, 8) |
The NRCF Value from the FPP Inputs for the Constraint Id used to calculate Used Residual Amount |
| DRCF |
numeric(18, 8) |
numeric(18, 8) |
The DRCF Value from the FPP Inputs for the Constraint Id used to calculate Unused Residual Amount |
| RESIDUALTOTAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
The total residual MWh(ABS(ACE_MWh) + ASOE(MWh)) of the requirement regions. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_FCAS_REGUL_TRK_LCHD_IDX |
nonclustered |
LASTCHANGED |
| SET_FCAS_REGULATION_TRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SET_FCAS_REGULATION_TRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SET_FCAS_REGULATION_TRK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_REGULATION_TRK |
nonclustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME, CONSTRAINTID |
| SET_FCAS_REGULATION_TRK_CCI |
clustered, columnstore |
n/a |