|
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 |
|
|
|