obp24_hst_cz_sc_or_expr_resp_facility

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 facility_id character varying 60
5 decision character varying 30
6 fds_dec_text character varying 60
7 fds_dec_reasoncode character varying 30
8 fds_dec_category character varying 60
9 fds_sort_res_cod_tab_i1 character varying 30
10 fds_sort_res_cod_tab_i2 character varying 30
11 fds_sort_res_cod_tab_i3 character varying 30
12 fds_sort_res_cod_tab_i4 character varying 30
13 fds_sort_res_cod_tab_i5 character varying 30
14 fds_sort_res_cod_tab_i6 character varying 30
15 fds_sort_res_cod_tab_i7 character varying 30
16 fds_sort_res_cod_tab_i8 character varying 30
17 fds_sort_res_cod_tab_i9 character varying 30
18 fds_sort_res_cod_tab_i10 character varying 30
19 fds_sort_res_cod_tab_i11 character varying 30
20 fds_sort_res_cod_tab_i12 character varying 30
21 fds_sort_res_cod_tab_i13 character varying 30
22 fds_sort_res_cod_tab_i14 character varying 30
23 fds_sort_res_cod_tab_i15 character varying 30
24 fds_sort_res_cod_tab_i16 character varying 30
25 fds_sort_res_cod_tab_i17 character varying 30
26 fds_sort_res_cod_tab_i18 character varying 30
27 fds_sort_res_cod_tab_i19 character varying 30
28 fds_sort_res_cod_tab_i20 character varying 30
29 fds_sort_res_cod_tab_i21 character varying 30
30 fds_sort_res_cod_tab_i22 character varying 30
31 fds_sort_res_cod_tab_i23 character varying 30
32 fds_sort_res_cod_tab_i24 character varying 30
33 fds_sort_res_cod_tab_i25 character varying 30
34 fds_sorted_dec_table_i1 character varying 150
35 fds_sorted_dec_table_i2 character varying 150
36 fds_sorted_dec_table_i3 character varying 150
37 fds_sorted_dec_table_i4 character varying 150
38 fds_sorted_dec_table_i5 character varying 150
39 fds_sorted_dec_table_i6 character varying 150
40 fds_sorted_dec_table_i7 character varying 150
41 fds_sorted_dec_table_i8 character varying 150
42 fds_sorted_dec_table_i9 character varying 150
43 fds_sorted_dec_table_i10 character varying 150
44 fds_sorted_dec_table_i11 character varying 150
45 fds_sorted_dec_table_i12 character varying 150
46 fds_sorted_dec_table_i13 character varying 150
47 fds_sorted_dec_table_i14 character varying 150
48 fds_sorted_dec_table_i15 character varying 150
49 fds_sorted_dec_table_i16 character varying 150
50 fds_sorted_dec_table_i17 character varying 150
51 fds_sorted_dec_table_i18 character varying 150
52 fds_sorted_dec_table_i19 character varying 150
53 fds_sorted_dec_table_i20 character varying 150
54 fds_sorted_dec_table_i21 character varying 150
55 fds_sorted_dec_table_i22 character varying 150
56 fds_sorted_dec_table_i23 character varying 150
57 fds_sorted_dec_table_i24 character varying 150
58 fds_sorted_dec_table_i25 character varying 150
59 frs_score numeric 20
60 frs_score_index numeric 20
61 frg_fac_risk_grade numeric 20
62 frssp1_score numeric 20
63 frssp1_score_index numeric 20
64 frgsp1_fac_riskgrade_spare1 numeric 20
65 frssp2_score numeric 20
66 frssp2_score_index numeric 20
67 frssp2_fac_riskgrade_spare2 numeric 20
68 ffds_dec_text character varying 60
69 ffds_dec_reason_code character varying 30
70 ffds_dec_category character varying 60
71 ffds_sort_res_cod_tab_i1 character varying 30
72 ffds_sort_res_cod_tab_i2 character varying 30
73 ffds_sort_res_cod_tab_i3 character varying 30
74 ffds_sort_res_cod_tab_i4 character varying 30
75 ffds_sort_res_cod_tab_i5 character varying 30
76 ffds_sort_res_cod_tab_i6 character varying 30
77 ffds_sort_res_cod_tab_i7 character varying 30
78 ffds_sort_res_cod_tab_i8 character varying 30
79 ffds_sort_res_cod_tab_i9 character varying 30
80 ffds_sort_res_cod_tab_i10 character varying 30
81 ffds_sort_res_cod_tab_i11 character varying 30
82 ffds_sort_res_cod_tab_i12 character varying 30
83 ffds_sort_res_cod_tab_i13 character varying 30
84 ffds_sort_res_cod_tab_i14 character varying 30
85 ffds_sort_res_cod_tab_i15 character varying 30
86 ffds_sort_res_cod_tab_i16 character varying 30
87 ffds_sort_res_cod_tab_i17 character varying 30
88 ffds_sort_res_cod_tab_i18 character varying 30
89 ffds_sort_res_cod_tab_i19 character varying 30
90 ffds_sort_res_cod_tab_i20 character varying 30
91 ffds_sort_res_cod_tab_i21 character varying 30
92 ffds_sort_res_cod_tab_i22 character varying 30
93 ffds_sort_res_cod_tab_i23 character varying 30
94 ffds_sort_res_cod_tab_i24 character varying 30
95 ffds_sort_res_cod_tab_i25 character varying 30
96 ffds_sorted_dec_table_i1 character varying 150
97 ffds_sorted_dec_table_i2 character varying 150
98 ffds_sorted_dec_table_i3 character varying 150
99 ffds_sorted_dec_table_i4 character varying 150
100 ffds_sorted_dec_table_i5 character varying 150
101 ffds_sorted_dec_table_i6 character varying 150
102 ffds_sorted_dec_table_i7 character varying 150
103 ffds_sorted_dec_table_i8 character varying 150
104 ffds_sorted_dec_table_i9 character varying 150
105 ffds_sorted_dec_table_i10 character varying 150
106 ffds_sorted_dec_table_i11 character varying 150
107 ffds_sorted_dec_table_i12 character varying 150
108 ffds_sorted_dec_table_i13 character varying 150
109 ffds_sorted_dec_table_i14 character varying 150
110 ffds_sorted_dec_table_i15 character varying 150
111 ffds_sorted_dec_table_i16 character varying 150
112 ffds_sorted_dec_table_i17 character varying 150
113 ffds_sorted_dec_table_i18 character varying 150
114 ffds_sorted_dec_table_i19 character varying 150
115 ffds_sorted_dec_table_i20 character varying 150
116 ffds_sorted_dec_table_i21 character varying 150
117 ffds_sorted_dec_table_i22 character varying 150
118 ffds_sorted_dec_table_i23 character varying 150
119 ffds_sorted_dec_table_i24 character varying 150
120 ffds_sorted_dec_table_i25 character varying 150
121 ffrs_score numeric 20
122 ffrs_score_index numeric 20
123 ffrg_ffac_riskgrade numeric 20
124 ffrssp1_score numeric 20
125 ffrssp1_score_index numeric 20
126 ffrgsp1_ffac_riskgrade_spare1 numeric 20
127 ffrssp2_score numeric 20
128 ffrssp2_score_index numeric 20
129 ffrgsp2_ffac_riskgrade_spare2 numeric 20
130 mi_required_flag character varying 3
131 mi_insurance_type numeric 20
132 mlvlr_limit_requested numeric 20
133 mlvlr_final_limit_req numeric 20
134 mlvlr_max_unsec_exp numeric 20
135 mlvlr_unsec_exp numeric 20
136 mlvlr_total_exp numeric 20
137 mlvlr_max_total_exp numeric 20
138 mlvte_total_exp numeric 20
139 mlvte_max_total_exp numeric 20
140 mlv_lvr_max_lvr numeric 20
141 mlv_lvr_max_lvr_perc numeric 20
142 ctr_capacity_to_repay character varying 9
143 ctr_repayment_amount numeric 20
144 ctr_sen_repay_amount numeric 20
145 ctr_exst_ln_commitment numeric 20
146 ctr_prop_ln_commitment numeric 20
147 ctr_exst_ln_int_rate numeric 20
148 ctr_exst_ln_sen_int_rate numeric 20
149 ctr_prop_ln_int_rate numeric 20
150 ctr_prop_ln_sen_int_rate numeric 20
151 spare_s1 character varying 90
152 spare_s2 character varying 90
153 spare_s3 character varying 90
154 spare_s4 character varying 90
155 spare_s5 character varying 90
156 spare_s6 character varying 90
157 spare_s7 character varying 90
158 spare_s8 character varying 90
159 spare_s9 character varying 90
160 spare_s10 character varying 90
161 spare_s11 character varying 90
162 spare_s12 character varying 90
163 spare_s13 character varying 90
164 spare_s14 character varying 90
165 spare_s15 character varying 90
166 spare_s16 character varying 90
167 spare_s17 character varying 90
168 spare_s18 character varying 90
169 spare_s19 character varying 90
170 spare_s20 character varying 90
171 spare_f1 numeric 20
172 spare_f2 numeric 20
173 spare_f3 numeric 20
174 spare_f4 numeric 20
175 spare_f5 numeric 20
176 spare_f6 numeric 20
177 spare_f7 numeric 20
178 spare_f8 numeric 20
179 spare_f9 numeric 20
180 spare_f10 numeric 20
181 spare_f11 numeric 20
182 spare_f12 numeric 20
183 spare_f13 numeric 20
184 spare_f14 numeric 20
185 spare_f15 numeric 20
186 spare_f16 numeric 20
187 spare_f17 numeric 20
188 spare_f18 numeric 20
189 spare_f19 numeric 20
190 spare_f20 numeric 20
191 cdc_source_system_code character varying 12
192 cdc_record_type character varying 48
193 cdc_commit_timestamp timestamp without time zone
194 cdc_extract_timestamp timestamp without time zone
195 decisioncr character varying 30
196 ffds_cr_dec_text character varying 60
197 ffds_cr_dec_reason_code character varying 30
198 ffds_cr_dec_category character varying 30
199 ffds_cr_dec_table_i1 character varying 150
200 ffds_cr_dec_table_i2 character varying 150
201 ffds_cr_dec_table_i3 character varying 150
202 ffds_cr_dec_table_i4 character varying 150
203 ffds_cr_dec_table_i5 character varying 150
204 ffds_cr_dec_table_i6 character varying 150
205 ffds_cr_dec_table_i7 character varying 150
206 ffds_cr_dec_table_i8 character varying 150
207 ffds_cr_dec_table_i9 character varying 150
208 ffds_cr_dec_table_i10 character varying 150
209 ffds_cr_dec_table_i11 character varying 150
210 ffds_cr_dec_table_i12 character varying 150
211 ffds_cr_dec_table_i13 character varying 150
212 ffds_cr_dec_table_i14 character varying 150
213 ffds_cr_dec_table_i15 character varying 150
214 ffds_cr_dec_table_i16 character varying 150
215 ffds_cr_dec_table_i17 character varying 150
216 ffds_cr_dec_table_i18 character varying 150
217 ffds_cr_dec_table_i19 character varying 150
218 ffds_cr_dec_table_i20 character varying 150
219 ffds_cr_dec_table_i21 character varying 150
220 ffds_cr_dec_table_i22 character varying 150
221 ffds_cr_dec_table_i23 character varying 150
222 ffds_cr_dec_table_i24 character varying 150
223 ffds_cr_dec_table_i25 character varying 30
224 ffds_cr_dec_rsn_cde_i1 character varying 30
225 ffds_cr_dec_rsn_cde_i2 character varying 30
226 ffds_cr_dec_rsn_cde_i3 character varying 30
227 ffds_cr_dec_rsn_cde_i4 character varying 30
228 ffds_cr_dec_rsn_cde_i5 character varying 30
229 ffds_cr_dec_rsn_cde_i6 character varying 30
230 ffds_cr_dec_rsn_cde_i7 character varying 30
231 ffds_cr_dec_rsn_cde_i8 character varying 30
232 ffds_cr_dec_rsn_cde_i9 character varying 30
233 ffds_cr_dec_rsn_cde_i10 character varying 30
234 ffds_cr_dec_rsn_cde_i11 character varying 30
235 ffds_cr_dec_rsn_cde_i12 character varying 30
236 ffds_cr_dec_rsn_cde_i13 character varying 30
237 ffds_cr_dec_rsn_cde_i14 character varying 30
238 ffds_cr_dec_rsn_cde_i15 character varying 30
239 ffds_cr_dec_rsn_cde_i16 character varying 30
240 ffds_cr_dec_rsn_cde_i17 character varying 30
241 ffds_cr_dec_rsn_cde_i18 character varying 30
242 ffds_cr_dec_rsn_cde_i19 character varying 30
243 ffds_cr_dec_rsn_cde_i20 character varying 30
244 ffds_cr_dec_rsn_cde_i21 character varying 30
245 ffds_cr_dec_rsn_cde_i22 character varying 30
246 ffds_cr_dec_rsn_cde_i23 character varying 30
247 ffds_cr_dec_rsn_cde_i24 character varying 30
248 ffds_cr_dec_rsn_cde_i25 character varying 30
249 ffrg_cr_risk_grade numeric 20
250 ffrs_cr_risk_score numeric 20
251 ffrs_cr_risk_score_index numeric 20
252 ff_cr_mtg_dis_limit numeric 20
253 ff_cr_pl_dis_limit numeric 20
254 ff_cr_cc_dis_limit numeric 20
255 ff_cr_leased_dis_limit numeric 20
256 ff_cr_dis_limit_rate numeric 20
257 ff_cr_total_dis_limit numeric 20