DW_EWC_X_EWDI_CUST_CI_WO_EVT_TYP_D

Details

Module: Customer Analytics

Type: Dimension

Key Columns

WO_EVT_TYP_CD

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
WO_EVT_TYP_CD VARCHAR2 12 True Write Off Event Type
SOURCE_RECORD_ID VARCHAR2 12 Source Record Id
BI_WO_EVT_TYPE_FLG VARCHAR2 2 Event Type
C1_BI_CC_CL_LBL VARCHAR2 4 Contact Class
CASH_ONLY_PTS NUMBER 5 0 Affect Cash-Only Score By
CC_ACCT_FLG VARCHAR2 4 Account Usage
CC_ACTION_FLG VARCHAR2 2 Contact Action
CC_CL_CD VARCHAR2 4 Contact Class
CC_PER_FLG VARCHAR2 4 Person Usage
CC_PREM_FLG VARCHAR2 4 Premise Usage
CC_TYPE_CD VARCHAR2 12 Contact Type
CR_RATING_DURATION NUMBER 3 0 Months Affecting Credit Rating
CR_RATING_PTS NUMBER 5 0 Affect Credit Rating By
CUSTOM_ARCH_ELIG_CRIT_FLG VARCHAR2 4 Custom Archive Eligibility Criteria
ENTITY_REL_FLG VARCHAR2 4 Entity Relationship
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6