CFD_TCFDD_PRDT_APPL_APRVL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_APPL_APRVL_ID BIGINT 8
2 WRK_ITM_NUM CHARACTER VARYING(15) 15
3 APPLICANT_NUM CHARACTER VARYING(30) 30
4 PRDT_APPL_ID BIGINT 8
5 APPL_CUST_NUM CHARACTER VARYING(60) 60
6 CUST_NUM CHARACTER VARYING(20) 20
7 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
8 ORG_ADD_FLG CHARACTER VARYING(6) 6
9 CUST_ID BIGINT 8
10 CMPY_ID BIGINT 8
11 PRDT_ID BIGINT 8
12 LN_PURP_ID BIGINT 8
13 LN_TYP_ID BIGINT 8
14 SRC_ACCT_NUM CHARACTER VARYING(20) 20
15 SRC_PRDT_CODE CHARACTER VARYING(10) 10
16 APRVL_DATE TIMESTAMP 8
17 APRVL_AMT NUMERIC(18,6) 19
18 OWNR_OCCUP_INVSTMT_IND CHARACTER VARYING(20) 20
19 SUB_PURP_CODE CHARACTER VARYING(4) 4
20 FHB_IND CHARACTER VARYING(3) 3
21 EFF_STRT_DATE TIMESTAMP 8
22 EFF_END_DATE TIMESTAMP 8
23 SNPSHT_DATE TIMESTAMP 8
24 DATA_LOAD_DATE TIMESTAMP 8
25 SRC_SYS_ID CHARACTER VARYING(5) 5
26 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
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