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. DISPATCH_MNSPBIDTRK is the audit trail of the bids actually used for each dispatch run.


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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


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

DATE

 

Date the bid/offer becomes effective

OFFERVERSIONNO

NUMBER(3,0)

 

VersionNo of the bid/offer used

LASTCHANGED

DATE

 

Record creation timestamp