CFD_TCFDD_LIFE_RISK_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LIFE_RISK_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_ID BIGINT 8
4 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
5 POL_NUM CHARACTER VARYING(20) 20
6 PRDT_ID BIGINT 8
7 CHNL_ID BIGINT 8
8 CHNL_CODE CHARACTER VARYING(10) 10
9 SUB_CHNL_ID BIGINT 8
10 SUB_CHNL_CODE CHARACTER VARYING(20) 20
11 PAYT_METH_ID BIGINT 8
12 PAYT_METH_CODE CHARACTER VARYING(20) 20
13 PAYT_FREQ_ID BIGINT 8
14 PAYT_FREQ_CODE CHARACTER VARYING(20) 20
15 SUM_INSD_AMT NUMERIC(18,6) 19
16 ANN_PREM_AMT NUMERIC(18,6) 19
17 INS_STRT_DATE TIMESTAMP 8
18 INS_END_DATE TIMESTAMP 8
19 POL_STRT_DATE TIMESTAMP 8
20 POL_EXPIRY_DATE TIMESTAMP 8
21 POL_REN_DATE TIMESTAMP 8
22 CANCEL_RSN_ID BIGINT 8
23 CANCEL_RSN_CODE CHARACTER VARYING(20) 20
24 SRC_CMPGN_CODE CHARACTER VARYING(20) 20
25 FAMILY_DISC_PCTAGE NUMERIC(10,4) 19
26 STAFF_DISC_PCTAGE NUMERIC(10,4) 19
27 PREM_FRZE_BNFT_IND CHARACTER(1) 1
28 INSTLMT_PREM_AMT NUMERIC(18,6) 19
29 LSI_DISC_PCTAGE NUMERIC(10,4) 19
30 CVRG_STAT_ID BIGINT 8
31 CVRG_STAT_CODE CHARACTER VARYING(20) 20
32 POL_STAT_ID BIGINT 8
33 POL_STAT_CODE CHARACTER VARYING(20) 20
34 POL_STAT_EFF_DATE TIMESTAMP 8
35 POL_STAT_RGSTN_DATE TIMESTAMP 8
36 POL_RGSTN_DATE TIMESTAMP 8
37 POL_CANCEL_DATE TIMESTAMP 8
38 SUM_INSD_INDXTN_IND CHARACTER(1) 1
39 EFF_STRT_DATE TIMESTAMP 8
40 EFF_END_DATE TIMESTAMP 8
41 DATA_LOAD_DATE TIMESTAMP 8
42 SNPSHT_DATE TIMESTAMP 8
43 SRC_SYS_ID CHARACTER VARYING(5) 5
44 LOAD_ID BIGINT 8
45 LIFE_POL_ID DOUBLE PRECISION 8
46 PRDT_DISCLOSURE_STMT_ID BIGINT 8
47 PRDT_DISCLOSURE_STMT_CODE CHARACTER VARYING(20) 20
48 AGNT_ID BIGINT 8
49 AGNT_CODE CHARACTER VARYING(20) 20
50 PREV_INSD_FLG CHARACTER VARYING(1) 1
51 PREV_INSRR_ID BIGINT 8
52 PREV_INSRR_CODE CHARACTER VARYING(20) 20
53 PREV_BUS_TYP_ID DOUBLE PRECISION 8
54 PREV_BUS_TYP_CODE CHARACTER VARYING(20) 20
55 PREV_POL_NUM1 CHARACTER VARYING(20) 20
56 PREV_POL_NUM2 CHARACTER VARYING(20) 20
57 PREV_POL_NUM3 CHARACTER VARYING(20) 20
58 LIMITED_UWRITING_FLG CHARACTER VARYING(1) 1
59 POL_PREM_STAT_CODE CHARACTER VARYING(20) 20
60 POL_PREM_STAT_ID BIGINT 8
61 CVRG_PREM_STAT_ID BIGINT 8
62 CVRG_PREM_STAT_CODE CHARACTER VARYING(20) 20
63 PREM_TYP_ID BIGINT 8
64 PREM_TYP_CODE CHARACTER VARYING(20) 20
65 INS_CANCEL_DATE TIMESTAMP 8
66 SD_STATE_ID BIGINT 8
67 SD_STATE_CODE CHARACTER VARYING(20) 20
68 INSTLMT_SD_AMT NUMERIC(18,6) 19
69 ANN_SD_AMT NUMERIC(18,6) 19
70 DSBLTY_WAIT_PERD DOUBLE PRECISION 8
71 DSBLTY_SICK_PERD_CODE CHARACTER VARYING(10) 10
72 DSBLTY_SICK_PERD DOUBLE PRECISION 8
73 DSBLTY_ACDNT_PERD_CODE CHARACTER VARYING(10) 10
74 DSBLTY_ACDNT_PERD DOUBLE PRECISION 8
75 DSBLTY_OCCUP_CLASS_ID BIGINT 8
76 DSBLTY_OCCUP_CLASS_CODE CHARACTER VARYING(20) 20
77 INS_RISK_SURRENDER_VAL NUMERIC(18,6) 19
78 BUS_SEC_OPT_IND CHARACTER VARYING(3) 3
79 SPCL_EVENT_OPT_ID BIGINT 8
80 SPCL_EVENT_OPT_CODE CHARACTER VARYING(20) 20
81 INCOME_UPD_STAT_IND CHARACTER VARYING(4) 4
82 ACDNTL_INJ_BNFT_IND CHARACTER VARYING(3) 3
83 ADTNL_PACKAGE_IND CHARACTER VARYING(3) 3
84 INSD_OCCUP_ID BIGINT 8
85 INSD_OCCUP_CODE CHARACTER VARYING(20) 20
86 INSD_CLIENT_STAT_ID BIGINT 8
87 INSD_CLIENT_STAT_CODE CHARACTER VARYING(20) 20
88 INSD_BRTH_DATE TIMESTAMP 8
89 INSD_GNDR_IND CHARACTER VARYING(3) 3
90 INSD_SMKR_IND CHARACTER VARYING(1) 1
91 INSD_ENTRY_AGE_YR DOUBLE PRECISION 8
92 PREM_HLDY_STRT_DATE TIMESTAMP 8
93 PREM_HLDY_END_DATE TIMESTAMP 8
94 POL_RGSTR_STATE_ID BIGINT 8
95 POL_RGSTR_STATE_CODE CHARACTER VARYING(20) 20
96 TPD_POUT_TYP_ID DOUBLE PRECISION 8
97 TPD_POUT_TYP_CODE CHARACTER VARYING(20) 20
98 INDMNTY_OPT_ID DOUBLE PRECISION 8
99 INDMNTY_OPT_CODE CHARACTER VARYING(20) 20
100 TPD_POUT_DEFN_TYP_ID DOUBLE PRECISION 8
101 TPD_POUT_DEFN_TYP_CODE CHARACTER VARYING(20) 20
102 CVRG_STAT_DATE TIMESTAMP 8
103 CVRG_STAT_EFF_DATE TIMESTAMP 8
104 NXT_INSTLMT_CPI_PREM_AMT NUMERIC(18,6) 19
105 NXT_INSTLMT_PREM_AMT NUMERIC(18,6) 19
106 NXT_SUM_INSD_AMT NUMERIC(18,6) 19
107 EQUIVALENT_ANN_PREM_AMT NUMERIC(18,6) 19
108 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
109 PREM_INDXTN_IND CHARACTER VARYING(4) 4
110 GLOSSY_ID BIGINT 8
111 GLOSSY_CODE CHARACTER VARYING(20) 20
112 DSBLTY_WAIT_PERD_CODE CHARACTER VARYING(20) 20
113 SINGLE_PREM_AMT NUMERIC(18,6) 19
114 REPLACED_BUS_FLG CHARACTER VARYING(1) 1
115 TRAUMA_TYP_ID DOUBLE PRECISION 8
116 TRAUMA_TYP_CODE CHARACTER VARYING(20) 20
117 TRAUMA_REINST_OPT_FLG CHARACTER VARYING(3) 3
118 LINKED_POL_NUM CHARACTER VARYING(20) 20
119 POL_LINKAGE_TYP_ID DOUBLE PRECISION 8
120 POL_LINKAGE_TYP_CODE CHARACTER VARYING(20) 20
121 OLD_PRDT_ID DOUBLE PRECISION 8
122 OLD_POL_NUM CHARACTER VARYING(20) 20
123 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
124 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
125 PROMO_CODE CHARACTER VARYING(12) 12
126 U_NUMBER CHARACTER VARYING(8) 8
127 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
128 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
129 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
130 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8