RX_FILL_COVERAGES

Description:

This table contains the coverages used for prescription fills. A given fill can have multiple coverages associated with it. Other clinical information about the fill is in table ORDER_DISP_INFO.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	CONTACT_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6	RX_COVERAGES_ID	NUMERIC	No
	The unique identifier for the list of coverage records used for the prescription fill.
7	PAYOR_PAY_AMOUNT	NUMERIC	No
	This is the amount each payor is responsible for on a prescription.
8	RX_ACCTS_ID	NUMERIC	No
	The unique identifier of the guarantor account to use for any outstanding prescription balances on the order. It is populated in one of two ways. If a personal/family coverage is chosen in order entry, then a guarantor account (in the Pickup Pharmacy's service area) attached to that coverage will be used. Or, if an account of a type other than personal/family is selected (for example, workers' comp), then that guarantor account will be used.
9	PLAN_PRICE_FOR_CVG	NUMERIC	No
	When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This column is the coverage-specific plan price for the fill. This will be sent in to the payor during adjudication or used when billing charity or discount coverages.
10	PAYER_TAX_DUE	NUMERIC	No
	This is the rounded tax amount each payer is responsible for on a prescription. This is used for UAE billing.