MR_EVENT_SCHEDULE (Historical table)
MR_EVENT_SCHEDULE defines the Stack version of the Acceptance Schedule and is the parent table to MR_DayOffer_Stack and 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) |
Effective Date/Time of Schedule; Allows many Stack versions |
| DEMAND_EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Foreign key reference to ResDemandTrk.EffectiveDate |
| DEMAND_OFFERDATE |
datetime(3) |
datetime2(0) |
Foreign key reference to ResDemandTrk.OfferDate |
| DEMAND_VERSIONNO |
numeric(3, 0) |
smallint |
Foreign key reference to ResDemandTrk.VersionNo |
| AUTHORISEDBY |
varchar(20) |
varchar(20) |
Authorised person confirming Offer Stack (AKA Acceptance) |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date and time the Offer Stack confirmed |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time the record was inserted/modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_EVENT_SCHEDULE_LCX |
nonclustered |
LASTCHANGED |
| MR_EVENT_SCHEDULE_PK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MR_EVENT_SCHEDULE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MR_EVENT_SCHEDULE |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_EVENT_SCHEDULE_LCX |
nonclustered |
LASTCHANGED |
| MR_EVENT_SCHEDULE_PK |
clustered, unique, primary key |
MR_DATE, REGIONID, VERSION_DATETIME |