Collection 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 | ||
| ARS_AMT | NUMBER | 15 | 2 | Arrears Amount | |||
| COLL_ARS_DT | NUMBER | 38 | 0 | Arrears Date | |||
| COLL_CAT_PRIO_FLG | VARCHAR2 | 38 | 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_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 | ||||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| CRIT_PRIO_FLG | VARCHAR2 | 38 | Priority | ||||
| CURRENCY_CD | VARCHAR2 | 38 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| TRIGGER_BP_SW | VARCHAR2 | 38 | Trigger Business Process | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |