Skip to content

PASA_INTERZONAL_BOUNDARY

PASA_INTERZONAL_BOUNDARY shows the mapping of each Interzonal connector boundary to its constituent Energy Management System Branch IDs.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
INTERZONALCONNECTORID varchar(50) 🔑 varchar(50) 🔑 The identifier for this Interzonal connector
EFFECTIVEDATE datetime(3) 🔑 datetime2(0) 🔑 Effective date of this Interzonal connector boundary definition
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 Branch Flow from FromSubstation to ToSubstation.
BRANCHTOSUBSTATION varchar(30) varchar(30) Branch ToSubstation. Positive Branch Flow from FromSubstation to ToSubstation.
BRANCHTYPE varchar(10) varchar(10) Branch Type(LN = Line, XF = Transformer, ZBR = Zero Impedance Branch)
BRANCH_TO_INTERZONAL_FLOWMULT numeric(1, 0) smallint Multiplier(1 or -1) used to convert from Branch Flow direction to Interzonal connector 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_INTERZONAL_BOUNDARY_PK clustered, unique, primary key INTERZONALCONNECTORID, EFFECTIVEDATE, VERSIONNO, BRANCHID, BRANCHSUBID

GR-MMS data model indexes

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

Historical-MMS data model indexes

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