FCT_BNK_CRHDS_EXPR_DECISION_UNSEC_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian Credit Decision data with customer contact details, income repayments amounts budget surplus etc for unsecured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 U_COARSE_PRIMARY_ROLE_276 CHARACTER VARYING(3) 3
3 U_FINE_PRIMARY_ROLE_277 CHARACTER VARYING(3) 3
4 U_SPARE_104_278 CHARACTER VARYING(1) 1
5 U_AGE_279 CHARACTER VARYING(10) 10
6 U_EMPMT_STATUS_280 CHARACTER VARYING(2) 2
7 U_EXIST_CUST_FLG_281 CHARACTER VARYING(1) 1
8 U_EXIST_LNDG_CUST_282 CHARACTER VARYING(1) 1
9 U_SPARE_107_283 CHARACTER VARYING(10) 10
10 U_HOME_TELEPHONE_FLG_285 CHARACTER VARYING(1) 1
11 U_EMAIL_ADDRESS_FLG_286 CHARACTER VARYING(1) 1
12 U_FAX_FLG_287 CHARACTER VARYING(1) 1
13 U_N_REV_FCLTY_O_ORGS_288 CHARACTER VARYING(10) 10
14 U_N_NREV_FCLTY_O_ORG_289 CHARACTER VARYING(10) 10
15 U_N_EXI_SM_NREV_FCLTY_290 CHARACTER VARYING(10) 10
16 U_N_EXI_SM_REV_FCLTY_291 CHARACTER VARYING(10) 10
17 U_N_MSEC_FCLTY_O_ORG_292 CHARACTER VARYING(10) 10
18 U_N_NMSEC_FCLTY_O_ORG_293 CHARACTER VARYING(10) 10
19 U_N_EXI_SM_NMSECFCLTY_294 CHARACTER VARYING(10) 10
20 U_N_EXI_SM_MSEC_FCLTY_295 CHARACTER VARYING(10) 10
21 U_SPARE_110_296 CHARACTER VARYING(10) 10
22 U_RESDT_STATUS_297 CHARACTER VARYING(1) 1
23 U_T_AT_CURR_ADDR_MMM_298 CHARACTER VARYING(10) 10
24 U_T_AT_PRE_ADDR_MMM_299 CHARACTER VARYING(10) 10
25 U_T_IN_CUR_EMPMT_MMM_300 CHARACTER VARYING(10) 10
26 U_T_IN_PRE_EMPMT_MMM_301 CHARACTER VARYING(10) 10
27 U_TOT_N_OF_DEPENDANTS_302 CHARACTER VARYING(10) 10
28 U_TOT_T_AT_ADDRS_MMM_303 CHARACTER VARYING(10) 10
29 U_TOT_T_IN_EMPMT_MMM_304 CHARACTER VARYING(10) 10
30 U_HOME_POST_CODE_308 CHARACTER VARYING(4) 4
31 U_STATE_OF_RESIDENCE_309 CHARACTER VARYING(4) 4
32 U_DRIVERS_LICENCE_IND_310 CHARACTER VARYING(1) 1
33 U_EDUCATION_LEVEL_313 CHARACTER VARYING(4) 4
34 U_MOBILE_TELEPH_FLG_319 CHARACTER VARYING(1) 1
35 U_OCCUPATION_321 CHARACTER VARYING(10) 10
36 U_PRO_PACK_APPL_323 CHARACTER VARYING(1) 1
37 U_REFEREE_PROV_FLG_325 CHARACTER VARYING(1) 1
38 U_SPARE_102_332 CHARACTER VARYING(3) 3
39 U_RSHIP2ANY_NAMED_APP_334 CHARACTER VARYING(3) 3
40 U_COARSE_PRIMARY_ROLE_336 CHARACTER VARYING(3) 3
41 U_FINE_PRIMARY_ROLE_337 CHARACTER VARYING(3) 3
42 U_SPARE_105_338 CHARACTER VARYING(1) 1
43 U_AGE_339 CHARACTER VARYING(10) 10
44 U_EMPMT_STATUS_340 CHARACTER VARYING(2) 2
45 U_EXIST_CUST_FLG_341 CHARACTER VARYING(1) 1
46 U_EXIST_LNDG_CUST_342 CHARACTER VARYING(1) 1
47 U_SPARE_108_343 CHARACTER VARYING(10) 10
48 U_HOME_TELEPHONE_FLG_345 CHARACTER VARYING(1) 1
49 U_EMAIL_ADDRESS_FLG_346 CHARACTER VARYING(1) 1
50 U_FAX_FLG_347 CHARACTER VARYING(1) 1
51 U_N_REV_FCLTY_O_ORGS_348 CHARACTER VARYING(10) 10
52 U_N_NREV_FCLTY_O_ORG_349 CHARACTER VARYING(10) 10
53 U_N_EXI_SM_NREV_FCLTY_350 CHARACTER VARYING(10) 10
54 U_N_EXI_SM_REV_FCLTY_351 CHARACTER VARYING(10) 10
55 U_N_MSEC_FCLTY_O_ORGS_352 CHARACTER VARYING(10) 10
56 U_N_NMSEC_FCLTY_O_ORG_353 CHARACTER VARYING(10) 10
57 U_N_EXI_SM_NMSEC_FCLT_354 CHARACTER VARYING(10) 10
58 U_N_EXI_SM_MSEC_FCLTY_355 CHARACTER VARYING(10) 10
59 U_SPARE_111_356 CHARACTER VARYING(10) 10
60 U_RESDT_STATUS_357 CHARACTER VARYING(1) 1
61 U_T_AT_CURR_ADDR_MMM_358 CHARACTER VARYING(10) 10
62 U_T_AT_PREV_ADDR_MMM_359 CHARACTER VARYING(10) 10
63 U_T_IN_CUR_EMPMT_MMM_360 CHARACTER VARYING(10) 10
64 U_T_IN_PRE_EMPMT_MMM_361 CHARACTER VARYING(10) 10
65 U_TOT_NUM_DEPENDANTS_362 CHARACTER VARYING(10) 10
66 U_TOT_T_AT_ADDR_MMM_363 CHARACTER VARYING(10) 10
67 U_TOT_T_IN_EMPMT_MMM_364 CHARACTER VARYING(10) 10
68 U_HOME_POST_CODE_368 CHARACTER VARYING(4) 4
69 U_STATE_OF_RESIDENCE_369 CHARACTER VARYING(4) 4
70 U_DRIVERS_LICENCE_IND_370 CHARACTER VARYING(1) 1
71 U_EDUCATION_LEVEL_373 CHARACTER VARYING(4) 4
72 U_MOBILE_TELEPH_FLG_379 CHARACTER VARYING(1) 1
73 U_OCCUPATION_381 CHARACTER VARYING(10) 10
74 U_REFEREE_PROV_FLG_384 CHARACTER VARYING(1) 1
75 U_SPARE_103_391 CHARACTER VARYING(3) 3
76 U_RSHIP2ANY_NAMED_APP_393 CHARACTER VARYING(3) 3
77 U_MAX_AGE_433 CHARACTER VARYING(10) 10
78 U_MIN_AGE_434 CHARACTER VARYING(10) 10
79 U_MAX_AGE_435 CHARACTER VARYING(10) 10
80 U_MIN_AGE_436 CHARACTER VARYING(10) 10
81 U_FIRST_T_BUYER_FLG_437 CHARACTER VARYING(1) 1
82 U_ACCEPTABLE_APP_FLG_440 CHARACTER VARYING(1) 1
83 U_RESIDENT_FLG_442 CHARACTER VARYING(1) 1
84 U_STAFF_IND_443 CHARACTER VARYING(1) 1
85 U_MX_N_MSECFCLT_O_ORG_445 CHARACTER VARYING(10) 10
86 U_MX_N_NMSECFCLT_O_OR_446 CHARACTER VARYING(10) 10
87 U_MX_N_EXI_SM_NMSECF_447 CHARACTER VARYING(10) 10
88 U_MX_N_EXI_SM_MSECF_448 CHARACTER VARYING(10) 10
89 U_MX_T_AT_CURR_ADDR_449 CHARACTER VARYING(10) 10
90 U_MN_T_AT_CURR_ADDR_450 CHARACTER VARYING(10) 10
91 U_MX_T_IN_CURR_EMPMT_451 CHARACTER VARYING(10) 10
92 U_MN_T_IN_CURR_EMPMT_452 CHARACTER VARYING(10) 10
93 U_MX_TOT_TIME_AT_ADDR_453 CHARACTER VARYING(10) 10
94 U_MN_TOT_TIME_AT_ADDR_454 CHARACTER VARYING(10) 10
95 U_MX_TOT_T_IN_EMPMT_455 CHARACTER VARYING(10) 10
96 U_MN_TOT_T_IN_EMPMT_456 CHARACTER VARYING(10) 10
97 U_MX_LOAN_TERMPLUSAGE_457 CHARACTER VARYING(10) 10
98 U_MN_LOAN_TERMPLUSAGE_458 CHARACTER VARYING(10) 10
99 U_MX_LOAN_TERMPLUSAGE_459 CHARACTER VARYING(10) 10
100 U_MN_LOAN_TERMPLUSAGE_460 CHARACTER VARYING(10) 10
101 U_N_OF_INDIVID_APPS_461 CHARACTER VARYING(10) 10
102 U_NUM_OF_ENTITY_APPS_462 CHARACTER VARYING(10) 10
103 U_BORROW_CONTRI2LOAN_467 CHARACTER VARYING(32) 32
104 U_AOL_APPL_479 CHARACTER VARYING(1) 1
105 U_INCOME_MULTIPLIER_480 CHARACTER VARYING(32) 32
106 U_LOANREP2NETMDISPINC_482 CHARACTER VARYING(32) 32
107 U_RQSTD_LOAN_TERM_484 CHARACTER VARYING(10) 10
108 U_RQSTD_MARGIN_485 CHARACTER VARYING(32) 32
109 U_MTHPYMTS2MTHINC_PCT_486 CHARACTER VARYING(32) 32
110 U_SEC_OR_UNSEC_FLG_488 CHARACTER VARYING(1) 1
111 U_SPARE_109_489 CHARACTER VARYING(10) 10
112 U_TOT_MLOANREP_E_LOAN_490 CHARACTER VARYING(32) 32
113 U_MTHLY_BUDGET_SURPLU_491 CHARACTER VARYING(32) 32
114 U_MTHLY_BUDGET_SURPLU_492 CHARACTER VARYING(32) 32
115 U_NET_ASSETS_493 CHARACTER VARYING(32) 32
116 U_NET_ASSETS_494 CHARACTER VARYING(32) 32
117 U_NET_MTHY_INCOME_495 CHARACTER VARYING(32) 32
118 U_NET_ASSETS_496 CHARACTER VARYING(32) 32
119 U_NET_MTHY_INCOME_497 CHARACTER VARYING(32) 32
120 U_TOT_ASSETS_499 CHARACTER VARYING(32) 32
121 U_SPARE_112_500 CHARACTER VARYING(10) 10
122 U_TOT_CR_LIM_EXI_LOAN_502 CHARACTER VARYING(32) 32
123 U_SPARE_115_503 CHARACTER VARYING(10) 10
124 U_SPARE_113_506 CHARACTER VARYING(10) 10
125 U_TOT_EXIST_SEC_REPAY_510 CHARACTER VARYING(32) 32
126 U_TOT_MLOANREP_I_LOAN_512 CHARACTER VARYING(32) 32
127 U_INPUT_OFFICER_DCA_515 CHARACTER VARYING(1) 1
128 U_ACCEPTABLE_PURP_FLG_516 CHARACTER VARYING(1) 1
129 U_BRANCH_NUM_518 CHARACTER VARYING(5) 5
130 U_BROKER_CODE_519 CHARACTER VARYING(5) 5
131 U_BORROW_CONTRI2LOAN_522 CHARACTER VARYING(32) 32
132 U_INTEREST_TYPE_528 CHARACTER VARYING(3) 3
133 U_LOAN_REPAY_AMT_534 CHARACTER VARYING(32) 32
134 U_NUM_OF_APPS_542 CHARACTER VARYING(32) 32
135 U_NUM_OF_GTORS_545 CHARACTER VARYING(32) 32
136 U_PRE_APPROVAL_FLG_549 CHARACTER VARYING(1) 1
137 U_NONPMI_POSTCODE_FLG_555 CHARACTER VARYING(1) 1
138 U_LOAN_REPAY_AMNT_620 CHARACTER VARYING(32) 32
139 U_MAX_HISTORY_WTH_S_M_642 CHARACTER VARYING(10) 10
140 U_MAX_HISTORY_WTH_S_M_643 CHARACTER VARYING(10) 10
141 U_MAX_HISTORY_WTH_S_M_644 CHARACTER VARYING(10) 10
142 U_MAX_HISTORY_WTH_S_M_645 CHARACTER VARYING(10) 10
143 U_MAX_HISTORY_WTH_S_M_646 CHARACTER VARYING(10) 10
144 U_MAX_HISTORY_WTH_S_M_647 CHARACTER VARYING(10) 10
145 U_MAX_HISTORY_WTH_S_M_648 CHARACTER VARYING(10) 10
146 U_MAX_HISTORY_WTH_S_M_649 CHARACTER VARYING(10) 10
147 U_MAX_HISTORY_WTH_S_M_650 CHARACTER VARYING(10) 10
148 U_MAX_HISTORY_WTH_S_M_651 CHARACTER VARYING(10) 10
149 U_MAX_HISTORY_WTH_S_M_652 CHARACTER VARYING(10) 10
150 U_MAX_HISTORY_WTH_S_M_653 CHARACTER VARYING(10) 10
151 U_VALIDAT_CERT_HELD_654 CHARACTER VARYING(1) 1
152 U_SPARE_116_667 CHARACTER VARYING(10) 10
153 U_SPARE_117_668 CHARACTER VARYING(10) 10
154 U_SELFEMP_INCOME_VAR_669 CHARACTER VARYING(32) 32
155 U_SPARE_114_681 CHARACTER VARYING(10) 10
156 U_TOT_REAL_ESTATE_A_682 CHARACTER VARYING(32) 32
157 U_MTGE_INS_MX_LOAN_AM_693 CHARACTER VARYING(32) 32
158 U_MTGE_INS_MAX_LVR_694 CHARACTER VARYING(32) 32
159 U_GENUIN_SAV_FLG_3PCT_695 CHARACTER VARYING(1) 1
160 U_CAMPAIGN_CODE_696 CHARACTER VARYING(8) 8
161 U_SELF_EMPLOYED_IND_698 CHARACTER VARYING(3) 3
162 U_STD_NOV_LEASE_FLG_700 CHARACTER VARYING(1) 1
163 U_E_LOAN_AVGNDAY_AR_701 CHARACTER VARYING(32) 32
164 U_E_LOAN_DIFF_P2C_FLG_702 CHARACTER VARYING(1) 1
165 U_REPROCESS_FLG_703 CHARACTER VARYING(1) 1
166 U_STD_RENTAL_APPL_FLG_704 CHARACTER VARYING(1) 1
167 U_STD_MOTOR_APPL_FLG_705 CHARACTER VARYING(1) 1
168 U_CUST_SEGMENT_APPL_706 CHARACTER VARYING(1) 1
169 U_COMPLEX_MOT_APPL_F_707 CHARACTER VARYING(1) 1
170 U_FINANC_VERIFD_IND_708 CHARACTER VARYING(1) 1
171 U_FINS_OUT_OF_DATE_709 CHARACTER VARYING(1) 1
172 U_REPLAC_SM_EF_LOAN_F_718 CHARACTER VARYING(1) 1
173 U_EXIST_S_M_LNDG_CUST_719 CHARACTER VARYING(1) 1
174 U_EXIST_SM_DEPOS_AMT_720 CHARACTER VARYING(32) 32
175 U_RESIDUAL_VALUE_AMT_721 CHARACTER VARYING(32) 32
176 U_RESIDUAL_VALUE_PCT_722 CHARACTER VARYING(32) 32
177 U_ATO_MX_RESIDUAL_VAL_723 CHARACTER VARYING(32) 32
178 U_BALLOON_PAYT_724 CHARACTER VARYING(32) 32
179 U_ATO_MAX_BALLOON_PAY_725 CHARACTER VARYING(32) 32
180 U_PRODUCT_MIN_TERM_726 CHARACTER VARYING(32) 32
181 U_PRODUCT_MAX_TERM_727 CHARACTER VARYING(32) 32
182 U_PRODUCT_MIN_MARGIN_728 CHARACTER VARYING(32) 32
183 U_DUPL_APP_FLG_L12M_736 CHARACTER VARYING(1) 1
184 U_E_MOTOR_FIN_ANCS_F_739 CHARACTER VARYING(10) 10
185 U_E_MOT_F_N_EQ2TFPCT_740 CHARACTER VARYING(32) 32
186 U_FRANCH_LIC_MOT_DEAL_742 CHARACTER VARYING(1) 1
187 U_VEH_DETAILS_YEAR_785 CHARACTER VARYING(4) 4
188 U_VEH_DETAILS_MAKE_786 CHARACTER VARYING(20) 20
189 U_VEH_DETAILS_MODEL_787 CHARACTER VARYING(20) 20
190 U_VEH_VAL_TRD_LOWPRC_793 CHARACTER VARYING(32) 32
191 U_VEH_VAL_TRADEPRICE_794 CHARACTER VARYING(32) 32
192 U_VEH_VAL_RETAILPRICE_795 CHARACTER VARYING(32) 32
193 U_VEH_VAL_MARKETVALUE_796 CHARACTER VARYING(32) 32
194 U_VEH_VAL_MAR_VAL_RET_797 CHARACTER VARYING(32) 32
195 U_VEH_VAL_DEPRTN_RATE_798 CHARACTER VARYING(32) 32
196 U_NUM_OF_INDIVIDUALS_967 CHARACTER VARYING(10) 10
197 U_LOAN_REPY2NET_M_INC_968 CHARACTER VARYING(32) 32
198 U_SPARE_11_969 CHARACTER VARYING(10) 10
199 U_SPARE_12_970 CHARACTER VARYING(32) 32
200 U_SPARE_13_971 CHARACTER VARYING(10) 10
201 U_SPARE_14_972 CHARACTER VARYING(10) 10
202 U_SPARE_15_973 CHARACTER VARYING(10) 10
203 U_SPARE_16_974 CHARACTER VARYING(10) 10
204 U_SPARE_17_975 CHARACTER VARYING(10) 10
205 U_SPARE_18_976 CHARACTER VARYING(10) 10
206 U_SPARE_19_977 CHARACTER VARYING(10) 10
207 U_SPARE_20_978 CHARACTER VARYING(10) 10
208 U_DEBT_AGREEMENT_FLG_985 CHARACTER VARYING(1) 1
209 U_DEBT_AGRMNT_COMPL_F_986 CHARACTER VARYING(1) 1
210 U_SPARE_29_987 CHARACTER VARYING(1) 1
211 U_SPARE_30_988 CHARACTER VARYING(1) 1
212 U_SPARE_31_989 CHARACTER VARYING(1) 1
213 U_SPARE_32_990 CHARACTER VARYING(1) 1
214 U_SPARE_33_991 CHARACTER VARYING(1) 1
215 U_SPARE_34_992 CHARACTER VARYING(1) 1
216 U_SPARE_35_993 CHARACTER VARYING(1) 1
217 U_SPARE_36_994 CHARACTER VARYING(1) 1
218 U_SPARE_37_995 CHARACTER VARYING(1) 1
219 U_SPARE_38_996 CHARACTER VARYING(1) 1
220 U_SPARE_39_997 CHARACTER VARYING(1) 1
221 U_SPARE_40_998 CHARACTER VARYING(1) 1
222 U_SPARE_41_999 CHARACTER VARYING(1) 1
223 U_SPARE_42_1000 CHARACTER VARYING(1) 1
224 U_SPARE_43_1001 CHARACTER VARYING(1) 1
225 U_SPARE_44_1002 CHARACTER VARYING(1) 1
226 U_SPARE_45_1003 CHARACTER VARYING(1) 1
227 U_SPARE_46_1004 CHARACTER VARYING(1) 1
228 U_SPARE_47_1005 CHARACTER VARYING(1) 1
229 U_SPARE_48_1006 CHARACTER VARYING(1) 1
230 U_SPARE_49_1007 CHARACTER VARYING(1) 1
231 U_SPARE_50_1008 CHARACTER VARYING(1) 1
232 U_PRODUCT_MIN_AMT_1017 CHARACTER VARYING(32) 32
233 U_TOT_BO_SECSM_LOAN_1018 CHARACTER VARYING(32) 32
234 U_TOT_BO_SECSM_LOAN_1019 CHARACTER VARYING(32) 32
235 U_TOT_BO_USECSM_LOAN_1020 CHARACTER VARYING(32) 32
236 U_TOT_BO_USECSM_LOAN_1021 CHARACTER VARYING(32) 32
237 U_TOT_BO_ALLSEC_LOAN_1022 CHARACTER VARYING(32) 32
238 U_TOT_BO_ALLSEC_LOAN_1023 CHARACTER VARYING(32) 32
239 U_TOT_BO_ALLUSEC_LOA_1024 CHARACTER VARYING(32) 32
240 U_TOT_BO_ALLUSEC_LOA_1025 CHARACTER VARYING(32) 32
241 U_SPARE_68_1026 CHARACTER VARYING(10) 10
242 U_SPARE_69_1027 CHARACTER VARYING(10) 10
243 U_SPARE_70_1028 CHARACTER VARYING(10) 10
244 U_SPEC_LOAN_PRD_CODE_1033 CHARACTER VARYING(4) 4
245 U_SPARE_76_1034 CHARACTER VARYING(4) 4
246 U_SPARE_77_1035 CHARACTER VARYING(4) 4
247 U_SPARE_78_1036 CHARACTER VARYING(4) 4
248 U_SPARE_79_1037 CHARACTER VARYING(4) 4
249 U_SPARE_80_1038 CHARACTER VARYING(4) 4
250 U_SPARE_81_1039 CHARACTER VARYING(4) 4
251 U_SPARE_82_1040 CHARACTER VARYING(4) 4
252 U_SPARE_83_1041 CHARACTER VARYING(4) 4
253 U_SPARE_84_1042 CHARACTER VARYING(4) 4
254 U_SPARE_85_1043 CHARACTER VARYING(4) 4
255 U_SPARE_86_1044 CHARACTER VARYING(4) 4
256 U_SPARE_87_1045 CHARACTER VARYING(4) 4
257 U_SPARE_88_1046 CHARACTER VARYING(4) 4
258 U_SPARE_89_1047 CHARACTER VARYING(4) 4
259 U_SPARE_90_1048 CHARACTER VARYING(4) 4
260 U_SPARE_91_1049 CHARACTER VARYING(8) 8
261 U_SPARE_96_1054 CHARACTER VARYING(8) 8
262 U_SPARE_97_1055 CHARACTER VARYING(8) 8
263 U_SPARE_98_1056 CHARACTER VARYING(8) 8
264 U_SPARE_99_1057 CHARACTER VARYING(8) 8
265 U_SPARE_100_1058 CHARACTER VARYING(8) 8
266 U_CURRENT_CALL_TYPE_1059 CHARACTER VARYING(10) 10
267 U_N_DAYS_APPL_PROCSD_1060 CHARACTER VARYING(10) 10