PB_COLL_STEP_HX_TBL

Description:

This table contains information about the history of all collection processes on a PBA. This includes the step the process moved to, the date that the move happened, and the amount of money outstanding from the transactions 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
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.