DISPATCHOFFERTRK
DISPATCHOFFERTRK is the energy and ancillary service bid tracking table for the Dispatch process. The table identifies which bids from BIDDAYOFFER and BIDOFFERPERIOD were applied for a given unit and bid type for each dispatch interval.
Package
DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35) |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid type Identifier - the ancillary service to which the bid applies |
| BIDSETTLEMENTDATE |
datetime(3) |
datetime2(0) (not nullable) |
Settlement date of bid applied |
| BIDOFFERDATE |
datetime(3) |
datetime2(0) (not nullable) |
Time this bid was processed and loaded |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHOFFERTRK_LCHD_IDX |
nonclustered |
LASTCHANGED |
| DISPATCHOFFERTRK_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| DISPATCHOFFERTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCHOFFERTRK |
clustered, unique, primary key |
SETTLEMENTDATE, BIDTYPE, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHOFFERTRK_CCI |
clustered, columnstore |
n/a |
| PK_DISPATCHOFFERTRK |
nonclustered, unique, primary key |
BIDTYPE, SETTLEMENTDATE, DUID |