CFDRPT_TCFDS_PERS_INS_HH_DTL_SNP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

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