PARTICIPANTNOTICETRK

PARTICIPANTNOTICETRK provides the cross-reference between participant market notices and participants.

Package

MARKET_NOTICE

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
NOTICEID	numeric(10, 0)	int	Market notice 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)
PARTICIPANTNOTICETRK_LCX	nonclustered	LASTCHANGED
PARTICIPANTNOTICETRK_NDX2	nonclustered	PARTICIPANTID
PARTICIPANTNOTICETRK_PK	clustered, unique, primary key	PARTICIPANTID, NOTICEID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PARTICIPANTNOTICETRK_LASTCHANGED	nonclustered	LASTCHANGED
IX_PARTICIPANTNOTICETRK_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_PARTICIPANTNOTICETRK	clustered, unique, primary key	PARTICIPANTID, NOTICEID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PARTICIPANTNOTICETRK_LASTCHANGED	nonclustered	LASTCHANGED
IX_PARTICIPANTNOTICETRK_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_PARTICIPANTNOTICETRK	clustered, unique, primary key	PARTICIPANTID, NOTICEID