ARPB_TX_AGCY_HX

Description:

Stores the history of the changes in the current collection agency assigned to a charge. (Not populated for agency account workqueue based assignment).

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
	This line number identifies the sequence of changes in the assigned agency for a transaction.
3	AGENCY_ID	NUMERIC	No
	Stores the collection agency to which a charge is assigned.
4	AGENCY_ID_COLL_AGENCY_NAME	VARCHAR	No
	The name of the collection agency.
5	SENT_DTTM	DATETIME (UTC)	No
	Stores the instant a charge was sent to a collection agency. This value is stored as a UTC instant.
6	RETURN_DTTM	DATETIME (UTC)	No
	Stores the instant a charge returned from its assigned collection agency. This value is stored as a UTC instant.