obp24_hst_cz_sc_or_expr_req_applicant

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 master_key character varying 150
2 submission_id character varying 60
3 application_id character varying 60
4 applicant_id character varying 60
5 age numeric 20
6 coarse_primary_role character varying 9
7 drivers_licence_ind character varying 3
8 email_address_flg character varying 3
9 empmt_status character varying 6
10 exist_cust_flg character varying 3
11 exist_lndg_cust_exclcc character varying 3
12 fax_flg character varying 3
13 fine_primary_role character varying 9
14 home_post_code character varying 12
15 home_telephone_flg character varying 3
16 referee_provided_flg character varying 3
17 resdt_status character varying 3
18 rship_to_any_named_app character varying 9
19 state_of_residence character varying 12
20 time_at_curr_addr_mmm numeric 20
21 time_at_prev_addr_mmm numeric 20
22 time_in_curr_emp_mmm numeric 20
23 time_in_prev_emp_mmm numeric 20
24 tot_no_dependants numeric 20
25 tot_time_at_addr_mmm numeric 20
26 tot_time_in_emp_mmm numeric 20
27 num_exst_sm_mtg_sec_fac numeric 20
28 num_exst_sm_non_mtg_sec_fac numeric 20
29 num_exst_sm_non_rev_fac numeric 20
30 num_exst_sm_rev_fac numeric 20
31 num_mtg_sec_fac_w_oth_orgs numeric 20
32 num_n_mtg_sec_fac_w_oth_orgs numeric 20
33 num_non_rev_fac_w_oth_orgs numeric 20
34 num_rev_fac_w_oth_orgs numeric 20
35 occupation character varying 15
36 facility_index_i1 numeric 20
37 facility_index_i2 numeric 20
38 facility_index_i3 numeric 20
39 facility_index_i4 numeric 20
40 facility_index_i5 numeric 20
41 facility_index_i6 numeric 20
42 facility_index_i7 numeric 20
43 facility_index_i8 numeric 20
44 facility_index_i9 numeric 20
45 facility_index_i10 numeric 20
46 collateral_index_i1 numeric 20
47 collateral_index_i2 numeric 20
48 collateral_index_i3 numeric 20
49 collateral_index_i4 numeric 20
50 collateral_index_i5 numeric 20
51 collateral_index_i6 numeric 20
52 collateral_index_i7 numeric 20
53 collateral_index_i8 numeric 20
54 collateral_index_i9 numeric 20
55 collateral_index_i10 numeric 20
56 surname character varying 210
57 first_name character varying 180
58 middle_name character varying 180
59 date_of_birth timestamp without time zone
60 employer_name character varying 480
61 gender character varying 3
62 driver_licence_number character varying 90
63 driver_licence_country character varying 9
64 passport_country_code character varying 9
65 passport_number character varying 180
66 marital_status character varying 30
67 bureau_search_consent character varying 3
68 number_of_dependents numeric 20
69 party_type character varying 30
70 applicant_type character varying 6
71 self_employed character varying 9
72 self_employed_type character varying 30
73 own_perc_of_the_business numeric 20
74 company_reg_number character varying 45
75 dir_gender_i1 character varying 3
76 dir_gender_i2 character varying 3
77 dir_gender_i3 character varying 3
78 dir_surname_i1 character varying 210
79 dir_surname_i2 character varying 210
80 dir_surname_i3 character varying 210
81 dir_first_name_i1 character varying 180
82 dir_first_name_i2 character varying 180
83 dir_first_name_i3 character varying 180
84 dir_middle_name_i1 character varying 180
85 dir_middle_name_i2 character varying 180
86 dir_middle_name_i3 character varying 180
87 dir_id_num_i1 character varying 240
88 dir_id_num_i2 character varying 240
89 dir_id_num_i3 character varying 240
90 dir_dob_i1 timestamp without time zone
91 dir_dob_i2 timestamp without time zone
92 dir_dob_i3 timestamp without time zone
93 dir_bur_enq_ref_num_i1 character varying 90
94 dir_bur_enq_ref_num_i2 character varying 90
95 dir_bur_enq_ref_num_i3 character varying 90
96 dir_privacy_consent_i1 character varying 3
97 dir_privacy_consent_i2 character varying 3
98 dir_privacy_consent_i3 character varying 3
99 dir_curr_addr_i1 character varying 750
100 dir_curr_addr_i2 character varying 750
101 dir_curr_addr_i3 character varying 750
102 min_time_in_bus numeric 20
103 time_bus_comm_ent numeric 20
104 addr_type character varying 6
105 caddr_unformatted_addr character varying 3330
106 caddr_propertyname character varying 150
107 caddr_unitnumber numeric 20
108 caddr_streetnumber numeric 20
109 caddr_streetname character varying 300
110 caddr_streettype character varying 60
111 caddr_suburb character varying 60
112 caddr_city character varying 60
113 caddr_state character varying 9
114 caddr_postcode numeric 20
115 caddr_country character varying 9
116 paddr_unformatted_addr character varying 3330
117 paddr_propertyname character varying 150
118 paddr_unitnumber numeric 20
119 paddr_streetnumber numeric 20
120 paddr_streetname character varying 300
121 paddr_streettype character varying 60
122 paddr_suburb character varying 60
123 paddr_city character varying 60
124 paddr_state character varying 9
125 paddr_postcode numeric 20
126 paddr_country character varying 9
127 cnt_home_ph_areacode character varying 24
128 cnt_home_tel_number character varying 96
129 cnt_home_ph_intl_dialcode character varying 24
130 cnt_mobile_ph_number character varying 96
131 cnt_mobile_ph_intl_dialcode character varying 24
132 cnt_work_ph_areacode character varying 24
133 cnt_work_tel_number character varying 96
134 cnt_work_ph_intl_dialcode character varying 24
135 inc_gross_incm numeric 20
136 inc_freq_of_gross_incm numeric 20
137 inc_net_incm numeric 20
138 inc_freq_of_net_incm numeric 20
139 ci_base_payg_incm numeric 20
140 ci_supp_payg_incm numeric 20
141 ci_contr_temp_agency_incm numeric 20
142 ci_sup_ann_pen_annuities numeric 20
143 ci_govt_pension numeric 20
144 ci_rental_permanent numeric 20
145 ci_rent_casual_hol_letting numeric 20
146 si_overtime numeric 20
147 si_allowances numeric 20
148 si_bonuses numeric 20
149 si_comm_earned_cont_6_mon numeric 20
150 si_td_int_held_as_coll numeric 20
151 si_div_excl_sec_for_mar_lndg numeric 20
152 si_incm_os_listed_curr_only numeric 20
153 si_seasonal_incm numeric 20
154 si_child_maint numeric 20
155 si_family_tax_ab numeric 20
156 si_rent_fam_br_own_occ_prop numeric 20
157 si_rental_nras numeric 20
158 si_fully_maint_nv_adj numeric 20
159 le_basic_hous_prop_exp numeric 20
160 le_comm_media numeric 20
161 le_food_groceries numeric 20
162 le_recr_entertainment numeric 20
163 le_cloth_personal_care numeric 20
164 le_medical_health numeric 20
165 le_transport numeric 20
166 le_education numeric 20
167 le_insurance numeric 20
168 le_other numeric 20
169 oe_health_insurance numeric 20
170 oe_child_care numeric 20
171 oe_child_support numeric 20
172 oe_other_expenses numeric 20
173 oe_rent_board numeric 20
174 oe_private_school_fees numeric 20
175 oe_post_tax_sal_sacrifice numeric 20
176 pl_sales numeric 20
177 pl_opening_stock numeric 20
178 pl_purchases numeric 20
179 pl_oth_cost_of_sales numeric 20
180 pl_closing_stock numeric 20
181 pl_oth_bus_income numeric 20
182 pl_all_bus_exp numeric 20
183 pl_abnormal_income numeric 20
184 pl_abnormal_expenses numeric 20
185 pl_addback_int_exp numeric 20
186 pl_addback_fin_lease_exp numeric 20
187 pl_addback_dep_amort_intang numeric 20
188 pl_addback_sal_wages_to_own numeric 20
189 pl_addback_other numeric 20
190 distr_sal_wages_to_o_by_bus numeric 20
191 distr_res_bus_cash_flow_distr numeric 20
192 bs_cash_at_bank_on_hand numeric 20
193 bs_trade_debtors numeric 20
194 bs_stock_inv numeric 20
195 bs_oth_curr_assets numeric 20
196 bs_ln_sto_rel_ent numeric 20
197 bs_intang_assets numeric 20
198 bs_fixed_assets numeric 20
199 bs_other_assets numeric 20
200 bs_bank_over_draft numeric 20
201 bs_trade_creditors numeric 20
202 bs_taxes_payable numeric 20
203 bs_oth_curr_liab numeric 20
204 bs_loans_from_rel_ent numeric 20
205 bs_oth_non_curr_liab numeric 20
206 spare_s1 character varying 90
207 spare_s2 character varying 90
208 spare_s3 character varying 90
209 spare_s4 character varying 90
210 spare_s5 character varying 90
211 spare_s6 character varying 90
212 spare_s7 character varying 90
213 spare_s8 character varying 90
214 spare_s9 character varying 90
215 spare_s10 character varying 90
216 spare_f1 numeric 20
217 spare_f2 numeric 20
218 spare_f3 numeric 20
219 spare_f4 numeric 20
220 spare_f5 numeric 20
221 spare_f6 numeric 20
222 spare_f7 numeric 20
223 spare_f8 numeric 20
224 spare_f9 numeric 20
225 spare_f10 numeric 20
226 da_spare_s1 character varying 90
227 da_spare_s2 character varying 90
228 da_spare_s3 character varying 90
229 da_spare_s4 character varying 90
230 da_spare_s5 character varying 90
231 da_spare_s6 character varying 90
232 da_spare_s7 character varying 90
233 da_spare_s8 character varying 90
234 da_spare_s9 character varying 90
235 da_spare_s10 character varying 90
236 da_spare_f1 numeric 20
237 da_spare_f2 numeric 20
238 da_spare_f3 numeric 20
239 da_spare_f4 numeric 20
240 da_spare_f5 numeric 20
241 da_spare_f6 numeric 20
242 da_spare_f7 numeric 20
243 da_spare_f8 numeric 20
244 da_spare_f9 numeric 20
245 da_spare_f10 numeric 20
246 cdc_source_system_code character varying 12
247 cdc_record_type character varying 48
248 cdc_commit_timestamp timestamp without time zone
249 cdc_extract_timestamp timestamp without time zone