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
Final Review
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.