DISPATCHTRK (Historical table)
DISPATCHTRK is no longer used. DISPATCHTRK was the cross-reference between each dispatch run and SPD case run. DISPATCHTRK may be available on the InfoServer but not replicated to participant databases as it contains data duplicated in other tables.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date and time starting at 04:05 |
| REASON |
varchar(64) |
varchar(64) |
Reason code (if rerun) |
| SPDRUNNO |
numeric(3, 0) |
smallint |
Case identifier for LP Solver |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| RUNNO |
numeric(3, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHTRK_LCX |
nonclustered |
LASTCHANGED |
| DISPATCHTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCHTRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCHTRK |
clustered, unique, primary key |
SETTLEMENTDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE |