CFD_TCFDD_LIFE_RSK_INSRNCE_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LIFE_RISK_INS_PRDT_HOLDING_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 GLOSSY_ID DOUBLE PRECISION 8
9 CHNL_ID DOUBLE PRECISION 8
10 PAYT_METH_ID DOUBLE PRECISION 8
11 PAYT_FREQ_ID DOUBLE PRECISION 8
12 USG_PURP_ID DOUBLE PRECISION 8
13 POL_DISC_IND CHARACTER VARYING(4) 4
14 AGNT_CHCK_DGT CHARACTER VARYING(10) 10
15 FNNCER_NAM_1 CHARACTER VARYING(100) 100
16 FNNCER_NAM_2 CHARACTER VARYING(100) 100
17 PRCH_AMT NUMERIC(18,6) 19
18 LUMP_SUM_BNFT_AMT NUMERIC(18,6) 19
19 SERV_IC_NAM CHARACTER VARYING(100) 100
20 ACCT_BAL NUMERIC(18,6) 19
21 SUM_INSD_AMT NUMERIC(18,6) 19
22 ANN_PREM_AMT NUMERIC(18,6) 19
23 SD_AMT NUMERIC(18,6) 19
24 LEVIES_AMT NUMERIC(18,6) 19
25 EFF_STRT_DATE TIMESTAMP 8
26 EFF_END_DATE TIMESTAMP 8
27 SNPSHT_DATE TIMESTAMP 8
28 DATA_LOAD_DATE TIMESTAMP 8
29 SRC_SYS_ID CHARACTER VARYING(5) 5
30 LOAD_ID DOUBLE PRECISION 8
31 PRDT_ID DOUBLE PRECISION 8
32 INS_STRT_DATE TIMESTAMP 8
33 INS_END_DATE TIMESTAMP 8
34 ASIS_CODE CHARACTER VARYING(20) 20
35 AGNT_CODE CHARACTER VARYING(20) 20
36 BRKR_TYP_ID BIGINT 8
37 BRKR_TYP_CODE CHARACTER VARYING(20) 20
38 BUS_CHNL_CODE CHARACTER VARYING(20) 20
39 DSBLTY_WAIT_PERD BIGINT 8
40 DSBLTY_SICK_PERD_CODE CHARACTER VARYING(10) 10
41 DSBLTY_SICK_PERD BIGINT 8
42 DSBLTY_ACDNT_PERD_CODE CHARACTER VARYING(10) 10
43 DSBLTY_ACDNT_PERD BIGINT 8
44 DSBLTY_OCCUP_CLASS_CODE CHARACTER VARYING(20) 20
45 SMKR_FLG CHARACTER VARYING(1) 1
46 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
47 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
48 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
49 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8