SET_FCAS_REG_DEF_AMT
This report contains the the FCAS Regulation Amounts that include FPP Amounts, Used Amounts and Unused Amounts calculated using the Default Contribution Factors. This is when FPP Factors are not available for a particular interval and system used DCF in the calculation.
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 |
| 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_DEF_AMT_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_DEF_AMT |
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_DEF_AMT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, UNITID, CONSTRAINTID, PERIODID |