|
Name |
|
|
Comment |
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. |
|
Source Own (confidential) data updates every predispatch run. All bids are available to all participants as part of next day market data. Volume 1, 700, 000 per year |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
LINKID |
|
PERIODID |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PREDISPATCHSEQNO |
VARCHAR2(20) |
X |
Predispatch run identifier |
|
LINKID |
VARCHAR2(10) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
|
PERIODID |
VARCHAR2(20) |
X |
Trading Interval number |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Participant Identifier |
|
SETTLEMENTDATE |
DATE |
|
Market Date from which bid is active |
|
OFFERDATE |
DATE |
|
Offer date for bid |
|
VERSIONNO |
NUMBER(3,0) |
|
Version No. for given offer date and settlement date used |
|
DATETIME |
DATE |
|
Period expressed as Date/Time |
|
LASTCHANGED |
DATE |
|
Record creation timestamp |
|
|
|