Name |
|
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. |
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. |
Name |
BIDTYPE |
DUID |
PERIODID |
PREDISPATCHSEQNO |
Name |
LASTCHANGED |
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 |
|
|
|