bid__bidperoffer_d__3
AEMO Description
BIDPEROFFER_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 | 176,317,442 |
| Combined Size | 787.88 MiB |
| MMS Table | bidperoffer_d |
| Unified View | nemwebviews.bid__bidperoffer_d__3 |
Schema Evolution
| Column | Type | Description | 1314781e |
|---|---|---|---|
BANDAVAIL1 |
Nullable(Float64) |
Availability at price band 1 | ✓ |
BANDAVAIL10 |
Nullable(Float64) |
Availability at price band 10 | ✓ |
BANDAVAIL2 |
Nullable(Float64) |
Availability at price band 2 | ✓ |
BANDAVAIL3 |
Nullable(Float64) |
Availability at price band 3 | ✓ |
BANDAVAIL4 |
Nullable(Float64) |
Availability at price band 4 | ✓ |
BANDAVAIL5 |
Nullable(Float64) |
Availability at price band 5 | ✓ |
BANDAVAIL6 |
Nullable(Float64) |
Availability at price band 6 | ✓ |
BANDAVAIL7 |
Nullable(Float64) |
Availability at price band 7 | ✓ |
BANDAVAIL8 |
Nullable(Float64) |
Availability at price band 8 | ✓ |
BANDAVAIL9 |
Nullable(Float64) |
Availability at price band 9 | ✓ |
BIDSETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date for which the bid was submitted | ✓ |
BIDTYPE |
LowCardinality(String) |
Bid Type Identifier | ✓ |
DIRECTION |
LowCardinality(String) |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL | ✓ |
DUID |
LowCardinality(String) |
Dispatchable Unit identifier | ✓ |
ENABLEMENTMAX |
Nullable(Float64) |
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) | ✓ |
ENABLEMENTMIN |
Nullable(Float64) |
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) | ✓ |
ENERGYLIMIT |
Nullable(Float64) |
The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit | ✓ |
FIXEDLOAD |
Nullable(Float64) |
Fixed unit output MW (Energy Bids Only). A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) | ✓ |
HIGHBREAKPOINT |
Nullable(Float64) |
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
Date and Time of the dispatch interval to which the offer applied | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
LOWBREAKPOINT |
Nullable(Float64) |
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) | ✓ |
MAXAVAIL |
Nullable(Float64) |
Maximum availability for this BidType in this period | ✓ |
OFFERDATE |
Nullable(DateTime64(3)) |
Offer date and time | ✓ |
PASAAVAILABILITY |
Nullable(Float64) |
Allows for future use for energy bids, being the physical plant capability including any capability potentially available within 24 hours | ✓ |
PERIODID |
Nullable(Float64) |
The trading interval period identifier (1-288) | ✓ |
ROCDOWN |
Nullable(Float64) |
MW/Min for lower (Energy Bids Only) | ✓ |
ROCUP |
Nullable(Float64) |
MW/min for raise (Energy Bids Only) | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date for which the bid applied | ✓ |
VERSIONNO |
Nullable(Float64) |
Version number of offer | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
1314781e |
176,317,442 | 787.88 MiB |
Last updated: 2025-12-10 08:00:03