PARTICIPANTCATEGORY

PARTICIPANTCATEGORY sets out valid participant categories.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTCATEGORYID	varchar(10)	varchar(10)	Participant category identifier
DESCRIPTION	varchar(64)	varchar(64)	Category description
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
PARTICIPANTCATEGORY_LCX	nonclustered	LASTCHANGED
PARTICIPANTCATEGORY_PK	clustered, unique, primary key	PARTICIPANTCATEGORYID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PARTICIPANTCATEGORY_LASTCHANGED	nonclustered	LASTCHANGED
PK_PARTICIPANTCATEGORY	clustered, unique, primary key	PARTICIPANTCATEGORYID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PARTICIPANTCATEGORY_LCX	nonclustered	LASTCHANGED
PARTICIPANTCATEGORY_PK	clustered, unique, primary key	PARTICIPANTCATEGORYID