|
Name |
|
|
Comment |
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes substitution price 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 |
|
INTERVAL_DATETIME |
|
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 |
|
PERIODID |
NUMBER(3) |
|
Period identifier |
|
RRP |
NUMBER(18,8) |
|
SNOWY1 RRP for the dispatch interval |
|
IS_CSP_INTERVAL |
NUMBER(1) |
|
A flag to indicate whether a binding CSP constraint was present in the dispatch interval. A value of 1 indicates that CSP processing occurred due to a binding CSP constraint, while a value of 0 indicates that no binding CSP constraints were present in this interval |
|
LOWERTUMUT_TLF |
NUMBER(18,8) |
|
Transmission loss factor of the Lower Tumut unit |
|
UPPERTUMUT_TLF |
NUMBER(18,8) |
|
Transmission Loss factor of the Upper Tumut unit |
|
LOWERTUMUT_PRICE |
NUMBER(18,8) |
|
The dispatch price at the Lower Tumut node |
|
UPPERTUMUT_PRICE |
NUMBER(18,8) |
|
The dispatch price at the Upper Tumut node |
|
LOWERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
Sum of CSPAxCOEFF for all constraints and Lower Tumut left-hand terms |
|
UPPERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
Sum of CSPAxCOEFF for all constraints and Upper Tumut left-hand terms |
|
LOWERTUMUT_SPDP_UNCAPPED |
NUMBER(18,8) |
|
LOWERTUMUT_SPDP before VOLL or MPF capping is applied |
|
UPPERTUMUT_SPDP_UNCAPPED |
NUMBER(18,8) |
|
UPPERTUMUT_SPDP before VOLL or MPF capping is applied |
|
LOWERTUMUT_SPDP |
NUMBER(18,8) |
|
Substitute Price for Lower Tumut |
|
UPPERTUMUT_SPDP |
NUMBER(18,8) |
|
Substitute Price for Upper Tumut |
|
INTERVAL_ABS_X |
NUMBER(18,8) |
|
Sum of all ABS_X values for binding CSP constraints in the dispatch interval |
|
INTERVAL_ABS_Y |
NUMBER(18,8) |
|
Sum of all ABS_Y values for binding CSP constraints in the dispatch interval |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
|
|