DISPATCH_MR_SCHEDULE_TRK
DISPATCH_MR_SCHEDULE_TRK records the Mandatory Restrictions Acceptance Schedule applied to this dispatch interval for this region. DISPATCH_MR_SCHEDULE_TRK is populated by the Dispatch process and records the MR Offer Stack applied in each dispatch interval. DISPATCH_MR_SCHEDULE_TRK is used by Settlements to calculate payments according to the correct MR offer stack.
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date Time of the Dispatch Interval |
| REGIONID |
varchar(10) |
varchar(10) |
Unique RegionID; Key reference to MR_Event_Schedule |
| MR_DATE |
datetime(3) |
datetime2(0) |
Mandatory Restriction date; Key reference to MR_Event_Schedule table |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Date Time the MR acceptance stack was created; Key reference to MR_Event_Schedule table |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time the record was last inserted/modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_MR_SCHEDULE_TRK_LCX |
nonclustered |
LASTCHANGED |
| DISPATCH_MR_SCHEDULE_TRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCH_MR_SCHEDULE_TRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCH_MR_SCHEDULE_TRK |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_MR_SCHEDULE_TRK_LCX |
nonclustered |
LASTCHANGED |
| DISPATCH_MR_SCHEDULE_TRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID |