Skip to content

PASA_INTERCONNECTOR_MAPPING

PASA_INTERCONNECTOR_MAPPING shows the mapping of each Interconnector to its From Region ID and To Region ID.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
INTERCONNECTORID varchar(20) 🔑 varchar(20) 🔑 The identifier for this Interconnector
EFFECTIVEDATE datetime(3) 🔑 datetime2(0) 🔑 Effective date of this Interconnector mapping
VERSIONNO numeric(3, 0) 🔑 smallint 🔑 Version number for the Effective date
FROMREGIONID varchar(20) varchar(10) From Region ID for this Interconnector
TOREGIONID varchar(20) varchar(10) To Region ID for this Interconnector
INTERCONNECTOR_FULLNAME varchar(50) varchar(50) Full Name for this Interconnector
OPERATINGSTATUS varchar(20) varchar(20) Active or inactive indicator
LASTCHANGED datetime(3) datetime2(0) Date time this record was created

Official MMS data model indexes

Index name Index type Index columns (in order)
PASA_INTERCONNECTOR_MAPPING_PK clustered, unique, primary key INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_PASA_INTERCONNECTOR_MAPPING clustered, unique, primary key INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_PASA_INTERCONNECTOR_MAPPING clustered, unique, primary key INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO