Table: DISPATCHOFFERTRK

DISPATCHOFFERTRK

Name

DISPATCHOFFERTRK

Comment

DISPATCHOFFERTRK is the energy and ancillary service bid tracking table for the Dispatch process. The table identifies which bids from BIDDAYOFFER and BIDOFFERPERIOD were applied for a given unit and bid type for each dispatch interval.


Description

DISPATCHOFFERTRK data is confidential to each participant until the next trading day, when the data is public to all participants.

Source

DISPATCHOFFERTRK updates every 5 minutes.

Volume

Approximately 250,000 records per day.


Primary Key Columns

Name

BIDTYPE

DUID

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Index Columns

Name

DUID

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35)

DUID

VARCHAR2(10)

X

Dispatchable unit identifier

BIDTYPE

VARCHAR2(10)

X

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

BIDSETTLEMENTDATE

DATE

 

Settlement date of bid applied

BIDOFFERDATE

TIMESTAMP(3)

 

Time this bid was processed and loaded

LASTCHANGED

DATE

 

Last date and time record changed