Name |
|
Comment |
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. |
DISPATCH_MNSPBIDTRK shows own details for participant as they occur, with all details until close of business yesterday being available to all participants after end of day. Source DISPATCH_MNSPBIDTRK potentially updates every 5 minutes. Volume 220, 000 per year |
Name |
LINKID |
PARTICIPANTID |
RUNNO |
SETTLEMENTDATE |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:05 |
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no; always 1 |
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant that owns unit during effective record period |
LINKID |
VARCHAR2(10) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
OFFERSETTLEMENTDATE |
DATE |
|
Offer date for bid |
OFFEREFFECTIVEDATE |
TIMESTAMP(3) |
|
Time this bid was processed and loaded |
OFFERVERSIONNO |
NUMBER(3,0) |
|
VersionNo of the bid/offer used |
LASTCHANGED |
DATE |
|
Record creation timestamp |
|
|
|