|
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 |
|
|
|