DISPATCHBLOCKEDCONSTRAINT
DISPATCH Blocked Constraints lists any constraints that were blocked in a dispatch run. If no constraints are blocked, there will be no rows for that dispatch run.
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Dispatch Interval |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Generic Constraint identifier (synonymous with GenConID) |
| RUNNO |
numeric(3, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHBLOCKEDCONSTRAINT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCHBLOCKEDCONSTRAINT |
clustered, unique, primary key |
SETTLEMENTDATE, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHBLOCKEDCONSTRAINT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, CONSTRAINTID |