DISPATCH_MNSPBIDTRK
DISPATCH_MNSPBIDTRK shows the MNSP bid tracking, including the bid version used in each dispatch run for each MNSP Interconnector Link. The table identifies which bids from MNSP_DAYOFFER and MNSP_BIDOFFERPERIOD were applied.
Package
DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:05 |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant that owns unit during effective record period |
| LINKID |
varchar(10) |
varchar(10) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
| OFFERSETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Offer date for bid |
| OFFEREFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Time this bid was processed and loaded |
| OFFERVERSIONNO |
numeric(3, 0) |
smallint |
VersionNo of the bid/offer used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Record creation timestamp |
| RUNNO |
numeric(3, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_MNSPBIDTRK_LCX |
nonclustered |
LASTCHANGED |
| DISPATCH_MNSPBIDTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, PARTICIPANTID, LINKID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCH_MNSPBIDTRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCH_MNSPBIDTRK |
clustered, unique, primary key |
SETTLEMENTDATE, PARTICIPANTID, LINKID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_MNSPBIDTRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, PARTICIPANTID, LINKID |