Table: DISPATCHBIDTRK

DISPATCHBIDTRK

Name

DISPATCHBIDTRK

Comment

DISPATCHBIDTRK shows the bid tracking, including the bid version used in each dispatch run for each unit. DISPATCHBIDTRK is the audit trail of the bid actually used in each dispatch.


Primary Key Columns

Name

DUID

OFFEREFFECTIVEDATE

OFFERVERSIONNO

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Index Columns

Name

DUID

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market date starting at 04:05

RUNNO

NUMBER(3,0)

X

Dispatch run no from 1 to 288 (as per bid)

OFFEREFFECTIVEDATE

DATE

X

Effective date of offer used

OFFERVERSIONNO

NUMBER(3,0)

X

Version no of offer used

DUID

VARCHAR2(10)

X

Dispatchable unit identifier

BIDTYPE

VARCHAR2(10)

 

Bid type (daily, default or rebid)

LASTCHANGED

DATE

 

Last date and time record changed