ARPB_TX_COL_EXT_HX

Description: |
Contains the collections agency extract history.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | EXT_HX_AGENCY_ID | NUMERIC | No |
The unique ID of the collection agency record.
4 | EXT_HX_AGENCY_ID_COLL_AGENCY_NAME | VARCHAR | No |
The name of the collection agency.
5 | EXT_HX_ACTIVITY_C_NAME | VARCHAR | No |
Collection agency extract insurance amount
May contain organization-specific values: No
Category Entries:
Requested Send to Agency
Sent to Agency
Requested Recall From Agency
Recalled from Agency
Returned
Updated
Payment Collected
No Balance, Agency Cleared
User Requested Send to Agency
Users Requested Recall from Agency
Manual Request Ignored
Converted from Account Workqueue Framework
Request Resulting from Repost
6 | EXT_HX_ACT_DATE | DATETIME | No |
Collection agency extract activity date
7 | EXT_HX_PAT_AMT | NUMERIC | No |
Collection agency extract patient amount.
8 | EXT_HX_INS_AMT | NUMERIC | No |
Collection agency extract insurance amount.
9 | EXT_HX_USER_ID | VARCHAR | No |
The collection agency extract user ID for the transaction record.
10 | EXT_HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | EXT_HX_COMMENT | VARCHAR | No |
Collection agency extract comment.
12 | EXT_HX_PMT_AMT | NUMERIC | No |
Stores the amount of a payment collected by the collection agency extract framework
13 | EXT_HX_RET_REASON_C_NAME | VARCHAR | No |
Stores the reason for the agency returning a transaction in the agency extract framework.
May contain organization-specific values: Yes
No Entries Defined
14 | EXT_HX_ACCT_INST_UTC_DTTM | DATETIME (UTC) | No |
The extract activity instant. This value is stored as a UTC instant