CFD_TCFDD_CCI_LOAN_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCI_LN_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
3 PRDT_SYS_CODE CHARACTER VARYING(10) 10
4 PRDT_HOLDNG_ID BIGINT 8
5 ACTV_IND CHARACTER VARYING(1) 1
6 AGNT_ID BIGINT 8
7 GLOSSY_ID BIGINT 8
8 BRCH_ID BIGINT 8
9 CHNL_ID BIGINT 8
10 PAYT_METH_ID BIGINT 8
11 USG_PURP_ID BIGINT 8
12 AGNT_CHCK_DGT CHARACTER VARYING(10) 10
13 FNNCER_NAM_1 CHARACTER VARYING(100) 100
14 FNNCER_NAM_2 CHARACTER VARYING(100) 100
15 PRCH_AMT NUMERIC(18,6) 19
16 SERV_IC_NAM CHARACTER VARYING(100) 100
17 ACCT_BAL NUMERIC(18,6) 19
18 SUM_INSD_AMT NUMERIC(18,6) 19
19 ANN_PREM_AMT NUMERIC(18,6) 19
20 SD_AMT NUMERIC(18,6) 19
21 EFF_STRT_DATE TIMESTAMP 8
22 EFF_END_DATE TIMESTAMP 8
23 SNPSHT_DATE TIMESTAMP 8
24 DATA_LOAD_DATE TIMESTAMP 8
25 SRC_SYS_ID CHARACTER VARYING(5) 5
26 LOAD_ID BIGINT 8
27 PRDT_ID BIGINT 8
28 PRDT_STRT_DATE TIMESTAMP 8
29 PRDT_END_DATE TIMESTAMP 8
30 BRCH_CODE CHARACTER VARYING(20) 20
31 PAYT_METH_CODE CHARACTER VARYING(20) 20
32 PAYT_FREQ_CODE CHARACTER VARYING(20) 20
33 ASIS_CODE CHARACTER VARYING(20) 20
34 AGNT_CODE CHARACTER VARYING(20) 20
35 POL_STRT_DATE TIMESTAMP 8
36 INSTLMNT_PREM_AMT NUMERIC(18,6) 19
37 CVRG_STAT_ID BIGINT 8
38 CVRG_STAT_CODE CHARACTER VARYING(20) 20
39 POL_STAT_ID BIGINT 8
40 POL_STAT_CODE CHARACTER VARYING(20) 20
41 POL_STAT_EFF_DATE TIMESTAMP 8
42 POL_STAT_RGSTN_DATE TIMESTAMP 8
43 PREV_INSD_FLG CHARACTER VARYING(1) 1
44 SD_STATE_ID BIGINT 8
45 SD_STAT_CODE CHARACTER VARYING(20) 20
46 INSTLMNT_SD_AMT NUMERIC(18,6) 19
47 ANN_SD_AMT NUMERIC(18,6) 19
48 DSBLTY_WAIT_PERD BIGINT 8
49 DSBLTY_SICK_PERD_CODE CHARACTER VARYING(20) 20
50 DSBLTY_SICK_PERD BIGINT 8
51 DSBLTY_ACDNT_PERD_CODE CHARACTER VARYING(20) 20
52 DSBLTY_ACDNT_PERD BIGINT 8
53 DSBLTY_OCCUP_CLASS_ID BIGINT 8
54 DSBLTY_OCCUP_CLASS_CODE BIGINT 8
55 INSD_RISK_SURRENDER_VAL NUMERIC(18,6) 19
56 INSD_OCCUP_ID BIGINT 8
57 INSD_OCCUP_CODE CHARACTER VARYING(20) 20
58 INSD_SMKR_IND CHARACTER VARYING(1) 1
59 INSD_ENTRY_AGE_YR BIGINT 8
60 CVRG_STAT_DATE TIMESTAMP 8
61 CVRG_STAT_EFF_DATE TIMESTAMP 8
62 EQUIVALENT_ANN_PREM_AMT NUMERIC(18,6) 19
63 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
64 GLOSSY_CODE CHARACTER VARYING(20) 20
65 SINGLE_PREM_AMT NUMERIC(18,6) 19
66 BRKR_TYP_ID BIGINT 8
67 BRKR_TYP_CODE CHARACTER VARYING(20) 20
68 UNT_TYP_ID BIGINT 8
69 UNIT_TYP_CODE CHARACTER VARYING(20) 20
70 PAYT_FREQ_ID BIGINT 8
71 LIFE_POL_ID BIGINT 8
72 POL_NUM CHARACTER VARYING(20) 20
73 CHNL_CODE CHARACTER VARYING(10) 10
74 SUB_CHNL_ID BIGINT 8
75 SUB_CHNL_CODE CHARACTER VARYING(20) 20
76 DSBLTY_WAIT_PERD_CODE CHARACTER VARYING(20) 20
77 REPLACED_BUS_FLG CHARACTER VARYING(1) 1
78 OLD_PRDT_ID BIGINT 8
79 OLD_POL_NUM CHARACTER VARYING(20) 20
80 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
81 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
82 PROMO_CODE CHARACTER VARYING(12) 12
83 U_NUMBER CHARACTER VARYING(8) 8
84 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
85 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
86 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
87 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8