CFD_TCFDR_SUPER_INSRNCE_SUB_TYPE

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INS_SUB_TYP_ID DOUBLE PRECISION 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 INS_SUB_TYP_CODE CHARACTER VARYING(20) 20
4 INS_SUB_TYP_NAM CHARACTER VARYING(50) 50
5 INS_TYP_CODE CHARACTER VARYING(20) 20
6 INS_TYP_NAM CHARACTER VARYING(50) 50
7 INS_SUB_TYP_STAT_CODE CHARACTER VARYING(10) 10
8 INS_SUB_TYP_STRT_DATE TIMESTAMP 8
9 INS_SUB_TYP_END_DATE TIMESTAMP 8
10 NO_UWRITING_MAX_COV_AMT NUMERIC(18,2) 19
11 UWRITING_MAX_COV_AMT NUMERIC(18,2) 19
12 MAX_COV_TOPUP_AMT NUMERIC(18,2) 19
13 COV_UNIT_AMT NUMERIC(18,2) 19
14 FACTOR1_NAM CHARACTER VARYING(10) 10
15 FACTOR1_INDEX_FLG CHARACTER VARYING(1) 1
16 FACTOR2_NAM CHARACTER VARYING(10) 10
17 FACTOR2_INDEX_FLG CHARACTER VARYING(1) 1
18 FACTOR3_NAM CHARACTER VARYING(10) 10
19 FACTOR3_INDEX_FLG CHARACTER VARYING(1) 1
20 BNFT_WAIT_PERD DOUBLE PRECISION 8
21 BNFT_WAIT_PERD_TYP_CODE CHARACTER VARYING(1) 1
22 BNFT_PERD DOUBLE PRECISION 8
23 BNFT_PERD_TYP_CODE CHARACTER VARYING(1) 1
24 DEF_RVW_DATE TIMESTAMP 8
25 INITIATE_FOLLOWUP_DAY_CNT DOUBLE PRECISION 8
26 PREDEFINED_FLD_COV_UNIT_CNT DOUBLE PRECISION 8
27 LDNG_METH_FLG CHARACTER VARYING(20) 20
28 NXT_RVW_IN_MONTHS DOUBLE PRECISION 8
29 RVW_BASE_FLG CHARACTER VARYING(1) 1
30 RIDER_FLG CHARACTER VARYING(1) 1
31 PREM_GRP_RT_FLG CHARACTER VARYING(20) 20
32 CORP_TO_PRSN_SUB_TYP_CODE DOUBLE PRECISION 8
33 STAMP_DUTY_VALID_FLG CHARACTER VARYING(1) 1
34 DEATH_COV_FLG CHARACTER VARYING(1) 1
35 SALARY_PERSIST_COV_FLG CHARACTER VARYING(1) 1
36 DSBLTY_COV_FLG CHARACTER VARYING(3) 3
37 TRAUMA_FLG CHARACTER VARYING(1) 1
38 DATA_LOAD_DATE TIMESTAMP 8
39 SNPSHT_DATE TIMESTAMP 8
40 SRC_SYS_ID CHARACTER VARYING(5) 5
41 LOAD_ID DOUBLE PRECISION 8
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