CFD_TCFDD_SUPER_INSRNCE_COVER_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 INS_COV_NUM CHARACTER VARYING(20) 20
3 EFF_STRT_DATE TIMESTAMP 8
4 TRM_COV_NUM CHARACTER VARYING(20) 20
5 INS_SUB_TYP_ID DOUBLE PRECISION 8
6 INS_SUB_TYP_CODE CHARACTER VARYING(20) 20
7 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
8 SUPER_PRDT_HOLDNG_ID DOUBLE PRECISION 8
9 COV_TYP_FLG CHARACTER VARYING(1) 1
10 TOPUP_FLG CHARACTER VARYING(1) 1
11 EMPR_GRP_NUM CHARACTER VARYING(20) 20
12 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
13 COV_STRT_DATE TIMESTAMP 8
14 TRM_STRT_DATE TIMESTAMP 8
15 TRM_END_DATE TIMESTAMP 8
16 COV_CANCEL_DATE TIMESTAMP 8
17 COV_STAT_ID DOUBLE PRECISION 8
18 COV_STAT_CODE CHARACTER VARYING(20) 20
19 CLM_STAT_ID DOUBLE PRECISION 8
20 CLM_STAT_CODE CHARACTER VARYING(20) 20
21 POL_PRNT_FLG CHARACTER VARYING(10) 10
22 UWRITING_STAT_CODE CHARACTER VARYING(10) 10
23 MBR_AUTO_ACPT_LIM_AMT NUMERIC(18,2) 19
24 PREM_RT_ID DOUBLE PRECISION 8
25 PREM_RT_CODE CHARACTER VARYING(20) 20
26 BASE_PREM_AMT NUMERIC(18,2) 19
27 HAZ_OCCUP_ID DOUBLE PRECISION 8
28 HAZ_OCCUP_CODE CHARACTER VARYING(20) 20
29 HAZ_OCCUP_LDNG_TYP_ID DOUBLE PRECISION 8
30 HAZ_OCCUP_LDNG_TYP_CODE CHARACTER VARYING(20) 20
31 HAZ_OCCUP_LDNG_PCTAGE NUMERIC(5,2) 19
32 MDCL_LDNG_TYP_ID DOUBLE PRECISION 8
33 MDCL_LDNG_TYP_CODE CHARACTER VARYING(20) 20
34 MDCL_LDNG_PCTAGE NUMERIC(5,2) 19
35 MANUAL_LDNG_TYP_ID DOUBLE PRECISION 8
36 MANUAL_LDNG_TYP_CODE CHARACTER VARYING(20) 20
37 MANUAL_LDNG_PCTAGE NUMERIC(18,2) 19
38 EMPR_GRP_LDNG_TYP_ID DOUBLE PRECISION 8
39 EMPR_GRP_LDNG_TYP_CODE CHARACTER VARYING(20) 20
40 EMPR_GRP_LDNG_PCTAGE NUMERIC(5,2) 19
41 PREM_COLCT_FREQ_ID DOUBLE PRECISION 8
42 PREM_COLCT_FREQ_CODE CHARACTER VARYING(10) 10
43 NONSUPER_BASE_PREM_AMT NUMERIC(18,2) 19
44 SUPER_PREM_AMT NUMERIC(18,2) 19
45 ANN_PREM_AMT NUMERIC(18,2) 19
46 REFUNDED_PREM_AMT NUMERIC(18,2) 19
47 PREM_CALC_METH_ID DOUBLE PRECISION 8
48 PREM_CALC_METH_CODE CHARACTER VARYING(20) 20
49 PREM_SALARY_MULTIPLIER_RT NUMERIC(7,4) 19
50 FLAT_COV_AMT NUMERIC(18,2) 19
51 EMP_SALARY_COV_PCTAGE NUMERIC(5,2) 19
52 RETIREMENT_AGE_FLG CHARACTER VARYING(1) 1
53 RETIREMENT_AGE_YR DOUBLE PRECISION 8
54 SUM_INS_BAL_DEPENDENCY_FLG CHARACTER VARYING(1) 1
55 CALC_SUM_INSD_AMT NUMERIC(18,2) 19
56 ACTL_SUM_INSD_AMT NUMERIC(18,2) 19
57 YTD_NONSUPER_PREM_PAID_AMT NUMERIC(18,2) 19
58 NONSUPER_PREM_AMT NUMERIC(18,2) 19
59 FWD_UWRITING_COV_LIM_AMT NUMERIC(18,2) 19
60 FWD_UWRITING_COV_ACPT_DATE TIMESTAMP 8
61 FWD_UWRITING_COV_AMT NUMERIC(18,2) 19
62 FWD_UWRITING_SALARY_PCTAGE NUMERIC(5,2) 19
63 SALARY_AMT NUMERIC(18,2) 19
64 COV_UNT_CNT DOUBLE PRECISION 8
65 STAMP_DUTY_RT NUMERIC(5,2) 19
66 STATE_ID DOUBLE PRECISION 8
67 STAMP_DUTY_STATE_CODE CHARACTER VARYING(30) 30
68 PREM_COLCTN_METH_ID DOUBLE PRECISION 8
69 PREM_COLCTN_METH_CODE CHARACTER VARYING(20) 20
70 DEF_COMM_TYP_CODE CHARACTER VARYING(1) 1
71 CONVERTED_SYS_REF_NUM CHARACTER VARYING(20) 20
72 CONVERTED_GROSS_PREM_AMT NUMERIC(18,2) 19
73 LST_RVW_DATE TIMESTAMP 8
74 EFF_END_DATE TIMESTAMP 8
75 DATA_LOAD_DATE TIMESTAMP 8
76 SNPSHT_DATE TIMESTAMP 8
77 SRC_SYS_ID CHARACTER VARYING(5) 5
78 LOAD_ID DOUBLE PRECISION 8
79 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
80 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
81 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
82 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8