FCT_CUST_LOAN_PH

Database

INSNZP01_CL

Schema

CLPADM

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_DESC CHARACTER VARYING(100) 100
12 PRDT_BRND_ID BIGINT 8
13 PRDT_BRND_CODE CHARACTER VARYING(20) 20
14 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
15 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
16 SOURCE_PRODUCT_DESCRIPTION CHARACTER VARYING(336) 336
17 PRDT_SUB_TYP_CODE CHARACTER VARYING(20) 20
18 PRDT_SEGMENT_GRP_CODE CHARACTER VARYING(20) 20
19 BANKING_TYPE CHARACTER VARYING(6) 6
20 CHNL_ID BIGINT 8
21 CHNL_CODE CHARACTER VARYING(10) 10
22 CHNL_TYP_CODE CHARACTER VARYING(10) 10
23 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
24 ORG_LN_AMT DOUBLE PRECISION 8
25 ANZSIC_TYP_ID BIGINT 8
26 ANZSIC_TYP_CODE CHARACTER VARYING(4) 4
27 SUBMISSION_ID CHARACTER VARYING(50) 50
28 APPLICATION_ID CHARACTER VARYING(50) 50
29 AQUISITION_DATE TIMESTAMP 8
30 BORR_NUM CHARACTER VARYING(16) 16
31 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
32 BORR_SHRT_NAM CHARACTER VARYING(300) 300
33 INT_CALC_TYP_ID BIGINT 8
34 INT_CALC_TYP_CODE CHARACTER VARYING(1) 1
35 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
36 CNTRY_CODE CHARACTER VARYING(10) 10
37 COST_CENTRE_CODE CHARACTER VARYING(150) 150
38 CR_ANALYST_ID BIGINT 8
39 CR_ANALYST_CODE CHARACTER VARYING(40) 40
40 DEPT_ID BIGINT 8
41 DEPT_CODE CHARACTER VARYING(100) 100
42 LN_CLOSE_DATE TIMESTAMP 8
43 CRNT_MAT_DATE TIMESTAMP 8
44 LN_ADDED_DATE TIMESTAMP 8
45 LN_ISSUED_DATE TIMESTAMP 8
46 LN_PURP_ID BIGINT 8
47 LN_PURP_CODE CHARACTER VARYING(20) 20
48 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
49 LN_SUBPURP_ID BIGINT 8
50 LN_SUBPURPOSE_CODE CHARACTER VARYING(10) 10
51 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
52 LN_STAT_ID BIGINT 8
53 LN_STAT_CODE CHARACTER VARYING(20) 20
54 ACCOUNT_STATUS_DESC CHARACTER VARYING(256) 256
55 LN_TYP_ID BIGINT 8
56 LN_TYP_CODE CHARACTER VARYING(20) 20
57 NEW_CNVRSN_IND CHARACTER VARYING(3) 3
58 ORG_BRCH_ID BIGINT 8
59 ORG_BRCH_CODE CHARACTER VARYING(20) 20
60 APPLICATION_BRANCH_NAME CHARACTER VARYING(105) 105
61 STAFF_ACCOUNT_FLAG CHARACTER VARYING(1) 1
62 ORG_INS_PREM_AMT NUMERIC(18,6) 19
63 ORG_TRM_NUM BIGINT 8
64 PRIM_OFCR_ID BIGINT 8
65 PRIM_OFCR_CODE CHARACTER VARYING(20) 20
66 PROP_RGTS_TYP_ID BIGINT 8
67 PROP_RGTS_TYP_CODE CHARACTER VARYING(20) 20
68 PROP_TYP_ID BIGINT 8
69 PROP_TYP_CODE CHARACTER VARYING(20) 20
70 RISK_CLASS_CODE CHARACTER VARYING(5) 5
71 SERV_BRCH_ID BIGINT 8
72 SERV_BRCH_CODE CHARACTER VARYING(20) 20
73 APRVL_DATE TIMESTAMP 8
74 AGNT_ID BIGINT 8
75 AGNT_CODE CHARACTER VARYING(20) 20
76 CAP_RT_END_DATE TIMESTAMP 8
77 CALC_LN_VALN_RT NUMERIC(18,6) 19
78 CALC_COLL_VAL NUMERIC(18,6) 19
79 LATEST_COLLATERAL_VALUE DOUBLE PRECISION 8
80 CONVERT_LN_TYP_ID BIGINT 8
81 OFFER_SWAP_INDICATOR CHARACTER VARYING(1) 1
82 NEW_OFFER_ID CHARACTER VARYING(30) 30
83 OFFER_SWAP_DATE TIMESTAMP 8
84 FRST_ADVANCE_AMT NUMERIC(18,6) 19
85 PRINCIPAL_OFFSET_ALLOWED_FLAG CHARACTER VARYING(1) 1
86 MOBILE_BANKING_ALLOWED_FLAG CHARACTER VARYING(1) 1
87 INTERNET_BANKING_ALLOWED_FLAG CHARACTER VARYING(1) 1
88 PHONE_BANKING_ALLOWED_FLAG CHARACTER VARYING(1) 1
89 INTNT_CSHBK_IND CHARACTER VARYING(3) 3
90 BRANCH_BANKING_ALLOWED_FLAG CHARACTER VARYING(1) 1
91 ACCELERATED_PAYMENT_ALLOWED_FLAG CHARACTER VARYING(1) 1
92 STATEMENT_ALLOWED_FLAG CHARACTER VARYING(1) 1
93 BUNDLE_NAME CHARACTER VARYING(40) 40
94 LN_STLMNT_DATE TIMESTAMP 8
95 ANN_INT_RT NUMERIC(18,6) 19
96 LST_INTERST_RT_CHG_DATE TIMESTAMP 8
97 NXT_INT_RT_CHG_DATE TIMESTAMP 8
98 BILL_PERIOD_CODE CHARACTER VARYING(40) 40
99 PAYT_AMT NUMERIC(18,6) 19
100 BILL_STRT_DATE TIMESTAMP 8
101 SCHD_TYP_CODE CHARACTER VARYING(40) 40
102 REQUESTED_AMOUNT DOUBLE PRECISION 8
103 FIXED_TERM_MONTHS DOUBLE PRECISION 8
104 FIXED_PERIOD_END_DATE TIMESTAMP 8
105 EXPECTED_CODE_TYPE CHARACTER VARYING(14) 14
106 LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
107 MARGIN_RATE NUMERIC(8,5) 19
108 BASE_RATE NUMERIC(8,5) 19
109 IN_COLLECTIONS CHARACTER VARYING(1) 1
110 IS_DELINQUENT CHARACTER VARYING(1) 1
111 DELINQUENCY_START_DATE TIMESTAMP 8
112 DELINQUENCY_END_DATE TIMESTAMP 8
113 LN_RVW_DATE TIMESTAMP 8
114 LN_RECAST_DATE TIMESTAMP 8
115 ORG_MAT_DATE TIMESTAMP 8
116 LN_STAT_SET_DATE TIMESTAMP 8
117 LNDG_POL_NUM CHARACTER VARYING(10) 10
118 LNDG_POL_DATE TIMESTAMP 8
119 SCND_OFCR_ID BIGINT 8
120 SCND_OFCR_CODE CHARACTER VARYING(20) 20
121 ASSC_LN_ACCT_NUM CHARACTER VARYING(20) 20
122 BANK_LINK_IND CHARACTER VARYING(3) 3
123 CONVERT_LEND_POL_NUM CHARACTER VARYING(20) 20
124 CONVERT_LN_TYP_CODE CHARACTER VARYING(20) 20
125 LN_DOCUMENT_DATE TIMESTAMP 8
126 LN_PACKAGE_ID BIGINT 8
127 LN_PACKAGE_CODE CHARACTER VARYING(20) 20
128 POUT_RSN_ID BIGINT 8
129 POUT_RSN_CODE CHARACTER VARYING(20) 20
130 SALES_OFCR_ID BIGINT 8
131 SALES_OFCR_CODE CHARACTER VARYING(20) 20
132 SALUTATION CHARACTER VARYING(50) 50
133 SMALL_BUS_SEC_CODE CHARACTER VARYING(20) 20
134 JURISDICTION_STATE_ID CHARACTER VARYING(20) 20
135 JURISDICTION_STATE_CODE CHARACTER VARYING(20) 20
136 BILL_END_DATE TIMESTAMP 8
137 CSHBK_AVAILED_AMT NUMERIC(18,6) 19
138 DELQ_10_29_CNT DOUBLE PRECISION 8
139 DELQ_30_59_CNT DOUBLE PRECISION 8
140 DELQ_60_89_CNT DOUBLE PRECISION 8
141 DELQ_90_119_CNT DOUBLE PRECISION 8
142 DELQ_OVR_120_CNT DOUBLE PRECISION 8
143 DATA_LOAD_DATE TIMESTAMP 8
144 SNPSHT_DATE TIMESTAMP 8
145 SRC_SYS_ID CHARACTER VARYING(5) 5
146 LOAD_ID BIGINT 8
147 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
148 FRST_PAYT_DUE_DATE TIMESTAMP 8
149 MIGRATED_LOAN CHARACTER VARYING(1) 1
150 HOG_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
151 EFF_STRT_DATE TIMESTAMP 8
152 EFF_END_DATE TIMESTAMP 8
153 IS_EOD_RECORD CHARACTER VARYING(1) 1
154 IS_RECORD_CURRENT CHARACTER VARYING(1) 1
155 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
156 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
157 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
158 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
159 SALE_OFF_DEPT_COST_CENTRE_DESC CHARACTER VARYING(240) 240
160 MIGRATED_STATUS CHARACTER VARYING(20) 20
161 INSURANCE_TYPE CHARACTER VARYING(20) 20
162 INSURANCE_PROVIDER_ID CHARACTER VARYING(50) 50
163 INSURANCE_START_DATE TIMESTAMP 8
164 INSURANCE_END_DATE TIMESTAMP 8
165 LIFE_INSURED_1 CHARACTER VARYING(250) 250
166 INSURANCE_COVER_CODE_1 CHARACTER VARYING(100) 100
167 INSURANCE_POLICY_NUMBER_1 CHARACTER VARYING(50) 50
168 LIFE_INSURED_2 CHARACTER VARYING(250) 250
169 INSURANCE_COVER_CODE_2 CHARACTER VARYING(100) 100
170 INSURANCE_POLICY_NUMBER_2 CHARACTER VARYING(50) 50