Skip to content

PASA_DUID_SUBSTATION_MAPPING

PASA_DUID_SUBSTATION_MAPPING shows the mapping of each DUID to its Energy Management System Substation ID.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

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

GR-MMS data model indexes

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

Historical-MMS data model indexes

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