CFD_TCFDD_LOAN_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LN_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 PRDT_HOLDNG_ID BIGINT 8
5 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
6 PRDT_SYS_PRDT_CODE CHARACTER VARYING(20) 20
7 PRDT_SYS_CMPY_CODE CHARACTER VARYING(10) 10
8 PRDT_ID BIGINT 8
9 PRDT_GRP_CODE CHARACTER VARYING(20) 20
10 PRDT_TYP_CODE CHARACTER VARYING(20) 20
11 PRDT_BRND_ID BIGINT 8
12 PRDT_BRND_CODE CHARACTER VARYING(20) 20
13 CHNL_ID BIGINT 8
14 CHNL_CODE CHARACTER VARYING(10) 10
15 CHNL_TYP_CODE CHARACTER VARYING(10) 10
16 ORG_LN_AMT NUMERIC(18,6) 19
17 ANZSIC_TYP_ID BIGINT 8
18 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
19 AQUISITION_DATE TIMESTAMP 8
20 BORR_NUM BIGINT 8
21 BORR_SHRT_NAM CHARACTER VARYING(50) 50
22 INT_CALC_TYP_ID BIGINT 8
23 INT_CALC_TYP_CODE CHARACTER VARYING(20) 20
24 CNTRY_CODE BIGINT 8
25 COST_CENTRE_CODE CHARACTER VARYING(10) 10
26 CR_ANALYST_ID BIGINT 8
27 CR_ANALYST_CODE CHARACTER VARYING(20) 20
28 DEPT_ID BIGINT 8
29 DEPT_CODE CHARACTER VARYING(20) 20
30 LN_CLOSE_DATE TIMESTAMP 8
31 CRNT_MAT_DATE TIMESTAMP 8
32 LN_ADDED_DATE TIMESTAMP 8
33 LN_ISSUED_DATE TIMESTAMP 8
34 LN_RVW_DATE TIMESTAMP 8
35 LN_RECAST_DATE TIMESTAMP 8
36 ORG_MAT_DATE TIMESTAMP 8
37 LN_STAT_SET_DATE TIMESTAMP 8
38 LNDG_POL_NUM CHARACTER VARYING(10) 10
39 LNDG_POL_DATE TIMESTAMP 8
40 LN_PURP_ID BIGINT 8
41 LN_PURP_CODE CHARACTER VARYING(20) 20
42 LN_SUBPURP_ID BIGINT 8
43 LN_SUBPURPOSE_CODE CHARACTER VARYING(20) 20
44 LN_STAT_ID BIGINT 8
45 LN_STAT_CODE CHARACTER VARYING(20) 20
46 LN_TYP_ID BIGINT 8
47 LN_TYP_CODE CHARACTER VARYING(20) 20
48 NEW_CNVRSN_IND CHARACTER VARYING(3) 3
49 ORG_BRCH_ID BIGINT 8
50 ORG_BRCH_CODE CHARACTER VARYING(20) 20
51 ORG_INS_PREM_AMT NUMERIC(18,6) 19
52 ORG_TRM_NUM BIGINT 8
53 PRIM_OFCR_ID BIGINT 8
54 PRIM_OFCR_CODE CHARACTER VARYING(20) 20
55 PROP_RGTS_TYP_ID BIGINT 8
56 PROP_RGTS_TYP_CODE CHARACTER VARYING(20) 20
57 PROP_TYP_ID BIGINT 8
58 PROP_TYP_CODE CHARACTER VARYING(20) 20
59 RISK_CLASS_CODE CHARACTER VARYING(4) 4
60 SCND_OFCR_ID BIGINT 8
61 SCND_OFCR_CODE CHARACTER VARYING(20) 20
62 SERV_BRCH_ID BIGINT 8
63 SERV_BRCH_CODE CHARACTER VARYING(20) 20
64 APRVL_DATE TIMESTAMP 8
65 ASSC_LN_ACCT_NUM CHARACTER VARYING(20) 20
66 BANK_LINK_IND CHARACTER VARYING(3) 3
67 AGNT_ID BIGINT 8
68 AGNT_CODE CHARACTER VARYING(20) 20
69 CAP_RT_END_DATE TIMESTAMP 8
70 CSHBK_ID_FLG CHARACTER VARYING(20) 20
71 CALC_LN_VALN_RT NUMERIC(18,6) 19
72 CALC_COLL_VAL NUMERIC(18,6) 19
73 CONVERT_LEND_POL_NUM CHARACTER VARYING(20) 20
74 CONVERT_LN_TYP_ID BIGINT 8
75 CONVERT_LN_TYP_CODE CHARACTER VARYING(20) 20
76 LN_DOCUMENT_DATE TIMESTAMP 8
77 FRST_ADVANCE_AMT NUMERIC(18,6) 19
78 INTNT_CSHBK_IND CHARACTER VARYING(3) 3
79 LN_PACKAGE_ID BIGINT 8
80 LN_PACKAGE_CODE CHARACTER VARYING(20) 20
81 POUT_RSN_ID BIGINT 8
82 POUT_RSN_CODE CHARACTER VARYING(20) 20
83 SALES_OFCR_ID BIGINT 8
84 SALES_OFCR_CODE CHARACTER VARYING(20) 20
85 SALUTATION CHARACTER VARYING(50) 50
86 LN_STLMNT_DATE TIMESTAMP 8
87 SMALL_BUS_SEC_CODE CHARACTER VARYING(20) 20
88 JURISDICTION_STATE_ID BIGINT 8
89 JURISDICTION_STATE_CODE CHARACTER VARYING(20) 20
90 ANN_INT_RT NUMERIC(18,6) 19
91 LST_INTERST_RT_CHG_DATE TIMESTAMP 8
92 NXT_INT_RT_CHG_DATE TIMESTAMP 8
93 BILL_PERIOD_CODE CHARACTER VARYING(4) 4
94 PAYT_AMT NUMERIC(18,6) 19
95 BILL_STRT_DATE TIMESTAMP 8
96 BILL_END_DATE TIMESTAMP 8
97 SCHD_TYP_CODE CHARACTER VARYING(4) 4
98 EFF_STRT_DATE TIMESTAMP 8
99 EFF_END_DATE TIMESTAMP 8
100 DATA_LOAD_DATE TIMESTAMP 8
101 SNPSHT_DATE TIMESTAMP 8
102 SRC_SYS_ID CHARACTER VARYING(5) 5
103 LOAD_ID BIGINT 8
104 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
105 FRST_PAYT_DUE_DATE TIMESTAMP 8
106 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
107 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
108 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
109 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8