MTPASA_INTERCONNECTORSOLUTION (Historical table)
MTPASA_INTERCONNECTORSOLUTION is obsolete from 2017 End of Year DM4.27 Release. The MTPASA_INTERCONNECTORSOLUTION table shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the ldcblock within the day. Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables (see Change Notices 400, 400a and 400b).
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins |
| RUN_NO |
numeric(3, 0) |
smallint |
Unique run id. Generated from the solution file caseid |
| ENERGYBLOCK |
datetime(3) |
datetime2(0) |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block |
| DAY |
datetime(3) |
datetime2(0) |
Day this solution is for. Generated from the solution file periodid |
| LDCBLOCK |
numeric(3, 0) |
smallint |
LDC block this solution is for. Generated from the solution file periodid |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
The unique identifier for the interconnector |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
| CAPACITYMWFLOW |
numeric(12, 2) |
numeric(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 |
numeric(12, 2) |
numeric(12, 2) |
Capacity adequacy assessment marginal value; 0 if not binding |
| CAPACITYVIOLATIONDEGREE |
numeric(12, 2) |
numeric(12, 2) |
Capacity adequacy assessment violation degree, 0 if not violating; where CapacityMWFLow <= export + violation Degree (Deficit)CapacityMWFLow >= import + CapacityViolationDegree (Deficit) |
| CALCULATEDEXPORTLIMIT |
numeric(12, 2) |
numeric(12, 2) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit |
| CALCULATEDIMPORTLIMIT |
numeric(12, 2) |
numeric(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 |
datetime(3) |
datetime2(0) |
Date the solution was loaded |
| EXPORTLIMITCONSTRAINTID |
varchar(20) |
varchar(20) |
ID of the constraint that sets the Interconnector Export Limit |
| IMPORTLIMITCONSTRAINTID |
varchar(20) |
varchar(20) |
ID of the constraint that sets the Interconnector Import Limit |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_INTERCONNECTORSOLN_NDX2 |
nonclustered |
LASTCHANGED |
| MTPASA_INTERCONNECTORSOLN_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, INTERCONNECTORID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_INTERCONNECTORSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, INTERCONNECTORID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_INTERCONNECTORSOLUTION_CCI |
clustered, columnstore |
n/a |
| PK_MTPASA_INTERCONNECTORSOLUTION |
nonclustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, INTERCONNECTORID |