|
Name |
|
|
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. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
Name |
|
CONSTRAINTID |
|
DATETIME |
|
Name |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|