Table: PREDISPATCH_MNSPBIDTRK

PREDISPATCH_MNSPBIDTRK

Name

PREDISPATCH_MNSPBIDTRK

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.


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

LINKID

PERIODID

PREDISPATCHSEQNO


Index Columns

Name

LASTCHANGED


Content

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

TIMESTAMP(3)

 

Time this bid was processed and loaded

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