Table: MNSP_INTERCONNECTOR

MNSP_INTERCONNECTOR

Name

MNSP_INTERCONNECTOR

Comment

MNSP_INTERCONNECTOR sets out attributes of each interconnector.


Description

MNSP_INTERCONNECTOR data is public, so is available to all participants.

Source

MNSP_INTERCONNECTOR changes infrequently, typically annually.

Volume

Twice the number of MNSPs.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

EFFECTIVEDATE

LINKID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

LINKID

VARCHAR2(10)

X

Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to.

EFFECTIVEDATE

DATE

X

Date when Interconnector becomes effective

VERSIONNO

NUMBER(3,0)

X

Version of data for other key data - a higher version for same key data will take precedence

INTERCONNECTORID

VARCHAR2(10)

 

Interconnector Identifier

FROMREGION

VARCHAR2(10)

 

Nominated source region for Interconnector

TOREGION

VARCHAR2(10)

 

Nominated destination region for Interconnector

MAXCAPACITY

NUMBER(5,0)

 

Maximum capacity

TLF

NUMBER(12,7)

 

Transmission Loss Factor (redundant from May 2012)

LHSFACTOR

NUMBER(12,7)

 

Factor applied to the LHS of constraint equations; set by AEMO

METERFLOWCONSTANT

NUMBER(12,7)

 

Obsolete; no longer applied. Ignore.

AUTHORISEDDATE

DATE

 

Date of authorisation. Nominal date but required to enable Interconnector.

AUTHORISEDBY

VARCHAR2(15)

 

Authorising officer

LASTCHANGED

DATE

 

Last date and time record changed

FROM_REGION_TLF

NUMBER(12,7)

 

Transmission Loss Factor for Link "From Region" end

TO_REGION_TLF

NUMBER(12,7)

 

Transmission Loss Factor for Link at "To Region" end