PREDISPATCH_MNSPBIDTRK
PREDISPATCH_MNSPBIDTRK shows the MNSP bid tracking, including the bid version used in each predispatch run for each MNSP Interconnector Link. PREDISPATCH_MNSPBIDTRK shows the audit trail of the bid used for each predispatch run.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20)  |
int |
Predispatch run identifier |
| LINKID |
varchar(10) |
varchar(10) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
| PERIODID |
varchar(20) |
varchar(20) |
Trading Interval number |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant Identifier |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Market Date from which bid is active |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Time this bid was processed and loaded |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version No. for given offer date and settlement date used |
| DATETIME |
datetime(3) |
datetime2(0) |
Period expressed as Date/Time |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Record creation timestamp |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCH_MNSPBIDTRK_LCX |
nonclustered |
LASTCHANGED |
| PREDISPATCH_MNSPBIDTRK_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, LINKID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PREDISPATCH_MNSPBIDTRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PREDISPATCH_MNSPBIDTRK |
clustered, unique, primary key |
PREDISPATCHSEQNO, LINKID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCH_MNSPBIDTRK_LCX |
nonclustered |
LASTCHANGED |
| PREDISPATCH_MNSPBIDTRK_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, LINKID, PERIODID |