Table: BILLINGAPCRECOVERY

BILLINGAPCRECOVERY

Name

BILLINGAPCRECOVERY

Comment

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


Description

Source

Obsolete; was updated weekly with each billing run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Contract year

WEEKNO

NUMBER(3,0)

X

Billing week

BILLRUNNO

NUMBER(3,0)

X

Billing run number

PARTICIPANTID

VARCHAR2(10)

X

Participant identifier

REGIONID

VARCHAR2(10)

X

Region Identifier

APCRECOVERY

NUMBER(15,0)

 

APC Recovery amount for week

LASTCHANGED

DATE

 

Last date and time record changed