Collectible Process
Module: Customer Analytics
Type: Fact
COLL_PROC_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| COLL_PROC_ID | VARCHAR2 | 10 | True | Collection Process | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| ACTIVE_COLL_PROC_CNT | NUMBER | 38 | 0 | Active Collection Processes | |||
| ACTIVE_SEV_PROC_CNT | NUMBER | Active Severance Processes | |||||
| ARS_AT_START_AMT | NUMBER | 15 | 2 | Arrears At Start | |||
| CANCL_SYS_COLL_PROC_CNT | NUMBER | 38 | 0 | Canceled by System Collection Processes | |||
| CANCL_USER_COLL_PROC_CNT | NUMBER | 38 | 0 | Canceled by User Collection Processes | |||
| COLLECTIBLE_ARS_AT_END_AMT | NUMBER | 15 | 2 | Collectible Process Arrears At End | |||
| COLLECTIBLE_ARS_DIFF_AMT | NUMBER | 15 | 2 | Collectible Arrears Difference | |||
| COLLECTIBLE_PROC_COMPL_DT | NUMBER | 38 | 0 | Collectible Process End Date | |||
| COLLECTIBLE_PROC_COMPL_DT_DATE_ | DATE | 0 | |||||
| COLLPROC_ARS_AT_END_AMT | NUMBER | 15 | 2 | Collection Process Arrears at End | |||
| COLL_ARS_DIFF_AMT | NUMBER | 15 | 2 | Collection Arrears Difference | |||
| COLL_ARS_DT | NUMBER | 38 | 0 | Arrears Date | |||
| COLL_CAT_PRIO_FLG | VARCHAR2 | 2 | Collection Condition Priority | ||||
| COLL_CL_CNTL_CD | VARCHAR2 | 20 | Collection Class Control | DW_EWC_X_EWDI_CUST_CI_COLL_CL_CNTL_D | COLL_CL_CNTL_CD | ||
| COLL_PROC_CNT | NUMBER | 38 | 0 | Collection Processes | |||
| COLL_PROC_COMPL_DT | NUMBER | 38 | 0 | Collection Process End Date | |||
| COLL_PROC_TMPL_CD | VARCHAR2 | 12 | Collection Process Template | DW_EWC_X_EWDI_CUST_CI_COLL_PROC_TM_D | COLL_PROC_TMPL_CD | ||
| COLL_STATUS_FLG | VARCHAR2 | 2 | Collection Status | ||||
| COLL_STAT_RSN_FLG | VARCHAR2 | 2 | Collection Status Reason | ||||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| COMPL_COLL_PROC_CNT | NUMBER | 38 | 0 | Completed Collection Processes | |||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| CRIT_PRIO_FLG | VARCHAR2 | 2 | Priority | ||||
| CURRENCY_CD | VARCHAR2 | 38 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| CURR_ARS_AMT | NUMBER | 15 | 2 | Current Arrears Amount | |||
| CURR_COLLECTIBLE_EVT_TYPE_CD | VARCHAR2 | 12 | Next Pending Collectible Event Type | DW_EWC_X_EWDI_CUST_C1_BI_COLLEVTTYPE_VW | COLLECTIBLE_EVT_TYPE_CD | ||
| CURR_COLL_EVT_TYP_CD | VARCHAR2 | 12 | Next Pending Collection Event Type | DW_EWC_X_EWDI_CUST_CI_COLL_EVT_TYP_D | COLL_EVT_TYP_CD | ||
| CURR_SEV_EVT_TYPE_CD | VARCHAR2 | 12 | Next Pending Severance Event Type | DW_EWC_X_EWDI_CUST_CI_SEV_EVT_TYPE_D | SEV_EVT_TYPE_CD | ||
| EFF_COLLECTIBLE_EVT_TYPE_CD | VARCHAR2 | 12 | Effective Collectible Event Type | DW_EWC_X_EWDI_CUST_C1_BI_COLLEVTTYPE_VW | COLLECTIBLE_EVT_TYPE_CD | ||
| EFF_COLL_EVT_TYP_CD | VARCHAR2 | 12 | Effective Collection Event Type | DW_EWC_X_EWDI_CUST_CI_COLL_EVT_TYP_D | COLL_EVT_TYP_CD | ||
| EFF_SEV_EVT_TYPE_CD | VARCHAR2 | 12 | Effective Severance Event Type | DW_EWC_X_EWDI_CUST_CI_SEV_EVT_TYPE_D | SEV_EVT_TYPE_CD | ||
| INACTIVE_COLLECTIBLE_CNT | NUMBER | 38 | 0 | Inactive Collectible Processes | |||
| INACTIVE_COLL_PROC_CNT | NUMBER | 38 | 0 | Inactive Collection Processes | |||
| INACTIVE_SEV_PROC_CNT | NUMBER | Inactive Severance Processes | |||||
| LATEST_CE_COMPLETION_DT | NUMBER | 38 | 0 | ||||
| LATEST_CE_COMPLETION_DT_DATE_ | DATE | 0 | |||||
| OVERALL_ACTIVE_COLL_CNT | NUMBER | 38 | 0 | Active Collectible Processes | |||
| OVERALL_COLLECTIBLE_STAT_FLG | VARCHAR2 | 4 | Collectible Status | ||||
| OVERALL_EFF_COLL_CNT | NUMBER | 38 | 0 | Effective Collectible Processes | |||
| OVERALL_INEFF_COLL_CNT | NUMBER | 38 | 0 | Ineffective Collectible Processes | |||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| SEV_PROC_CNT | NUMBER | Total Severance Processes | |||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |