PARTICIPANTCLASS

PARTICIPANTCLASS sets out valid participant classifications.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTCLASSID	varchar(20)	varchar(20)	Class of participant
DESCRIPTION	varchar(64)	varchar(64)	Description of participant class
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
PARTCLASS_PK	clustered, unique, primary key	PARTICIPANTCLASSID
PARTICIPANTCLASS_LCX	nonclustered	LASTCHANGED

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PARTICIPANTCLASS_LASTCHANGED	nonclustered	LASTCHANGED
PK_PARTICIPANTCLASS	clustered, unique, primary key	PARTICIPANTCLASSID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PARTCLASS_PK	clustered, unique, primary key	PARTICIPANTCLASSID
PARTICIPANTCLASS_LCX	nonclustered	LASTCHANGED