Table: BILLING_CSP_DEROGATION_AMOUNT

BILLING_CSP_DEROGATION_AMOUNT

Name

BILLING_CSP_DEROGATION_AMOUNT

Comment

CSP derogation amounts with respect to participant allocated payment


Description

Source

BILLING_CSP_DEROGATION_AMOUNT is populated by the posting of a billing run.

Volume

An indicative maximum is one record inserted per billing run, or 11 records inserted per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

AMOUNT_ID

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


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

PARTICIPANTID

VARCHAR2(10)

X

The participant allocated the payment amount for the derogation

AMOUNT_ID

VARCHAR2(20)

X

Amount identifier represented as a string, from "ta1" through to "ta6" (or "ta8" for a lymmco derogation result)

DEROGATION_AMOUNT

NUMBER(18,8)

 

Derogation amount associated with the amount identifier

LASTCHANGED

DATE

 

Last changed date for the record