Table: STPASA_CONSTRAINTSOLUTION

STPASA_CONSTRAINTSOLUTION

Name

STPASA_CONSTRAINTSOLUTION

Comment

STPASA_CONSTRAINTSOLUTION shows binding and violated constraint results from the capacity evaluation, including the RHS value.


Description

STPASA_CONSTRAINTSOLUTION is public data.

Source

STPASA_CONSTRAINTSOLUTION is updated each STPASA run (i.e. every 2 hours).

Volume

Rows per day: 19000 (est.)

Mb per month: 90


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

RUN_DATETIME

RUNTYPE

STUDYREGIONID


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)

CAPACITYRHS

NUMBER(12,2)

 

The RHS value in the capacity evaluation.

CAPACITYMARGINALVALUE

NUMBER(12,2)

 

Capacity adequacy assessment marginal value, 0 if not binding

CAPACITYVIOLATIONDEGREE

NUMBER(12,2)

 

Capacity adequacy assessment violation degree for generic constraint; 0 if not violating

LASTCHANGED

DATE

 

Last changed date of this record

RUNTYPE

VARCHAR2(20)

X

Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR.

STUDYREGIONID

VARCHAR2(20)

X

Primary Region for LP Solve (or MARKET if none).