|
Name |
|
|
Comment |
BIDDAYOFFER shows the Energy and Ancillary Service bid data for each Market Day. BIDDAYOFFER is the parent table to BIDPEROFFER. |
|
The ancillary service arrangements require availability and prices for each Frequency Control Ancillary Service to be bid on a similar basis to energy. Three tables (BIDOFFERFILETRK, BIDDAYOFFER and BIDPEROFFER) facilitate ancillary service bidding and include energy bidding. BIDDAYOFFER data is confidential to the submitting participant until made public after 4am the next day. Source BIDDAYOFFER updates as ancillary service bids are processed. BIDDAYOFFER includes all accepted energy and ancillary service bids. Volume Approximately 1,500,000 records per year |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
Name |
|
BIDTYPE |
|
DUID |
|
OFFERDATE |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Market date for applying the bid |
|
OFFERDATE |
TIMESTAMP(3) |
X |
Offer date of data |
|
VERSIONNO |
NUMBER(22,0) |
|
Version No. for given offer date |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DAILYENERGYCONSTRAINT |
NUMBER(12,6) |
|
Maximum energy available from Energy Constrained Plant. (Energy Bids Only) |
|
REBIDEXPLANATION |
VARCHAR2(500) |
|
Explanation for all rebids and inflexibilities |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
MINIMUMLOAD |
NUMBER(22,0) |
|
Minimum MW load fast start plant |
|
T1 |
NUMBER(22,0) |
|
Time to synchronise in minutes (Energy Bids Only) |
|
T2 |
NUMBER(22,0) |
|
Time to minimum load in minutes (Energy Bids Only) |
|
T3 |
NUMBER(22,0) |
|
Time at minimum load in minutes (Energy Bids Only) |
|
T4 |
NUMBER(22,0) |
|
Time to shutdown in minutes (Energy Bids Only) |
|
NORMALSTATUS |
VARCHAR2(3) |
|
not used; was ON/OFF for loads (Energy Bids Only) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(16,6) |
|
Mandatory Restriction Offer Factor |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Daily if processed before BidCutOff of previous day, otherwise REBID |
|
REBID_EVENT_TIME |
VARCHAR2(20) |
|
The time of the event(s) or other occurrence(s) cited/adduced as the reason for the rebid. Required for rebids, not required for fixed load or low ramp rates.Expected in the format: HH:MM:SS |
|
REBID_AWARE_TIME |
VARCHAR2(20) |
|
Intended to support the AER Rebidding Guidelines.The time at which the participant became aware of the event(s) / occurrence(s) that prompted the rebid.Not validated by AEMO |
|
REBID_DECISION_TIME |
VARCHAR2(20) |
|
Intended to support the AER Rebidding Guidelines.The time at which the participant made the decision to rebid.Not validated by AEMO |
|
REBID_CATEGORY |
VARCHAR2(1) |
|
Optional for Rebid. [P,A,F,E] - (P)lant or physical change, (A)EMO forecast or Dispatch change, (F)inancial or commercial change, (E)rror requiring Rebid remediation |
|
REFERENCE_ID |
VARCHAR2(100) |
|
A participants unique Reference Id |
|
|
|