FCT_BNK_CRHDS_EXPR_DECISION_SEC_INSIGHT

Database

INSNZP01_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 secured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_COARSE_PRIMARY_ROLE_276 CHARACTER VARYING(3) 3
3 S_FINE_PRIMARY_ROLE_277 CHARACTER VARYING(3) 3
4 S_SPARE_104_278 CHARACTER VARYING(1) 1
5 S_AGE_279 CHARACTER VARYING(10) 10
6 S_EMPMT_STATUS_280 CHARACTER VARYING(2) 2
7 S_EXIST_CUST_FLG_281 CHARACTER VARYING(1) 1
8 S_EXIST_LNDG_CUST_282 CHARACTER VARYING(1) 1
9 S_SPARE_107_283 CHARACTER VARYING(10) 10
10 S_HOME_TELEPHONE_FLG_285 CHARACTER VARYING(1) 1
11 S_EMAIL_ADDRESS_FLG_286 CHARACTER VARYING(1) 1
12 S_FAX_FLG_287 CHARACTER VARYING(1) 1
13 S_N_REV_FCLTY_O_ORGS_288 CHARACTER VARYING(10) 10
14 S_N_NREV_FCLTY_O_ORG_289 CHARACTER VARYING(10) 10
15 S_N_EXI_SM_NREV_FCLTY_290 CHARACTER VARYING(10) 10
16 S_N_EXI_SM_REV_FCLTY_291 CHARACTER VARYING(10) 10
17 S_N_MSEC_FCLTY_O_ORG_292 CHARACTER VARYING(10) 10
18 S_N_NMSEC_FCLTY_O_ORG_293 CHARACTER VARYING(10) 10
19 S_N_EXI_SM_NMSECFCLTY_294 CHARACTER VARYING(10) 10
20 S_N_EXI_SM_MSEC_FCLTY_295 CHARACTER VARYING(10) 10
21 S_SPARE_110_296 CHARACTER VARYING(10) 10
22 S_RESDT_STATUS_297 CHARACTER VARYING(1) 1
23 S_T_AT_CURR_ADDR_MMM_298 CHARACTER VARYING(10) 10
24 S_T_AT_PRE_ADDR_MMM_299 CHARACTER VARYING(10) 10
25 S_T_IN_CUR_EMPMT_MMM_300 CHARACTER VARYING(10) 10
26 S_T_IN_PRE_EMPMT_MMM_301 CHARACTER VARYING(10) 10
27 S_TOT_N_OF_DEPENDANTS_302 CHARACTER VARYING(10) 10
28 S_TOT_T_AT_ADDRS_MMM_303 CHARACTER VARYING(10) 10
29 S_TOT_T_IN_EMPMT_MMM_304 CHARACTER VARYING(10) 10
30 S_HOME_POST_CODE_308 CHARACTER VARYING(4) 4
31 S_STATE_OF_RESIDENCE_309 CHARACTER VARYING(4) 4
32 S_DRIVERS_LICENCE_IND_310 CHARACTER VARYING(1) 1
33 S_EDUCATION_LEVEL_313 CHARACTER VARYING(4) 4
34 S_MOBILE_TELEPH_FLG_319 CHARACTER VARYING(1) 1
35 S_OCCUPATION_321 CHARACTER VARYING(10) 10
36 S_PRO_PACK_APPL_323 CHARACTER VARYING(1) 1
37 S_REFEREE_PROV_FLG_325 CHARACTER VARYING(1) 1
38 S_SPARE_102_332 CHARACTER VARYING(3) 3
39 S_RSHIP2ANY_NAMED_APP_334 CHARACTER VARYING(3) 3
40 S_COARSE_PRIMARY_ROLE_336 CHARACTER VARYING(3) 3
41 S_FINE_PRIMARY_ROLE_337 CHARACTER VARYING(3) 3
42 S_SPARE_105_338 CHARACTER VARYING(1) 1
43 S_AGE_339 CHARACTER VARYING(10) 10
44 S_EMPMT_STATUS_340 CHARACTER VARYING(2) 2
45 S_EXIST_CUST_FLG_341 CHARACTER VARYING(1) 1
46 S_EXIST_LNDG_CUST_342 CHARACTER VARYING(1) 1
47 S_SPARE_108_343 CHARACTER VARYING(10) 10
48 S_HOME_TELEPHONE_FLG_345 CHARACTER VARYING(1) 1
49 S_EMAIL_ADDRESS_FLG_346 CHARACTER VARYING(1) 1
50 S_FAX_FLG_347 CHARACTER VARYING(1) 1
51 S_N_REV_FCLTY_O_ORGS_348 CHARACTER VARYING(10) 10
52 S_N_NREV_FCLTY_O_ORG_349 CHARACTER VARYING(10) 10
53 S_N_EXI_SM_NREV_FCLTY_350 CHARACTER VARYING(10) 10
54 S_N_EXI_SM_REV_FCLTY_351 CHARACTER VARYING(10) 10
55 S_N_MSEC_FCLTY_O_ORGS_352 CHARACTER VARYING(10) 10
56 S_N_NMSEC_FCLTY_O_ORG_353 CHARACTER VARYING(10) 10
57 S_N_EXI_SM_NMSEC_FCLT_354 CHARACTER VARYING(10) 10
58 S_N_EXI_SM_MSEC_FCLTY_355 CHARACTER VARYING(10) 10
59 S_SPARE_111_356 CHARACTER VARYING(10) 10
60 S_RESDT_STATUS_357 CHARACTER VARYING(1) 1
61 S_T_AT_CURR_ADDR_MMM_358 CHARACTER VARYING(10) 10
62 S_T_AT_PREV_ADDR_MMM_359 CHARACTER VARYING(10) 10
63 S_T_IN_CUR_EMPMT_MMM_360 CHARACTER VARYING(10) 10
64 S_T_IN_PRE_EMPMT_MMM_361 CHARACTER VARYING(10) 10
65 S_TOT_NUM_DEPENDANTS_362 CHARACTER VARYING(10) 10
66 S_TOT_T_AT_ADDR_MMM_363 CHARACTER VARYING(10) 10
67 S_TOT_T_IN_EMPMT_MMM_364 CHARACTER VARYING(10) 10
68 S_HOME_POST_CODE_368 CHARACTER VARYING(4) 4
69 S_STATE_OF_RESIDENCE_369 CHARACTER VARYING(4) 4
70 S_DRIVERS_LICENCE_IND_370 CHARACTER VARYING(1) 1
71 S_EDUCATION_LEVEL_373 CHARACTER VARYING(4) 4
72 S_MOBILE_TELEPH_FLG_379 CHARACTER VARYING(1) 1
73 S_OCCUPATION_381 CHARACTER VARYING(10) 10
74 S_REFEREE_PROV_FLG_384 CHARACTER VARYING(1) 1
75 S_SPARE_103_391 CHARACTER VARYING(3) 3
76 S_RSHIP2ANY_NAMED_APP_393 CHARACTER VARYING(3) 3
77 S_MAX_AGE_433 CHARACTER VARYING(10) 10
78 S_MIN_AGE_434 CHARACTER VARYING(10) 10
79 S_MAX_AGE_435 CHARACTER VARYING(10) 10
80 S_MIN_AGE_436 CHARACTER VARYING(10) 10
81 S_FIRST_T_BUYER_FLG_437 CHARACTER VARYING(1) 1
82 S_ACCEPTABLE_APP_FLG_440 CHARACTER VARYING(1) 1
83 S_RESIDENT_FLG_442 CHARACTER VARYING(1) 1
84 S_STAFF_IND_443 CHARACTER VARYING(1) 1
85 S_MX_N_MSECFCLT_O_ORG_445 CHARACTER VARYING(10) 10
86 S_MX_N_NMSECFCLT_O_OR_446 CHARACTER VARYING(10) 10
87 S_MX_N_EXI_SM_NMSECF_447 CHARACTER VARYING(10) 10
88 S_MX_N_EXI_SM_MSECF_448 CHARACTER VARYING(10) 10
89 S_MX_T_AT_CURR_ADDR_449 CHARACTER VARYING(10) 10
90 S_MN_T_AT_CURR_ADDR_450 CHARACTER VARYING(10) 10
91 S_MX_T_IN_CURR_EMPMT_451 CHARACTER VARYING(10) 10
92 S_MN_T_IN_CURR_EMPMT_452 CHARACTER VARYING(10) 10
93 S_MX_TOT_TIME_AT_ADDR_453 CHARACTER VARYING(10) 10
94 S_MN_TOT_TIME_AT_ADDR_454 CHARACTER VARYING(10) 10
95 S_MX_TOT_T_IN_EMPMT_455 CHARACTER VARYING(10) 10
96 S_MN_TOT_T_IN_EMPMT_456 CHARACTER VARYING(10) 10
97 S_MX_LOAN_TERMPLUSAGE_457 CHARACTER VARYING(10) 10
98 S_MN_LOAN_TERMPLUSAGE_458 CHARACTER VARYING(10) 10
99 S_MX_LOAN_TERMPLUSAGE_459 CHARACTER VARYING(10) 10
100 S_MN_LOAN_TERMPLUSAGE_460 CHARACTER VARYING(10) 10
101 S_N_OF_INDIVID_APPS_461 CHARACTER VARYING(10) 10
102 S_NUM_OF_ENTITY_APPS_462 CHARACTER VARYING(10) 10
103 S_BORROW_CONTRI2LOAN_467 CHARACTER VARYING(32) 32
104 S_AOL_APPL_479 CHARACTER VARYING(1) 1
105 S_INCOME_MULTIPLIER_480 CHARACTER VARYING(32) 32
106 S_LOANREP2NETMDISPINC_482 CHARACTER VARYING(32) 32
107 S_RQSTD_LOAN_TERM_484 CHARACTER VARYING(10) 10
108 S_RQSTD_MARGIN_485 CHARACTER VARYING(32) 32
109 S_MTHPYMTS2MTHINC_PCT_486 CHARACTER VARYING(32) 32
110 S_SEC_OR_UNSEC_FLG_488 CHARACTER VARYING(1) 1
111 S_SPARE_109_489 CHARACTER VARYING(10) 10
112 S_TOT_MLOANREP_E_LOAN_490 CHARACTER VARYING(32) 32
113 S_MTHLY_BUDGET_SURPLU_491 CHARACTER VARYING(32) 32
114 S_MTHLY_BUDGET_SURPLU_492 CHARACTER VARYING(32) 32
115 S_NET_ASSETS_493 CHARACTER VARYING(32) 32
116 S_NET_ASSETS_494 CHARACTER VARYING(32) 32
117 S_NET_MTHY_INCOME_495 CHARACTER VARYING(32) 32
118 S_NET_ASSETS_496 CHARACTER VARYING(32) 32
119 S_NET_MTHY_INCOME_497 CHARACTER VARYING(32) 32
120 S_TOT_ASSETS_499 CHARACTER VARYING(32) 32
121 S_SPARE_112_500 CHARACTER VARYING(10) 10
122 S_TOT_CR_LIM_EXI_LOAN_502 CHARACTER VARYING(32) 32
123 S_SPARE_115_503 CHARACTER VARYING(10) 10
124 S_SPARE_113_506 CHARACTER VARYING(10) 10
125 S_TOT_EXIST_SEC_REPAY_510 CHARACTER VARYING(32) 32
126 S_TOT_MLOANREP_I_LOAN_512 CHARACTER VARYING(32) 32
127 S_INPUT_OFFICER_DCA_515 CHARACTER VARYING(1) 1
128 S_ACCEPTABLE_PURP_FLG_516 CHARACTER VARYING(1) 1
129 S_BRANCH_NUM_518 CHARACTER VARYING(5) 5
130 S_BROKER_CODE_519 CHARACTER VARYING(5) 5
131 S_BORROW_CONTRI2LOAN_522 CHARACTER VARYING(32) 32
132 S_INTEREST_TYPE_528 CHARACTER VARYING(3) 3
133 S_LOAN_REPAY_AMT_534 CHARACTER VARYING(32) 32
134 S_NUM_OF_APPS_542 CHARACTER VARYING(32) 32
135 S_NUM_OF_GTORS_545 CHARACTER VARYING(32) 32
136 S_PRE_APPROVAL_FLG_549 CHARACTER VARYING(1) 1
137 S_NONPMI_POSTCODE_FLG_555 CHARACTER VARYING(1) 1
138 S_LOAN_REPAY_AMNT_620 CHARACTER VARYING(32) 32
139 S_MAX_HISTORY_WTH_S_M_642 CHARACTER VARYING(10) 10
140 S_MAX_HISTORY_WTH_S_M_643 CHARACTER VARYING(10) 10
141 S_MAX_HISTORY_WTH_S_M_644 CHARACTER VARYING(10) 10
142 S_MAX_HISTORY_WTH_S_M_645 CHARACTER VARYING(10) 10
143 S_MAX_HISTORY_WTH_S_M_646 CHARACTER VARYING(10) 10
144 S_MAX_HISTORY_WTH_S_M_647 CHARACTER VARYING(10) 10
145 S_MAX_HISTORY_WTH_S_M_648 CHARACTER VARYING(10) 10
146 S_MAX_HISTORY_WTH_S_M_649 CHARACTER VARYING(10) 10
147 S_MAX_HISTORY_WTH_S_M_650 CHARACTER VARYING(10) 10
148 S_MAX_HISTORY_WTH_S_M_651 CHARACTER VARYING(10) 10
149 S_MAX_HISTORY_WTH_S_M_652 CHARACTER VARYING(10) 10
150 S_MAX_HISTORY_WTH_S_M_653 CHARACTER VARYING(10) 10
151 S_VALIDAT_CERT_HELD_654 CHARACTER VARYING(1) 1
152 S_SPARE_116_667 CHARACTER VARYING(10) 10
153 S_SPARE_117_668 CHARACTER VARYING(10) 10
154 S_SELFEMP_INCOME_VAR_669 CHARACTER VARYING(32) 32
155 S_SPARE_114_681 CHARACTER VARYING(10) 10
156 S_TOT_REAL_ESTATE_A_682 CHARACTER VARYING(32) 32
157 S_MTGE_INS_MX_LOAN_AM_693 CHARACTER VARYING(32) 32
158 S_MTGE_INS_MAX_LVR_694 CHARACTER VARYING(32) 32
159 S_GENUIN_SAV_FLG_3PCT_695 CHARACTER VARYING(1) 1
160 S_CAMPAIGN_CODE_696 CHARACTER VARYING(8) 8
161 S_SELF_EMPLOYED_IND_698 CHARACTER VARYING(3) 3
162 S_STD_NOV_LEASE_FLG_700 CHARACTER VARYING(1) 1
163 S_E_LOAN_AVGNDAY_AR_701 CHARACTER VARYING(32) 32
164 S_E_LOAN_DIFF_P2C_FLG_702 CHARACTER VARYING(1) 1
165 S_REPROCESS_FLG_703 CHARACTER VARYING(1) 1
166 S_STD_RENTAL_APPL_FLG_704 CHARACTER VARYING(1) 1
167 S_STD_MOTOR_APPL_FLG_705 CHARACTER VARYING(1) 1
168 S_CUST_SEGMENT_APPL_706 CHARACTER VARYING(1) 1
169 S_COMPLEX_MOT_APPL_F_707 CHARACTER VARYING(1) 1
170 S_FINANC_VERIFD_IND_708 CHARACTER VARYING(1) 1
171 S_FINS_OUT_OF_DATE_709 CHARACTER VARYING(1) 1
172 S_REPLAC_SM_EF_LOAN_F_718 CHARACTER VARYING(1) 1
173 S_EXIST_S_M_LNDG_CUST_719 CHARACTER VARYING(1) 1
174 S_EXIST_SM_DEPOS_AMT_720 CHARACTER VARYING(32) 32
175 S_RESIDUAL_VALUE_AMT_721 CHARACTER VARYING(32) 32
176 S_RESIDUAL_VALUE_PCT_722 CHARACTER VARYING(32) 32
177 S_ATO_MX_RESIDUAL_VAL_723 CHARACTER VARYING(32) 32
178 S_BALLOON_PAYT_724 CHARACTER VARYING(32) 32
179 S_ATO_MAX_BALLOON_PAY_725 CHARACTER VARYING(32) 32
180 S_PRODUCT_MIN_TERM_726 CHARACTER VARYING(32) 32
181 S_PRODUCT_MAX_TERM_727 CHARACTER VARYING(32) 32
182 S_PRODUCT_MIN_MARGIN_728 CHARACTER VARYING(32) 32
183 S_DUPL_APP_FLG_L12M_736 CHARACTER VARYING(1) 1
184 S_E_MOTOR_FIN_ANCS_F_739 CHARACTER VARYING(10) 10
185 S_E_MOT_F_N_EQ2TFPCT_740 CHARACTER VARYING(32) 32
186 S_FRANCH_LIC_MOT_DEAL_742 CHARACTER VARYING(1) 1
187 S_VEH_DETAILS_YEAR_785 CHARACTER VARYING(4) 4
188 S_VEH_DETAILS_MAKE_786 CHARACTER VARYING(20) 20
189 S_VEH_DETAILS_MODEL_787 CHARACTER VARYING(20) 20
190 S_VEH_VAL_TRD_LOWPRC_793 CHARACTER VARYING(32) 32
191 S_VEH_VAL_TRADEPRICE_794 CHARACTER VARYING(32) 32
192 S_VEH_VAL_RETAILPRICE_795 CHARACTER VARYING(32) 32
193 S_VEH_VAL_MARKETVALUE_796 CHARACTER VARYING(32) 32
194 S_VEH_VAL_MAR_VAL_RET_797 CHARACTER VARYING(32) 32
195 S_VEH_VAL_DEPRTN_RATE_798 CHARACTER VARYING(32) 32
196 S_NUM_OF_INDIVIDUALS_967 CHARACTER VARYING(10) 10
197 S_LOAN_REPY2NET_M_INC_968 CHARACTER VARYING(32) 32
198 S_SPARE_11_969 CHARACTER VARYING(10) 10
199 S_SPARE_12_970 CHARACTER VARYING(32) 32
200 S_SPARE_13_971 CHARACTER VARYING(10) 10
201 S_SPARE_14_972 CHARACTER VARYING(10) 10
202 S_SPARE_15_973 CHARACTER VARYING(10) 10
203 S_SPARE_16_974 CHARACTER VARYING(10) 10
204 S_SPARE_17_975 CHARACTER VARYING(10) 10
205 S_SPARE_18_976 CHARACTER VARYING(10) 10
206 S_SPARE_19_977 CHARACTER VARYING(10) 10
207 S_SPARE_20_978 CHARACTER VARYING(10) 10
208 S_DEBT_AGREEMENT_FLG_985 CHARACTER VARYING(1) 1
209 S_DEBT_AGRMNT_COMPL_F_986 CHARACTER VARYING(1) 1
210 S_SPARE_29_987 CHARACTER VARYING(1) 1
211 S_SPARE_30_988 CHARACTER VARYING(1) 1
212 S_SPARE_31_989 CHARACTER VARYING(1) 1
213 S_SPARE_32_990 CHARACTER VARYING(1) 1
214 S_SPARE_33_991 CHARACTER VARYING(1) 1
215 S_SPARE_34_992 CHARACTER VARYING(1) 1
216 S_SPARE_35_993 CHARACTER VARYING(1) 1
217 S_SPARE_36_994 CHARACTER VARYING(1) 1
218 S_SPARE_37_995 CHARACTER VARYING(1) 1
219 S_SPARE_38_996 CHARACTER VARYING(1) 1
220 S_SPARE_39_997 CHARACTER VARYING(1) 1
221 S_SPARE_40_998 CHARACTER VARYING(1) 1
222 S_SPARE_41_999 CHARACTER VARYING(1) 1
223 S_SPARE_42_1000 CHARACTER VARYING(1) 1
224 S_SPARE_43_1001 CHARACTER VARYING(1) 1
225 S_SPARE_44_1002 CHARACTER VARYING(1) 1
226 S_SPARE_45_1003 CHARACTER VARYING(1) 1
227 S_SPARE_46_1004 CHARACTER VARYING(1) 1
228 S_SPARE_47_1005 CHARACTER VARYING(1) 1
229 S_SPARE_48_1006 CHARACTER VARYING(1) 1
230 S_SPARE_49_1007 CHARACTER VARYING(1) 1
231 S_SPARE_50_1008 CHARACTER VARYING(1) 1
232 S_PRODUCT_MIN_AMT_1017 CHARACTER VARYING(32) 32
233 S_TOT_BO_SECSM_LOAN_1018 CHARACTER VARYING(32) 32
234 S_TOT_BO_SECSM_LOAN_1019 CHARACTER VARYING(32) 32
235 S_TOT_BO_USECSM_LOAN_1020 CHARACTER VARYING(32) 32
236 S_TOT_BO_USECSM_LOAN_1021 CHARACTER VARYING(32) 32
237 S_TOT_BO_ALLSEC_LOAN_1022 CHARACTER VARYING(32) 32
238 S_TOT_BO_ALLSEC_LOAN_1023 CHARACTER VARYING(32) 32
239 S_TOT_BO_ALLUSEC_LOA_1024 CHARACTER VARYING(32) 32
240 S_TOT_BO_ALLUSEC_LOA_1025 CHARACTER VARYING(32) 32
241 S_SPARE_68_1026 CHARACTER VARYING(10) 10
242 S_SPARE_69_1027 CHARACTER VARYING(10) 10
243 S_SPARE_70_1028 CHARACTER VARYING(10) 10
244 S_SPEC_LOAN_PRD_CODE_1033 CHARACTER VARYING(4) 4
245 S_SPARE_76_1034 CHARACTER VARYING(4) 4
246 S_SPARE_77_1035 CHARACTER VARYING(4) 4
247 S_SPARE_78_1036 CHARACTER VARYING(4) 4
248 S_SPARE_79_1037 CHARACTER VARYING(4) 4
249 S_SPARE_80_1038 CHARACTER VARYING(4) 4
250 S_SPARE_81_1039 CHARACTER VARYING(4) 4
251 S_SPARE_82_1040 CHARACTER VARYING(4) 4
252 S_SPARE_83_1041 CHARACTER VARYING(4) 4
253 S_SPARE_84_1042 CHARACTER VARYING(4) 4
254 S_SPARE_85_1043 CHARACTER VARYING(4) 4
255 S_SPARE_86_1044 CHARACTER VARYING(4) 4
256 S_SPARE_87_1045 CHARACTER VARYING(4) 4
257 S_SPARE_88_1046 CHARACTER VARYING(4) 4
258 S_SPARE_89_1047 CHARACTER VARYING(4) 4
259 S_SPARE_90_1048 CHARACTER VARYING(4) 4
260 S_SPARE_91_1049 CHARACTER VARYING(8) 8
261 S_SPARE_96_1054 CHARACTER VARYING(8) 8
262 S_SPARE_97_1055 CHARACTER VARYING(8) 8
263 S_SPARE_98_1056 CHARACTER VARYING(8) 8
264 S_SPARE_99_1057 CHARACTER VARYING(8) 8
265 S_SPARE_100_1058 CHARACTER VARYING(8) 8
266 S_CURRENT_CALL_TYPE_1059 CHARACTER VARYING(10) 10
267 S_N_DAYS_APPL_PROCSD_1060 CHARACTER VARYING(10) 10