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.