CFD_TCFDD_SUPERANNUATION_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

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