CFD_TCFDD_INVESTMENT_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INVSTMT_PRDT_HOLDNG_ID DOUBLE PRECISION 8
2 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
3 PRDT_SYS_CODE CHARACTER VARYING(10) 10
4 PRDT_HOLDNG_ID DOUBLE PRECISION 8
5 ACTV_IND CHARACTER VARYING(1) 1
6 AGNT_ID DOUBLE PRECISION 8
7 CHNL_ID DOUBLE PRECISION 8
8 BAL_NON_PRTCPNG_FND_AMT NUMERIC(18,6) 19
9 BAL_PRTCPNG_FND_AMT NUMERIC(18,6) 19
10 BRCH_ID DOUBLE PRECISION 8
11 BRKR_TYP_ID DOUBLE PRECISION 8
12 CNTCT_NAM CHARACTER VARYING(100) 100
13 CNTCT_POSN CHARACTER VARYING(100) 100
14 DR_AMT NUMERIC(18,6) 19
15 DR_FREQ_ID DOUBLE PRECISION 8
16 FNNCER_NAM_1 CHARACTER VARYING(100) 100
17 FNNCER_NAM_2 CHARACTER VARYING(100) 100
18 FIXED_PAY_AMT NUMERIC(18,6) 19
19 INSRR_NAM_1 CHARACTER VARYING(100) 100
20 INSRR_NAM_2 CHARACTER VARYING(100) 100
21 ACTV_EMP_CNT DOUBLE PRECISION 8
22 PAYT_INSTRUCTION_TEXT CHARACTER VARYING(100) 100
23 PAYT_METH_ID DOUBLE PRECISION 8
24 POL_DISC_IND CHARACTER VARYING(4) 4
25 PRCH_AMT NUMERIC(18,6) 19
26 USG_PURP_ID DOUBLE PRECISION 8
27 SERV_IC_NAM CHARACTER VARYING(100) 100
28 TOT_IRRGULR_CONTRBUTN NUMERIC(18,6) 19
29 TOT_UNT_CNT DOUBLE PRECISION 8
30 UNT_TYP_ID DOUBLE PRECISION 8
31 ACCT_BAL NUMERIC(18,6) 19
32 SUM_INSD_AMT NUMERIC(18,6) 19
33 ANN_PREM_AMT NUMERIC(18,6) 19
34 EFF_STRT_DATE TIMESTAMP 8
35 EFF_END_DATE TIMESTAMP 8
36 DATA_LOAD_DATE TIMESTAMP 8
37 SNPSHT_DATE TIMESTAMP 8
38 SRC_SYS_ID CHARACTER VARYING(5) 5
39 LOAD_ID DOUBLE PRECISION 8
40 PRDT_ID DOUBLE PRECISION 8
41 PRDT_STRT_DATE TIMESTAMP 8
42 PRDT_END_DATE TIMESTAMP 8
43 ASIS_CODE CHARACTER VARYING(20) 20
44 AGNT_CODE CHARACTER VARYING(20) 20
45 BRKR_TYP_CODE CHARACTER VARYING(20) 20
46 BUS_CHNL_CODE CHARACTER VARYING(20) 20
47 DSBLTY_WAIT_PERD BIGINT 8
48 DSBLTY_SICK_PERD_CODE CHARACTER VARYING(10) 10
49 DSBLTY_SICK_PERD BIGINT 8
50 DSBLTY_ACDNT_PERD_CODE CHARACTER VARYING(10) 10
51 DSBLTY_ACDNT_PERD BIGINT 8
52 DSBLTY_OCCUP_CLASS_CODE CHARACTER VARYING(20) 20
53 SMKR_FLG CHARACTER VARYING(1) 1
54 DSBLTY_WAIT_PERD_CODE CHARACTER VARYING(20) 20
55 CHNL_CODE CHARACTER VARYING(10) 10
56 SUB_CHNL_ID DOUBLE PRECISION 8
57 SUB_CHNL_CODE CHARACTER VARYING(20) 20
58 PAYT_METH_CODE CHARACTER VARYING(20) 20
59 PAYT_FREQ_CODE CHARACTER VARYING(20) 20
60 BRCH_CODE CHARACTER VARYING(20) 20
61 UNT_TYP_CODE CHARACTER VARYING(20) 20
62 USG_PURP_CODE CHARACTER VARYING(20) 20
63 SINGLE_PREM_AMT NUMERIC(18,6) 19
64 PRDT_DISCLOSURE_STMT_ID DOUBLE PRECISION 8
65 PRDT_DISCLOSURE_STMT_CODE CHARACTER VARYING(20) 20
66 PREV_INSD_FLG CHARACTER VARYING(1) 1
67 PREV_INSRR_ID DOUBLE PRECISION 8
68 PREV_INSRR_CODE CHARACTER VARYING(20) 20
69 PREV_BUS_TYP_ID DOUBLE PRECISION 8
70 PREV_BUS_TYP_CODE CHARACTER VARYING(20) 20
71 PREV_POL_NUM1 CHARACTER VARYING(20) 20
72 PREV_POL_NUM2 CHARACTER VARYING(20) 20
73 PREV_POL_NUM3 CHARACTER VARYING(20) 20
74 LIMITED_UWRITING_FLG CHARACTER VARYING(1) 1
75 POL_PREM_STAT_CODE CHARACTER VARYING(20) 20
76 POL_PREM_STAT_ID DOUBLE PRECISION 8
77 CVRG_PREM_STAT_ID DOUBLE PRECISION 8
78 CVRG_PREM_STAT_CODE CHARACTER VARYING(20) 20
79 PREM_TYP_ID DOUBLE PRECISION 8
80 PREM_TYP_CODE CHARACTER VARYING(20) 20
81 INS_CANCEL_DATE TIMESTAMP 8
82 SD_STATE_ID DOUBLE PRECISION 8
83 SD_STATE_CODE CHARACTER VARYING(20) 20
84 INSTLMT_SD_AMT NUMERIC(18,6) 19
85 ANN_SD_AMT NUMERIC(18,6) 19
86 DSBLTY_OCCUP_CLASS_ID DOUBLE PRECISION 8
87 INS_RISK_SURRENDER_VAL NUMERIC(18,6) 19
88 BUS_SEC_OPT_IND CHARACTER VARYING(3) 3
89 SPCL_EVENT_OPT_ID DOUBLE PRECISION 8
90 SPCL_EVENT_OPT_CODE CHARACTER VARYING(20) 20
91 INCOME_UPD_STAT_IND CHARACTER VARYING(4) 4
92 ACDNTL_INJ_BNFT_IND CHARACTER VARYING(3) 3
93 ADTNL_PACKAGE_IND CHARACTER VARYING(3) 3
94 INSD_OCCUP_ID DOUBLE PRECISION 8
95 INSD_OCCUP_CODE CHARACTER VARYING(20) 20
96 INSD_CLIENT_STAT_ID DOUBLE PRECISION 8
97 INSD_CLIENT_STAT_CODE CHARACTER VARYING(20) 20
98 INSD_BRTH_DATE TIMESTAMP 8
99 INSD_GNDR_IND CHARACTER VARYING(3) 3
100 LIFE_POL_ID DOUBLE PRECISION 8
101 POL_NUM CHARACTER VARYING(20) 20
102 POL_STRT_DATE TIMESTAMP 8
103 POL_EXPIRY_DATE TIMESTAMP 8
104 POL_REN_DATE TIMESTAMP 8
105 CANCEL_RSN_ID DOUBLE PRECISION 8
106 CANCEL_RSN_CODE CHARACTER VARYING(20) 20
107 PREM_FRZE_BNFT_IND CHARACTER VARYING(1) 1
108 INSTLMT_PREM_AMT NUMERIC(18,6) 19
109 LSI_DISC_PCTAGE NUMERIC(18,4) 19
110 CVRG_STAT_ID DOUBLE PRECISION 8
111 CVRG_STAT_CODE CHARACTER VARYING(20) 20
112 POL_STAT_ID DOUBLE PRECISION 8
113 POL_STAT_CODE CHARACTER VARYING(20) 20
114 POL_STAT_EFF_DATE TIMESTAMP 8
115 POL_STAT_RGSTN_DATE TIMESTAMP 8
116 POL_RGSTN_DATE TIMESTAMP 8
117 POL_CANCEL_DATE TIMESTAMP 8
118 SUM_INSD_INDXTN_IND CHARACTER VARYING(1) 1
119 INSD_ENTRY_AGE_YR DOUBLE PRECISION 8
120 PREM_HLDY_STRT_DATE TIMESTAMP 8
121 PREM_HLDY_END_DATE TIMESTAMP 8
122 POL_RGSTR_STATE_ID DOUBLE PRECISION 8
123 POL_RGSTR_STATE_CODE CHARACTER VARYING(20) 20
124 TPD_POUT_TYP_ID DOUBLE PRECISION 8
125 TPD_POUT_TYP_CODE CHARACTER VARYING(20) 20
126 INDMNTY_OPT_ID DOUBLE PRECISION 8
127 INDMNTY_OPT_CODE CHARACTER VARYING(20) 20
128 TPD_POUT_DEFN_TYP_ID DOUBLE PRECISION 8
129 TPD_POUT_DEFN_TYP_CODE CHARACTER VARYING(20) 20
130 CVRG_STAT_DATE TIMESTAMP 8
131 CVRG_STAT_EFF_DATE TIMESTAMP 8
132 NXT_INSTLMT_CPI_PREM_AMT NUMERIC(18,6) 19
133 NXT_INSTLMT_PREM_AMT NUMERIC(18,6) 19
134 NXT_SUM_INSD_AMT NUMERIC(18,6) 19
135 EQUIVALENT_ANN_PREM_AMT NUMERIC(18,6) 19
136 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
137 PREM_INDXTN_IND CHARACTER VARYING(4) 4
138 GLOSSY_ID DOUBLE PRECISION 8
139 GLOSSY_CODE CHARACTER VARYING(20) 20
140 REPLACED_BUS_FLG CHARACTER VARYING(1) 1
141 TRAUMA_TYP_ID DOUBLE PRECISION 8
142 TRAUMA_TYP_CODE CHARACTER VARYING(20) 20
143 TRAUMA_REINST_OPT_FLG CHARACTER VARYING(3) 3
144 LINKED_POL_NUM CHARACTER VARYING(20) 20
145 POL_LINKAGE_TYP_ID DOUBLE PRECISION 8
146 POL_LINKAGE_TYP_CODE CHARACTER VARYING(20) 20
147 OLD_PRDT_ID DOUBLE PRECISION 8
148 OLD_POL_NUM CHARACTER VARYING(20) 20
149 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
150 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
151 PROMO_CODE CHARACTER VARYING(12) 12
152 U_NUMBER CHARACTER VARYING(8) 8
153 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
154 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
155 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
156 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8