CFD_TCFDT_MOTOR_INS_POL_TXN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TXN_REF_NUM CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 MOTOR_INS_PRDT_HOLDNG_ID BIGINT 8
5 TRM_ID CHARACTER VARYING(20) 20
6 CRNT_TXN_NUM CHARACTER VARYING(4) 4
7 REVL_IND CHARACTER VARYING(1) 1
8 CVRG_STAT_ID BIGINT 8
9 POL_EFF_DATE TIMESTAMP 8
10 CVRG_RENEWED_DATE TIMESTAMP 8
11 CVRG_EXPIRY_DATE TIMESTAMP 8
12 CVRG_CHG_EFF_DATE TIMESTAMP 8
13 CVRG_CHG_EXPIRY_DATE TIMESTAMP 8
14 TXN_EFF_DATE TIMESTAMP 8
15 TXN_TYP_ID BIGINT 8
16 TXN_DATE TIMESTAMP 8
17 BASE_PREM_AMT NUMERIC(18,6) 19
18 CUMM_BASE_PREM_AMT NUMERIC(18,6) 19
19 SD_AMT NUMERIC(18,6) 19
20 GST_AMT NUMERIC(18,6) 19
21 FSL_AMT NUMERIC(18,6) 19
22 COMM_AMT NUMERIC(18,6) 19
23 PAYT_STAT_ID BIGINT 8
24 PREM_PAYT_DATE TIMESTAMP 8
25 PREM_PAID_AMT NUMERIC(18,6) 19
26 REN_PAID_IND BIGINT 8
27 RENEWED_IND BIGINT 8
28 DATA_LOAD_DATE TIMESTAMP 8
29 SNPSHT_DATE TIMESTAMP 8
30 SRC_SYS_ID CHARACTER VARYING(5) 5
31 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
32 LOAD_ID BIGINT 8
33 TXN_INFORCE_IND BIGINT 8
34 ANN_PREM_AMT NUMERIC(18,6) 19
35 INCR_BASE_PREM_AMT NUMERIC(18,6) 19
36 DERIVED_TXN_NUM DOUBLE PRECISION 8
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8