DW_EWC_X_EWDI_CUST_CI_CASE_TYPE_D

Details

Module: Customer Analytics

Type: Dimension

Key Columns

CASE_TYPE_CD

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CASE_TYPE_CD VARCHAR2 12 True Case Type
SOURCE_RECORD_ID VARCHAR2 12 Source Record Id
CASE_ACCT_FLG VARCHAR2 4 Account Usage
CASE_CONT_INFO_FLG VARCHAR2 4 Contact Person & Method Usage
CASE_CONT_INST_FLG VARCHAR2 4 Contact Instructions Usage
CASE_PER_FLG VARCHAR2 4 Person Usage
CASE_PHONE_FLG VARCHAR2 4 Case Phone Usage
CASE_PREM_FLG VARCHAR2 4 Premise Usage
CASE_USER_FLG VARCHAR2 4 Responsible User Usage
ENTITY_REL_FLG VARCHAR2 4 Entity Relationship
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6