Skip to content

PASA_INTERCONNECTOR_BOUNDARY

PASA_INTERCONNECTOR_BOUNDARY shows the mapping of each Interconnector boundary to its constituent Energy Management System Branch IDs.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
INTERCONNECTORID varchar(20) 🔑 varchar(20) 🔑 The identifier of the Interconnector
EFFECTIVEDATE datetime(3) 🔑 datetime2(0) 🔑 Effective date of this Interconnector Boundary mapping
VERSIONNO numeric(3, 0) 🔑 smallint 🔑 Version number for the Effective date
BRANCHID varchar(50) 🔑 varchar(50) 🔑 Branch Identifier
BRANCHSUBID varchar(50) 🔑 varchar(50) 🔑 Branch Sub-Identifier
BRANCHFROMSUBSTATION varchar(30) varchar(30) Branch FromSubstation. Positive BranchFlow from FromSubstation to ToSubstation.
BRANCHTOSUBSTATION varchar(30) varchar(30) Branch ToSubstation. Positive BranchFlow from FromSubStation to ToSubStation.
BRANCHTYPE varchar(10) varchar(10) Branch Type(LN = Line, XF = Transformer, ZBR = Zero Impedance Branch)
BRANCH_TO_INTERCONN_FLOWMULT numeric(1, 0) smallint Multiplier(1 or -1) used to convert from Branch Flow direction to Interconnector flow direction
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_INTERCONNECTORBOUNDARY_PK clustered, unique, primary key INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO, BRANCHID, BRANCHSUBID

GR-MMS data model indexes

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

Historical-MMS data model indexes

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