ARPB_TX_STMCLAIMHX
Description:
This table contains information about the statement and claim history for professional billing transactions.

Primary Key
Column Name Ordinal Position
TX_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TX_ID NUMERIC No
The unique ID of the transaction record
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 BC_HX_TYPE_C_NAME VARCHAR No
This item stores whether the current line is a bill or claim entry. A category value of 1 means claim and 2 means bill.
May contain organization-specific values: No
Category Entries:
Claim
Bill
4 BC_HX_DATE DATETIME No
The date the statement or claim was processed. This can be NULL when an insurance payment posts and it can’t find a matching claim with that payer in the history.
5 BC_HX_COVERAGE_ID NUMERIC No
The unique ID of the coverage that is associated with the bill or claim run
6 BC_HX_ASSIGNED_YN VARCHAR No
Indicates whether or not the coverage is assigned to insurance for this transaction. Y indicates the coverage is assigned.
May contain organization-specific values: No
Category Entries:
Yes
No
7 BC_HX_AMOUNT NUMERIC No
The amount of the transaction on the bill or claim.
8 BC_HX_INVOICE_NUM VARCHAR No
The invoice number for the bill or claim.
9 BC_HX_PAYMENT_AMT NUMERIC No
Payment amount for payment associated with this invoice. This field applies to claims only.
10 BC_HX_PAYMENT_DATE DATETIME No
Payment date for payment associated with this invoice. This field applies to claims only.
11 BC_HX_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
12 BC_HX_RESUBMIT_DATE DATETIME No
Resubmit date for this claim. This field applies to claims only.
13 BC_HX_CLM_DB_ID NUMERIC No
The unique ID of the claim information record for this claim. This field applies to claims only.
14 BC_HX_HELD_AMOUNT VARCHAR No
Amount held (not shown) on a bill. This item applies to bills only.
15 BC_HX_BO_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
16 BC_HX_AUX_PROC VARCHAR No
Claim Auxiliary Procedure. This item is only used by claims. This is populated when claim bundling grouping rules are used and there are procedures that are left over from the claim. This item is a semicolon delimited list of extra procedures. For example, if the bundling rule is set up to bundle and 99212 and a 99213 and there are two 99212s and one 99213, then the 99212 procedure identifier would appear in this column.
17 BC_HX_ACCEPT_DATE DATETIME No
Accept date for bill or claim
18 BC_HX_FIRST_CLM_FLG VARCHAR No
This item is set to 0 for accepted claims where all previous lines in the statement-claim history are claims. This item is set to 1 for accepted claims where there is at least one previous line in the statement-claim history that was a statement. This item is only populated for claims.
19 BC_HX_AR_CLASS_C_NAME VARCHAR No
AR classification at the time of claim/statement run acceptance.
May contain organization-specific values: No
Category Entries:
Active
External
Bad Debt
External W/O
Bad Debt W/O
20 BC_HX_ACCEPT_DTTM DATETIME (UTC) No
The UTC date and time the statement or claim was accepted.