CFD_TCFDD_LIFE_RISK_CVRG_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LIFE_RISK_CVRG_DETL_ID BIGINT 8
2 LIFE_RISK_PRDT_HOLDNG_ID BIGINT 8
3 PRDT_SYS_CODE CHARACTER VARYING(10) 10
4 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
5 LYR_NUM BIGINT 8
6 LYR_STAT_ID BIGINT 8
7 LYR_STAT_CODE CHARACTER VARYING(20) 20
8 LYR_STAT_EFF_DATE TIMESTAMP 8
9 LYR_STAT_RGSTN_DATE TIMESTAMP 8
10 LYR_SUM_INSD_AMT NUMERIC(18,6) 19
11 MDCL_LDNG_PCTAGE NUMERIC(10,4) 19
12 LYR_ANN_PREM_AMT NUMERIC(18,6) 19
13 LYR_INSTLMT_PREM_AMT NUMERIC(18,6) 19
14 SD_AMT NUMERIC(18,6) 19
15 SD_PCTAGE NUMERIC(10,4) 19
16 OTH_LDNG_AMT NUMERIC(18,6) 19
17 OTH_LDNG_PCTAGE NUMERIC(10,4) 19
18 RISK_EXCLUSION1_ID BIGINT 8
19 RISK_EXCLUSION1_CODE CHARACTER VARYING(20) 20
20 RISK_EXCLUSION2_ID BIGINT 8
21 RISK_EXCLUSION2_CODE CHARACTER VARYING(20) 20
22 RISK_EXCLUSION3_ID BIGINT 8
23 RISK_EXCLUSION3_CODE CHARACTER VARYING(20) 20
24 RISK_EXCLUSION4_ID BIGINT 8
25 RISK_EXCLUSION4_CODE CHARACTER VARYING(20) 20
26 RISK_EXCLUSION5_ID BIGINT 8
27 RISK_EXCLUSION5_CODE CHARACTER VARYING(20) 20
28 LYR_END_DATE TIMESTAMP 8
29 EFF_STRT_DATE TIMESTAMP 8
30 EFF_END_DATE TIMESTAMP 8
31 SNPSHT_DATE TIMESTAMP 8
32 DATA_LOAD_DATE TIMESTAMP 8
33 SRC_SYS_ID CHARACTER VARYING(5) 5
34 LOAD_ID BIGINT 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