Table: MNSP_DAYOFFER

MNSP_DAYOFFER

Name

MNSP_DAYOFFER

Comment

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.


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


Primary Key Columns

Name

LINKID

OFFERDATE

PARTICIPANTID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market Date from which bid is active

OFFERDATE

TIMESTAMP(3)

X

Time this bid was processed and loaded

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 e.g. 20:11:00

REBID_AWARE_TIME

VARCHAR2(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

VARCHAR2(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

VARCHAR2(1)

 

Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO

REFERENCE_ID

VARCHAR2(100)

 

A participants unique Reference Id