Table: PREDISPATCHOFFERTRK

PREDISPATCHOFFERTRK

Name

PREDISPATCHOFFERTRK

Comment

PREDISPATCHOFFERTRK is for the ancillary service bid tracking of predispatch processing. PREDISPATCHOFFERTRK identifies which bids from BIDDAYOFFER and BIDOFFERPERIOD were applied for a given unit and ancillary service for each predispatch run.


Description

Source

PREDISPATCHOFFERTRK updates every 30 minutes. The data is confidential to each participant until the next trading day.

Volume

Approximately 45,000 records per day.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


Primary Key Columns

Name

BIDTYPE

DUID

PERIODID

PREDISPATCHSEQNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

PREDISPATCHSEQNO

VARCHAR2(20)

X

Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30

DUID

VARCHAR2(10)

X

Dispatchable Unit identifier

BIDTYPE

VARCHAR2(20)

X

Bid type Identifier - the ancillary service to which the bid applies

PERIODID

VARCHAR2(20)

X

PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period.

BIDSETTLEMENTDATE

DATE

 

Settlement date of bid applied

BIDOFFERDATE

TIMESTAMP(3)

 

Time this bid was processed and loaded

DATETIME

DATE

 

Period date and time

LASTCHANGED

DATE

 

Last date and time record changed