PB_COLL_PROCESS_TBL

Description:

The related table for all the collections processes on a PBA.

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_STAT_C_NAME	VARCHAR	No
	The status of the collections process. Used to determine system behavior. May contain organization-specific values: No Category Entries: Awaiting Review Active - Internal Active - External Inactive - Internal Inactive - External Deleted Paused
4	PB_COLL_STEP_C_NAME	VARCHAR	No
	The current step of the collections process on the account. May contain organization-specific values: Yes Category Entries: Paid Off Written Off
5	PB_IN_COLL_SINCE_DATE	DATETIME	No
	Represents the date on which this instance entered the collections process.
6	COLL_PROCESS_NUM	INTEGER	No
	The unique ID for the collection process on the account.
7	PB_IN_STAT_SINCE_DATE	DATETIME	No
	Represents the date in which this instance entered the current status of the collections process.
8	PB_IN_STEP_SINCE_DATE	DATETIME	No
	Represents the date in which this instance entered the current step of the collections process.
9	PB_ORIG_AMT_OUTST_N	NUMERIC	No
	Stores the total amount outstanding that was originally added to collections.