Skip to content

AGGREGATE_DISPATCH_GROUP

Entity allowing for compliance monitoring over grouped DUIDs.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
ADG_ID varchar(20) 🔑 varchar(20) 🔑 Aggregate Dispatch Group ID
COMMENTS varchar(100) varchar(100) A participant provided comment
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed

Official MMS data model indexes

Index name Index type Index columns (in order)
AGGREGATE_DISPATCH_GROUP_PK clustered, unique, primary key ADG_ID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_AGGREGATE_DISPATCH_GROUP clustered, unique, primary key ADG_ID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
AGGREGATE_DISPATCH_GROUP_PK clustered, unique, primary key ADG_ID