OBP24_HST_CZ_SC_OR_EXPR_DECISION

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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 INTEGER 4
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 BIGINT 8
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 SMALLINT 2
14 S_N_NREV_FCLTY_O_ORG_289 SMALLINT 2
15 S_N_EXI_SM_NREV_FCLTY_290 SMALLINT 2
16 S_N_EXI_SM_REV_FCLTY_291 SMALLINT 2
17 S_N_MSEC_FCLTY_O_ORG_292 SMALLINT 2
18 S_N_NMSEC_FCLTY_O_ORG_293 SMALLINT 2
19 S_N_EXI_SM_NMSECFCLTY_294 SMALLINT 2
20 S_N_EXI_SM_MSEC_FCLTY_295 SMALLINT 2
21 S_SPARE_110_296 BIGINT 8
22 S_RESDT_STATUS_297 CHARACTER VARYING(1) 1
23 S_T_AT_CURR_ADDR_MMM_298 SMALLINT 2
24 S_T_AT_PRE_ADDR_MMM_299 SMALLINT 2
25 S_T_IN_CUR_EMPMT_MMM_300 SMALLINT 2
26 S_T_IN_PRE_EMPMT_MMM_301 SMALLINT 2
27 S_TOT_N_OF_DEPENDANTS_302 SMALLINT 2
28 S_TOT_T_AT_ADDRS_MMM_303 SMALLINT 2
29 S_TOT_T_IN_EMPMT_MMM_304 SMALLINT 2
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(5) 5
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 INTEGER 4
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 BIGINT 8
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 SMALLINT 2
52 S_N_NREV_FCLTY_O_ORG_349 SMALLINT 2
53 S_N_EXI_SM_NREV_FCLTY_350 SMALLINT 2
54 S_N_EXI_SM_REV_FCLTY_351 SMALLINT 2
55 S_N_MSEC_FCLTY_O_ORGS_352 SMALLINT 2
56 S_N_NMSEC_FCLTY_O_ORG_353 SMALLINT 2
57 S_N_EXI_SM_NMSEC_FCLT_354 SMALLINT 2
58 S_N_EXI_SM_MSEC_FCLTY_355 SMALLINT 2
59 S_SPARE_111_356 BIGINT 8
60 S_RESDT_STATUS_357 CHARACTER VARYING(1) 1
61 S_T_AT_CURR_ADDR_MMM_358 SMALLINT 2
62 S_T_AT_PREV_ADDR_MMM_359 SMALLINT 2
63 S_T_IN_CUR_EMPMT_MMM_360 SMALLINT 2
64 S_T_IN_PRE_EMPMT_MMM_361 SMALLINT 2
65 S_TOT_NUM_DEPENDANTS_362 SMALLINT 2
66 S_TOT_T_AT_ADDR_MMM_363 SMALLINT 2
67 S_TOT_T_IN_EMPMT_MMM_364 SMALLINT 2
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(5) 5
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 INTEGER 4
78 S_MIN_AGE_434 INTEGER 4
79 S_MAX_AGE_435 INTEGER 4
80 S_MIN_AGE_436 INTEGER 4
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 SMALLINT 2
86 S_MX_N_NMSECFCLT_O_OR_446 SMALLINT 2
87 S_MX_N_EXI_SM_NMSECF_447 SMALLINT 2
88 S_MX_N_EXI_SM_MSECF_448 SMALLINT 2
89 S_MX_T_AT_CURR_ADDR_449 SMALLINT 2
90 S_MN_T_AT_CURR_ADDR_450 SMALLINT 2
91 S_MX_T_IN_CURR_EMPMT_451 SMALLINT 2
92 S_MN_T_IN_CURR_EMPMT_452 SMALLINT 2
93 S_MX_TOT_TIME_AT_ADDR_453 SMALLINT 2
94 S_MN_TOT_TIME_AT_ADDR_454 SMALLINT 2
95 S_MX_TOT_T_IN_EMPMT_455 SMALLINT 2
96 S_MN_TOT_T_IN_EMPMT_456 SMALLINT 2
97 S_MX_LOAN_TERMPLUSAGE_457 SMALLINT 2
98 S_MN_LOAN_TERMPLUSAGE_458 SMALLINT 2
99 S_MX_LOAN_TERMPLUSAGE_459 SMALLINT 2
100 S_MN_LOAN_TERMPLUSAGE_460 SMALLINT 2
101 S_N_OF_INDIVID_APPS_461 SMALLINT 2
102 S_NUM_OF_ENTITY_APPS_462 SMALLINT 2
103 S_BORROW_CONTRI2LOAN_467 SMALLINT 2
104 S_AOL_APPL_479 CHARACTER VARYING(1) 1
105 S_INCOME_MULTIPLIER_480 NUMERIC(9,2) 19
106 S_LOANREP2NETMDISPINC_482 SMALLINT 2
107 S_RQSTD_LOAN_TERM_484 SMALLINT 2
108 S_RQSTD_MARGIN_485 NUMERIC(9,2) 19
109 S_MTHPYMTS2MTHINC_PCT_486 SMALLINT 2
110 S_SEC_OR_UNSEC_FLG_488 CHARACTER VARYING(1) 1
111 S_SPARE_109_489 INTEGER 4
112 S_TOT_MLOANREP_E_LOAN_490 INTEGER 4
113 S_MTHLY_BUDGET_SURPLU_491 INTEGER 4
114 S_MTHLY_BUDGET_SURPLU_492 INTEGER 4
115 S_NET_ASSETS_493 INTEGER 4
116 S_NET_ASSETS_494 INTEGER 4
117 S_NET_MTHY_INCOME_495 INTEGER 4
118 S_NET_ASSETS_496 INTEGER 4
119 S_NET_MTHY_INCOME_497 INTEGER 4
120 S_TOT_ASSETS_499 INTEGER 4
121 S_SPARE_112_500 INTEGER 4
122 S_TOT_CR_LIM_EXI_LOAN_502 INTEGER 4
123 S_SPARE_115_503 INTEGER 4
124 S_SPARE_113_506 INTEGER 4
125 S_TOT_EXIST_SEC_REPAY_510 SMALLINT 2
126 S_TOT_MLOANREP_I_LOAN_512 INTEGER 4
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 INTEGER 4
132 S_INTEREST_TYPE_528 CHARACTER VARYING(3) 3
133 S_LOAN_REPAY_AMT_534 INTEGER 4
134 S_NUM_OF_APPS_542 SMALLINT 2
135 S_NUM_OF_GTORS_545 SMALLINT 2
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 INTEGER 4
139 S_MAX_HISTORY_WTH_S_M_642 SMALLINT 2
140 S_MAX_HISTORY_WTH_S_M_643 SMALLINT 2
141 S_MAX_HISTORY_WTH_S_M_644 SMALLINT 2
142 S_MAX_HISTORY_WTH_S_M_645 SMALLINT 2
143 S_MAX_HISTORY_WTH_S_M_646 SMALLINT 2
144 S_MAX_HISTORY_WTH_S_M_647 SMALLINT 2
145 S_MAX_HISTORY_WTH_S_M_648 SMALLINT 2
146 S_MAX_HISTORY_WTH_S_M_649 SMALLINT 2
147 S_MAX_HISTORY_WTH_S_M_650 SMALLINT 2
148 S_MAX_HISTORY_WTH_S_M_651 SMALLINT 2
149 S_MAX_HISTORY_WTH_S_M_652 SMALLINT 2
150 S_MAX_HISTORY_WTH_S_M_653 SMALLINT 2
151 S_VALIDAT_CERT_HELD_654 CHARACTER VARYING(1) 1
152 S_SPARE_116_667 SMALLINT 2
153 S_SPARE_117_668 SMALLINT 2
154 S_SELFEMP_INCOME_VAR_669 SMALLINT 2
155 S_SPARE_114_681 INTEGER 4
156 S_TOT_REAL_ESTATE_A_682 INTEGER 4
157 S_MTGE_INS_MX_LOAN_AM_693 BIGINT 8
158 S_MTGE_INS_MAX_LVR_694 NUMERIC(7,2) 19
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 SMALLINT 2
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 BIGINT 8
175 S_RESIDUAL_VALUE_AMT_721 BIGINT 8
176 S_RESIDUAL_VALUE_PCT_722 NUMERIC(9,2) 19
177 S_ATO_MX_RESIDUAL_VAL_723 BIGINT 8
178 S_BALLOON_PAYT_724 BIGINT 8
179 S_ATO_MAX_BALLOON_PAY_725 BIGINT 8
180 S_PRODUCT_MIN_TERM_726 SMALLINT 2
181 S_PRODUCT_MAX_TERM_727 SMALLINT 2
182 S_PRODUCT_MIN_MARGIN_728 NUMERIC(9,2) 19
183 S_DUPL_APP_FLG_L12M_736 CHARACTER VARYING(1) 1
184 S_E_MOTOR_FIN_ANCS_F_739 BIGINT 8
185 S_E_MOT_F_N_EQ2TFPCT_740 NUMERIC(9,2) 19
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 INTEGER 4
191 S_VEH_VAL_TRADEPRICE_794 INTEGER 4
192 S_VEH_VAL_RETAILPRICE_795 INTEGER 4
193 S_VEH_VAL_MARKETVALUE_796 INTEGER 4
194 S_VEH_VAL_MAR_VAL_RET_797 NUMERIC(8,3) 19
195 S_VEH_VAL_DEPRTN_RATE_798 NUMERIC(8,3) 19
196 S_NUM_OF_INDIVIDUALS_967 SMALLINT 2
197 S_LOAN_REPY2NET_M_INC_968 SMALLINT 2
198 S_SPARE_11_969 SMALLINT 2
199 S_SPARE_12_970 SMALLINT 2
200 S_SPARE_13_971 SMALLINT 2
201 S_SPARE_14_972 SMALLINT 2
202 S_SPARE_15_973 SMALLINT 2
203 S_SPARE_16_974 SMALLINT 2
204 S_SPARE_17_975 SMALLINT 2
205 S_SPARE_18_976 SMALLINT 2
206 S_SPARE_19_977 SMALLINT 2
207 S_SPARE_20_978 SMALLINT 2
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 BIGINT 8
233 S_TOT_BO_SECSM_LOAN_1018 BIGINT 8
234 S_TOT_BO_SECSM_LOAN_1019 BIGINT 8
235 S_TOT_BO_USECSM_LOAN_1020 BIGINT 8
236 S_TOT_BO_USECSM_LOAN_1021 BIGINT 8
237 S_TOT_BO_ALLSEC_LOAN_1022 BIGINT 8
238 S_TOT_BO_ALLSEC_LOAN_1023 BIGINT 8
239 S_TOT_BO_ALLUSEC_LOA_1024 BIGINT 8
240 S_TOT_BO_ALLUSEC_LOA_1025 BIGINT 8
241 S_SPARE_68_1026 BIGINT 8
242 S_SPARE_69_1027 BIGINT 8
243 S_SPARE_70_1028 BIGINT 8
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 SMALLINT 2
267 S_N_DAYS_APPL_PROCSD_1060 SMALLINT 2
268 U_COARSE_PRIMARY_ROLE_276 CHARACTER VARYING(3) 3
269 U_FINE_PRIMARY_ROLE_277 CHARACTER VARYING(3) 3
270 U_SPARE_104_278 CHARACTER VARYING(1) 1
271 U_AGE_279 INTEGER 4
272 U_EMPMT_STATUS_280 CHARACTER VARYING(2) 2
273 U_EXIST_CUST_FLG_281 CHARACTER VARYING(1) 1
274 U_EXIST_LNDG_CUST_282 CHARACTER VARYING(1) 1
275 U_SPARE_107_283 BIGINT 8
276 U_HOME_TELEPHONE_FLG_285 CHARACTER VARYING(1) 1
277 U_EMAIL_ADDRESS_FLG_286 CHARACTER VARYING(1) 1
278 U_FAX_FLG_287 CHARACTER VARYING(1) 1
279 U_N_REV_FCLTY_O_ORGS_288 SMALLINT 2
280 U_N_NREV_FCLTY_O_ORG_289 SMALLINT 2
281 U_N_EXI_SM_NREV_FCLTY_290 SMALLINT 2
282 U_N_EXI_SM_REV_FCLTY_291 SMALLINT 2
283 U_N_MSEC_FCLTY_O_ORG_292 SMALLINT 2
284 U_N_NMSEC_FCLTY_O_ORG_293 SMALLINT 2
285 U_N_EXI_SM_NMSECFCLTY_294 SMALLINT 2
286 U_N_EXI_SM_MSEC_FCLTY_295 SMALLINT 2
287 U_SPARE_110_296 BIGINT 8
288 U_RESDT_STATUS_297 CHARACTER VARYING(1) 1
289 U_T_AT_CURR_ADDR_MMM_298 SMALLINT 2
290 U_T_AT_PRE_ADDR_MMM_299 SMALLINT 2
291 U_T_IN_CUR_EMPMT_MMM_300 SMALLINT 2
292 U_T_IN_PRE_EMPMT_MMM_301 SMALLINT 2
293 U_TOT_N_OF_DEPENDANTS_302 SMALLINT 2
294 U_TOT_T_AT_ADDRS_MMM_303 SMALLINT 2
295 U_TOT_T_IN_EMPMT_MMM_304 SMALLINT 2
296 U_HOME_POST_CODE_308 CHARACTER VARYING(4) 4
297 U_STATE_OF_RESIDENCE_309 CHARACTER VARYING(4) 4
298 U_DRIVERS_LICENCE_IND_310 CHARACTER VARYING(1) 1
299 U_EDUCATION_LEVEL_313 CHARACTER VARYING(4) 4
300 U_MOBILE_TELEPH_FLG_319 CHARACTER VARYING(1) 1
301 U_OCCUPATION_321 CHARACTER VARYING(5) 5
302 U_PRO_PACK_APPL_323 CHARACTER VARYING(1) 1
303 U_REFEREE_PROV_FLG_325 CHARACTER VARYING(1) 1
304 U_SPARE_102_332 CHARACTER VARYING(3) 3
305 U_RSHIP2ANY_NAMED_APP_334 CHARACTER VARYING(3) 3
306 U_COARSE_PRIMARY_ROLE_336 CHARACTER VARYING(3) 3
307 U_FINE_PRIMARY_ROLE_337 CHARACTER VARYING(3) 3
308 U_SPARE_105_338 CHARACTER VARYING(1) 1
309 U_AGE_339 INTEGER 4
310 U_EMPMT_STATUS_340 CHARACTER VARYING(2) 2
311 U_EXIST_CUST_FLG_341 CHARACTER VARYING(1) 1
312 U_EXIST_LNDG_CUST_342 CHARACTER VARYING(1) 1
313 U_SPARE_108_343 BIGINT 8
314 U_HOME_TELEPHONE_FLG_345 CHARACTER VARYING(1) 1
315 U_EMAIL_ADDRESS_FLG_346 CHARACTER VARYING(1) 1
316 U_FAX_FLG_347 CHARACTER VARYING(1) 1
317 U_N_REV_FCLTY_O_ORGS_348 SMALLINT 2
318 U_N_NREV_FCLTY_O_ORG_349 SMALLINT 2
319 U_N_EXI_SM_NREV_FCLTY_350 SMALLINT 2
320 U_N_EXI_SM_REV_FCLTY_351 SMALLINT 2
321 U_N_MSEC_FCLTY_O_ORGS_352 SMALLINT 2
322 U_N_NMSEC_FCLTY_O_ORG_353 SMALLINT 2
323 U_N_EXI_SM_NMSEC_FCLT_354 SMALLINT 2
324 U_N_EXI_SM_MSEC_FCLTY_355 SMALLINT 2
325 U_SPARE_111_356 BIGINT 8
326 U_RESDT_STATUS_357 CHARACTER VARYING(1) 1
327 U_T_AT_CURR_ADDR_MMM_358 SMALLINT 2
328 U_T_AT_PREV_ADDR_MMM_359 SMALLINT 2
329 U_T_IN_CUR_EMPMT_MMM_360 SMALLINT 2
330 U_T_IN_PRE_EMPMT_MMM_361 SMALLINT 2
331 U_TOT_NUM_DEPENDANTS_362 SMALLINT 2
332 U_TOT_T_AT_ADDR_MMM_363 SMALLINT 2
333 U_TOT_T_IN_EMPMT_MMM_364 SMALLINT 2
334 U_HOME_POST_CODE_368 CHARACTER VARYING(4) 4
335 U_STATE_OF_RESIDENCE_369 CHARACTER VARYING(4) 4
336 U_DRIVERS_LICENCE_IND_370 CHARACTER VARYING(1) 1
337 U_EDUCATION_LEVEL_373 CHARACTER VARYING(4) 4
338 U_MOBILE_TELEPH_FLG_379 CHARACTER VARYING(1) 1
339 U_OCCUPATION_381 CHARACTER VARYING(5) 5
340 U_REFEREE_PROV_FLG_384 CHARACTER VARYING(1) 1
341 U_SPARE_103_391 CHARACTER VARYING(3) 3
342 U_RSHIP2ANY_NAMED_APP_393 CHARACTER VARYING(3) 3
343 U_MAX_AGE_433 INTEGER 4
344 U_MIN_AGE_434 INTEGER 4
345 U_MAX_AGE_435 INTEGER 4
346 U_MIN_AGE_436 INTEGER 4
347 U_FIRST_T_BUYER_FLG_437 CHARACTER VARYING(1) 1
348 U_ACCEPTABLE_APP_FLG_440 CHARACTER VARYING(1) 1
349 U_RESIDENT_FLG_442 CHARACTER VARYING(1) 1
350 U_STAFF_IND_443 CHARACTER VARYING(1) 1
351 U_MX_N_MSECFCLT_O_ORG_445 SMALLINT 2
352 U_MX_N_NMSECFCLT_O_OR_446 SMALLINT 2
353 U_MX_N_EXI_SM_NMSECF_447 SMALLINT 2
354 U_MX_N_EXI_SM_MSECF_448 SMALLINT 2
355 U_MX_T_AT_CURR_ADDR_449 SMALLINT 2
356 U_MN_T_AT_CURR_ADDR_450 SMALLINT 2
357 U_MX_T_IN_CURR_EMPMT_451 SMALLINT 2
358 U_MN_T_IN_CURR_EMPMT_452 SMALLINT 2
359 U_MX_TOT_TIME_AT_ADDR_453 SMALLINT 2
360 U_MN_TOT_TIME_AT_ADDR_454 SMALLINT 2
361 U_MX_TOT_T_IN_EMPMT_455 SMALLINT 2
362 U_MN_TOT_T_IN_EMPMT_456 SMALLINT 2
363 U_MX_LOAN_TERMPLUSAGE_457 SMALLINT 2
364 U_MN_LOAN_TERMPLUSAGE_458 SMALLINT 2
365 U_MX_LOAN_TERMPLUSAGE_459 SMALLINT 2
366 U_MN_LOAN_TERMPLUSAGE_460 SMALLINT 2
367 U_N_OF_INDIVID_APPS_461 SMALLINT 2
368 U_NUM_OF_ENTITY_APPS_462 SMALLINT 2
369 U_BORROW_CONTRI2LOAN_467 SMALLINT 2
370 U_AOL_APPL_479 CHARACTER VARYING(1) 1
371 U_INCOME_MULTIPLIER_480 NUMERIC(9,2) 19
372 U_LOANREP2NETMDISPINC_482 SMALLINT 2
373 U_RQSTD_LOAN_TERM_484 SMALLINT 2
374 U_RQSTD_MARGIN_485 NUMERIC(9,2) 19
375 U_MTHPYMTS2MTHINC_PCT_486 SMALLINT 2
376 U_SEC_OR_UNSEC_FLG_488 CHARACTER VARYING(1) 1
377 U_SPARE_109_489 INTEGER 4
378 U_TOT_MLOANREP_E_LOAN_490 INTEGER 4
379 U_MTHLY_BUDGET_SURPLU_491 INTEGER 4
380 U_MTHLY_BUDGET_SURPLU_492 INTEGER 4
381 U_NET_ASSETS_493 INTEGER 4
382 U_NET_ASSETS_494 INTEGER 4
383 U_NET_MTHY_INCOME_495 INTEGER 4
384 U_NET_ASSETS_496 INTEGER 4
385 U_NET_MTHY_INCOME_497 INTEGER 4
386 U_TOT_ASSETS_499 INTEGER 4
387 U_SPARE_112_500 INTEGER 4
388 U_TOT_CR_LIM_EXI_LOAN_502 INTEGER 4
389 U_SPARE_115_503 INTEGER 4
390 U_SPARE_113_506 INTEGER 4
391 U_TOT_EXIST_SEC_REPAY_510 SMALLINT 2
392 U_TOT_MLOANREP_I_LOAN_512 INTEGER 4
393 U_INPUT_OFFICER_DCA_515 CHARACTER VARYING(1) 1
394 U_ACCEPTABLE_PURP_FLG_516 CHARACTER VARYING(1) 1
395 U_BRANCH_NUM_518 CHARACTER VARYING(5) 5
396 U_BROKER_CODE_519 CHARACTER VARYING(5) 5
397 U_BORROW_CONTRI2LOAN_522 INTEGER 4
398 U_INTEREST_TYPE_528 CHARACTER VARYING(3) 3
399 U_LOAN_REPAY_AMT_534 INTEGER 4
400 U_NUM_OF_APPS_542 SMALLINT 2
401 U_NUM_OF_GTORS_545 SMALLINT 2
402 U_PRE_APPROVAL_FLG_549 CHARACTER VARYING(1) 1
403 U_NONPMI_POSTCODE_FLG_555 CHARACTER VARYING(1) 1
404 U_LOAN_REPAY_AMNT_620 INTEGER 4
405 U_MAX_HISTORY_WTH_S_M_642 SMALLINT 2
406 U_MAX_HISTORY_WTH_S_M_643 SMALLINT 2
407 U_MAX_HISTORY_WTH_S_M_644 SMALLINT 2
408 U_MAX_HISTORY_WTH_S_M_645 SMALLINT 2
409 U_MAX_HISTORY_WTH_S_M_646 SMALLINT 2
410 U_MAX_HISTORY_WTH_S_M_647 SMALLINT 2
411 U_MAX_HISTORY_WTH_S_M_648 SMALLINT 2
412 U_MAX_HISTORY_WTH_S_M_649 SMALLINT 2
413 U_MAX_HISTORY_WTH_S_M_650 SMALLINT 2
414 U_MAX_HISTORY_WTH_S_M_651 SMALLINT 2
415 U_MAX_HISTORY_WTH_S_M_652 SMALLINT 2
416 U_MAX_HISTORY_WTH_S_M_653 SMALLINT 2
417 U_VALIDAT_CERT_HELD_654 CHARACTER VARYING(1) 1
418 U_SPARE_116_667 SMALLINT 2
419 U_SPARE_117_668 SMALLINT 2
420 U_SELFEMP_INCOME_VAR_669 SMALLINT 2
421 U_SPARE_114_681 INTEGER 4
422 U_TOT_REAL_ESTATE_A_682 INTEGER 4
423 U_MTGE_INS_MX_LOAN_AM_693 BIGINT 8
424 U_MTGE_INS_MAX_LVR_694 NUMERIC(7,2) 19
425 U_GENUIN_SAV_FLG_3PCT_695 CHARACTER VARYING(1) 1
426 U_CAMPAIGN_CODE_696 CHARACTER VARYING(8) 8
427 U_SELF_EMPLOYED_IND_698 CHARACTER VARYING(3) 3
428 U_STD_NOV_LEASE_FLG_700 CHARACTER VARYING(1) 1
429 U_E_LOAN_AVGNDAY_AR_701 SMALLINT 2
430 U_E_LOAN_DIFF_P2C_FLG_702 CHARACTER VARYING(1) 1
431 U_REPROCESS_FLG_703 CHARACTER VARYING(1) 1
432 U_STD_RENTAL_APPL_FLG_704 CHARACTER VARYING(1) 1
433 U_STD_MOTOR_APPL_FLG_705 CHARACTER VARYING(1) 1
434 U_CUST_SEGMENT_APPL_706 CHARACTER VARYING(1) 1
435 U_COMPLEX_MOT_APPL_F_707 CHARACTER VARYING(1) 1
436 U_FINANC_VERIFD_IND_708 CHARACTER VARYING(1) 1
437 U_FINS_OUT_OF_DATE_709 CHARACTER VARYING(1) 1
438 U_REPLAC_SM_EF_LOAN_F_718 CHARACTER VARYING(1) 1
439 U_EXIST_S_M_LNDG_CUST_719 CHARACTER VARYING(1) 1
440 U_EXIST_SM_DEPOS_AMT_720 BIGINT 8
441 U_RESIDUAL_VALUE_AMT_721 BIGINT 8
442 U_RESIDUAL_VALUE_PCT_722 NUMERIC(9,2) 19
443 U_ATO_MX_RESIDUAL_VAL_723 BIGINT 8
444 U_BALLOON_PAYT_724 BIGINT 8
445 U_ATO_MAX_BALLOON_PAY_725 BIGINT 8
446 U_PRODUCT_MIN_TERM_726 SMALLINT 2
447 U_PRODUCT_MAX_TERM_727 SMALLINT 2
448 U_PRODUCT_MIN_MARGIN_728 NUMERIC(9,2) 19
449 U_DUPL_APP_FLG_L12M_736 CHARACTER VARYING(1) 1
450 U_E_MOTOR_FIN_ANCS_F_739 BIGINT 8
451 U_E_MOT_F_N_EQ2TFPCT_740 NUMERIC(9,2) 19
452 U_FRANCH_LIC_MOT_DEAL_742 CHARACTER VARYING(1) 1
453 U_VEH_DETAILS_YEAR_785 CHARACTER VARYING(4) 4
454 U_VEH_DETAILS_MAKE_786 CHARACTER VARYING(20) 20
455 U_VEH_DETAILS_MODEL_787 CHARACTER VARYING(20) 20
456 U_VEH_VAL_TRD_LOWPRC_793 INTEGER 4
457 U_VEH_VAL_TRADEPRICE_794 INTEGER 4
458 U_VEH_VAL_RETAILPRICE_795 INTEGER 4
459 U_VEH_VAL_MARKETVALUE_796 INTEGER 4
460 U_VEH_VAL_MAR_VAL_RET_797 NUMERIC(8,3) 19
461 U_VEH_VAL_DEPRTN_RATE_798 NUMERIC(8,3) 19
462 U_NUM_OF_INDIVIDUALS_967 SMALLINT 2
463 U_LOAN_REPY2NET_M_INC_968 SMALLINT 2
464 U_SPARE_11_969 SMALLINT 2
465 U_SPARE_12_970 SMALLINT 2
466 U_SPARE_13_971 SMALLINT 2
467 U_SPARE_14_972 SMALLINT 2
468 U_SPARE_15_973 SMALLINT 2
469 U_SPARE_16_974 SMALLINT 2
470 U_SPARE_17_975 SMALLINT 2
471 U_SPARE_18_976 SMALLINT 2
472 U_SPARE_19_977 SMALLINT 2
473 U_SPARE_20_978 SMALLINT 2
474 U_DEBT_AGREEMENT_FLG_985 CHARACTER VARYING(1) 1
475 U_DEBT_AGRMNT_COMPL_F_986 CHARACTER VARYING(1) 1
476 U_SPARE_29_987 CHARACTER VARYING(1) 1
477 U_SPARE_30_988 CHARACTER VARYING(1) 1
478 U_SPARE_31_989 CHARACTER VARYING(1) 1
479 U_SPARE_32_990 CHARACTER VARYING(1) 1
480 U_SPARE_33_991 CHARACTER VARYING(1) 1
481 U_SPARE_34_992 CHARACTER VARYING(1) 1
482 U_SPARE_35_993 CHARACTER VARYING(1) 1
483 U_SPARE_36_994 CHARACTER VARYING(1) 1
484 U_SPARE_37_995 CHARACTER VARYING(1) 1
485 U_SPARE_38_996 CHARACTER VARYING(1) 1
486 U_SPARE_39_997 CHARACTER VARYING(1) 1
487 U_SPARE_40_998 CHARACTER VARYING(1) 1
488 U_SPARE_41_999 CHARACTER VARYING(1) 1
489 U_SPARE_42_1000 CHARACTER VARYING(1) 1
490 U_SPARE_43_1001 CHARACTER VARYING(1) 1
491 U_SPARE_44_1002 CHARACTER VARYING(1) 1
492 U_SPARE_45_1003 CHARACTER VARYING(1) 1
493 U_SPARE_46_1004 CHARACTER VARYING(1) 1
494 U_SPARE_47_1005 CHARACTER VARYING(1) 1
495 U_SPARE_48_1006 CHARACTER VARYING(1) 1
496 U_SPARE_49_1007 CHARACTER VARYING(1) 1
497 U_SPARE_50_1008 CHARACTER VARYING(1) 1
498 U_PRODUCT_MIN_AMT_1017 BIGINT 8
499 U_TOT_BO_SECSM_LOAN_1018 BIGINT 8
500 U_TOT_BO_SECSM_LOAN_1019 BIGINT 8
501 U_TOT_BO_USECSM_LOAN_1020 BIGINT 8
502 U_TOT_BO_USECSM_LOAN_1021 BIGINT 8
503 U_TOT_BO_ALLSEC_LOAN_1022 BIGINT 8
504 U_TOT_BO_ALLSEC_LOAN_1023 BIGINT 8
505 U_TOT_BO_ALLUSEC_LOA_1024 BIGINT 8
506 U_TOT_BO_ALLUSEC_LOA_1025 BIGINT 8
507 U_SPARE_68_1026 BIGINT 8
508 U_SPARE_69_1027 BIGINT 8
509 U_SPARE_70_1028 BIGINT 8
510 U_SPEC_LOAN_PRD_CODE_1033 CHARACTER VARYING(4) 4
511 U_SPARE_76_1034 CHARACTER VARYING(4) 4
512 U_SPARE_77_1035 CHARACTER VARYING(4) 4
513 U_SPARE_78_1036 CHARACTER VARYING(4) 4
514 U_SPARE_79_1037 CHARACTER VARYING(4) 4
515 U_SPARE_80_1038 CHARACTER VARYING(4) 4
516 U_SPARE_81_1039 CHARACTER VARYING(4) 4
517 U_SPARE_82_1040 CHARACTER VARYING(4) 4
518 U_SPARE_83_1041 CHARACTER VARYING(4) 4
519 U_SPARE_84_1042 CHARACTER VARYING(4) 4
520 U_SPARE_85_1043 CHARACTER VARYING(4) 4
521 U_SPARE_86_1044 CHARACTER VARYING(4) 4
522 U_SPARE_87_1045 CHARACTER VARYING(4) 4
523 U_SPARE_88_1046 CHARACTER VARYING(4) 4
524 U_SPARE_89_1047 CHARACTER VARYING(4) 4
525 U_SPARE_90_1048 CHARACTER VARYING(4) 4
526 U_SPARE_91_1049 CHARACTER VARYING(8) 8
527 U_SPARE_96_1054 CHARACTER VARYING(8) 8
528 U_SPARE_97_1055 CHARACTER VARYING(8) 8
529 U_SPARE_98_1056 CHARACTER VARYING(8) 8
530 U_SPARE_99_1057 CHARACTER VARYING(8) 8
531 U_SPARE_100_1058 CHARACTER VARYING(8) 8
532 U_CURRENT_CALL_TYPE_1059 SMALLINT 2
533 U_N_DAYS_APPL_PROCSD_1060 SMALLINT 2
534 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
535 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
536 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
537 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8