APCCOMPAMOUNT (Historical table)

APCCOMPAMOUNT shows the Administered Price Cap (APC) compensation amount.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
APCID	varchar(10)	varchar(10)	APC Identifier
PARTICIPANTID	varchar(10)	varchar(10)	Participant identifier
VERSIONNO	numeric(3, 0)	smallint	Version number
PERIODID	numeric(6, 0)	smallint	Offset from start date and period in APCCOMP table.
AMOUNT	numeric(15, 5)	numeric(15, 5)	Compensation audit.
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
APCCOMPAMOUNT_LCX	nonclustered	LASTCHANGED
APCCOMPAMOUNT_PK	clustered, unique, primary key	APCID, PARTICIPANTID, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_APCCOMPAMOUNT_LASTCHANGED	nonclustered	LASTCHANGED
PK_APCCOMPAMOUNT	clustered, unique, primary key	APCID, PARTICIPANTID, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
APCCOMPAMOUNT_LCX	nonclustered	LASTCHANGED
APCCOMPAMOUNT_PK	clustered, unique, primary key	APCID, PARTICIPANTID, VERSIONNO, PERIODID