MR_EVENT (Historical table)
MR_EVENT defines an MR Event for a given region on a specific trading date.
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 |
| DESCRIPTION |
varchar(200) |
varchar(200) |
Description of MR |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Required for MR_Event to take effect |
| AUTHORISEDBY |
varchar(20) |
varchar(20) |
Ignored - Tracking purpose only |
| OFFER_CUT_OFF_TIME |
datetime(3) |
datetime2(0) |
Cut off after when new Offers and Scaling Factor changes are disallowed |
| SETTLEMENT_COMPLETE |
numeric(1, 0) |
tinyint |
Flag:1 = MR settlement figures locked. Do not recalculate, 0 = MR settlements to be recalculated |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date/Time record inserted/modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_EVENT_LCX |
nonclustered |
LASTCHANGED |
| MR_EVENT_PK |
clustered, unique, primary key |
MR_DATE, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MR_EVENT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MR_EVENT |
clustered, unique, primary key |
MR_DATE, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MR_EVENT_LCX |
nonclustered |
LASTCHANGED |
| MR_EVENT_PK |
clustered, unique, primary key |
MR_DATE, REGIONID |