Table: SET_ APC_RECOVERY

SET_ APC_RECOVERY

Name

SET_ APC_RECOVERY

Comment

APC Compensation recovery amounts in the Settlements timeframe


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

APEVENTID

CLAIMID

PARTICIPANTID

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Content

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

Settlements Trading Interval.

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_
AMOUNT

NUMBER(18,8)

 

Total Recovery amount in the region for the event claim in this interval