SET_CSP_SUPPORTDATA_SUBPRICE (Historical table)
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.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement Date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Settlement run number |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
Dispatch interval identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Period identifier |
| RRP |
numeric(18, 8) |
numeric(18, 8) |
SNOWY1 RRP for the dispatch interval |
| IS_CSP_INTERVAL |
numeric(1, 0) |
tinyint |
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 |
numeric(18, 8) |
numeric(18, 8) |
Transmission loss factor of the Lower Tumut unit |
| UPPERTUMUT_TLF |
numeric(18, 8) |
numeric(18, 8) |
Transmission Loss factor of the Upper Tumut unit |
| LOWERTUMUT_PRICE |
numeric(18, 8) |
numeric(18, 8) |
The dispatch price at the Lower Tumut node |
| UPPERTUMUT_PRICE |
numeric(18, 8) |
numeric(18, 8) |
The dispatch price at the Upper Tumut node |
| LOWERTUMUT_CSPA_COEFF |
numeric(18, 8) |
numeric(18, 8) |
Sum of CSPAxCOEFF for all constraints and Lower Tumut left-hand terms |
| UPPERTUMUT_CSPA_COEFF |
numeric(18, 8) |
numeric(18, 8) |
Sum of CSPAxCOEFF for all constraints and Upper Tumut left-hand terms |
| LOWERTUMUT_SPDP_UNCAPPED |
numeric(18, 8) |
numeric(18, 8) |
LOWERTUMUT_SPDP before VOLL or MPF capping is applied |
| UPPERTUMUT_SPDP_UNCAPPED |
numeric(18, 8) |
numeric(18, 8) |
UPPERTUMUT_SPDP before VOLL or MPF capping is applied |
| LOWERTUMUT_SPDP |
numeric(18, 8) |
numeric(18, 8) |
Substitute Price for Lower Tumut |
| UPPERTUMUT_SPDP |
numeric(18, 8) |
numeric(18, 8) |
Substitute Price for Upper Tumut |
| INTERVAL_ABS_X |
numeric(18, 8) |
numeric(18, 8) |
Sum of all ABS_X values for binding CSP constraints in the dispatch interval |
| INTERVAL_ABS_Y |
numeric(18, 8) |
numeric(18, 8) |
Sum of all ABS_Y values for binding CSP constraints in the dispatch interval |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_CSP_SUPPDATA_SUBPRCE_NDX1 |
nonclustered |
LASTCHANGED |
| SET_CSP_SUPPDATA_SUBPRCE_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SET_CSP_SUPPORTDATA_SUBPRICE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SET_CSP_SUPPORTDATA_SUBPRICE |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_CSP_SUPPDATA_SUBPRCE_NDX1 |
nonclustered |
LASTCHANGED |
| SET_CSP_SUPPDATA_SUBPRCE_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME |