SET_FPP
This report contains the summary of FPP Amounts for each ParticipantId in each 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 |
| REGIONID |
varchar(20) |
varchar(10) |
The RegionId used for the residual calculation. This is the Constraint Requirement Region. |
| PERIODID |
numeric(3, 0) |
smallint |
The Period ID Identifier |
| LOWERREG_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Amount from the Eligible Units. |
| LOWERREG_ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Amount from the ACE Portion of the Residual amount |
| LOWERREG_ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Amount from the ASOE Portion of the Residual amount |
| LOWERREG_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Lower Reg Residual Amount which is also LowerReg_ACE_Amount + LowerReg_ASOE_Amount |
| RAISEREG_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Amount from the Eligible Units. |
| RAISEREG_ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Amount from the ACE Portion of the Residual amount |
| RAISEREG_ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Amount from the ASOE Portion of the Residual amount |
| RAISEREG_RESIDUAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Raise Reg Residual Amount which is also RaiseReg_ACE_Amount + RaiseReg_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_FPP_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, REGIONID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FPP |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, REGIONID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FPP |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, REGIONID, PERIODID |