Skip to content

PASA_SUBSTATION_ZONE_MAPPING

PASA_SUBSTATION_ZONE_MAPPING shows the mapping of each Energy Management System Substation ID to its parent Zone ID.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
SUBSTATIONID varchar(30) 🔑 varchar(30) 🔑 The Energy Management System identifier for this Substation
EFFECTIVEDATE datetime(3) 🔑 datetime2(0) 🔑 Effective date of this Energy Management System Substation ID to Zone ID mapping
VERSIONNO numeric(3, 0) 🔑 smallint 🔑 Version number for the Effective date
ZONEID varchar(30) varchar(30) The identifier of the Zone to which this Energy Management System Substation ID belongs
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_SUBSTATION_ZONEMAPPING_PK clustered, unique, primary key SUBSTATIONID, EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_PASA_SUBSTATION_ZONE_MAPPING clustered, unique, primary key SUBSTATIONID, EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_PASA_SUBSTATION_ZONE_MAPPING clustered, unique, primary key SUBSTATIONID, EFFECTIVEDATE, VERSIONNO