MTPASA_INTERCONNECTORRESULT
Interconnector results for interval of max demand per day.
Package
MTPASA
Visibility
Public
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(4, 0) |
smallint |
Unique run id. |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Always RELIABILITY |
| DEMAND_POE_TYPE |
varchar(20) |
varchar(20) |
Demand POE type used. Value is POE10 |
| DAY |
datetime(3) |
datetime2(0) |
Day this result is for |
| INTERCONNECTORID |
varchar(20) |
varchar(20) |
The unique identifier for the interconnector |
| PERIODID |
numeric(3, 0) |
smallint |
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) |
| FLOW90 |
numeric(12, 2) |
numeric(12, 2) |
The 90th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) |
| FLOW50 |
numeric(12, 2) |
numeric(12, 2) |
The 50th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) |
| FLOW10 |
numeric(12, 2) |
numeric(12, 2) |
The 10th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) |
| PROBABILITYOFBINDINGEXPORT |
numeric(8, 5) |
numeric(8, 5) |
Proportion of iterations and reference years with interconnector constrained when exporting |
| PROBABILITYOFBINDINGIMPORT |
numeric(8, 5) |
numeric(8, 5) |
Proportion of iterations and reference years with interconnector constrained when importing |
| CALCULATEDEXPORTLIMIT |
numeric(12, 2) |
numeric(12, 2) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit, averaged across iterations and reference years |
| CALCULATEDIMPORTLIMIT |
numeric(12, 2) |
numeric(12, 2) |
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit, averaged across iterations and reference years |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_INTERCONNECTORRESULT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, INTERCONNECTORID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_INTERCONNECTORRESULT |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, INTERCONNECTORID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_INTERCONNECTORRESULT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, DAY, INTERCONNECTORID |