FCT_CUST_CTP_INSURANCE_PH

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CTP_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 PRDT_ID BIGINT 8
7 PRDT_TYP_CODE CHARACTER VARYING(20) 20
8 PRDT_GRP_CODE CHARACTER VARYING(20) 20
9 POL_NUM CHARACTER VARYING(20) 20
10 CVRG_NUM CHARACTER VARYING(4) 4
11 TRM_ID CHARACTER VARYING(20) 20
12 CRNT_TXN_NUM CHARACTER VARYING(4) 4
13 NEW_SEQ DOUBLE PRECISION 8
14 REVL_IND CHARACTER VARYING(20) 20
15 CVRG_RENEWED_DATE TIMESTAMP 8
16 CVRG_EXPIRY_DATE TIMESTAMP 8
17 CVRG_CHG_EFF_DATE TIMESTAMP 8
18 ANN_PREM_AMT NUMERIC(18,6) 19
19 BASE_PREM_AMT NUMERIC(18,6) 19
20 CVRG_STAT_ID BIGINT 8
21 CVRG_STAT_CODE CHARACTER VARYING(20) 20
22 CVRG_TYP_CODE CHARACTER VARYING(4) 4
23 CANC_LAPSE_IND CHARACTER VARYING(20) 20
24 CANCEL_RSN_ID BIGINT 8
25 CANCEL_RSN_CODE CHARACTER VARYING(20) 20
26 TXN_INFORCE_IND DOUBLE PRECISION 8
27 INFORCE_INC_DATE TIMESTAMP 8
28 INFORCE_EXPIRY_DATE TIMESTAMP 8
29 STATE_ID BIGINT 8
30 STATE CHARACTER VARYING(3) 3
31 USG_PURP_ID BIGINT 8
32 USG_PURP_CODE CHARACTER VARYING(4) 4
33 VEH_MAKE_ID BIGINT 8
34 VEH_MAKE_CODE CHARACTER VARYING(20) 20
35 VEH_MODEL_ID BIGINT 8
36 VEH_MODEL_CODE CHARACTER VARYING(20) 20
37 VEH_BODYSTYLE_ID BIGINT 8
38 VEH_BODYSTYLE_CODE CHARACTER VARYING(20) 20
39 POL_EFF_DATE TIMESTAMP 8
40 RISK_SBRB CHARACTER VARYING(50) 50
41 RISK_POST_CODE CHARACTER VARYING(8) 8
42 BRCH_ID BIGINT 8
43 BRCH_CODE CHARACTER VARYING(20) 20
44 CHNL_ID BIGINT 8
45 CHNL_CODE CHARACTER VARYING(20) 20
46 PAYT_FREQ_ID BIGINT 8
47 PAYT_FREQ_CODE CHARACTER VARYING(20) 20
48 PAYT_STAT_ID BIGINT 8
49 PAYT_STAT_CODE CHARACTER VARYING(20) 20
50 TXN_TYP_ID BIGINT 8
51 TXN_TYP_CODE CHARACTER VARYING(20) 20
52 CRNT_ITC_FLG CHARACTER VARYING(1) 1
53 FTR_ITC_FLG CHARACTER VARYING(1) 1
54 NVIC CHARACTER VARYING(10) 10
55 GIO_VEH_NUM CHARACTER VARYING(10) 10
56 MANUFACTURE_YR CHARACTER VARYING(4) 4
57 RGSTN_NUM CHARACTER VARYING(20) 20
58 RGSTN_STRT_DATE TIMESTAMP 8
59 VEH_USG CHARACTER VARYING(20) 20
60 VEH_CLASS CHARACTER VARYING(5) 5
61 BUS_IND CHARACTER VARYING(20) 20
62 EFF_STRT_DATE TIMESTAMP 8
63 EFF_END_DATE TIMESTAMP 8
64 SNPSHT_DATE TIMESTAMP 8
65 SRC_SYS_ID CHARACTER VARYING(5) 5
66 DATA_LOAD_DATE TIMESTAMP 8
67 LOAD_ID BIGINT 8
68 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
69 BUS_DIV_ID DOUBLE PRECISION 8
70 BUS_DIV_CODE CHARACTER VARYING(4) 4
71 VIN_CHASSIS_NUM CHARACTER VARYING(25) 25
72 REN_TRM_PERD DOUBLE PRECISION 8
73 SERV_IC_NAM CHARACTER VARYING(100) 100
74 COMM_CODE CHARACTER VARYING(10) 10
75 VEH_INSD_IND CHARACTER VARYING(1) 1
76 SPCL_DISC_IND CHARACTER VARYING(1) 1
77 INS_STRT_DATE TIMESTAMP 8
78 INS_END_DATE TIMESTAMP 8
79 PRDT_STAT_CODE CHARACTER VARYING(20) 20
80 ADDR_REF_NUM DOUBLE PRECISION 8
81 DERIVED_TXN_NUM DOUBLE PRECISION 8
82 OLD_PRDT_ID DOUBLE PRECISION 8
83 OLD_POL_NUM CHARACTER VARYING(20) 20
84 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
85 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
86 OLD_CVRG_NUM CHARACTER VARYING(4) 4
87 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
88 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
89 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
90 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8