|
Name |
|
|
Comment |
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes the constraint-level information for each five minute interval in the settlement run |
|
Source Settlements data process is populated at the posting of a billing run in which it is included. Volume Estimated number of rows is an average of 1000 per week based on the 35 settlement days posted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
INTERVAL_DATETIME |
DATE |
X |
Dispatch interval identifier |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Constraint identifier |
|
PERIODID |
NUMBER(3) |
X |
Settlements trading interval identifier |
|
MARGINALVALUE |
NUMBER(18,8) |
|
Marginal value of the constraint |
|
RHS |
NUMBER(18,8) |
|
RHS value of the constraint |
|
LOWERTUMUT_FACTOR |
NUMBER(18,8) |
|
Value of the Lower Tumut left-hand term of the constraint |
|
UPPERTUMUT_FACTOR |
NUMBER(18,8) |
|
Value of the Upper Tumut left hand term of the constraint |
|
LOWERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
LOWERTUMUT_FACTOR x MARGINALVALUE |
|
UPPERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
UPPERTUMUT_FACTOR x MARGINALVALUE |
|
ABS_X |
NUMBER(18,8) |
|
Equal to RHS if the constraint direction is SOUTH, otherwise zero |
|
ABS_Y |
NUMBER(18,8) |
|
Equal to RHS if the constraint direction is NORTH, otherwise zero |
|
LASTCHANGED |
DATE |
|
Last changed date of the record |
|
|
|