SET_FCAS_REG_AMOUNT
This report contains the the FCAS Regulation Amounts that include FPP Amounts, Used Amounts and Unused Amounts calculated using the Contribution Factors.
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 |
| UNITID |
varchar(20) |
varchar(10) |
The UNITID with CF factor assigned. This is a DUID or a TNI. Refer table FPP_CONTRIBUTION_FACTOR |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
The FCAS Regulation Constraint ID |
| PERIODID |
numeric(3, 0) |
smallint |
The Period ID Identifier |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant Id Identifier |
| BIDTYPE |
varchar(10) |
varchar(10) |
The BidType LOWERREG or RAISEREG for the Constraint ID |
| FPP_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The FPP Amount calculated for the Constraint and UNITID using the FPP Contribution Factor |
| USED_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Regulation Used Recovery Amount from the eligible Units using Negative CF Value |
| UNUSED_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Regulation Unused Recovery Amount from Eligible Units using DCF Value |
| 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_AMOUNT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, UNITID, CONSTRAINTID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_REG_AMOUNT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, UNITID, CONSTRAINTID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_REG_AMOUNT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, UNITID, CONSTRAINTID, PERIODID |