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.