MCC_CASESOLUTION
Top level table for each MCC dispatch rerun process. Note there will be one record for each dispatch interval.
Package
MCC_DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
5-minute Dispatch Run identifier |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MCC_CASESOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MCC_CASESOLUTION |
clustered, unique, primary key |
RUN_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MCC_CASESOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME |