DISPATCHBIDTRK (Historical table)
DISPATCHBIDTRK shows the bid tracking, including the bid version used in each dispatch run for each unit. DISPATCHBIDTRK is the audit trail of the bid actually used in each dispatch.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:05 |
| OFFEREFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Effective date of offer used |
| OFFERVERSIONNO |
numeric(3, 0) |
smallint |
Version no of offer used |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid type (daily, default or rebid) |
| 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) |
| DISPATCHBIDTRK_LCX |
nonclustered |
LASTCHANGED |
| DISPATCHBIDTRK_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| DISPATCHBIDTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, OFFEREFFECTIVEDATE, OFFERVERSIONNO, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCHBIDTRK_DUID_LASTCHANGED |
nonclustered |
DUID, LASTCHANGED |
| IX_DISPATCHBIDTRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCHBIDTRK |
clustered, unique, primary key |
SETTLEMENTDATE, OFFEREFFECTIVEDATE, OFFERVERSIONNO, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHBIDTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, OFFEREFFECTIVEDATE, OFFERVERSIONNO, DUID |