bids__mnsp_dayoffer
AEMO Description
MNSP_DAYOFFER updates as bids are processed. All bids are av
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 269,868 |
| Combined Size | 3.41 MiB |
| MMS Table | mnsp_dayoffer |
| Unified View | nemwebviews.bids__mnsp_dayoffer |
Schema Evolution
| Column | Type | Description | 1e51775e | 8bfc6029 |
|---|---|---|---|---|
ENTRYTYPE |
LowCardinality(String) |
Bid type. Either Rebid or Daily | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ | ✓ |
LINKID |
LowCardinality(String) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. | ✓ | ✓ |
OFFERDATE |
Nullable(DateTime64(3)) |
Time this bid was processed and loaded | ✓ | ✓ |
PARTICIPANTID |
LowCardinality(String) |
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 | ✓ | ✓ |
REBID_AWARE_TIME |
LowCardinality(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_AWARE_TIME |
Nullable(Float64) |
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 |
Nullable(Float64) |
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_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 |
LowCardinality(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 |
LowCardinality(String) |
A participants unique Reference Id | ✓ | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market Date from which bid is active | ✓ | ✓ |
VERSIONNO |
Nullable(Float64) |
Version of data for other key data - a higher version for same key data will take precedence | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | |
source_zip |
String |
✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
1e51775e |
2 | 2.11 KiB |
8bfc6029 |
269,866 | 3.41 MiB |
Last updated: 2026-07-16 05:00:06