INTERCONNMWFLOW (Historical table)
INTERCONNMWFLOW shows Metered Interconnector flow data. INTERCONNMWFLOW shows the meter data provided by Meter Data Providers to MSATS. Despite the name, this view shows metered energy (MWh) and not power flow (MW).
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement Date (based on Trading day, not dispatch day - i.e. period 1 ends 00:30) |
| VERSIONNO |
numeric(6, 0) |
smallint |
Meter Data Version number |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector Identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Settlement Period identifier (half hour period) |
| IMPORTENERGYVALUE |
numeric(15, 6) |
numeric(15, 6) |
Imported Energy value (MWh) |
| EXPORTENERGYVALUE |
numeric(15, 6) |
numeric(15, 6) |
Exported Energy value (MWh) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Record creation timestamp |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTERCONNMWFLOW_LCIDX |
nonclustered |
LASTCHANGED |
| INTERCONNMWFLOW_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERCONNECTORID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_INTERCONNMWFLOW |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERCONNECTORID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTERCONNMWFLOW_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERCONNECTORID, PERIODID |