MR_PEROFFER_STACK (Historical table)
MR_PEROFFER_STACK defines the accepted capacity on a period basis for the Acceptance Schedule, is a child table to MR_DayOffer_Stack and only includes records or units with accepted_capacity > 0 for the specific period.
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 Period Stack versions for the one Scaling Factor stack |
| STACK_POSITION |
numeric(3, 0) |
smallint |
LAOF Stack order |
| PERIODID |
numeric(3, 0) |
smallint |
Trade Period for the MR Offer |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit ID or LinkID. Only required here for CSV reports |
| ACCEPTED_CAPACITY |
numeric(6, 0) |
smallint |
MR Capacity to be Dispatched |
| DEDUCTED_CAPACITY |
numeric(6, 0) |
smallint |
Requested capacity reduction amount |
| 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_PEROFFER_STACK_LCX |
nonclustered |
LASTCHANGED |
| MR_PEROFFER_STACK_PK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME, STACK_POSITION, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MR_PEROFFER_STACK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MR_PEROFFER_STACK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME, STACK_POSITION, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_PEROFFER_STACK_LCX |
nonclustered |
LASTCHANGED |
| MR_PEROFFER_STACK_PK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME, STACK_POSITION, PERIODID |