PREDISPATCHBLOCKEDCONSTRAINT
PREDISPATCH Blocked Constraints lists any constraints that were blocked in a Predispatch run. If no constraints are blocked, there will be no rows for that predispatch run.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20)  |
int |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Generic Constraint identifier (synonymous with GenConID) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHBLOCKEDCONSTR |
clustered, unique, primary key |
PREDISPATCHSEQNO, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHBLOCKEDCONSTRAINT |
clustered, unique, primary key |
PREDISPATCHSEQNO, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHBLOCKEDCONSTR |
clustered, unique, primary key |
PREDISPATCHSEQNO, CONSTRAINTID |