|
Name |
|
|
Comment |
PREDISPATCHBIDTRK contains an audit trail of bids used in each predispatch run. Where predispatch is over 2 days, two bids are listed. |
|
Status PREDISPATCHOFFERTRK and related views are obsolete. Please see tables and views related to BIDPEROFFER. Source Own (confidential) data shows via inserts with every thirty-minute predispatch. Daily update after close of day shows all market bids for the closed day. Period date and time |
|
Name |
|
DUID |
|
PERIODID |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
|
DUID |
|
SETTLEMENTDATE |
|
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 |
|
PERIODID |
VARCHAR2(20) |
X |
PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period. |
|
BIDTYPE |
VARCHAR2(10) |
|
Bid type (daily, default or rebid) |
|
OFFERDATE |
DATE |
|
Offer date for bid |
|
VERSIONNO |
NUMBER(3,0) |
|
Version no of offer for the offer date |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
SETTLEMENTDATE |
DATE |
|
Market Settlement Date |
|
DATETIME |
DATE |
|
Period date and time |
|
|
|