CFDRPT_TCFDS_PERS_INS_CUST_DTL_SNP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 CUST_ID DOUBLE PRECISION 8
3 HOUSEHOLD_ID DOUBLE PRECISION 8
4 ENTITY_TYP_DESC CHARACTER VARYING(50) 50
5 DECEASED_IND CHARACTER VARYING(3) 3
6 DECEASED_DATE TIMESTAMP 8
7 BRTH_DATE TIMESTAMP 8
8 PRIM_CUST_IND CHARACTER VARYING(3) 3
9 GNDR_IND CHARACTER VARYING(3) 3
10 ADDR_TYP_DESC CHARACTER VARYING(50) 50
11 PCODE DOUBLE PRECISION 8
12 STATE_CODE CHARACTER VARYING(20) 20
13 DPID CHARACTER VARYING(20) 20
14 CENSUS_COLCTIVE_DISTRICT_CODE CHARACTER VARYING(20) 20
15 BNKRPT_IND CHARACTER VARYING(1) 1
16 CONSNT_MKTG_SUN_IND CHARACTER VARYING(3) 3
17 CONSNT_MKTG_GIO_IND CHARACTER VARYING(3) 3
18 CONSNT_MKTG_AAMI_IND CHARACTER VARYING(3) 3
19 CONSNT_MKTG_APIA_IND CHARACTER VARYING(3) 3
20 CONSNT_MKTG_SHANNON_IND CHARACTER VARYING(3) 3
21 CONSNT_MKTG_JCI_IND CHARACTER VARYING(3) 3
22 CONSNT_MKTG_BINGLE_IND CHARACTER VARYING(3) 3
23 CONSNT_MKTG_IMR_IND CHARACTER VARYING(3) 3
24 CONSNT_MKTG_CIL_IND CHARACTER VARYING(3) 3
25 CONSNT_MKTG_VERO_IND CHARACTER VARYING(3) 3
26 CONSNT_MKTG_AMP_IND CHARACTER VARYING(3) 3
27 CONSNT_MKTG_WHT_LBL_IND CHARACTER VARYING(3) 3
28 FRST_POL_STRT_DATE TIMESTAMP 8
29 LST_POL_STRT_DATE TIMESTAMP 8
30 POL_CTP_SUN_CONT_VAL DOUBLE PRECISION 8
31 POL_CTP_GIO_CONT_VAL DOUBLE PRECISION 8
32 POL_CTP_AAMI_CONT_VAL DOUBLE PRECISION 8
33 POL_CTP_AMP_CONT_VAL DOUBLE PRECISION 8
34 POL_CTP_APIA_CONT_VAL DOUBLE PRECISION 8
35 POL_CTP_SHANNON_CONT_VAL DOUBLE PRECISION 8
36 POL_CTP_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
37 POL_MOT_SUN_CONT_VAL DOUBLE PRECISION 8
38 POL_MOT_GIO_CONT_VAL DOUBLE PRECISION 8
39 POL_MOT_AAMI_CONT_VAL DOUBLE PRECISION 8
40 POL_MOT_APIA_CONT_VAL DOUBLE PRECISION 8
41 POL_MOT_SHANNON_CONT_VAL DOUBLE PRECISION 8
42 POL_MOT_JCI_CONT_VAL DOUBLE PRECISION 8
43 POL_MOT_BINGLE_CONT_VAL DOUBLE PRECISION 8
44 POL_MOT_IMR_CONT_VAL DOUBLE PRECISION 8
45 POL_MOT_CIL_CONT_VAL DOUBLE PRECISION 8
46 POL_MOT_VERO_CONT_VAL DOUBLE PRECISION 8
47 POL_MOT_AMP_CONT_VAL DOUBLE PRECISION 8
48 POL_MOT_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
49 RISK_MOT_SUN_CONT_VAL DOUBLE PRECISION 8
50 RISK_MOT_GIO_CONT_VAL DOUBLE PRECISION 8
51 RISK_MOT_AAMI_CONT_VAL DOUBLE PRECISION 8
52 RISK_MOT_APIA_CONT_VAL DOUBLE PRECISION 8
53 RISK_MOT_SHANNON_CONT_VAL DOUBLE PRECISION 8
54 RISK_MOT_JCI_CONT_VAL DOUBLE PRECISION 8
55 RISK_MOT_BINGLE_CONT_VAL DOUBLE PRECISION 8
56 RISK_MOT_IMR_CONT_VAL DOUBLE PRECISION 8
57 RISK_MOT_CIL_CONT_VAL DOUBLE PRECISION 8
58 RISK_MOT_VERO_CONT_VAL DOUBLE PRECISION 8
59 RISK_MOT_AMP_CONT_VAL DOUBLE PRECISION 8
60 RISK_MOT_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
61 POL_HME_SUN_CONT_VAL DOUBLE PRECISION 8
62 POL_HME_GIO_CONT_VAL DOUBLE PRECISION 8
63 POL_HME_AAMI_CONT_VAL DOUBLE PRECISION 8
64 POL_HME_APIA_CONT_VAL DOUBLE PRECISION 8
65 POL_HME_SHANNON_CONT_VAL DOUBLE PRECISION 8
66 POL_HME_CIL_CONT_VAL DOUBLE PRECISION 8
67 POL_HME_VERO_CONT_VAL DOUBLE PRECISION 8
68 POL_HME_AMP_CONT_VAL DOUBLE PRECISION 8
69 POL_HME_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
70 RISK_HME_BLDG_SUN_CONT_VAL DOUBLE PRECISION 8
71 RISK_HME_BLDG_GIO_CONT_VAL DOUBLE PRECISION 8
72 RISK_HME_BLDG_AAMI_CONT_VAL DOUBLE PRECISION 8
73 RISK_HME_BLDG_APIA_CONT_VAL DOUBLE PRECISION 8
74 RISK_HME_BLDG_SHANNON_CONT_VAL DOUBLE PRECISION 8
75 RISK_HME_BLDG_CIL_CONT_VAL DOUBLE PRECISION 8
76 RISK_HME_BLDG_VERO_CONT_VAL DOUBLE PRECISION 8
77 RISK_HME_BLDG_AMP_CONT_VAL DOUBLE PRECISION 8
78 RISK_HME_BLDG_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
79 RISK_HME_CTS_SUN_CONT_VAL DOUBLE PRECISION 8
80 RISK_HME_CTS_GIO_CONT_VAL DOUBLE PRECISION 8
81 RISK_HME_CTS_AAMI_CONT_VAL DOUBLE PRECISION 8
82 RISK_HME_CTS_APIA_CONT_VAL DOUBLE PRECISION 8
83 RISK_HME_CTS_SHANNON_CONT_VAL DOUBLE PRECISION 8
84 RISK_HME_CTS_CIL_CONT_VAL DOUBLE PRECISION 8
85 RISK_HME_CTS_VERO_CONT_VAL DOUBLE PRECISION 8
86 RISK_HME_CTS_AMP_CONT_VAL DOUBLE PRECISION 8
87 RISK_HME_CTS_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
88 RISK_HME_OTH_SUN_CONT_VAL DOUBLE PRECISION 8
89 RISK_HME_OTH_GIO_CONT_VAL DOUBLE PRECISION 8
90 RISK_HME_OTH_AAMI_CONT_VAL DOUBLE PRECISION 8
91 RISK_HME_OTH_APIA_CONT_VAL DOUBLE PRECISION 8
92 RISK_HME_OTH_SHANNON_CONT_VAL DOUBLE PRECISION 8
93 RISK_HME_OTH_CIL_CONT_VAL DOUBLE PRECISION 8
94 RISK_HME_OTH_VERO_CONT_VAL DOUBLE PRECISION 8
95 RISK_HME_OTH_AMP_CONT_VAL DOUBLE PRECISION 8
96 RISK_HME_OTH_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
97 POL_RETAIL_SUN_CONT_VAL DOUBLE PRECISION 8
98 POL_RETAIL_GIO_CONT_VAL DOUBLE PRECISION 8
99 POL_RETAIL_AAMI_CONT_VAL DOUBLE PRECISION 8
100 POL_RETAIL_AMP_CONT_VAL DOUBLE PRECISION 8
101 POL_RETAIL_APIA_CONT_VAL DOUBLE PRECISION 8
102 POL_RETAIL_WHT_LBL_CONT_VAL DOUBLE PRECISION 8
103 DIRECT_CHNL_POL_CONT_VAL DOUBLE PRECISION 8
104 INDIRECT_CHNL_POL_CONT_VAL DOUBLE PRECISION 8
105 UNK_CHNL_POL_CONT_VAL DOUBLE PRECISION 8
106 LST_PRCH_RISK_CHNL_TYP_CODE CHARACTER VARYING(20) 20
107 LST_PRCH_RISK_CHNL_DESC CHARACTER VARYING(50) 50
108 INDIRECT_CHNL_SUN_PRDT_IND CHARACTER VARYING(3) 3
109 INDIRECT_CHNL_GIO_PRDT_IND CHARACTER VARYING(3) 3
110 INDIRECT_CHNL_AAMI_PRDT_IND CHARACTER VARYING(3) 3
111 INDIRECT_CHNL_APIA_PRDT_IND CHARACTER VARYING(3) 3
112 INDIRECT_CHNL_VERO_PRDT_IND CHARACTER VARYING(3) 3
113 PREV_MTH_CUST_NUM CHARACTER VARYING(20) 20
114 PREV_MTH_CUST_CNT DOUBLE PRECISION 8
115 PREV_MTH_HH_ID DOUBLE PRECISION 8
116 PREV_MTH_HH_CNT DOUBLE PRECISION 8
117 CUST_PRDT_BRND_CNT DOUBLE PRECISION 8
118 CUST_BRND_PRDT_TYP_CNT DOUBLE PRECISION 8
119 SRC_SYS_ID CHARACTER VARYING(5) 5
120 SNPSHT_DATE TIMESTAMP 8
121 DATA_LOAD_DATE TIMESTAMP 8
122 LOAD_ID DOUBLE PRECISION 8
123 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
124 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
125 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
126 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8