Table: DISPATCH_MNSPBIDTRK

DISPATCH_MNSPBIDTRK

Name

DISPATCH_MNSPBIDTRK

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.


Description

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


Primary Key Columns

Name

LINKID

PARTICIPANTID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

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