Table: PREDISPATCHCONSTRAINT

PREDISPATCHCONSTRAINT

Name

PREDISPATCHCONSTRAINT

Comment

PREDISPATCHCONSTRAINT sets out constraints that are binding in each predispatch run and interconnector constraints (whether binding or not). Only binding and interconnector constraints are reported. Binding contracts have marginal value greater than $0. Interconnector constraints are listed so RHS values can be reported for ST PASA.
Constraint solutions only report fixed loading /MR constraints on the next day.


Description

PREDISPATCHCONSTRAINT data is confidential on the day of creation, and public to all participants after the end of the market day.

Source

PREDISPATCHCONSTRAINT updates with every thirty-minute predispatch run.

Note

The PERIODID columns in tables PREDISPATCHCONSTRAINT and PREDISPATCH_FCAS_REQ have no consistent relationship with the other PERIODID values in the other tables in the PRE-DISPATCH package (such as PREDISPATCHPRICE). AEMO and many Participants appreciate the data model is inconsistent, but the cost of changing existing systems has been judged as being unjustifiable. An additional field DATETIME was added to allow joins between these data sets.


Primary Key Columns

Name

CONSTRAINTID

DATETIME


Index Columns

Name

PREDISPATCHSEQNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

PREDISPATCHSEQNO

VARCHAR2(20)

 

Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30

RUNNO

NUMBER(3,0)

 

SPD Predispatch run no, typically 1. It increments if the case is re-run.

CONSTRAINTID

VARCHAR2(20)

X

Generic constraint identifier

PERIODID

VARCHAR2(20)

 

Unique period identifier, in the format yyyymmddpp. The period (pp) is 01 to 48, with 01 corresponding to the half-hour ending at 04:30am.

INTERVENTION

NUMBER(2,0)

 

Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0

RHS

NUMBER(15,5)

 

RHS value used.

MARGINALVALUE

NUMBER(15,5)

 

Marginal value of violated constraint

VIOLATIONDEGREE

NUMBER(15,5)

 

Degree of constraint violation

LASTCHANGED

DATE

 

Last date and time record changed

DATETIME

DATE

X

Period date and time

DUID

VARCHAR2(20)

 

DUID to which the Constraint is confidential. Null denotes non-confidential

GENCONID_EFFECTIVEDATE

DATE

 

Effective date of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval

GENCONID_VERSIONNO

NUMBER(22,0)

 

Version number of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval

LHS

number(15,5)

 

Aggregation of the constraints LHS term solution values