Table: SET_CSP_SUPPORTDATA_CONSTRAINT

SET_CSP_SUPPORTDATA_CONSTRAINT

Name

SET_CSP_SUPPORTDATA_CONSTRAINT

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


Description

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.


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

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

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