|
Name |
|
|
Comment |
MNSP_DAYOFFER shows price and other non-period data pertaining to a specific MNSP bid and Link ID to be effective from the given Settlement Date. |
|
MNSP_DAYOFFER shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data. Volume 4, 000 per year |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
Name |
|
LINKID |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market Date from which bid is active |
|
OFFERDATE |
TIMESTAMP(3) |
X |
Offer date for bid |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data will take precedence |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
LINKID |
VARCHAR2(10) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Bid type. Either Rebid or Daily |
|
REBIDEXPLANATION |
VARCHAR2(500) |
|
Explanation for all rebids and inflexibilities |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 7 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(16,6) |
|
Mandatory Restriction Offer Factor |
|
REBID_EVENT_TIME |
VARCHAR2(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 |
|
REBID_AWARE_TIME |
VARCHAR2(20) |
|
Intended to support the AER Rebidding Guidelines. 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 |
VARCHAR2(20) |
|
Intended to support the AER Rebidding Guidelines. The time at which the participant made the decision to rebid. Not validated by AEMO |
|
REBID_CATEGORY |
VARCHAR2(1) |
|
Intended to support the AER Rebidding Guidelines. A provided rebid category. Not validated by AEMO |
|
REFERENCE_ID |
VARCHAR2(100) |
|
A participants unique Reference Id |
|
|
|