CDI_TCFDD_CUSTOMER_INCIDENT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_INCIDENT_ID BIGINT 8
2 CUST_INCIDENT_NUM CHARACTER VARYING(20) 20
3 CUST_NUM CHARACTER VARYING(20) 20
4 CUST_ID BIGINT 8
5 CIS_CUST_NUM CHARACTER VARYING(20) 20
6 CNTCT_ID BIGINT 8
7 INCIDENT_CAT_ID BIGINT 8
8 INCIDENT_TYP_ID BIGINT 8
9 CMPGN_TRACKING_ID BIGINT 8
10 INCIDENT_STAT_ID BIGINT 8
11 INCIDENT_PRTY_ID BIGINT 8
12 INCIDENT_SRC_ID BIGINT 8
13 ASGNED_TO_USER CHARACTER VARYING(50) 50
14 RESOLUTION_TYP_CODE_04 BIGINT 8
15 RESOLUTION_TYP_CODE_03 BIGINT 8
16 RESOLUTION_TYP_CODE_02 BIGINT 8
17 RESOLUTION_TYP_CODE_01 BIGINT 8
18 INSERTED_BY_USER CHARACTER VARYING(50) 50
19 INSERTED_DATE TIMESTAMP 8
20 UPDD_BY_USER CHARACTER VARYING(20) 20
21 UPDD_DATE TIMESTAMP 8
22 MODIFIED_DATE TIMESTAMP 8
23 RECORD_STAT_IND CHARACTER VARYING(20) 20
24 INCIDENT_PRDT_ID CHARACTER VARYING(50) 50
25 EFF_STRT_DATE TIMESTAMP 8
26 EFF_END_DATE TIMESTAMP 8
27 DATA_LOAD_DATE TIMESTAMP 8
28 SNPSHT_DATE TIMESTAMP 8
29 SRC_SYS_ID CHARACTER VARYING(5) 5
30 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
31 LOAD_ID BIGINT 8
32 CUST_INCIDENT_DESC CHARACTER VARYING(1500) 1500
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8