IRFMEVENTS

IRFMEVENTS sets out specific Industrial Relations Forced Majeure events.

Package

FORCE_MAJEURE

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
IRFMID	varchar(10)	varchar(10)	-
STARTDATE	datetime(3)	datetime2(0)	-
STARTPERIOD	numeric(3, 0)	smallint	-
ENDDATE	datetime(3)	datetime2(0)	-
ENDPERIOD	numeric(3, 0)	smallint	-
LASTCHANGED	datetime(3)	datetime2(0)	-

Official MMS data model indexes

Index name	Index type	Index columns (in order)
IRFMEVENTS_LCX	nonclustered	LASTCHANGED
IRFMEVENTS_PK	clustered, unique, primary key	IRFMID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_IRFMEVENTS_LASTCHANGED	nonclustered	LASTCHANGED
PK_IRFMEVENTS	clustered, unique, primary key	IRFMID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
IRFMEVENTS_LCX	nonclustered	LASTCHANGED
IRFMEVENTS_PK	clustered, unique, primary key	IRFMID