PREDISPATCHOFFERTRK
PREDISPATCHOFFERTRK is for the ancillary service bid tracking of predispatch processing. PREDISPATCHOFFERTRK identifies which bids from BIDDAYOFFER and BIDOFFERPERIOD were applied for a given unit and ancillary service for each predispatch run.
Package
PRE_DISPATCH
Visibility
Private, Public Next-Day
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 |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit identifier |
| BIDTYPE |
varchar(20) |
varchar(20) |
Bid type Identifier - the ancillary service to which the bid applies |
| DATETIME |
datetime(3) |
datetime2(0) |
Period date and time |
| BIDSETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Settlement date of bid applied |
| BIDOFFERDATE |
datetime(3) |
datetime2(0) |
Time this bid was processed and loaded |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| PERIODID |
varchar(20) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCHOFFERTRK_LCHD_IDX |
nonclustered |
LASTCHANGED |
| PREDISPATCHOFFERTRK_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, DUID, BIDTYPE, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHOFFERTRK |
clustered, unique, primary key |
PREDISPATCHSEQNO, BIDTYPE, DUID, DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCHOFFERTRK_CCI |
clustered, columnstore |
n/a |
| PREDISPATCHOFFERTRK_PK |
nonclustered, unique, primary key |
DUID, BIDTYPE, PREDISPATCHSEQNO, DATETIME |