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


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