BILLINGRUNTRK

BILLINGRUNTRK identifies the Statement type (i. e. Status of PRELIM, FINAL, REVISE) and date of the BillRunNo posted, per WeekNo. This provides a further extension of tracking data from the BILLINGDAYTRK table.

Package

BILLING_RUN

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	Year of the run
WEEKNO	numeric(3, 0)	smallint	Week number of the run
BILLRUNNO	numeric(3, 0)	smallint	Sequential run number
STATUS	varchar(6)	varchar(6)	The billing run type, PRELIM, FINAL, REVISE or INTERIM
ADJ_CLEARED	varchar(1)	varchar(1)	Flag
AUTHORISEDDATE	datetime(3)	datetime2(0)	null, since not used
AUTHORISEDBY	varchar(10)	varchar(10)	null, since not used
POSTDATE	datetime(3)	datetime2(0)	When the results were posted
POSTBY	varchar(10)	varchar(10)	Who posted the results
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
RECEIPTPOSTDATE	datetime(3)	datetime2(0)	null, since not used
RECEIPTPOSTBY	varchar(10)	varchar(10)	null, since not used
PAYMENTPOSTDATE	datetime(3)	datetime2(0)	When the payment was posted
PAYMENTPOSTBY	varchar(10)	varchar(10)	Who posted the payment
SHORTFALL	numeric(16, 6)	numeric(16, 6)	Payment shortfall amount
MAKEUP	numeric(15, 5)	numeric(15, 5)	Not Used

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGRUNTRK_LCX	nonclustered	LASTCHANGED
BILLINGRUNTRK_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGRUNTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLINGRUNTRK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGRUNTRK_LCX	nonclustered	LASTCHANGED
BILLINGRUNTRK_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO