CFD_TCFDT_LIFE_RISK_COMMISSION_TXN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LIFE_RISK_COMM_TXN_ID DOUBLE PRECISION 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 AGNT_ID BIGINT 8
5 AGNT_CODE CHARACTER VARYING(20) 20
6 TXN_NUM DOUBLE PRECISION 8
7 SEQ_NUM DOUBLE PRECISION 8
8 COMM_CALC_EFF_DATE TIMESTAMP 8
9 LIFE_RISK_PRDT_HOLDNG_ID BIGINT 8
10 PRDT_ID BIGINT 8
11 PRDT_TYP_CODE CHARACTER VARYING(20) 20
12 PRDT_GRP_CODE CHARACTER VARYING(20) 20
13 COMM_PREM_AMT NUMERIC(18,6) 19
14 BASIC_COMM_METH_CODE CHARACTER VARYING(10) 10
15 COMM_CAT_ID DOUBLE PRECISION 8
16 COMM_CAT_CODE CHARACTER VARYING(10) 10
17 INIT_COMM_AMT NUMERIC(18,6) 19
18 INIT_COMM_PAYT_METH_ID BIGINT 8
19 INIT_COMM_PAYT_METH_CODE CHARACTER VARYING(10) 10
20 INIT_COMM_PAID_AMT NUMERIC(18,6) 19
21 EARNED_COMM_AMT NUMERIC(18,6) 19
22 PERSISTENT_COMM_PCTAGE NUMERIC(10,4) 19
23 PERSISTENT_COMM_PAYABLE_AMT NUMERIC(18,6) 19
24 PERSISTENT_COMM_PAID_AMT NUMERIC(18,6) 19
25 PERSISTENT_COMM_EARNED_AMT NUMERIC(18,6) 19
26 REN_COMM_PAYT_METH_ID BIGINT 8
27 REN_COMM_PAYT_METH_CODE CHARACTER VARYING(30) 30
28 REN_COMM_DUE_AMT NUMERIC(18,6) 19
29 REN_COMM_EARNED_AMT NUMERIC(18,6) 19
30 SPLT_BASIC_COMM_PCTAGE NUMERIC(10,4) 19
31 INIT_COMM_PCTAGE NUMERIC(10,4) 19
32 INIT_COMM_LESS_SD_IND CHARACTER VARYING(3) 3
33 INIT_COMM_LESS_MODEL_LOAD_IND CHARACTER VARYING(3) 3
34 INIT_COMM_LESS_GST_IND CHARACTER VARYING(3) 3
35 REN_COMM_PCTAGE NUMERIC(10,4) 19
36 REN_COMM_LESS_SD_IND CHARACTER VARYING(3) 3
37 REN_COMM_LESS_MODEL_LOAD_IND CHARACTER VARYING(3) 3
38 REN_COMM_LESS_GST_IND CHARACTER VARYING(3) 3
39 FLEXI_RT_CODE CHARACTER VARYING(4) 4
40 ADTNL_APIA_INIT_COMM_AMT NUMERIC(18,6) 19
41 DATA_LOAD_DATE TIMESTAMP 8
42 SNPSHT_DATE TIMESTAMP 8
43 SRC_SYS_ID CHARACTER VARYING(5) 5
44 LOAD_ID BIGINT 8
45 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
46 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
47 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
48 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8