IRFMAMOUNT

IRFMAMOUNT sets out settlement amounts associated with 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)	Unique Industrial Relations Force Majeure event
VERSIONNO	numeric(3, 0)	smallint	Version number of record of event
PERIODID	numeric(4, 0)	smallint	Settlement period
EFFECTIVEDATE	datetime(3)	datetime2(0)	Date of event
AMOUNT	numeric(15, 5)	numeric(15, 5)	Total settlement amount in $
AUTHORISEDBY	varchar(15)	varchar(15)	Person authorising amount
AUTHORISEDDATE	datetime(3)	datetime2(0)	Authorised date
LASTCHANGED	datetime(3)	datetime2(0)	last changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
IRFMAMOUNT_LCX	nonclustered	LASTCHANGED
IRFMAMOUNT_PK	clustered, unique, primary key	IRFMID, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_IRFMAMOUNT_LASTCHANGED	nonclustered	LASTCHANGED
PK_IRFMAMOUNT	clustered, unique, primary key	IRFMID, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
IRFMAMOUNT_LCX	nonclustered	LASTCHANGED
IRFMAMOUNT_PK	clustered, unique, primary key	IRFMID, VERSIONNO, PERIODID