Table: BIDDAYOFFER

BIDDAYOFFER

Name

BIDDAYOFFER

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


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


Primary Key Columns

Name

BIDTYPE

DUID

OFFERDATE

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

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

VERSIONNO

NUMBER(22,0)

 

Version No. for given offer date

PARTICIPANTID

VARCHAR2(10)

X

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