ACCT_COLL_AGENCY_HX

Description:

This table contains historical collection agency information associated with the guarantor account.

Primary Key

Column Name	Ordinal Position
ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCOUNT_ID	NUMERIC	No
	The unique identifier for the account 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	AGENCY_ID	NUMERIC	No
	The collection agency that this account was assigned to.
4	AGENCY_ID_COLL_AGENCY_NAME	VARCHAR	No
	The name of the collection agency.
5	SUBMIT_DATE	DATETIME	No
	The date the account was assigned to the collection agency.
6	RESOLVED_DATE	DATETIME	No
	The date the account was resolved by the collection agency.
7	RESOLUTION_TYPE_C_NAME	VARCHAR	No
	The type of resolution that occurred for this history line. May contain organization-specific values: No Category Entries: Recalled Completed Converted to Agency Extract Framework