FORCEMAJEURE (Historical table)
FORCEMAJEURE used to set out the start and end dates / periods of any force majeure event. FORCEMAJEURE is not used.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| FMID |
varchar(10)  |
varchar(10) |
Force Majeure Identifier |
| STARTDATE |
datetime(3) |
datetime2(0) |
Start Date for this event |
| STARTPERIOD |
numeric(3, 0) |
smallint |
Start Trading Interval for event |
| ENDDATE |
datetime(3) |
datetime2(0) |
End Date for this event |
| ENDPERIOD |
numeric(3, 0) |
smallint |
End Trading Interval for this event |
| APCSTARTDATE |
datetime(3) |
datetime2(0) |
APC Start Date |
| STARTAUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising start |
| ENDAUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising end of event |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FORCEMAJEURE_LCX |
nonclustered |
LASTCHANGED |
| FORCEMAJEURE_PK |
clustered, unique, primary key |
FMID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_FORCEMAJEURE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_FORCEMAJEURE |
clustered, unique, primary key |
FMID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FORCEMAJEURE_LCX |
nonclustered |
LASTCHANGED |
| FORCEMAJEURE_PK |
clustered, unique, primary key |
FMID |