ADG_DETAIL
Table for tracking evolving Aggregate Dispatch Group attributes.
Package
PARTICIPANT_REGISTRATION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| ADG_ID |
varchar(20)  |
varchar(20) |
Identifies the Aggregate Dispatch Group |
| EFFECTIVEDATE |
datetime(3) |
date |
Effective calendar date of record |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Date and time of the version of Dispatchable Unit details |
| ADG_TYPE |
varchar(20) |
varchar(20) |
Conformance Type for the Aggregate Dispatch Group. One of the following: CAP, MIXED, TARGET |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date record authorised |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising record |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| ADG_DETAIL_PK |
clustered, unique, primary key |
ADG_ID, EFFECTIVEDATE, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_ADG_DETAIL |
clustered, unique, primary key |
ADG_ID, EFFECTIVEDATE, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_ADG_DETAIL |
clustered, unique, primary key |
ADG_ID, EFFECTIVEDATE, VERSION_DATETIME |