ARPB_TX_ACTIONS
Description:
This table contains information about actions performed on 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 key or identification number for a given transaction.
2 LINE INTEGER No
This column contains the line count for the information in this table. Each action associated with this transaction is stored on a separate line, one line for each entry.
3 ACTION_TYPE_C_NAME VARCHAR No
The action type category ID taken on the transaction.
May contain organization-specific values: No
Category Entries:
Not Allowed Adjustment
Transfer to Self-Pay
Next Responsible Party
Resubmit Insurance
Write Off Self-Pay
Write Off Insurance
Transfer to Insurance
Gramm Rudman Adjustment
Denied
Turn Off Automatic Self-Pay Write-Off
Turn On Automatic Self-Pay Write-Off
Close Claim
Debit Adjustment
Research
Do Not Bill Insurance
Bill Insurance
Suspended NRP
Recalculate Discount
Service Level Authorization Edit
Post Dental Upgrade Adjustment
Create Shadow Charges
4 ACTION_DATE DATETIME No
The date in which this action is performed.
5 ACTION_AMOUNT NUMERIC No
The amount associated with this action.
6 PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
7 DENIAL_CODE VARCHAR No
The denial code associated with this action.
8 DENIAL_CODE_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
9 POST_DATE DATETIME No
The date this transaction was posted in calendar format.
10 STMT_DATE DATETIME No
The statement date of this transaction.
11 OUT_AMOUNT_BEFORE NUMERIC No
Outstanding amount of associated transaction before the action is performed.
12 OUT_AMOUNT_AFTER NUMERIC No
Outstanding amount of the associated transaction after the action is performed.
13 INS_AMOUNT_BEFORE NUMERIC No
Insurance amount of the associated transaction before the action is performed.
14 INS_AMOUNT_AFTER NUMERIC No
Insurance amount of the associated transaction after the action is performed.
15 BEFORE_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
16 AFTER_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
17 BEFORE_CVG_ID NUMERIC No
The coverage of the associated transaction before the action is performed.
18 AFTER_CVG_ID NUMERIC No
The coverage of the associated transaction after the action is performed.
19 ACTION_USER_ID VARCHAR No
The unique ID of the user who performed this action.
20 ACTION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
21 ADJ_CODE_ID_PROC_NAME VARCHAR No
The name of each procedure.
22 RMC_ID VARCHAR No
The first reason code ID associated with this action.
23 RMC_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
24 RMC_TWO_ID VARCHAR No
The second reason code ID associated with this action.
25 RMC_TWO_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
26 RMC_THREE_ID VARCHAR No
The third reason code ID associated with this action.
27 RMC_THREE_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
28 RMC_FOUR_ID VARCHAR No
The fourth reason code ID associated with this action.
29 RMC_FOUR_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
30 PMT_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
31 POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
32 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
33 PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
34 LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
35 SERVICE_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
36 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.
37 PRIMARY_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
38 MODIFIER_ONE VARCHAR No
The first procedure modifier of the associated transaction. This is the external modifier, as it would be printed on the claim.
39 MODIFIER_TWO VARCHAR No
The second procedure modifier of the associated transaction. This is the external modifier, as it would be printed on the claim.
40 MODIFIER_THREE VARCHAR No
The third modifier of the associated transaction. This is the external modifier, as it would be printed on the claim.
41 MODIFIER_FOUR VARCHAR No
The fourth modifier of the associated transaction. This is the external modifier, as it would be printed on the claim.
42 ASSIGNMENT_BEF_YN VARCHAR No
This item is a Yes/No flag to determine if the transaction was assigned to insurance before the action on this line for this transaction.
May contain organization-specific values: No
Category Entries:
Yes
No
43 ASSIGNMENT_AFTER_YN VARCHAR No
This item is a Yes/No flag to determine if the transaction was assigned to insurance after the action on this line for this transaction.
The category values for this column were already listed for column: ASSIGNMENT_BEF_YN
44 ACTION_REMIT_CODES VARCHAR No
This field stores a comma delimited list of external remittance codes for this transaction.
45 ACTION_COMMENT VARCHAR No
This is the system generated comment for this transaction.
46 ACTION_DATETIME DATETIME (UTC) No
The UTC date and time the action was performed.