CFD_TCFDD_COMMERCIAL_INSUR_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CMRCL_INS_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 BRCH_ID DOUBLE PRECISION 8
8 CHNL_ID DOUBLE PRECISION 8
9 VEH_MAKE_ID DOUBLE PRECISION 8
10 GLOSSY_ID DOUBLE PRECISION 8
11 PAYT_METH_ID DOUBLE PRECISION 8
12 VEH_MODEL_ID DOUBLE PRECISION 8
13 PAYT_FREQ_ID DOUBLE PRECISION 8
14 POL_DISC_IND CHARACTER VARYING(4) 4
15 AGNT_CHCK_DGT CHARACTER VARYING(10) 10
16 FNNCER_NAM_1 CHARACTER VARYING(100) 100
17 FNNCER_NAM_2 CHARACTER VARYING(100) 100
18 ACCT_BAL NUMERIC(18,6) 19
19 SUM_INSD_AMT NUMERIC(18,6) 19
20 ANN_PREM_AMT NUMERIC(18,6) 19
21 LEVIES_AMT NUMERIC(18,6) 19
22 SD_AMT NUMERIC(18,6) 19
23 SERV_IC_NAM CHARACTER VARYING(100) 100
24 MANUFACTURE_YR CHARACTER VARYING(10) 10
25 LUMP_SUM_AMT NUMERIC(18,6) 19
26 EFF_STRT_DATE TIMESTAMP 8
27 EFF_END_DATE TIMESTAMP 8
28 DATA_LOAD_DATE TIMESTAMP 8
29 SNPSHT_DATE TIMESTAMP 8
30 SRC_SYS_ID CHARACTER VARYING(5) 5
31 LOAD_ID DOUBLE PRECISION 8
32 PRDT_ID DOUBLE PRECISION 8
33 INS_STRT_DATE TIMESTAMP 8
34 INS_END_DATE TIMESTAMP 8
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8