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)
Same-Instance Consolidated Balances
Estimate Variance Write-Off
Multi-Instance Consolidated Balances
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.