MNSP_INTERCONNECTOR
MNSP_INTERCONNECTOR sets out attributes of each interconnector.
Package
PARTICIPANT_REGISTRATION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| LINKID |
varchar(10)  |
varchar(10) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Date when Interconnector becomes effective |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version of data for other key data - a higher version for same key data will take precedence |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector Identifier |
| FROMREGION |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| TOREGION |
varchar(10) |
varchar(10) |
Nominated destination region for Interconnector |
| MAXCAPACITY |
numeric(5, 0) |
smallint |
Maximum capacity |
| TLF |
numeric(12, 7) |
numeric(12, 7) |
Transmission Loss Factor (redundant from May 2012) |
| LHSFACTOR |
numeric(12, 7) |
numeric(12, 7) |
Factor applied to the LHS of constraint equations; set by AEMO |
| METERFLOWCONSTANT |
numeric(12, 7) |
numeric(12, 7) |
Obsolete; no longer applied. Ignore. |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date of authorisation. Nominal date but required to enable Interconnector. |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
Authorising officer |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| FROM_REGION_TLF |
numeric(12, 7) |
numeric(12, 7) |
Transmission Loss Factor for Link \"From Region\" end |
| TO_REGION_TLF |
numeric(12, 7) |
numeric(12, 7) |
Transmission Loss Factor for Link at \"To Region\" end |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MNSP_INTERCONNECTOR_LCX |
nonclustered |
LASTCHANGED |
| MNSP_INTERCONNECTOR_PK |
clustered, unique, primary key |
LINKID, EFFECTIVEDATE, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MNSP_INTERCONNECTOR_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MNSP_INTERCONNECTOR |
clustered, unique, primary key |
LINKID, EFFECTIVEDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MNSP_INTERCONNECTOR_LCX |
nonclustered |
LASTCHANGED |
| MNSP_INTERCONNECTOR_PK |
clustered, unique, primary key |
LINKID, EFFECTIVEDATE, VERSIONNO |