MR_DAYOFFER_STACK (Historical table)
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.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| MR_DATE |
datetime(3)  |
datetime2(0) |
Mandatory Restriction imposition date |
| REGIONID |
varchar(10) |
varchar(10) |
Unique RegionID |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
Allows many Stack versions |
| STACK_POSITION |
numeric(3, 0) |
smallint |
Loss Adjusted Offer Factor Stack order starting at 1 |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit ID or LinkID |
| AUTHORISED |
numeric(1, 0) |
tinyint |
Confirms the unit is allowed to Contribute MR Capacity |
| OFFER_SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Foreign key reference to XXXX_DayOffer.SettlementDate |
| OFFER_OFFERDATE |
datetime(3) |
datetime2(0) |
Foreign key reference to XXXX_DayOffer.OfferDate |
| OFFER_VERSIONNO |
numeric(3, 0) |
smallint |
Foreign key reference to XXXX_DayOffer.VersionNo |
| OFFER_TYPE |
varchar(20) |
varchar(20) |
Source tables - ENERGY or MNSP |
| LAOF |
numeric(16, 6) |
numeric(16, 6) |
Loss Adjusted Offer Factor = TLF times MR_Factor |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time the record was last inserted/modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_DAYOFFER_STACK_LCX |
nonclustered |
LASTCHANGED |
| MR_DAYOFFER_STACK_PK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME, STACK_POSITION |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MR_DAYOFFER_STACK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MR_DAYOFFER_STACK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME, STACK_POSITION |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_DAYOFFER_STACK_LCX |
nonclustered |
LASTCHANGED |
| MR_DAYOFFER_STACK_PK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME, STACK_POSITION |