Table: SETAPCCOMPENSATION

SETAPCCOMPENSATION

Name

SETAPCCOMPENSATION

Comment

SETAPCCOMPENSATION shows Administered Price Cap (APC) compensation payments for each period.


Description

SETAPCCOMPENSATION data is confidential to the relevant participant.

Source

SETAPCCOMPENSATION updates in settlement runs, as needed.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


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)

APCCOMPENSATION

NUMBER(15,5)

 

APC amount

LASTCHANGED

DATE

 

Last date and time record changed