MNSP_DAYOFFER
MNSP_DAYOFFER updates as bids are processed. All bids are available as part of next day market data. MNSP_DAYOFFER is the parent table to MNSP_BIDOFFERPERIOD, and joins to BIDOFFERFILETRK for 5MS Bids.
Package
BIDS
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market Date from which bid is active |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Time this bid was processed and loaded |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version of data for other key data - a higher version for same key data will take precedence |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant Identifier |
| LINKID |
varchar(10) |
varchar(10) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
| ENTRYTYPE |
varchar(20) |
varchar(20) |
Bid type. Either Rebid or Daily |
| REBIDEXPLANATION |
varchar(500) |
varchar(500) |
Explanation for all rebids and inflexibilities |
| PRICEBAND1 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 1 |
| PRICEBAND2 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 2 |
| PRICEBAND3 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 3 |
| PRICEBAND4 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 4 |
| PRICEBAND5 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 5 |
| PRICEBAND6 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 6 |
| PRICEBAND7 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 7 |
| PRICEBAND8 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 8 |
| PRICEBAND9 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 9 |
| PRICEBAND10 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 10 |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| MR_FACTOR |
numeric(16, 6) |
numeric(16, 6) |
Mandatory Restriction Offer Factor |
| REBID_EVENT_TIME |
varchar(20) |
varchar(20) |
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 |
| REBID_AWARE_TIME |
varchar(20) |
varchar(20) |
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_DECISION_TIME |
varchar(20) |
varchar(20) |
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_CATEGORY |
varchar(1) |
varchar(1) |
Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO |
| REFERENCE_ID |
varchar(100) |
varchar(100) |
A participants unique Reference Id |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MNSP_DAYOFFER_LCX |
nonclustered |
LASTCHANGED |
| MNSP_DAYOFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, LINKID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MNSP_DAYOFFER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MNSP_DAYOFFER |
clustered, unique, primary key |
SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, LINKID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MNSP_DAYOFFER_LCX |
nonclustered |
LASTCHANGED |
| MNSP_DAYOFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, LINKID |