BILLINGIRFM

BILLINGIRFM shows billing amounts associated with Industrial Relations Forced Majeure events for each participant.

Package

BILLING_RUN

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	Settlement Year
WEEKNO	numeric(3, 0)	smallint	Week number starting 1 Jan each year.
BILLRUNNO	numeric(3, 0)	smallint	Unique bill run
PARTICIPANTID	varchar(10)	varchar(10)	Participant Identifier
IRFMPAYMENT	numeric(15, 5)	numeric(15, 5)	Industrial Relations Forced Majeure payment for the billing period.
LASTCHANGED	datetime(3)	datetime2(0)	Last changed.

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGIRFM_LCX	nonclustered	LASTCHANGED
BILLINGIRFM_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGIRFM_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLINGIRFM	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGIRFM_LCX	nonclustered	LASTCHANGED
BILLINGIRFM_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID