Write Off Process
Module: Customer Analytics
Type: Fact
UNCOLL_PROC_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| UNCOLL_PROC_ID | VARCHAR2 | 10 | True | Uncollectible 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_WO_PROC_CNT | NUMBER | 38 | 0 | Active Write Off Processes | |||
| ARS_AT_END | NUMBER | 38 | 2 | Arrears At End | |||
| ARS_AT_START | NUMBER | 38 | 2 | Arrears At Start | |||
| ARS_DIFF | NUMBER | 38 | 2 | Arrears Difference | |||
| CANCL_SYS_WO_PROC_CNT | NUMBER | 38 | 0 | Cancelled By System Write Off Processes | |||
| CANCL_USER_WO_PROC_CNT | NUMBER | 38 | 0 | Cancelled By User Write Off Processes | |||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| COMPL_WO_PROC_CNT | NUMBER | 38 | 0 | Completed Write Off Processes | |||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| CURRENCY_CD | VARCHAR2 | 38 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| EFF_WO_EVT_TYP_CD | VARCHAR2 | 38 | Effective Write Off Event Type | DW_EWC_X_EWDI_CUST_CI_WO_EVT_TYP_D | WO_EVT_TYP_CD | ||
| EFF_WO_PROC_CNT | NUMBER | 38 | 0 | Effective Write Off Processes | |||
| INACTIVE_WO_PROC_CNT | NUMBER | 38 | 0 | Inactive Write Off Processes | |||
| INEFF_WO_PROC_CNT | NUMBER | 38 | 0 | Ineffective Write Off Processes | |||
| MAX_COMPLETION_DT | NUMBER | 38 | 0 | ||||
| MAX_COMPLETION_DT_DATE_ | DATE | 0 | |||||
| NEXT_WO_EVT_TRIGGER_DT | NUMBER | 38 | 0 | Next Pending Write Off Event Trigger Date | |||
| NEXT_WO_EVT_TYP_CD | VARCHAR2 | 38 | Next Pending Write Off Event Type | DW_EWC_X_EWDI_CUST_CI_WO_EVT_TYP_D | WO_EVT_TYP_CD | ||
| PER_ID | VARCHAR2 | 38 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| UNCOLL_PROC_STAT_FLG | VARCHAR2 | 4 | Uncollectible Process Status | ||||
| WO_CNTL_CD | VARCHAR2 | 38 | Write Off Control | DW_EWC_X_EWDI_CUST_CI_WO_CNTL_D | WO_CNTL_CD | ||
| WO_PROC_ACT_SA_CNT | NUMBER | Active Linked Service Agreements | |||||
| WO_PROC_CNT | NUMBER | 38 | 0 | Write Off Processes | |||
| WO_PROC_COMPL_DT | NUMBER | 38 | 0 | Completion Date | |||
| WO_PROC_INACT_SA_CNT | NUMBER | Inactive Linked Service Agreements | |||||
| WO_PROC_TMPL_CD | VARCHAR2 | 38 | Write Off Process Template | DW_EWC_X_EWDI_CUST_CI_WO_PROC_TMPL_D | WO_PROC_TMPL_CD | ||
| WO_PROC_TOT_SA_CNT | NUMBER | Linked Service Agreements | |||||
| WO_STATUS_FLG | VARCHAR2 | 2 | Write Off Status | ||||
| WO_STAT_RSN_FLG | VARCHAR2 | 2 | Write Off Status Reason | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |