PARTICIPANTCATEGORYALLOC

PARTICIPANTCATEGORYALLOC sets out the assignment of participants to particular categories.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTCATEGORYID	varchar(10)	varchar(10)	Category unique identifier
PARTICIPANTID	varchar(10)	varchar(10)	Unique 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)
PARTICIPANTCATALLOC_PK	clustered, unique, primary key	PARTICIPANTCATEGORYID, PARTICIPANTID
PARTICIPANTCATEGORYALLOC_LCX	nonclustered	LASTCHANGED

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PARTICIPANTCATEGORYALLOC_LASTCHANGED	nonclustered	LASTCHANGED
PK_PARTICIPANTCATEGORYALLOC	clustered, unique, primary key	PARTICIPANTCATEGORYID, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PARTICIPANTCATALLOC_PK	clustered, unique, primary key	PARTICIPANTCATEGORYID, PARTICIPANTID
PARTICIPANTCATEGORYALLOC_LCX	nonclustered	LASTCHANGED