PB_COLL_STEP_HX_TBL

Description:

This table contains information about the history of all collection activity on a PBA. This includes when steps are completed, when collections balances are written or paid off, and the amount of money outstanding in collections.

Primary Key

Column Name	Ordinal Position
PB_ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_ACCT_ID	VARCHAR	No
	The unique identifier (.1 item) 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	PB_COLL_STEP_C_NAME	VARCHAR	No
	Stores the history of the collections step on the account. May contain organization-specific values: Yes Category Entries: Paid Off Written Off Final Review
4	PB_MOD_HX_DATE	DATETIME	No
	Stores the history of when the collections step was modified on the account.
5	PB_AMT_OUTST_HX	NUMERIC	No
	Stores the history of the amount outstanding from transactions that are in collections.
6	PB_COLL_STEP_NUM	INTEGER	No
	The unique ID for the collection process on the account.
7	WHO_COMP_STEP_HX_USER_ID	VARCHAR	No
	Stores the history of the user that completed each step in a collections process.
8	WHO_COMP_STEP_HX_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	WAS_STEP_SKIP_YN	VARCHAR	No
	Indicates whether this step of the collection process was manually skipped. May contain organization-specific values: No Category Entries: No Yes
10	PB_COLL_STAT_C_NAME	VARCHAR	No
	Stores the history of the collections status on the account. May contain organization-specific values: No Category Entries: Awaiting Review Active - Internal Active - External Inactive - Internal Inactive - External Deleted Paused
11	COLL_PHONE_CALL_COMM_ID	NUMERIC	No
	Stores the history of any CRM cases that were opened in each step of a collections process.