MNSP_PARTICIPANT

MNSP_PARTICIPANT registers MNSP ownership.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
INTERCONNECTORID	varchar(10)	varchar(10)	Interconnector Identifier
EFFECTIVEDATE	datetime(3)	datetime2(0)	Calendar date when Interconnector ownership becomes effective
VERSIONNO	numeric(3, 0)	smallint	Version of data for other key data - a higher version for same key data takes precedence
PARTICIPANTID	varchar(10)	varchar(10)	Participant Identifier
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
MNSP_PARTICIPANT_LCX	nonclustered	LASTCHANGED
MNSP_PARTICIPANT_PK	clustered, unique, primary key	INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_MNSP_PARTICIPANT_LASTCHANGED	nonclustered	LASTCHANGED
PK_MNSP_PARTICIPANT	clustered, unique, primary key	INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
MNSP_PARTICIPANT_LCX	nonclustered	LASTCHANGED
MNSP_PARTICIPANT_PK	clustered, unique, primary key	INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO, PARTICIPANTID