|
Name |
|
|
Comment |
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes energy differential information for each half-hour interval in the settlement run |
|
THIS TABLE WILL BE DISCONTINUED AS PART OF THE END OF YEAR 2009 MMS RELEASESource 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 |
|
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 |
|
LOWERTUMUT_SPDP |
NUMBER(18,8) |
|
Lower Tumut Substitute Price for the half hour interval |
|
UPPERTUMUT_SPDP |
NUMBER(18,8) |
|
Upper Tumut Substitute Price for the half hour interval |
|
LOWERTUMUT_EVDP |
NUMBER(18,8) |
|
Lower Tumut Energy Value Differential for the half hour interval |
|
UPPERTUMUT_EVDP |
NUMBER(18,8) |
|
Upper Tumut Energy Value Differential for the half hour interval |
|
FLOW_DIRECTION |
VARCHAR2(20) |
|
Indicates the determined direction of flow in the half hour. Will be either “”NORTH” or “SOUTH” |
|
TOTAL_X |
NUMBER(18,8) |
|
Sum of all "ABS_X" values in the half hour |
|
TOTAL_Y |
NUMBER(18,8) |
|
Sum of all "ABS_Y" values in the half hour |
|
LOWERTUMUT_AGE |
NUMBER(18,8) |
|
Energy output of the Lower Tumut unit in the half hour interval |
|
UPPERTUMUT_AGE |
NUMBER(18,8) |
|
Energy output of the Upper Tumut unit in the half hour interval |
|
EVA |
NUMBER(18,8) |
|
Energy value adjustment for northward flows in the half-hour interval |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
|
|