|
Name |
|
|
Comment |
DISPATCH_MNSPBIDTRK shows the MNSP bid tracking, including the bid version used in each dispatch run for each MNSP Interconnector Link. DISPATCH_MNSPBIDTRK is the audit trail of the bids actually used for each dispatch run. |
|
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 |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
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 |
DATE |
|
Date the bid/offer becomes effective |
|
OFFERVERSIONNO |
NUMBER(3,0) |
|
VersionNo of the bid/offer used |
|
LASTCHANGED |
DATE |
|
Record creation timestamp |
|
|
|