Table: P5MIN_CONSTRAINTSOLUTION

P5MIN_CONSTRAINTSOLUTION

Name

P5MIN_CONSTRAINTSOLUTION

Comment

The Five-Minute Pre-Dispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The Five-Minute Pre-dispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods.
P5MIN_CONSTRAINTSOLUTION shows binding and violated constraint results from the capacity evaluation, including the RHS value.


Description

P5MIN_CONSTRAINTSOLUTION is public data, so is available to all participants.

Source

P5MIN_CONSTRAINTSOLUTION updates every five minutes.

Volume

Rows per day: ~2.3 million


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private & Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

RUN_DATETIME


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

CONSTRAINTID

VARCHAR2(20)

X

Constraint identifier (synonymous with GenConID)

RHS

NUMBER(15,5)

 

Right Hand Side value in the capacity evaluation

MARGINALVALUE

NUMBER(15,5)

 

Marginal cost of constraint (>0 if binding)

VIOLATIONDEGREE

NUMBER(15,5)

 

Amount of Violation (>0 if violating)

LASTCHANGED

DATE

 

Last date and time record changed

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

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 there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0)