BILLINGAPCRECOVERY

BILLINGAPCRECOVERY shows the Administered Price Cap (APC) Recovery for the billing period. Data is for each participant by region.

Package

BILLING_RUN

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTYEAR	numeric(4, 0)	smallint	Contract year
WEEKNO	numeric(3, 0)	smallint	Billing week
BILLRUNNO	numeric(3, 0)	smallint	Billing run number
PARTICIPANTID	varchar(10)	varchar(10)	Participant identifier
REGIONID	varchar(10)	varchar(10)	Region Identifier
APCRECOVERY	numeric(15, 0)	int	APC Recovery amount for week
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGAPCRECOVERY_LCX	nonclustered	LASTCHANGED
BILLINGAPCRECOVERY_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BILLINGAPCRECOVERY_LASTCHANGED	nonclustered	LASTCHANGED
PK_BILLINGAPCRECOVERY	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BILLINGAPCRECOVERY_LCX	nonclustered	LASTCHANGED
BILLINGAPCRECOVERY_PK	clustered, unique, primary key	CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID