|
Name |
|
|
Comment |
MTPASA_INTERCONNECTORSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
MTPASA_INTERCONNECTORSOLUTION is public so is available to all participants. Source MTPASA_INTERCONNECTORSOLUTION is updated each MTPASA run (i.e. weekly). Volume Rows per week: 35280 To store only the latest solution, divide these figures by 5 (number of weeks per month rounded up). |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DAY |
|
ENERGYBLOCK |
|
INTERCONNECTORID |
|
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 |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
The unique identifier for the interconnector |
|
CAPACITYMWFLOW |
NUMBER(12,2) |
|
Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints |
|
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; where CapacityMWFLow <= export + violation Degree (Deficit)CapacityMWFLow >= import + CapacityViolationDegree (Deficit) |
|
CALCULATEDEXPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit |
|
CALCULATEDIMPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow |
|
LASTCHANGED |
DATE |
|
Date the solution was loaded |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
|
EXPORTLIMITCONSTRAINTID |
VARCHAR2(20) |
|
ID of the constraint that sets the Interconnector Export Limit |
|
IMPORTLIMITCONSTRAINTID |
VARCHAR2(20) |
|
ID of the constraint that sets the Interconnector Import Limit |
|
|
|