RXW_DISPENSE_BILLING_ITEM
Description:
This table contains information about payments made for outpatient pharmacy prescription fills.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier (.1 item) for the work request record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
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 BILL_ITEM_TYPE_C_NAME VARCHAR No
This item contains the type of billing item this line contains.
May contain organization-specific values: No
Category Entries:
Payment
Adjustment
Non-Payment
Refund
5 AMOUNT NUMERIC No
This item contains the currency value amount for the billing item.
6 BILLING_COMMENT VARCHAR No
This item contains the comments for a pharmacy dispense billing item.
7 CHECK_NUM VARCHAR No
This item contains the check number for a pharmacy dispense payment of type "Check".
8 ADJUSTMENT_ID NUMERIC No
This item contains the procedure (EAP) record associated with the adjustment.
9 COMP_INST_DTTM DATETIME (UTC) No
This item contains the instant when the billing item was completed.
10 NON_PAY_REASON_C INTEGER No
This item contains the non-payment reason for a pharmacy dispense billing item of type of "Non-Payment".
11 PMT_TYPE_C_NAME VARCHAR No
This item contains the payment type for pharmacy dispense billing items of type "payment".
May contain organization-specific values: Yes
Category Entries:
Cash
Check
Credit Card
EOB
Voucher
Bank Account
Trust Account
12 ASSOCIATED_PAT_ID VARCHAR No
The patient associated with a billing item. Currently, this is only used for the Non-Payment payment type. The unpaid amount will only be associated with prescriptions and merchandise charges associated with that patient. This item will not be set if Professional Billing integration is not enabled for the pharmacy.