bid__biddayoffer_d
AEMO Description
BIDDAYOFFER_D shows the public summary of the energy and FCA
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 919,387 |
| Combined Size | 14.62 MiB |
| MMS Table | biddayoffer_d |
| Unified View | nemwebviews.bid__biddayoffer_d |
Schema Evolution
| Column | Type | Description | 94bd0a64 |
|---|---|---|---|
BIDSETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date for which the bid was submitted. | ✓ |
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) |
ON/OFF for loads (Energy Bids Only) | ✓ |
OFFERDATE |
Nullable(DateTime64(3)) |
Offer date and time | ✓ |
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 7 | ✓ |
PRICEBAND8 |
Nullable(Float64) |
Price for Availability Band 8 | ✓ |
PRICEBAND9 |
Nullable(Float64) |
Price for Availability Band 9 | ✓ |
REBIDEXPLANATION |
LowCardinality(String) |
Explanation for all rebids and inflexibilities | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date for which the bid applied | ✓ |
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 |
|---|---|---|
94bd0a64 |
919,387 | 14.62 MiB |
Last updated: 2026-01-02 16:00:04