CFD_TCFDD_LIFE_RISK_ADJUSTMENT_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LIFE_RISK_ADJ_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 LIFE_RISK_PRDT_HOLDNG_ID BIGINT 8
5 ADJ_NUM BIGINT 8
6 ADJ_EFF_DATE TIMESTAMP 8
7 ADJ_EXPIRY_DATE TIMESTAMP 8
8 ADJ_IN_YRS BIGINT 8
9 REASSURANCE_IND CHARACTER VARYING(3) 3
10 SUB_STD_LIFE_IND CHARACTER VARYING(3) 3
11 ADJ_ID BIGINT 8
12 ADJ_CODE CHARACTER VARYING(20) 20
13 ADJ_PCTAGE NUMERIC(10,4) 19
14 ADJ_PREM_AMT NUMERIC(18,6) 19
15 ADJ_AGE_YRS BIGINT 8
16 FIN_DISC_IND CHARACTER VARYING(3) 3
17 SPCL_WORDING_IND CHARACTER VARYING(3) 3
18 ADD_PCTAGE_IND CHARACTER VARYING(3) 3
19 LTD_TRM_IND CHARACTER VARYING(3) 3
20 HEALTHY_PLUS_OPT_IND CHARACTER VARYING(3) 3
21 EFF_END_DATE TIMESTAMP 8
22 EFF_STRT_DATE TIMESTAMP 8
23 DATA_LOAD_DATE TIMESTAMP 8
24 SNPSHT_DATE TIMESTAMP 8
25 SRC_SYS_ID CHARACTER VARYING(5) 5
26 LOAD_ID BIGINT 8
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8