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