Table: MTPASA_CONSTRAINTSOLUTION

MTPASA_CONSTRAINTSOLUTION

Name

MTPASA_CONSTRAINTSOLUTION

Comment

MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release.
The MTPASA_CONSTRAINTSOLUTION table holds the binding and violated constraint results from the capacity evaluation, including the RHS value.
Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables.


Description

MTPASA_CONSTRAINTSOLUTION is public data.

Source

MTPASA_CONSTRAINTSOLUTION is updated each MTPASA run (i.e. weekly).

Volume

Rows per week: 230

To store only the latest solution, divide these figures by 5.


Primary Key Columns

Name

CONSTRAINTID

DAY

ENERGYBLOCK

LDCBLOCK

RUN_DATETIME

RUN_NO

RUNTYPE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Date processing of the run begins

RUN_NO

NUMBER(3,0)

X

Unique run id. Generated from the solution file caseid

ENERGYBLOCK

DATE

X

Sunday at start of the week for this solutions energy block. Generated from the solution file energy block

DAY

DATE

X

Day this solution is for. Generated from the solution file periodid

LDCBLOCK

NUMBER(3,0)

X

LDC block this solution is for. Generated from the solution file periodid

CONSTRAINTID

VARCHAR2(20)

X

The unique identifier for the constraint

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; 0 if not violating

LASTCHANGED

DATE

 

Date the solution was loaded

RUNTYPE

VARCHAR2(20)

X

Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC