Table: MR_DAYOFFER_STACK

MR_DAYOFFER_STACK

Name

MR_DAYOFFER_STACK

Comment

MR_DAYOFFER_STACK defines the Stack order for each version of the Acceptance Schedule, including all units submitting MR offers for that event. MR_DAYOFFER_STACK is the child to MR_EVENT_SCHEDULE, and parent to MR_PEROFFER_STACK.


Description

Once the offer cut off time has passed and as the schedule changes AEMO is obliged to accept MR capacity to meet the schedule in merit order according to the offers submitted. The relationship to a specific schedule, the merit order of submitted offers and accepted quantities for each trading interval are stored in the MR_EVENT_SCHEDULE, MR_DAYOFFER_STACK and MR_PEROFFER_STACK.

MR_DAYOFFER_STACK sets includes all generators/MNSPs in the region that submitted an MR offer and a primary key reference to the Offer tables to identify the specific offer used for that unit. MR_DAYOFFER_STACK also includes a Stack Order, irrespective of whether the unit is required to meet the Schedule.

MR_DAYOFFER_STACK updates are confidential on day of submission, with public exposure the next day.

Source

MR_DAYOFFER_STACK updates are ad hoc.

Volume

100 rows per year


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


Primary Key Columns

Name

MR_DATE

REGIONID

STACK_POSITION

VERSION_DATETIME


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

MR_DATE

DATE

X

Mandatory Restriction imposition date

REGIONID

VARCHAR2(10)

X

Unique RegionID

VERSION_DATETIME

DATE

X

Allows many Stack versions

STACK_POSITION

NUMBER(3,0)

X

Loss Adjusted Offer Factor Stack order starting at 1

DUID

VARCHAR2(10)

 

Dispatchable Unit ID or LinkID

AUTHORISED

NUMBER(1,0)

 

Confirms the unit is allowed to Contribute MR Capacity

OFFER_SETTLEMENTDATE

DATE

 

Foreign key reference to XXXX_DayOffer.SettlementDate

OFFER_OFFERDATE

DATE

 

Foreign key reference to XXXX_DayOffer.OfferDate

OFFER_VERSIONNO

NUMBER(3,0)

 

Foreign key reference to XXXX_DayOffer.VersionNo

OFFER_TYPE

VARCHAR2(20)

 

Source tables - ENERGY or MNSP

LAOF

NUMBER(16,6)

 

Loss Adjusted Offer Factor = TLF times MR_Factor

LASTCHANGED

DATE

 

Date and time the record was last inserted/modified