METERDATA_INTERCONNECTOR
Publishes metering data associated with wholesale interconnectors for a given CASE_ID.
Package
METER_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CASE_ID |
numeric(15, 0)  |
int |
Case Identifier |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Settlement date within the case |
| INTERCONNECTORID |
varchar(20) |
varchar(20) |
Interconnector Identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Trading Interval. |
| IMPORTVALUE |
numeric(18, 8) |
numeric(18, 8) |
The import direction value for the meter read (MWh) |
| EXPORTVALUE |
numeric(18, 8) |
numeric(18, 8) |
The export direction value for the meter read (MWh) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_INTERCONNECTOR_PK |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, INTERCONNECTORID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_INTERCONNECTOR |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, INTERCONNECTORID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_INTERCONNECTOR |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, INTERCONNECTORID, PERIODID |