Name |
|
Comment |
MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
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. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
CONSTRAINTID |
DAY |
ENERGYBLOCK |
LDCBLOCK |
RUN_DATETIME |
RUN_NO |
RUNTYPE |
Name |
LASTCHANGED |
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 |
|
|
|