MTPASAINTERCONNECTORSOLUTION_D (Historical table)
MTPASAINTERCONNECTORSOLUTION_D shows interconnector results for MT PASA, shown region by region.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| DATETIME |
datetime(3)  |
datetime2(0) |
Date of results. One record for each day for next two years. |
| INTERCONNECTOR_ID |
varchar(12) |
varchar(12) |
Interconnector Identifier |
| POSITIVE_INTERCONNECTOR_FLOW |
numeric(16, 6) |
numeric(16, 6) |
The MW flow out |
| POSITIVE_TRANSFER_LIMITS |
numeric(16, 6) |
numeric(16, 6) |
The MW transfer limits out |
| POSITIVE_BINDING |
varchar(10) |
varchar(10) |
Indication of a binding limit in the out direction |
| NEGATIVE_INTERCONNECTOR_FLOW |
numeric(16, 6) |
numeric(16, 6) |
The MW flow in |
| NEGATIVE_TRANSFER_LIMITS |
numeric(16, 6) |
numeric(16, 6) |
the MW transfer limits in |
| NEGATIVE_BINDING |
varchar(10) |
varchar(10) |
Indication of a binding limit in the in direction |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last change date and time |
| RUN_DATETIME |
datetime(3) |
datetime2(0) (not nullable) |
The run date and time |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASAINTERCONSOLUTION_D_LCX |
nonclustered |
LASTCHANGED |
| MTPASAINTERCONSOLUTION_D_PK |
clustered, unique, primary key |
DATETIME, INTERCONNECTOR_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MTPASAINTERCONNECTORSOLUTION_D_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MTPASAINTERCONNECTORSOLUTION_D |
clustered, unique, primary key |
DATETIME, INTERCONNECTOR_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASAINTERCONSOLUTION_D_LCX |
nonclustered |
LASTCHANGED |
| MTPASAINTERCONSOLUTION_D_PK |
clustered, unique, primary key |
DATETIME, INTERCONNECTOR_ID |