CFDRPT_TCFDS_PERS_INS_RISK_DTL_SNP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 POL_NUM CHARACTER VARYING(20) 20
4 CUST_NUM CHARACTER VARYING(20) 20
5 HOUSEHOLD_ID DOUBLE PRECISION 8
6 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
7 CUST_RISK_SHARE_VAL NUMERIC(18,6) 19
8 RISK_SHARE_HH_VAL NUMERIC(18,6) 19
9 PRDT_BRND_CODE CHARACTER VARYING(10) 10
10 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(20) 20
11 ENTITY_TYP_DESC CHARACTER VARYING(50) 50
12 DERIVED_POL_NUM CHARACTER VARYING(20) 20
13 PRDT_ID DOUBLE PRECISION 8
14 PRDT_DESC CHARACTER VARYING(100) 100
15 PRDT_GRP_CODE CHARACTER VARYING(20) 20
16 PRDT_TYP_CODE CHARACTER VARYING(20) 20
17 PRDT_SUB_TYP_CODE CHARACTER VARYING(20) 20
18 CVRG_TYP_CODE CHARACTER VARYING(5) 5
19 PRDT_SGMNT_GRP_CODE CHARACTER VARYING(20) 20
20 GWP_TOT_AMT NUMERIC(18,6) 19
21 GWP_CUST_SHARE_AMT NUMERIC(18,6) 19
22 ANN_PREM_TOT_AMT NUMERIC(18,6) 19
23 ANN_PREM_CUST_SHARE_AMT NUMERIC(18,6) 19
24 DERIVED_SUM_INSD_AMT NUMERIC(18,6) 19
25 POL_STRT_DATE TIMESTAMP 8
26 RISK_STRT_DATE TIMESTAMP 8
27 RISK_EXPIRY_DATE TIMESTAMP 8
28 RISK_RENEWED_DATE TIMESTAMP 8
29 PAYT_FREQ_DESC CHARACTER VARYING(50) 50
30 CHNL_TYP_CODE CHARACTER VARYING(20) 20
31 CHNL_DESC CHARACTER VARYING(50) 50
32 PREV_MTH_CUST_NUM CHARACTER VARYING(20) 20
33 PREV_MTH_HH_ID DOUBLE PRECISION 8
34 REN_PAID_IND CHARACTER VARYING(5) 5
35 PREM_PAYT_DATE TIMESTAMP 8
36 SRC_SYS_ID CHARACTER VARYING(5) 5
37 SNPSHT_DATE TIMESTAMP 8
38 DATA_LOAD_DATE TIMESTAMP 8
39 LOAD_ID DOUBLE PRECISION 8
40 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
41 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8