bids__biddayoffer__1
AEMO Description
BIDDAYOFFER shows the Energy and Ancillary Service bid data
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 91,278,646 |
| Combined Size | 2.09 GiB |
| MMS Table | biddayoffer |
| Unified View | nemwebviews.bids__biddayoffer__1 |
Schema Evolution
| Column | Type | Description | 188abf03 |
|---|---|---|---|
BIDTYPE |
LowCardinality(String) |
Bid Type Identifier | ✓ |
DAILYENERGYCONSTRAINT |
Nullable(Float64) |
Maximum energy available from Energy Constrained Plant. (Energy Bids Only) | ✓ |
DIRECTION |
LowCardinality(String) |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL | ✓ |
DUID |
LowCardinality(String) |
Dispatchable unit identifier | ✓ |
ENTRYTYPE |
LowCardinality(String) |
Daily if processed before BidCutOff of previous day, otherwise REBID | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
MINIMUMLOAD |
Nullable(Float64) |
Minimum MW load fast start plant | ✓ |
NORMALSTATUS |
Nullable(Float64) |
not used; was ON/OFF for loads (Energy Bids Only) | ✓ |
OFFERDATE |
Nullable(DateTime64(3)) |
Time this bid was processed and loaded | ✓ |
PARTICIPANTID |
LowCardinality(String) |
Unique participant identifier | ✓ |
PRICEBAND1 |
Nullable(Float64) |
Price for Availability Band 1 | ✓ |
PRICEBAND10 |
Nullable(Float64) |
Price for Availability Band 10 | ✓ |
PRICEBAND2 |
Nullable(Float64) |
Price for Availability Band 2 | ✓ |
PRICEBAND3 |
Nullable(Float64) |
Price for Availability Band 3 | ✓ |
PRICEBAND4 |
Nullable(Float64) |
Price for Availability Band 4 | ✓ |
PRICEBAND5 |
Nullable(Float64) |
Price for Availability Band 5 | ✓ |
PRICEBAND6 |
Nullable(Float64) |
Price for Availability Band 6 | ✓ |
PRICEBAND7 |
Nullable(Float64) |
Price for Availability Band 6 | ✓ |
PRICEBAND8 |
Nullable(Float64) |
Price for Availability Band 8 | ✓ |
PRICEBAND9 |
Nullable(Float64) |
Price for Availability Band 9 | ✓ |
REBIDEXPLANATION |
String |
Explanation for all rebids and inflexibilities | ✓ |
REBID_AWARE_TIME |
String |
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_CATEGORY |
LowCardinality(String) |
Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO | ✓ |
REBID_DECISION_TIME |
LowCardinality(String) |
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_EVENT_TIME |
String |
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 | ✓ |
REFERENCE_ID |
String |
A participants unique Reference Id | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date for applying the bid | ✓ |
T1 |
Nullable(Float64) |
Time to synchronise in minutes (Energy Bids Only) | ✓ |
T2 |
Nullable(Float64) |
Time to minimum load in minutes (Energy Bids Only) | ✓ |
T3 |
Nullable(Float64) |
Time at minimum load in minutes (Energy Bids Only) | ✓ |
T4 |
Nullable(Float64) |
Time to shutdown in minutes (Energy Bids Only) | ✓ |
VERSIONNO |
Nullable(Float64) |
Version No. for given offer date | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
188abf03 |
91,278,646 | 2.09 GiB |
Last updated: 2025-12-10 08:00:03