|
Name |
|
|
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. |
|
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 |
|
Name |
|
MR_DATE |
|
REGIONID |
|
STACK_POSITION |
|
VERSION_DATETIME |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|