BILLING_APC_RECOVERY
Billing result table for recovery of APC compensation payments.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing contract year |
| WEEKNO |
numeric(3, 0) |
smallint |
Billing week number |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing run number |
| APEVENTID |
numeric(6, 0) |
int |
AP Event Id |
| CLAIMID |
numeric(6, 0) |
int |
AP Event Claim Id |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Participant identifier |
| REGIONID |
varchar(20) |
varchar(20) |
Region Identifier |
| RECOVERY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount attributable to the participant in that region |
| ELIGIBILITY_START_INTERVAL |
datetime(3) |
datetime2(0) |
The starting half hourly interval for the eligibility period for recovery of APC Payment |
| ELIGIBILITY_END_INTERVAL |
datetime(3) |
datetime2(0) |
The ending half hourly interval for the eligibility period for recovery of APC Payment |
| PARTICIPANT_DEMAND |
numeric(18, 8) |
numeric(18, 8) |
The participant demand in the cost recovery region |
| REGION_DEMAND |
numeric(18, 8) |
numeric(18, 8) |
The sum of demand of all participants in the cost recovery region (Region Sum) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The date and time of last changed record |
| PARTICIPANT_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The ACE MWh value of the participant from the Eligibility Interval used for the APC Recovery Calculation. If the Billing Week is prior to the IESS rule effective date, then value is Null. |
| REGION_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The ACE MWh value of the Region from the Eligibility Interval used for the APC Recovery Calculation. This is the sum of the ACE MWh of all the participants in that recovery. If the Billing Week is prior to the IESS rule effective date, then value is Null. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_APC_RECOVERY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, APEVENTID, CLAIMID, PARTICIPANTID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_APC_RECOVERY |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, APEVENTID, CLAIMID, PARTICIPANTID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_APC_RECOVERY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, APEVENTID, CLAIMID, PARTICIPANTID, REGIONID |