Severance Process
Module: Customer Analytics
Type: Fact
SEV_PROC_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SEV_PROC_ID | VARCHAR2 | 10 | True | Severance 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_SEV_PROC_CNT | NUMBER | 38 | 0 | Active Severance Processes | |||
| ARS_AT_END_AMT | NUMBER | 38 | 2 | Arrears At End | |||
| ARS_AT_START_AMT | NUMBER | 38 | 2 | Arrears At Start | |||
| CANCL_SYS_SEV_PROC_CNT | NUMBER | 38 | 0 | Canceled by System Severance Processes | |||
| CANCL_USER_SEV_PROC_CNT | NUMBER | 38 | 0 | Canceled by User Severance Processes | |||
| COLL_EVT_ID | VARCHAR2 | 38 | Collection Event | DW_EWC_X_EWDI_CUST_CI_COLL_EVT_D | COLL_PROC_ID | ||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| COMPLETED_SEV_PROC_CNT | NUMBER | 38 | 0 | Completed Severance Processes | |||
| COMPLETE_DT | NUMBER | 38 | 0 | Completion Date | |||
| 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 | ||
| CURR_ARS_AMT | NUMBER | 38 | 2 | Current Arrears Amount | |||
| CURR_SEV_EVT_TYPE_CD | VARCHAR2 | 38 | Next Pending Severance Event Type | DW_EWC_X_EWDI_CUST_CI_SEV_EVT_TYPE_D | SEV_EVT_TYPE_CD | ||
| DISCONN_CNT | NUMBER | Disconnect Events | |||||
| DISCONN_WARN_CNT | NUMBER | Disconnect Warning Events | |||||
| DISCONN_WARN_DT | NUMBER | 38 | 0 | Disconnect Warning Date | |||
| EFF_SEV_EVT_TYPE_CD | VARCHAR2 | 38 | Effective Severance Event Type | DW_EWC_X_EWDI_CUST_CI_SEV_EVT_TYPE_D | SEV_EVT_TYPE_CD | ||
| EVT_SEQ | NUMBER | 38 | 0 | Event Sequence | DW_EWC_X_EWDI_CUST_CI_COLL_EVT_D | EVT_SEQ | |
| INACTIVE_SEV_PROC_CNT | NUMBER | 38 | 0 | Inactive Severance Processes | |||
| LATEST_SE_COMPLETION_DT | NUMBER | 38 | 0 | ||||
| LATEST_SE_COMPLETION_DT_DATE_ | DATE | 0 | |||||
| MESSAGE_CAT_NBR | NUMBER | 38 | 0 | Message Category | DW_EWB_X_EWDI_BASE_CI_MSG_D | MESSAGE_CAT_NBR | |
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| PREM_ID | VARCHAR2 | 38 | Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| RECONN_CNT | NUMBER | Reconnect Events | |||||
| SA_ID | VARCHAR2 | 10 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| SEV_ARS_DIFF_AMT | NUMBER | 38 | 2 | Severance Arrears Difference | |||
| SEV_ARS_DT | NUMBER | 38 | 0 | Arrears Date | |||
| SEV_MESSAGE_NBR | NUMBER | 38 | 0 | Message | DW_EWB_X_EWDI_BASE_CI_MSG_D | MESSAGE_TXT | |
| SEV_PROC_CNT | NUMBER | 38 | 0 | Total Severance Processes | |||
| SEV_PROC_TMPL_CD | VARCHAR2 | 38 | Severance Process Template | DW_EWC_X_EWDI_CUST_CI_SEV_PROC_TMP_D | SEV_PROC_TMPL_CD | ||
| SEV_STATUS_FLG | VARCHAR2 | 2 | Severance Status | ||||
| SEV_STAT_RSN_FLG | VARCHAR2 | 2 | Severance Status Reason | ||||
| SVC_DISCONN_DT | NUMBER | 38 | 0 | Service Disconnection Date | |||
| SVC_RECONN_DT | NUMBER | 38 | 0 | Service Reconnection Date | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |