Table: SETAPCRECOVERY

SETAPCRECOVERY

Name

SETAPCRECOVERY

Comment

SETAPCRECOVERY shows reimbursements for Administered Price Cap (APC) to be recovered from participants.


Description

SETAPCRECOVERY data is confidential to the relevant participant.

Source

SETAPCRECOVERY updates with each settlement run.


Primary Key Columns

Name

PARTICIPANTID

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement run number

PARTICIPANTID

VARCHAR2(10)

X

Participant identifier

REGIONID

VARCHAR2(10)

X

Region Identifier

PERIODID

NUMBER(3,0)

X

Settlement period (based on calendar day)

TOTALCOMPENSATION

NUMBER(15,5)

 

Total compensation

PARTICIPANTDEMAND

NUMBER(15,5)

 

Participant MW Demand

REGIONDEMAND

NUMBER(15,5)

 

Total region demand

APCRECOVERY

NUMBER(15,5)

 

APC Recovery amount

LASTCHANGED

DATE

 

Last date and time record changed