FCT_BNK_CRHDS_EXPR_RESULT_CAL_SEC_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract for Experian Credit Decision Secured Result Calculation data for Secured loans with decision categories and codes and next call types

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_INIT_BUR_SERV_TEN CHARACTER VARYING(20) 20
3 S_INIT_NEXT_CALL_TYPE_ON CHARACTER VARYING(20) 20
4 S_INIT_NEXT_CALL_TYPE_TGN CHARACTER VARYING(10) 10
5 S_INIT_NEXT_CALL_TYPE_TEN CHARACTER VARYING(20) 20
6 S_INIT_DEC_ORIG_DEC_CAT CHARACTER VARYING(1) 1
7 S_INIT_DEC_ORIG_DEC_RCODE CHARACTER VARYING(4) 4
8 S_INIT_DEC_POL_DEC_CAT CHARACTER VARYING(1) 1
9 S_INIT_DEC_POL_RSN_CODE1 CHARACTER VARYING(4) 4
10 S_INIT_DEC_FINAL_DEC_CAT CHARACTER VARYING(1) 1
11 S_INIT_BUR_REQ_A_BUR_RQ_FLG CHARACTER VARYING(1) 1
12 S_INIT_BUR_REQ_G_BUR_RQ_FLG CHARACTER VARYING(1) 1
13 S_INIT_BUR_SER_BUR_SER1 CHARACTER VARYING(1) 1
14 S_INIT_BUR_SER_BUR_SER2 CHARACTER VARYING(1) 1
15 S_INIT_BUR_SER_BUR_SER3 CHARACTER VARYING(1) 1
16 S_INIT_BUR_SER_BUR_SER4 CHARACTER VARYING(1) 1
17 S_INIT_BUR_SER_BUR_SER5 CHARACTER VARYING(1) 1
18 S_INIT_BUR_SER_BUR_SER6 CHARACTER VARYING(1) 1
19 S_INIT_BUR_SER_BUR_SER7 CHARACTER VARYING(1) 1
20 S_INIT_BUR_SER_BUR_SER8 CHARACTER VARYING(1) 1
21 S_INIT_BUR_SER_BUR_SER9 CHARACTER VARYING(1) 1
22 S_INIT_BUR_SER_BUR_SER10 CHARACTER VARYING(1) 1
23 S_INIT_NXTCALLTYP_N_C_T CHARACTER VARYING(10) 10
24 S_INIT_NXTCALL_TYPSCREENF CHARACTER VARYING(4) 4
25 S_INIT_DEC_POL_RSN_CODE2 CHARACTER VARYING(4) 4
26 S_INIT_DEC_POL_RSN_CODE3 CHARACTER VARYING(4) 4
27 S_INIT_DEC_POL_RSN_CODE4 CHARACTER VARYING(4) 4
28 S_INIT_DEC_POL_RSN_CODE5 CHARACTER VARYING(4) 4
29 S_INIT_DEC_POL_RSN_CODE6 CHARACTER VARYING(4) 4
30 S_INIT_DEC_POL_RSN_CODE7 CHARACTER VARYING(4) 4
31 S_INIT_DEC_POL_RSN_CODE8 CHARACTER VARYING(4) 4
32 S_INIT_DEC_POL_RSN_CODE9 CHARACTER VARYING(4) 4
33 S_INIT_DEC_POL_RSN_CODE10 CHARACTER VARYING(4) 4
34 S_INIT_DEC_POL_RSN_CODE11 CHARACTER VARYING(4) 4
35 S_INIT_DEC_POL_RSN_CODE12 CHARACTER VARYING(4) 4
36 S_INIT_DEC_POL_RSN_CODE13 CHARACTER VARYING(4) 4
37 S_INIT_DEC_POL_RSN_CODE14 CHARACTER VARYING(4) 4
38 S_INIT_DEC_POL_RSN_CODE15 CHARACTER VARYING(4) 4
39 S_INIT_DEC_POL_RSN_CODE16 CHARACTER VARYING(4) 4
40 S_INIT_DEC_POL_RSN_CODE17 CHARACTER VARYING(4) 4
41 S_INIT_DEC_POL_RSN_CODE18 CHARACTER VARYING(4) 4
42 S_INIT_DEC_POL_RSN_CODE19 CHARACTER VARYING(4) 4
43 S_INIT_DEC_POL_RSN_CODE20 CHARACTER VARYING(4) 4
44 S_FIN_MX_LOAN_LIM_RQ_E_ON CHARACTER VARYING(20) 20
45 S_FIN_MX_LOAN_LIM_R_E_TGN CHARACTER VARYING(10) 10
46 S_FIN_MX_LOAN_LIM_R_E_TEN CHARACTER VARYING(20) 20
47 S_FIN_MX_LOAN_TOT_EXP_ON CHARACTER VARYING(20) 20
48 S_FIN_MX_LOAN_TOT_EXP_TGN CHARACTER VARYING(10) 10
49 S_FIN_MX_LOAN_TOT_EXP_TEN CHARACTER VARYING(20) 20
50 S_FIN_MX_LOAN_LVR_ON CHARACTER VARYING(20) 20
51 S_FIN_MX_LOAN_LVR_TGN CHARACTER VARYING(10) 10
52 S_FIN_MX_LOAN_LVR_TEN CHARACTER VARYING(20) 20
53 S_FIN_DECISION_ON CHARACTER VARYING(20) 20
54 S_FIN_DECISION_TGN CHARACTER VARYING(10) 10
55 S_FULL_BUREAU_REQUIRED_ON CHARACTER VARYING(20) 20
56 S_FULL_BUREAU_REQ_TGN CHARACTER VARYING(10) 10
57 S_FULL_BUREAU_REQ_TEN CHARACTER VARYING(20) 20
58 S_FULL_BUREAU_SERV_ON CHARACTER VARYING(20) 20
59 S_FULL_BUREAU_SERV_TGN CHARACTER VARYING(10) 10
60 S_FULL_BUREAU_SERV_TEN CHARACTER VARYING(20) 20
61 S_FULL_MAX_LOAN_AMT_ON CHARACTER VARYING(20) 20
62 S_FULL_MAX_LOAN_AMT_TGN CHARACTER VARYING(10) 10
63 S_FULL_MAX_LOAN_AMT_TEN CHARACTER VARYING(20) 20
64 S_FULL_LOAN_PARA_ON CHARACTER VARYING(20) 20
65 S_FULL_LOAN_PARA_TGN CHARACTER VARYING(10) 10
66 S_FULL_LOAN_PARA_TEN CHARACTER VARYING(20) 20
67 S_FULL_MTG_INSURANCE_ON CHARACTER VARYING(20) 20
68 S_FULL_MTG_INSURANCE_TGN CHARACTER VARYING(10) 10
69 S_FULL_MTG_INSURANCE_TEN CHARACTER VARYING(20) 20
70 S_FULL_XSELL_ELIGIBLE_ON CHARACTER VARYING(20) 20
71 S_FULL_XSELL_ELIGIBLE_TGN CHARACTER VARYING(10) 10
72 S_FULL_XSELL_ELIGIBLE_TEN CHARACTER VARYING(20) 20
73 S_FULL_NEXT_CALL_TYPE_ON CHARACTER VARYING(20) 20
74 S_FULL_NEXT_CALL_TYPE_TGN CHARACTER VARYING(10) 10
75 S_FULL_NEXT_CALL_TYPE_TEN CHARACTER VARYING(20) 20
76 S_FINAL_RESULTS_O_N CHARACTER VARYING(20) 20
77 S_FINAL_RESULTS_TGN CHARACTER VARYING(10) 10
78 S_FULL_RISK_SCORE_ON CHARACTER VARYING(20) 20
79 S_FULL_RISK_SCORE_S_ID CHARACTER VARYING(10) 10
80 S_FULL_RISK_SCORE_SN CHARACTER VARYING(20) 20
81 S_FULL_RISK_GRADE_ON CHARACTER VARYING(20) 20
82 S_FULL_RISK_GRADE_TEN CHARACTER VARYING(20) 20
83 S_FULL_SCORE_SPARE1_ON CHARACTER VARYING(20) 20
84 S_FULL_SCORE_SPARE1_S_ID CHARACTER VARYING(10) 10
85 S_FULL_SCORE_SPARE1_SN CHARACTER VARYING(20) 20
86 S_FULL_GRADE_SPARE1_ON CHARACTER VARYING(20) 20
87 S_FULL_GRADE_SPARE1_TEN CHARACTER VARYING(20) 20
88 S_FULL_SCORE_SPARE2_ON CHARACTER VARYING(20) 20
89 S_FULL_SCORE_SPARE2_S_ID CHARACTER VARYING(10) 10
90 S_FULL_SCORE_SPARE2_SN CHARACTER VARYING(20) 20
91 S_FULL_GRADE_SPARE2_ON CHARACTER VARYING(20) 20
92 S_FULL_GRADE_SPARE2_TEN CHARACTER VARYING(20) 20
93 S_FULL_CRGS_SCORE_ON CHARACTER VARYING(20) 20
94 S_FULL_CRGS_SCORE_S_ID CHARACTER VARYING(10) 10
95 S_FULL_CRGS_SCORE_SN CHARACTER VARYING(20) 20
96 S_FULL_CRGS_GRADE_ON CHARACTER VARYING(20) 20
97 S_FULL_CRGS_GRADE_TEN CHARACTER VARYING(20) 20
98 S_FIN_DEC_ORG_DEC_CAT CHARACTER VARYING(1) 1
99 S_FIN_DEC_ORG_DEC_RSNCODE CHARACTER VARYING(4) 4
100 S_FIN_DEC_POL_DEC_CAT CHARACTER VARYING(1) 1
101 S_FIN_DEC_POL_RSN_CODE1 CHARACTER VARYING(4) 4
102 S_FIN_DEC_FIN_DEC_CAT CHARACTER VARYING(1) 1
103 S_FIN_MX_LOAN_LIM_REQ CHARACTER VARYING(32) 32
104 S_FIN_MX_LOAN_FIN_LIM_REQ CHARACTER VARYING(32) 32
105 S_FIN_MX_LOAN_UNSEC_EX CHARACTER VARYING(32) 32
106 S_FIN_MX_LOAN_MX_UNSEC_EX CHARACTER VARYING(32) 32
107 S_FIN_MX_LOAN_MX_TOT_EXP CHARACTER VARYING(32) 32
108 S_FIN_MX_LOAN_TOT_EXP CHARACTER VARYING(32) 32
109 S_FIN_MX_LOAN_MAX_LVR CHARACTER VARYING(32) 32
110 S_FIN_MX_LOAN_MX_LVR_P CHARACTER VARYING(32) 32
111 S_FIN_MX_LOAN_FIN_MX_LVRP CHARACTER VARYING(32) 32
112 S_FULL_BUR_REQ_A_B_R_FLG CHARACTER VARYING(1) 1
113 S_FULL_BUR_REQ_G_B_R_FLG CHARACTER VARYING(1) 1
114 S_FULL_BUR_SERV_B_SERV1 CHARACTER VARYING(1) 1
115 S_FULL_BUR_SERV_B_SERV2 CHARACTER VARYING(1) 1
116 S_FULL_BUR_SERV_B_SERV3 CHARACTER VARYING(1) 1
117 S_FULL_BUR_SERV_B_SERV4 CHARACTER VARYING(1) 1
118 S_FULL_BUR_SERV_B_SERV5 CHARACTER VARYING(1) 1
119 S_FULL_BUR_SERV_B_SERV6 CHARACTER VARYING(1) 1
120 S_FULL_BUR_SERV_B_SERV7 CHARACTER VARYING(1) 1
121 S_FULL_BUR_SERV_B_SERV8 CHARACTER VARYING(1) 1
122 S_FULL_BUR_SERV_B_SERV9 CHARACTER VARYING(1) 1
123 S_FULL_BUR_SERV_B_SERV10 CHARACTER VARYING(1) 1
124 S_FULL_MX_LOAN_AMT_C_M_LA CHARACTER VARYING(1) 1
125 S_FULL_MX_LOAN_AMT_MN_S_V CHARACTER VARYING(32) 32
126 S_FULL_MX_LOAN_AMT_L_E_F CHARACTER VARYING(32) 32
127 S_FULL_MX_LOAN_AMT_MX_E_A CHARACTER VARYING(32) 32
128 S_FULL_MX_LOAN_AMT_MN_E_A CHARACTER VARYING(32) 32
129 S_FULL_MX_LOAN_AMT_MN_L_V CHARACTER VARYING(32) 32
130 S_FULL_MX_LOAN_AMT_R_F CHARACTER VARYING(32) 32
131 S_FULL_MX_LOAN_AMT_MX_L_A CHARACTER VARYING(32) 32
132 S_FULL_MX_LOAN_AMT_AVAL_S CHARACTER VARYING(32) 32
133 S_FULL_MX_LOAN_AMT_S_MX CHARACTER VARYING(32) 32
134 S_FULL_MX_LOAN_AMT_L_E_FM CHARACTER VARYING(32) 32
135 S_FULL_MX_LOAN_AMT_L_E_M CHARACTER VARYING(32) 32
136 S_FULL_LOAN_PARA_INT_R_A CHARACTER VARYING(32) 32
137 S_FULL_LOAN_PARA_LOAN_R_P CHARACTER VARYING(32) 32
138 S_FULL_MTG_INSUR_REQ_FLG CHARACTER VARYING(1) 1
139 S_FULL_MTG_INSUR_INS_TYPE CHARACTER VARYING(10) 10
140 S_FULL_XSELL_ELIGIBIL_FLG CHARACTER VARYING(1) 1
141 S_FULL_XSELL_PROD_CODE1 CHARACTER VARYING(6) 6
142 S_FULL_XSELL_PROD_CODE2 CHARACTER VARYING(6) 6
143 S_FULL_XSELL_PROD_CODE3 CHARACTER VARYING(6) 6
144 S_FULL_XSELL_PROD_CODE4 CHARACTER VARYING(6) 6
145 S_FULL_NEXT_CALL_TYPE_NCT CHARACTER VARYING(10) 10
146 S_FULL_NEXT_CALL_TYPE_S_F CHARACTER VARYING(4) 4
147 S_FULL_SCORE_APP_SCORE CHARACTER VARYING(10) 10
148 S_FULL_RISK_GRADE_A_R_G CHARACTER VARYING(10) 10
149 S_FULL_SCORE_SPARE1_SC1 CHARACTER VARYING(10) 10
150 S_FULL_GRADE_SPARE1_GRD1 CHARACTER VARYING(10) 10
151 S_FULL_SCORE_SPARE2_SC2 CHARACTER VARYING(10) 10
152 S_FULL_GRADE_SPARE2_GRD2 CHARACTER VARYING(10) 10
153 S_FULL_CRGS_SCORE_SCORE CHARACTER VARYING(10) 10
154 S_FULL_CRGS_GRADE_GRADE CHARACTER VARYING(10) 10
155 S_FULL_DEC_FIN_DEC_CAT CHARACTER VARYING(1) 1
156 S_FULL_DEC_FIN_RSN_CODE1 CHARACTER VARYING(4) 4
157 S_FIN_DEC_POL_RSN_CODE2 CHARACTER VARYING(4) 4
158 S_FIN_DEC_POL_RSN_CODE3 CHARACTER VARYING(4) 4
159 S_FIN_DEC_POL_RSN_CODE4 CHARACTER VARYING(4) 4
160 S_FIN_DEC_POL_RSN_CODE5 CHARACTER VARYING(4) 4
161 S_FIN_DEC_POL_RSN_CODE6 CHARACTER VARYING(4) 4
162 S_FIN_DEC_POL_RSN_CODE7 CHARACTER VARYING(4) 4
163 S_FIN_DEC_POL_RSN_CODE8 CHARACTER VARYING(4) 4
164 S_FIN_DEC_POL_RSN_CODE9 CHARACTER VARYING(4) 4
165 S_FIN_DEC_POL_RSN_CODE10 CHARACTER VARYING(4) 4
166 S_FIN_DEC_POL_RSN_CODE11 CHARACTER VARYING(4) 4
167 S_FIN_DEC_POL_RSN_CODE12 CHARACTER VARYING(4) 4
168 S_FIN_DEC_POL_RSN_CODE13 CHARACTER VARYING(4) 4
169 S_FIN_DEC_POL_RSN_CODE14 CHARACTER VARYING(4) 4
170 S_FIN_DEC_POL_RSN_CODE15 CHARACTER VARYING(4) 4
171 S_FIN_DEC_POL_RSN_CODE16 CHARACTER VARYING(4) 4
172 S_FIN_DEC_POL_RSN_CODE17 CHARACTER VARYING(4) 4
173 S_FIN_DEC_POL_RSN_CODE18 CHARACTER VARYING(4) 4
174 S_FIN_DEC_POL_RSN_CODE19 CHARACTER VARYING(4) 4
175 S_FIN_DEC_POL_RSN_CODE20 CHARACTER VARYING(4) 4
176 S_FULL_VER_FIN_EMP_ON CHARACTER VARYING(20) 20
177 S_FULL_VER_FIN_EMP_TGN CHARACTER VARYING(10) 10
178 S_FULL_VER_FIN_EMP_TEN CHARACTER VARYING(20) 20
179 S_FULL_VER_CR_R_HIST_ON CHARACTER VARYING(20) 20
180 S_FULL_VER_CR_R_HIST_TGN CHARACTER VARYING(10) 10
181 S_FULL_VER_CR_R_HIST_TEN CHARACTER VARYING(20) 20
182 S_FULL_VER_B_CONTR_P_ON CHARACTER VARYING(20) 20
183 S_FULL_VER_B_CONTR_P_TGN CHARACTER VARYING(10) 10
184 S_FULL_VER_B_CONTR_P_TEN CHARACTER VARYING(20) 20
185 S_FULL_VER_GEN_SAVING_ON CHARACTER VARYING(20) 20
186 S_FULL_VER_GEN_SAVING_TGN CHARACTER VARYING(10) 10
187 S_FULL_VER_GEN_SAVING_TEN CHARACTER VARYING(20) 20
188 S_FULL_VER_A_REALEST_ON CHARACTER VARYING(20) 20
189 S_FULL_VER_A_REALEST_TGN CHARACTER VARYING(10) 10
190 S_FULL_VER_A_REALESTA_TEN CHARACTER VARYING(20) 20
191 S_FULL_VER_A_OTHER_ON CHARACTER VARYING(20) 20
192 S_FULL_VER_A_OTHER_TGN CHARACTER VARYING(10) 10
193 S_FULL_VERI_A_OTHER_TEN CHARACTER VARYING(20) 20
194 S_FULL_VER_RENT_EXP_ON CHARACTER VARYING(20) 20
195 S_FULL_VER_RENT_EXP_TGN CHARACTER VARYING(10) 10
196 S_FULL_VER_RENT_EXP_TEN CHARACTER VARYING(20) 20
197 S_FULL_VER_CR_REPORT_ON CHARACTER VARYING(20) 20
198 S_FULL_VER_CR_REPORT_TGN CHARACTER VARYING(10) 10
199 S_FULL_VER_CR_REPORT_TEN CHARACTER VARYING(20) 20
200 S_FULL_VER_RES_ADDR_ON CHARACTER VARYING(20) 20
201 S_FULL_VER_RES_ADDR_TGN CHARACTER VARYING(10) 10
202 S_FULL_VER_RES_ADDR_TEN CHARACTER VARYING(20) 20
203 S_FULL_VER_OTH1_ON CHARACTER VARYING(20) 20
204 S_FULL_VER_OTH1_TGN CHARACTER VARYING(10) 10
205 S_FULL_VER_OTH1_TEN CHARACTER VARYING(20) 20
206 S_FULL_VER_OTH2_ON CHARACTER VARYING(20) 20
207 S_FULL_VER_OTH2_TGN CHARACTER VARYING(10) 10
208 S_FULL_VER_OTH2_TEN CHARACTER VARYING(20) 20
209 S_FULL_VER_OTH3_ON CHARACTER VARYING(20) 20
210 S_FULL_VER_OTH3_TGN CHARACTER VARYING(10) 10
211 S_FULL_VER_OTH3_TEN CHARACTER VARYING(20) 20
212 S_FULL_VER_FIN_EMP_FLG CHARACTER VARYING(1) 1
213 S_FULL_VER_CR_R_HIST_FLG CHARACTER VARYING(1) 1
214 S_FULL_VER_B_CONTR_P_FLG CHARACTER VARYING(1) 1
215 S_FULL_VER_GEN_SAVING_FLG CHARACTER VARYING(1) 1
216 S_FULL_VER_A_REALEST_FLG CHARACTER VARYING(1) 1
217 S_FULL_VER_ASSET_OTH_FLG CHARACTER VARYING(1) 1
218 S_FULL_VER_RENTAL_EXP_FLG CHARACTER VARYING(1) 1
219 S_FULL_VER_CREDIT_REP_FLG CHARACTER VARYING(1) 1
220 S_FULL_VER_RES_ADD_FLG CHARACTER VARYING(1) 1
221 S_FULL_VER_OTH1_FLAG CHARACTER VARYING(1) 1
222 S_FULL_VER_OTH2_FLAG CHARACTER VARYING(1) 1
223 S_FULL_VER_OTH3_FLAG CHARACTER VARYING(1) 1
224 S_FULL_DEC_FIN_RSN_CODE2 CHARACTER VARYING(4) 4
225 S_FULL_DEC_FIN_RSN_CODE3 CHARACTER VARYING(4) 4
226 S_FULL_DEC_FIN_RSN_CODE4 CHARACTER VARYING(4) 4
227 S_FULL_DEC_FIN_RSN_CODE5 CHARACTER VARYING(4) 4
228 S_FULL_DEC_FIN_RSN_CODE6 CHARACTER VARYING(4) 4
229 S_FULL_DEC_FIN_RSN_CODE7 CHARACTER VARYING(4) 4
230 S_FULL_DEC_FIN_RSN_CODE8 CHARACTER VARYING(4) 4
231 S_FULL_DEC_FIN_RSN_CODE9 CHARACTER VARYING(4) 4
232 S_FULL_DEC_FIN_RSN_CODE10 CHARACTER VARYING(4) 4
233 S_FULL_DEC_FIN_RSN_CODE11 CHARACTER VARYING(4) 4
234 S_FULL_DEC_FIN_RSN_CODE12 CHARACTER VARYING(4) 4
235 S_FULL_DEC_FIN_RSN_CODE13 CHARACTER VARYING(4) 4
236 S_FULL_DEC_FIN_RSN_CODE14 CHARACTER VARYING(4) 4
237 S_FULL_DEC_FIN_RSN_CODE15 CHARACTER VARYING(4) 4
238 S_FULL_DEC_FIN_RSN_CODE16 CHARACTER VARYING(4) 4
239 S_FULL_DEC_FIN_RSN_CODE17 CHARACTER VARYING(4) 4
240 S_FULL_DEC_FIN_RSN_CODE18 CHARACTER VARYING(4) 4
241 S_FULL_DEC_FIN_RSN_CODE19 CHARACTER VARYING(4) 4
242 S_FULL_DEC_FIN_RSN_CODE20 CHARACTER VARYING(4) 4