CFD_TCFDT_MTL_LAYER_TXN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_RECORD_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 POL_NUM BIGINT 8
5 POL_RSHIP_ROLE_TYP_CODE BIGINT 8
6 LYR_NUM BIGINT 8
7 COV_STRT_DATE TIMESTAMP 8
8 OPEN_STAT_ID BIGINT 8
9 OPEN_STAT_CODE CHARACTER VARYING(20) 20
10 OPEN_STAT_RGSTN_DATE TIMESTAMP 8
11 OPEN_STAT_EFF_DATE TIMESTAMP 8
12 CLOSE_STAT_ID BIGINT 8
13 CLOSE_STAT_CODE CHARACTER VARYING(20) 20
14 CLOSE_STAT_RGSTN_DATE TIMESTAMP 8
15 CLOSE_STAT_EFF_DATE TIMESTAMP 8
16 COV_TYP_NUM BIGINT 8
17 SUM_INSD_AMT NUMERIC(18,6) 19
18 ANN_PREM_AMT NUMERIC(18,6) 19
19 INSD_ENTRY_AGE_YR BIGINT 8
20 INS_TRM_YR BIGINT 8
21 INS_TRM_END_DATE TIMESTAMP 8
22 INSD_END_TRM_AGE_YR BIGINT 8
23 NXT_AUTO_CHG_DUE_DATE TIMESTAMP 8
24 DATA_LOAD_DATE TIMESTAMP 8
25 SNPSHT_DATE TIMESTAMP 8
26 SRC_SYS_ID CHARACTER VARYING(5) 5
27 LOAD_ID BIGINT 8
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8