|
Name |
|
|
Comment |
Billing result table for recovery of APC compensation payments |
|
Updated with each billing run |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
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 |
|
|
|