bids__mnsp_dayoffer__1
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 | 1 |
| Combined Rows | 146,688 |
| Combined Size | 2.00 MiB |
| MMS Table | mnsp_dayoffer |
| Unified View | nemwebviews.bids__mnsp_dayoffer__1 |
Schema Evolution
| Column | Type | Description | 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_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 |
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 |
|---|---|---|
8bfc6029 |
146,688 | 2.00 MiB |
Last updated: 2025-12-10 08:00:03