CFD_TCFDD_MOTOR_INSURANCE_PH

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(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 PRDT_HOLDNG_ID BIGINT 8
5 PRDT_BRND_CODE CHARACTER VARYING(20) 20
6 POL_NUM CHARACTER VARYING(20) 20
7 CVRG_NUM CHARACTER VARYING(6) 6
8 TRM_ID CHARACTER VARYING(20) 20
9 CRNT_TXN_NUM CHARACTER VARYING(4) 4
10 REVL_IND CHARACTER VARYING(1) 1
11 PRDT_CLASS_CODE CHARACTER VARYING(1) 1
12 CMPY_CODE CHARACTER VARYING(20) 20
13 CVRG_TYP_CODE CHARACTER VARYING(3) 3
14 POL_STAT_ID BIGINT 8
15 AGNT_CHCK_DGT CHARACTER VARYING(10) 10
16 AGNT_ADDR_CODE CHARACTER VARYING(2) 2
17 AGNT_ID BIGINT 8
18 SERV_IC_NAM CHARACTER VARYING(100) 100
19 BRCH_ID BIGINT 8
20 CHNL_ID BIGINT 8
21 FNNCER_NAM_1 CHARACTER VARYING(100) 100
22 FNNCER_NAM_2 CHARACTER VARYING(100) 100
23 POL_STRT_DATE TIMESTAMP 8
24 CVRG_RENEWED_DATE TIMESTAMP 8
25 CVRG_EXPIRY_DATE TIMESTAMP 8
26 CVRG_CHG_EFF_DATE TIMESTAMP 8
27 CVRG_CHG_EXPIRY_DATE TIMESTAMP 8
28 TXN_EFF_DATE TIMESTAMP 8
29 POL_DISC_IND CHARACTER VARYING(4) 4
30 PAYT_FREQ_ID BIGINT 8
31 NVIC CHARACTER VARYING(10) 10
32 RGSTN_NUM CHARACTER VARYING(20) 20
33 CANCEL_RSN_ID BIGINT 8
34 CVRG_STAT_ID BIGINT 8
35 FIN_TYP_ID BIGINT 8
36 VEH_MAKE_ID BIGINT 8
37 VEH_MODEL_ID BIGINT 8
38 VEH_BODYSTYLE_ID BIGINT 8
39 VEH_SUM_INSD_AMT NUMERIC(18,6) 19
40 VEH_MARKET_VAL_AMT NUMERIC(18,6) 19
41 MANUFACTURE_YR CHARACTER VARYING(10) 10
42 FAMILY_NO_CLM_DISC_IND CHARACTER VARYING(3) 3
43 EFF_STRT_DATE TIMESTAMP 8
44 EFF_END_DATE TIMESTAMP 8
45 DATA_LOAD_DATE TIMESTAMP 8
46 SNPSHT_DATE TIMESTAMP 8
47 SRC_SYS_ID CHARACTER VARYING(5) 5
48 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
49 LOAD_ID BIGINT 8
50 PRDT_ID BIGINT 8
51 VEH_ID_NUM CHARACTER VARYING(30) 30
52 VEH_CLASS CHARACTER VARYING(3) 3
53 VEH_XS_AMT NUMERIC(18,6) 19
54 VOLUN_XS_AMT NUMERIC(18,6) 19
55 COMPULSORY_XS_AMT NUMERIC(18,6) 19
56 BASE_XS_AMT NUMERIC(18,6) 19
57 HAIL_XS_AMT NUMERIC(18,6) 19
58 PUNITIVE_XS_AMT NUMERIC(18,6) 19
59 THFT_XS_AMT NUMERIC(18,6) 19
60 AGE_XS_AMT NUMERIC(18,6) 19
61 HARD_TO_PLACE_XS_AMT NUMERIC(18,6) 19
62 FLEX_XS_AMT NUMERIC(18,6) 19
63 NO_CLM_DISC_APPLD NUMERIC(18,6) 19
64 PRDT_VAR_CODE CHARACTER VARYING(3) 3
65 PRNT_POL_NUM CHARACTER VARYING(20) 20
66 MULTI_POL_DISC_IND CHARACTER VARYING(1) 1
67 SENIOR_DISC_IND CHARACTER VARYING(1) 1
68 CTP_DISC_IND CHARACTER VARYING(1) 1
69 CTP_DISC_AMT NUMERIC(18,6) 19
70 RETIRED_DISC_IND CHARACTER VARYING(1) 1
71 STAFF_DISC_IND CHARACTER VARYING(1) 1
72 WINDSCREEN_OPT_IND CHARACTER VARYING(1) 1
73 HIRE_CAR_OPT_IND CHARACTER VARYING(1) 1
74 CAR_ALM_IND CHARACTER VARYING(1) 1
75 LURN CHARACTER VARYING(40) 40
76 LURN_SCALE CHARACTER VARYING(1) 1
77 RTD_RISK_BRTH_DATE TIMESTAMP 8
78 RTD_RISK_GNDR CHARACTER VARYING(10) 10
79 NAMD_DRVR_IND CHARACTER VARYING(1) 1
80 PURP_OF_USE_CODE CHARACTER VARYING(3) 3
81 RGSTN_EXPIRY_DATE TIMESTAMP 8
82 GARAGED_SUBURB CHARACTER VARYING(50) 50
83 GARAGED_POST_CODE CHARACTER VARYING(6) 6
84 TURBO_CHRGD CHARACTER VARYING(1) 1
85 PRCH_DATE TIMESTAMP 8
86 PRCH_PRICE NUMERIC(18,6) 19
87 TXN_INFORCE_IND BIGINT 8
88 VEH_RATING CHARACTER VARYING(2) 2
89 VEH_CATEGORY_CODE CHARACTER VARYING(3) 3
90 USG_PURP_ID BIGINT 8
91 PRDT_STAT_CODE CHARACTER VARYING(20) 20
92 INS_STRT_DATE TIMESTAMP 8
93 INS_END_DATE TIMESTAMP 8
94 ADDR_REF_NUM BIGINT 8
95 DERIVED_TXN_NUM DOUBLE PRECISION 8
96 LIFETIME_CMPLT_RPLCMNT_FLG CHARACTER VARYING(3) 3
97 OLD_PRDT_ID DOUBLE PRECISION 8
98 OLD_POL_NUM CHARACTER VARYING(20) 20
99 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
100 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
101 OLD_CVRG_NUM CHARACTER VARYING(4) 4
102 POL_END_CONSNT_IND CHARACTER VARYING(1) 1
103 ROAD_SIDE_ASSIST_IND CHARACTER VARYING(1) 1
104 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
105 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
106 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
107 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8