CFD_TCFDD_PRODUCT_APPLICATION

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_APPL_ID BIGINT 8
2 WRK_ITM_NUM CHARACTER VARYING(15) 15
3 APPLICANT_NUM CHARACTER VARYING(30) 30
4 APPL_CUST_NUM CHARACTER VARYING(60) 60
5 CUST_NUM CHARACTER VARYING(20) 20
6 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
7 CMPY_ID BIGINT 8
8 CUST_ID BIGINT 8
9 BRCH_ID BIGINT 8
10 PRDT_ID BIGINT 8
11 LN_PURP_ID BIGINT 8
12 LN_TYP_ID BIGINT 8
13 AGNT_ID BIGINT 8
14 SALES_OFCR_ID BIGINT 8
15 SRC_ACCT_NUM CHARACTER VARYING(20) 20
16 SRC_PRDT_CODE CHARACTER VARYING(10) 10
17 APPLICANT_FRST_NAM CHARACTER VARYING(50) 50
18 APPLICANT_LST_NAM CHARACTER VARYING(50) 50
19 APPL_DATE TIMESTAMP 8
20 APPL_AMT NUMERIC(18,6) 19
21 STAFF_IND CHARACTER VARYING(20) 20
22 LN_USE_CODE CHARACTER VARYING(1) 1
23 CNCLD_FLG BIGINT 8
24 CNCLD_RSN_DESC CHARACTER VARYING(60) 60
25 FHB_IND CHARACTER VARYING(3) 3
26 EFF_STRT_DATE TIMESTAMP 8
27 EFF_END_DATE TIMESTAMP 8
28 SNPSHT_DATE TIMESTAMP 8
29 SRC_SYS_ID CHARACTER VARYING(5) 5
30 DATA_LOAD_DATE TIMESTAMP 8
31 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
32 LOAD_ID BIGINT 8
33 DPNDNT_CNT BIGINT 8
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8