TRADINGINTERCONNECT
TRADINGINTERCONNECT shows the Interconnector flows for the 5 minutes Trading Interval. Prior to 5 Minute Settlements, this was the average of the six 5 minute dispatch intervals within the 30 minute period.
Package
TRADING_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date that this data applies to |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector identifier |
| PERIODID |
numeric(3, 0) |
smallint (not nullable) |
Period number where 1 represents the trading interval ending at 00:05 AEST |
| METEREDMWFLOW |
numeric(15, 5) |
numeric(15, 5) |
Average of the metered MW flow from the start of each dispatch interval. |
| MWFLOW |
numeric(15, 5) |
numeric(15, 5) |
Calculated MW Flow from SPD |
| MWLOSSES |
numeric(15, 5) |
numeric(15, 5) |
MW losses at calculated MW flow |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| RUNNO |
numeric(3, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGINTERCONNECT |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, INTERCONNECTORID, PERIODID |
| TRADINGINTERCONNECT_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGINTERCONNECT |
clustered, unique, primary key |
SETTLEMENTDATE, INTERCONNECTORID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGINTERCONNECT |
nonclustered, unique, primary key |
SETTLEMENTDATE, INTERCONNECTORID |
| TRADINGINTERCONNECT_CCI |
clustered, columnstore |
n/a |