|
Name |
|
|
Comment |
A settlement table for the publication of Snowy CSP derogation amounts. |
|
Source Settlements data process is populated at the posting of a billing run in which it is included. Volume Estimated number of rows is 13440 for a based on the 35 settlement days posted per week. Note this data would only be delivered to the participant receiving payments from the derogation. |
|
Name |
|
AMOUNT_ID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3) |
X |
Period identifier |
|
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 |
|
|
|