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.