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_PROC_NAME | VARCHAR | No |
The name of each procedure.
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.