SET_FCAS_REG_DEF_RESIDAMT
This report contains the FCAS Regulation Residue Amounts that include FPP Residual Amounts, Used Residual Amounts and Unused Residual Amounts calculated using the Energy Ratio for each Requirement Region and the Default Residual CF.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
The Settlement Date of the Billing Week |
| VERSIONNO |
numeric(3, 0) |
smallint |
The Settlement Run No |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant Id Identifier |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
The FCAS Regulation Constraint ID |
| PERIODID |
numeric(3, 0) |
smallint |
The Period ID Identifier |
| REGIONID |
varchar(20) |
varchar(10) |
The RegionId used for the residual calculation. This is the Constraint Requirement Region. |
| BIDTYPE |
varchar(10) |
varchar(10) |
The BidType LOWERREG or RAISEREG for the Constraint ID |
| ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The ACE MWh value that is used for the Residual Calculation.(Excluding CPID with CF) |
| ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The ASOE MWh value that is used for the Residual Calculation.(Excluding CPID with CF) |
| RESIDUAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
Sum of ABS(ACE_MWh) + ASOE_MWh. The MWh is not netted for residual calculation. |
| UNUSED_ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Unused Recovery ACE Amount calculated using the ACE MWh value of the requirement regions. |
| UNUSED_ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Unused Recovery ASOE Amount calculated using the ASOE MWh value of the requirement regions. |
| UNUSED_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Sum of UNUSED_ACE_AMOUNT + UNUSED_ASOE_AMOUNT. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The Last Changed Date time of the record. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_FCAS_REG_DEF_RESIDAMT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONSTRAINTID, PERIODID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_REG_DEF_RESIDAMT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONSTRAINTID, PERIODID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_REG_DEF_RESIDAMT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONSTRAINTID, PERIODID, REGIONID |