|
Name |
|
|
Comment |
APC Compensation recovery amounts in the Settlements timeframe |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
APEVENTID |
|
CLAIMID |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement run date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
PERIODID |
NUMBER(3) |
X |
Trading interval identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Region id for the recovery amount |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery amount in the region attributable to the participant for the event claim in this interval |
|
REGION_RECOVERY_ |
NUMBER(18,8) |
|
Total Recovery amount in the region for the event claim in this interval |
|
|
|