CFD_TCFDD_LOAN_POLICY_LINKAGE

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LOAN_POL_LINK_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 POL_NUM CHARACTER VARYING(20) 20
4 SEQ_NUM BIGINT 8
5 TXN_NUM BIGINT 8
6 FINANCIER_NAM CHARACTER VARYING(20) 20
7 LOAN_ACCOUNT_NUM CHARACTER VARYING(10) 10
8 EXTERNAL_IND CHARACTER VARYING(1) 1
9 LOAN_REFERENCE_NUM CHARACTER VARYING(20) 20
10 LOAN_AMT NUMERIC(13,2) 19
11 LOAN_NUM_CHK_VAL CHARACTER VARYING(1) 1
12 TXN_VALID_FLAG CHARACTER VARYING(1) 1
13 TXN_JOB_NAM CHARACTER VARYING(10) 10
14 TXN_USER_ID CHARACTER VARYING(10) 10
15 TXN_TS TIMESTAMP 8
16 EFF_STRT_DATE TIMESTAMP 8
17 EFF_END_DATE TIMESTAMP 8
18 DATA_LOAD_DATE TIMESTAMP 8
19 SNPSHT_DATE TIMESTAMP 8
20 SRC_SYS_ID CHARACTER VARYING(5) 5
21 LOAD_ID BIGINT 8
22 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8