ARPB_TRANSACTIONS

Description: |
This table contains information about professional billing transactions.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
A transaction's unique internal identification number. A patient's record can include charges, payments, or adjustments and the patient's account balance will reflect these transactions.
2 | POST_DATE | DATETIME | No |
The date when a transaction is entered into the billing system. This differs from the service date, which is the date when the service was performed.
3 | SERVICE_DATE | DATETIME | No |
The date a medical service is performed.
4 | TX_TYPE_C_NAME | VARCHAR | No |
The type of this transaction: Charge, payment or adjustment.
May contain organization-specific values: No
Category Entries:
Charge
Payment
Adjustment
AP Claim Tx
AP Claim Refund Tx
AP Claim DRG Tx
Pharmacy Claim Tx
5 | ACCOUNT_ID | NUMERIC | No |
The internal ID of the record that maintains the patient's transactions. A patient may use more than one account and an account may contain more than one patient.
6 | DEBIT_CREDIT_FLAG_NAME | VARCHAR | No |
This column contains a 1 if the transaction is a debit and a -1 if the transaction is a credit. A charge is always a debit, a payment is always a credit, and an adjustment can be either a debit or a credit.
May contain organization-specific values: No
Category Entries:
Debit
Credit
7 | SERV_PROVIDER_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
8 | BILLING_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
9 | DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
10 | POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
11 | LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
12 | SERVICE_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
13 | MODIFIER_ONE | VARCHAR | No |
The first procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim.
14 | MODIFIER_TWO | VARCHAR | No |
The second procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim.
15 | MODIFIER_THREE | VARCHAR | No |
The third procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim.
16 | MODIFIER_FOUR | VARCHAR | No |
The fourth procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim.
17 | PRIMARY_DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
18 | DX_TWO_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
19 | DX_THREE_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
20 | DX_FOUR_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
21 | DX_FIVE_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
22 | DX_SIX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
23 | PROCEDURE_QUANTITY | NUMERIC | No |
The quantity as entered in Charge Entry for the procedure of this transaction (TX_ID). If the row has a DETAIL_TYPE value of 10-13, this column displays a negative value. If the row has a DETAIL_TYPE value of 20-33, 43-45, 50, or 51, this column displays a zero.
24 | AMOUNT | NUMERIC | No |
The original amount of this transaction.
25 | OUTSTANDING_AMT | NUMERIC | No |
The outstanding amount of the transaction.
26 | INSURANCE_AMT | NUMERIC | No |
The insurance portion of the transaction.
27 | PATIENT_AMT | NUMERIC | No |
The patient or self-pay portion of the transaction.
28 | VOID_DATE | DATETIME | No |
If this transaction is voided, this column will have the date in which this transaction is voided.
29 | LAST_ACTION_DATE | DATETIME | No |
This column contains the most recent date when an action is performed on this transaction.
30 | PROV_SPECIALTY_C_NAME | VARCHAR | No |
This column contains the provider specialty of the provider associated with the transaction. The procedure category of the charge on the transaction may affect what specialty is recorded here and in the "Encounter Specialty" displayed in Hyperspace.
May contain organization-specific values: Yes
31 | PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
32 | TOTAL_MATCH_AMT | NUMERIC | No |
This column contains the total amount matched to the transaction, including adjustments.
33 | TOTAL_MTCH_INS_AMT | NUMERIC | No |
This column contains the total insurance amount matched to the transaction, including adjustments.
34 | TOTAL_MTCH_ADJ | NUMERIC | No |
This column contains the total adjustment amount matched to the transaction.
35 | TOTAL_MTCH_INS_ADJ | NUMERIC | No |
This column contains the total insurance adjustment amount matched to the transaction.
36 | REPOST_ETR_ID | NUMERIC | No |
This is the repost source transaction.
37 | REPOST_TYPE_C_NAME | VARCHAR | No |
The repost type category ID for the transaction.
May contain organization-specific values: No
Category Entries:
Repost
Correction
38 | DISCOUNT_TYPE_C_NAME | VARCHAR | No |
The discount type category ID for the transaction.
May contain organization-specific values: Yes
Category Entries:
None
Percentage
Fee Schedule
Extension
39 | PAT_ENC_CSN_ID | NUMERIC | No |
The Contact Serial Number for the patient encounter with which this transaction is associated. This number is unique across all patients and encounters in your system.
40 | ENC_FORM_NUM | VARCHAR | No |
The encounter form number corresponding to the charge transaction. If you are not using encounter forms, a negative number is stored in this item.
41 | BEN_SELF_PAY_AMT | NUMERIC | No |
Stores the adjudicated self-pay amount calculated by the benefits engine
42 | BEN_ADJ_COPAY_AMT | NUMERIC | No |
Stores the copay part of the adjudicated self-pay amount calculated by the benefits engine
43 | BEN_ADJ_COINS_AMT | NUMERIC | No |
Stores the coinsurance part of the adjudicated self-pay amount calculated by the benefits engine
44 | VISIT_NUMBER | VARCHAR | No |
This item stores the visit number for this transaction.
45 | REFERRAL_ID | NUMERIC | No |
This item stores the Referral (RFL) ID for this transaction.
46 | ORIGINAL_EPM_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
47 | ORIGINAL_FC_C_NAME | VARCHAR | No |
This item stores the original financial class for this transaction.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay
Patient Assistance Program
48 | ORIGINAL_CVG_ID | NUMERIC | No |
This item stores the original coverage (CVG) ID for this transaction.
49 | PAYOR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
50 | COVERAGE_ID | NUMERIC | No |
This item stores the current coverage (CVG) ID for this transaction.
51 | ASGN_YN | VARCHAR | No |
This item stores the assignment flag for a coverage. This item is set to Yes if the charge is currently assigned to the payor in the PAYOR_ID column.
May contain organization-specific values: No
Category Entries:
Yes
No
52 | FACILITY_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
53 | PAYMENT_SOURCE_C_NAME | VARCHAR | No |
This item stores the payment source for credit transactions. This is a list of possible sources including Cash, Check, Credit Card, etc.
May contain organization-specific values: Yes
Category Entries:
Cash
Check
Credit Card
EOB
Voucher
Bank Account
Trust Account
54 | USER_ID | VARCHAR | No |
This item stores the user who posted the transaction.
55 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
56 | NOT_BILL_INS_YN | VARCHAR | No |
Indicates whether the transaction is marked for do not bill insurance.
May contain organization-specific values: No
Category Entries:
No
Yes
57 | CHG_ROUTER_SRC_ID | VARCHAR | No |
This item stores the universal charge line (UCL) ID for this transaction.
58 | RECEIVE_DATE | DATETIME | No |
This item stores the charge entry batch receive date.
59 | CE_CODED_DATE | DATETIME | No |
The date this charge session was coded, from charge entry.
60 | PANEL_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
61 | BILL_AREA_ID | NUMERIC | No |
Networked to BIL: the Bill Area for this transaction.
62 | BILL_AREA_ID_BILL_AREA_NAME | VARCHAR | No |
The record name of this bill area, financial subdivision, or financial division.
63 | CREDIT_SRC_MODULE_C_NAME | VARCHAR | No |
The module that creates a payment or credit adjustment
May contain organization-specific values: No
Category Entries:
Account Maintenance
Payment Posting
Adjustment Posting
Collection (text)
Collection Workqueue
Charge Entry
Retroadjudication
Small Balance Write-off in Bills
Transfer
Transaction Import
Claim Processing
MyChart Web
Electronic Remittance
Claim Bundling Utility
Real Time Charge Interface
Secondary Write-off
Dental Treatment Plan
Transaction Maintenance Utilities
Follow-up workqueue User
Check-in/Check-out
Charge Homing
Release of Information
Enterprise Payment Posting
Reimbursement Recalculation Utility
Charge Correction
Charge Repost
Claim Edit Workqueue
Patient Refund
HB Integrity Checks
Welcome
PB Extract Framework
SBO Collection Actions
Nightly Processing
Web Service
Auto Pay Payment Plan
Pharmacy
Payment Collection
Financial Assistance
Credit Workqueue System
Credit Workqueue User
Follow-up Workqueue System
Self-Pay Discount
Adjustment Review Workqueue
Charge Router Void
Charge Router Repost
Rescheduling Repost
Prepay Discount Adjustment
Bundled Payment Distribution
Account Workqueue
Claim run Accept
Change Guarantor
MyChart Mobile
Guest Pay
Visit Auto Pay
Dental Upgrade Adjustment
Promotion Discount
Discretionary Discount
Non-Primary Not Allowed Adjustment
Estimate
Adjustment Review WQ Decline
Two-Way SMS
Shadow Charging
Reeval Reimbursement (User)
Override Reimbursement (User)
Override Reimbursement (System)
Same-Instance Consolidated Balances
Estimate Variance Write-Off
Multi-Instance Consolidated Balances
Virtual Assistant
Discount Offer
Post-payment Recovery
64 | UPDATE_DATE | DATETIME (Local) | No |
The date that this row was last updated.
65 | CLAIM_DATE | DATETIME | No |
The most recent date that this transaction has been on an accepted claim run.
66 | IPP_INV_NUMBER | VARCHAR | No |
This item stores the original invoice number that user posts to in GUI payment posting or remittance.
67 | IPP_INV_ID | NUMERIC | No |
This item stores the original invoice ID that user posts to in graphical user interface (GUI) payment posting or remittance.