SET_FCAS_REG_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.
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 FCAS 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. |
| FPP_ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The FPP ACE Amount calculated using the portion of ACE MWh value against the Total residual MWh of the requirement regions. |
| FPP_ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The FPP ASOE Amount calculated using the portion of ASOE MWh value against the Total residual MWh of the requirement regions. |
| FPP_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Sum of FPP_ACE_Amount + FPP_ASOE_Amount |
| USED_ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Used Recovery ACE Amount calculated using the ACE MWh value of the requirement regions. |
| USED_ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Used Recovery ASOE Amount calculated using the portion of ASOE MWh value against the Total residual MWh of the requirement regions. |
| USED_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Sum of USED_ACE_AMOUNT + USED_ASOE_AMOUNT. |
| UNUSED_ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Unused Recovery ACE Amount calculated using the portion of ACE MWh value against the Total residual MWh of the requirement regions. |
| UNUSED_ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Unused Recovery ASOE Amount calculated using the portion of ASOE MWh value against the Total residual MWh 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_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_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_RESIDAMT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONSTRAINTID, PERIODID, REGIONID |