Name |
|
Comment |
CSP derogation amounts with respect to participant allocated payment |
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. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
AMOUNT_ID |
BILLRUNNO |
CONTRACTYEAR |
PARTICIPANTID |
WEEKNO |
Name |
LASTCHANGED |
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 |
|
|
|