Name |
|
Comment |
Billing result table for recovery of APC compensation payments |
Updated with each billing run |
Name |
APEVENTID |
BILLRUNNO |
CLAIMID |
CONTRACTYEAR |
PARTICIPANTID |
REGIONID |
WEEKNO |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
WEEKNO |
NUMBER(3) |
X |
Billing week number |
BILLRUNNO |
NUMBER(3) |
X |
Billing run number |
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
REGIONID |
VARCHAR2(20) |
X |
Region Identifier |
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery amount attributable to the participant in that region |
ELIGIBILITY_START_INTERVAL |
DATE |
|
The starting half hourly interval for the eligibility period for recovery of APC Payment |
ELIGIBILITY_END_INTERVAL |
DATE |
|
The ending half hourly interval for the eligibility period for recovery of APC Payment |
PARTICIPANT_DEMAND |
NUMBER(18,8) |
|
The participant demand in the cost recovery region |
REGION_DEMAND |
NUMBER(18,8) |
|
The sum of demand of all participants in the cost recovery region (Region Sum) |
LASTCHANGED |
DATE |
|
The date and time of last changed record |
PARTICIPANT_ACE_MWH |
NUMBER(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 |
NUMBER(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. |
|
|
|