Table: SET_CSP_SUPPORTDATA_ENERGYDIFF

SET_CSP_SUPPORTDATA_ENERGYDIFF

Name

SET_CSP_SUPPORTDATA_ENERGYDIFF

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


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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