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