Table: BILLING_APC_COMPENSATION

BILLING_APC_COMPENSATION

Name

BILLING_APC_COMPENSATION

Comment

Billing result table for APC compensation payments.


Description

Updated with each billing run


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

APEVENTID

BILLRUNNO

CLAIMID

CONTRACTYEAR

WEEKNO


Content

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)

 

Participant identifier

COMPENSATION_AMOUNT

NUMBER(18,8)

 

Payment amount to the participant

EVENT_TYPE

VARCHAR2(20)

 

The Administered Price Event Type. Valid values: ENERGY, FCAS, BOTH

COMPENSATION_TYPE

VARCHAR2(20)

 

The Type of Administered Price Compensation Claim. Valid values: DIRECT_COST, OTHER_COST

LASTCHANGED

DATE

 

The date and time of last changed record