PMS_GROUP
Entity table for group.
Package
PARTICIPANT_REGISTRATION
Visibility
Public
Table schema
| Column | Official MMS Datatype | GR-MMS Datatype | Comment |
|---|---|---|---|
| GROUPID | numeric(20, 0)  |
bigint |
Abstract identifier for the group |
| CREATEDDATE | datetime(3) | datetime2(0) | Date record was created |
| LASTCHANGED | datetime(3) | datetime2(0) | Date record was last changed |
Official MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PMS_GROUP_PK | clustered, unique, primary key | GROUPID |
GR-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PK_PMS_GROUP | clustered, unique, primary key | GROUPID |
Historical-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PK_PMS_GROUP | clustered, unique, primary key | GROUPID |