Name |
|
Comment |
BIDDAYOFFER shows the Energy and Ancillary Service bid data for each Market Day. BIDDAYOFFER is the parent table to BIDOFFERPERIOD. BIDDAYOFFER is a child table to BIDOFFERFILETRK |
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 BIDOFFERPERIOD) 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 |
BIDTYPE |
DIRECTION |
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 |
Time this bid was processed and loaded |
DIRECTION |
VARCHAR2(20) |
X |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL |
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 e.g. 20:11:00 |
REBID_AWARE_TIME |
VARCHAR2(20) |
|
Intended to support the Rebidding and Technical Parameters Guideline. 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 Rebidding and Technical Parameters Guideline. The time at which the participant made the decision to rebid. Not validated by AEMO |
REBID_CATEGORY |
VARCHAR2(1) |
|
Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO |
REFERENCE_ID |
VARCHAR2(100) |
|
A participants unique Reference Id |
|
|
|