CFD_TCFDD_MOTOR_INS_PH_ADTNL_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MOTOR_INS_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(100) 100
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 CRNT_TXN_NUM CHARACTER VARYING(10) 10
5 FLEXI_XS_RSN_ID_1 BIGINT 8
6 FLEXI_XS_RSN_CODE_1 CHARACTER VARYING(4) 4
7 FLEXI_XS_AMT_1 NUMERIC(18,6) 19
8 FLEXI_XS_RSN_ID_2 BIGINT 8
9 FLEXI_XS_RSN_CODE_2 CHARACTER VARYING(4) 4
10 FLEXI_XS_AMT_2 NUMERIC(18,6) 19
11 VEH_RATING_NUM_YRS BIGINT 8
12 RATING_1_NUM_YRS BIGINT 8
13 LIFETIME_RATING_1_IND CHARACTER VARYING(3) 3
14 LIFETIME_RATING_1_YRS BIGINT 8
15 VEH_USG_ID BIGINT 8
16 VEH_USG_CODE CHARACTER VARYING(4) 4
17 ADTNL_DRVR_CNT BIGINT 8
18 FAMILY_INSD_IND CHARACTER VARYING(3) 3
19 XS_OPT_ID BIGINT 8
20 XS_OPT_CODE CHARACTER VARYING(4) 4
21 PREV_INSRR_ID BIGINT 8
22 PREV_INSRR_CODE CHARACTER VARYING(4) 4
23 PREV_INSRR_EXPIRY_DATE TIMESTAMP 8
24 PREV_INSRR_PREM_AMT NUMERIC(18,6) 19
25 VEH_XS_STD_AMT NUMERIC(18,6) 19
26 VEH_XS_HIRE_PRCH_AMT NUMERIC(18,6) 19
27 VEH_XS_MDFCTN_AMT NUMERIC(18,6) 19
28 VEH_XS_TOT_AMT NUMERIC(18,6) 19
29 THFT_XS_VEH_AMT NUMERIC(18,6) 19
30 THFT_XS_HSTRCL_AMT NUMERIC(18,6) 19
31 THFT_XS_TOT_AMT NUMERIC(18,6) 19
32 VEH_XS_CAT_CODE CHARACTER VARYING(4) 4
33 THFT_XS_CAT_CODE CHARACTER VARYING(4) 4
34 BUS_USE_XS_AMT NUMERIC(18,6) 19
35 VEH_ACC_CODE_1 CHARACTER VARYING(20) 20
36 VEH_ACC_VAL_1 BIGINT 8
37 VEH_ACC_CODE_2 CHARACTER VARYING(20) 20
38 VEH_ACC_VAL_2 BIGINT 8
39 VEH_ACC_CODE_3 CHARACTER VARYING(20) 20
40 VEH_ACC_VAL_3 BIGINT 8
41 VEH_ACC_CODE_4 CHARACTER VARYING(20) 20
42 VEH_ACC_VAL_4 BIGINT 8
43 VEH_ACC_CODE_5 CHARACTER VARYING(20) 20
44 VEH_ACC_VAL_5 BIGINT 8
45 VEH_ACC_CODE_6 CHARACTER VARYING(20) 20
46 VEH_ACC_VAL_6 BIGINT 8
47 VEH_ACC_CODE_7 CHARACTER VARYING(20) 20
48 VEH_ACC_VAL_7 BIGINT 8
49 VEH_ACC_CODE_8 CHARACTER VARYING(20) 20
50 VEH_ACC_VAL_8 BIGINT 8
51 VEH_ACC_CODE_9 CHARACTER VARYING(20) 20
52 VEH_ACC_VAL_9 BIGINT 8
53 VEH_ACC_CODE_10 CHARACTER VARYING(20) 20
54 VEH_ACC_VAL_10 BIGINT 8
55 VEH_ACC_CODE_11 CHARACTER VARYING(20) 20
56 VEH_ACC_VAL_11 BIGINT 8
57 VEH_ACC_CODE_12 CHARACTER VARYING(20) 20
58 VEH_ACC_VAL_12 BIGINT 8
59 VEH_ACC_CODE_13 CHARACTER VARYING(20) 20
60 VEH_ACC_VAL_13 BIGINT 8
61 VEH_ACC_CODE_14 CHARACTER VARYING(20) 20
62 VEH_ACC_VAL_14 BIGINT 8
63 VEH_ACC_CODE_15 CHARACTER VARYING(20) 20
64 VEH_ACC_VAL_15 BIGINT 8
65 VEH_ACC_CODE_16 CHARACTER VARYING(20) 20
66 VEH_ACC_VAL_16 BIGINT 8
67 VEH_ACC_CODE_17 CHARACTER VARYING(20) 20
68 VEH_ACC_VAL_17 BIGINT 8
69 VEH_ACC_CODE_18 CHARACTER VARYING(20) 20
70 VEH_ACC_VAL_18 BIGINT 8
71 VEH_ACC_CODE_19 CHARACTER VARYING(20) 20
72 VEH_ACC_VAL_19 BIGINT 8
73 VEH_ACC_CODE_20 CHARACTER VARYING(20) 20
74 VEH_ACC_VAL_20 BIGINT 8
75 VEH_MDFCTN_CODE_1 CHARACTER VARYING(20) 20
76 VEH_MDFCTN_CODE_2 CHARACTER VARYING(20) 20
77 VEH_MDFCTN_CODE_3 CHARACTER VARYING(20) 20
78 VEH_MDFCTN_CODE_4 CHARACTER VARYING(20) 20
79 VEH_MDFCTN_CODE_5 CHARACTER VARYING(20) 20
80 DRVR_CNVCTN_CODE_1 CHARACTER VARYING(20) 20
81 DRVR_CNVCTN_CODE_2 CHARACTER VARYING(20) 20
82 DRVR_CNVCTN_CODE_3 CHARACTER VARYING(20) 20
83 BUS_DIV_ID BIGINT 8
84 BUS_DIV_CODE CHARACTER VARYING(4) 4
85 VEH_BNFT_CODE_1 CHARACTER VARYING(20) 20
86 VEH_BNFT_CODE_2 CHARACTER VARYING(20) 20
87 VEH_BNFT_CODE_3 CHARACTER VARYING(20) 20
88 VEH_BNFT_CODE_4 CHARACTER VARYING(20) 20
89 VEH_BNFT_CODE_5 CHARACTER VARYING(20) 20
90 VEH_BNFT_CODE_6 CHARACTER VARYING(20) 20
91 RISK_DESC CHARACTER VARYING(50) 50
92 DATA_LOAD_DATE TIMESTAMP 8
93 SNPSHT_DATE TIMESTAMP 8
94 SRC_SYS_ID CHARACTER VARYING(5) 5
95 LOAD_ID BIGINT 8
96 INTN_CLIENT_NUM DOUBLE PRECISION 8
97 NEW_BUS_SRC_ID DOUBLE PRECISION 8
98 NEW_BUS_SRC_CODE CHARACTER VARYING(20) 20
99 FIRE_BRIGADE_AREA_ID DOUBLE PRECISION 8
100 FIRE_BRIGADE_AREA_CODE CHARACTER VARYING(20) 20
101 SUM_INSD_TYP_ID DOUBLE PRECISION 8
102 SUM_INSD_TYP_CODE CHARACTER VARYING(20) 20
103 MOTOR_VEH_PT_NUM DOUBLE PRECISION 8
104 VEH_NO_CLM_BONUS_CNFRMTIN_ID DOUBLE PRECISION 8
105 VEH_NO_CLM_BONUS_CNFRMTIN_CODE CHARACTER VARYING(20) 20
106 VEH_PARK_AREA_ID DOUBLE PRECISION 8
107 VEH_PARK_AREA_CODE CHARACTER VARYING(20) 20
108 DRVR_RSTRCTN_ID DOUBLE PRECISION 8
109 DRVR_RSTRCTN_CODE CHARACTER VARYING(3) 3
110 LEGAL_LIAB_GAP_COV_FLG CHARACTER VARYING(1) 1
111 TRLR_EXTSN_COV_IND CHARACTER VARYING(3) 3
112 VEH_ACC_FLG CHARACTER VARYING(1) 1
113 VEH_YRLY_DSTNCE_TRAVEL_ID DOUBLE PRECISION 8
114 VEH_YRLY_DSTNCE_TRAVEL_CODE CHARACTER VARYING(3) 3
115 CARAVAN_SAFETY_DISC_FLG CHARACTER VARYING(1) 1
116 CARAVAN_HIRED_IND CHARACTER VARYING(3) 3
117 CARAVAN_CHASSIS_NUM CHARACTER VARYING(20) 20
118 CARAVAN_ANNEX_IND CHARACTER VARYING(3) 3
119 CUST_CHNL_REF_CODE CHARACTER VARYING(20) 20
120 BUS_TXN_INCMPLT_STAT_ID DOUBLE PRECISION 8
121 BUS_TXN_INCMPLT_STAT_CODE CHARACTER VARYING(3) 3
122 MISC_RBTE_PCTAGE NUMERIC(10,4) 19
123 MISC_LDNG_PCTAGE NUMERIC(10,4) 19
124 TXN_PREM_CALC_OVRDE_RSN_ID DOUBLE PRECISION 8
125 TXN_PREM_CALC_OVRDE_RSN_CODE CHARACTER VARYING(20) 20
126 ANN_PREM_CALC_OVRDE_RSN_ID DOUBLE PRECISION 8
127 ANN_PREM_CALC_OVRDE_RSN_CODE CHARACTER VARYING(20) 20
128 PREV_INSD_IND CHARACTER VARYING(3) 3
129 DISC_GRP_ID DOUBLE PRECISION 8
130 DISC_GRP_CODE CHARACTER VARYING(20) 20
131 POL_REN_NOTICE_STAT_IND CHARACTER VARYING(1) 1
132 POL_REN_NOTICE_TYP_CODE CHARACTER VARYING(1) 1
133 RISK_CVRG_GRP_CODE CHARACTER VARYING(2) 2
134 VEH_MDFCTN_IND CHARACTER VARYING(1) 1
135 TXN_IMG_FLG CHARACTER VARYING(1) 1
136 POL_LOCK_UID CHARACTER VARYING(20) 20
137 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
138 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
139 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
140 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8