FCT_BNK_CRHDS_RESP_FACILITY_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(50) 50
2 SUBMISSION_ID CHARACTER VARYING(20) 20
3 APPLICATION_ID CHARACTER VARYING(20) 20
4 FACILITY_ID CHARACTER VARYING(20) 20
5 DECISION CHARACTER VARYING(10) 10
6 FDS_DEC_TEXT CHARACTER VARYING(20) 20
7 FDS_DEC_REASONCODE CHARACTER VARYING(10) 10
8 FDS_DEC_CATEGORY CHARACTER VARYING(20) 20
9 FDS_SORT_RES_COD_TAB_I1 CHARACTER VARYING(10) 10
10 FDS_SORT_RES_COD_TAB_I2 CHARACTER VARYING(10) 10
11 FDS_SORT_RES_COD_TAB_I3 CHARACTER VARYING(10) 10
12 FDS_SORT_RES_COD_TAB_I4 CHARACTER VARYING(10) 10
13 FDS_SORT_RES_COD_TAB_I5 CHARACTER VARYING(10) 10
14 FDS_SORT_RES_COD_TAB_I6 CHARACTER VARYING(10) 10
15 FDS_SORT_RES_COD_TAB_I7 CHARACTER VARYING(10) 10
16 FDS_SORT_RES_COD_TAB_I8 CHARACTER VARYING(10) 10
17 FDS_SORT_RES_COD_TAB_I9 CHARACTER VARYING(10) 10
18 FDS_SORT_RES_COD_TAB_I10 CHARACTER VARYING(10) 10
19 FDS_SORT_RES_COD_TAB_I11 CHARACTER VARYING(10) 10
20 FDS_SORT_RES_COD_TAB_I12 CHARACTER VARYING(10) 10
21 FDS_SORT_RES_COD_TAB_I13 CHARACTER VARYING(10) 10
22 FDS_SORT_RES_COD_TAB_I14 CHARACTER VARYING(10) 10
23 FDS_SORT_RES_COD_TAB_I15 CHARACTER VARYING(10) 10
24 FDS_SORT_RES_COD_TAB_I16 CHARACTER VARYING(10) 10
25 FDS_SORT_RES_COD_TAB_I17 CHARACTER VARYING(10) 10
26 FDS_SORT_RES_COD_TAB_I18 CHARACTER VARYING(10) 10
27 FDS_SORT_RES_COD_TAB_I19 CHARACTER VARYING(10) 10
28 FDS_SORT_RES_COD_TAB_I20 CHARACTER VARYING(10) 10
29 FDS_SORT_RES_COD_TAB_I21 CHARACTER VARYING(10) 10
30 FDS_SORT_RES_COD_TAB_I22 CHARACTER VARYING(10) 10
31 FDS_SORT_RES_COD_TAB_I23 CHARACTER VARYING(10) 10
32 FDS_SORT_RES_COD_TAB_I24 CHARACTER VARYING(10) 10
33 FDS_SORT_RES_COD_TAB_I25 CHARACTER VARYING(10) 10
34 FDS_SORTED_DEC_TABLE_I1 CHARACTER VARYING(50) 50
35 FDS_SORTED_DEC_TABLE_I2 CHARACTER VARYING(50) 50
36 FDS_SORTED_DEC_TABLE_I3 CHARACTER VARYING(50) 50
37 FDS_SORTED_DEC_TABLE_I4 CHARACTER VARYING(50) 50
38 FDS_SORTED_DEC_TABLE_I5 CHARACTER VARYING(50) 50
39 FDS_SORTED_DEC_TABLE_I6 CHARACTER VARYING(50) 50
40 FDS_SORTED_DEC_TABLE_I7 CHARACTER VARYING(50) 50
41 FDS_SORTED_DEC_TABLE_I8 CHARACTER VARYING(50) 50
42 FDS_SORTED_DEC_TABLE_I9 CHARACTER VARYING(50) 50
43 FDS_SORTED_DEC_TABLE_I10 CHARACTER VARYING(50) 50
44 FDS_SORTED_DEC_TABLE_I11 CHARACTER VARYING(50) 50
45 FDS_SORTED_DEC_TABLE_I12 CHARACTER VARYING(50) 50
46 FDS_SORTED_DEC_TABLE_I13 CHARACTER VARYING(50) 50
47 FDS_SORTED_DEC_TABLE_I14 CHARACTER VARYING(50) 50
48 FDS_SORTED_DEC_TABLE_I15 CHARACTER VARYING(50) 50
49 FDS_SORTED_DEC_TABLE_I16 CHARACTER VARYING(50) 50
50 FDS_SORTED_DEC_TABLE_I17 CHARACTER VARYING(50) 50
51 FDS_SORTED_DEC_TABLE_I18 CHARACTER VARYING(50) 50
52 FDS_SORTED_DEC_TABLE_I19 CHARACTER VARYING(50) 50
53 FDS_SORTED_DEC_TABLE_I20 CHARACTER VARYING(50) 50
54 FDS_SORTED_DEC_TABLE_I21 CHARACTER VARYING(50) 50
55 FDS_SORTED_DEC_TABLE_I22 CHARACTER VARYING(50) 50
56 FDS_SORTED_DEC_TABLE_I23 CHARACTER VARYING(50) 50
57 FDS_SORTED_DEC_TABLE_I24 CHARACTER VARYING(50) 50
58 FDS_SORTED_DEC_TABLE_I25 CHARACTER VARYING(50) 50
59 FRS_SCORE NUMERIC(20,2) 19
60 FRS_SCORE_INDEX NUMERIC(20,2) 19
61 FRG_FAC_RISK_GRADE NUMERIC(20,2) 19
62 FRSSP1_SCORE NUMERIC(20,2) 19
63 FRSSP1_SCORE_INDEX NUMERIC(20,2) 19
64 FRGSP1_FAC_RISKGRADE_SPARE1 NUMERIC(20,2) 19
65 FRSSP2_SCORE NUMERIC(20,2) 19
66 FRSSP2_SCORE_INDEX NUMERIC(20,2) 19
67 FRSSP2_FAC_RISKGRADE_SPARE2 NUMERIC(20,2) 19
68 FFDS_DEC_TEXT CHARACTER VARYING(20) 20
69 FFDS_DEC_REASON_CODE CHARACTER VARYING(10) 10
70 FFDS_DEC_CATEGORY CHARACTER VARYING(20) 20
71 FFDS_SORT_RES_COD_TAB_I1 CHARACTER VARYING(10) 10
72 FFDS_SORT_RES_COD_TAB_I2 CHARACTER VARYING(10) 10
73 FFDS_SORT_RES_COD_TAB_I3 CHARACTER VARYING(10) 10
74 FFDS_SORT_RES_COD_TAB_I4 CHARACTER VARYING(10) 10
75 FFDS_SORT_RES_COD_TAB_I5 CHARACTER VARYING(10) 10
76 FFDS_SORT_RES_COD_TAB_I6 CHARACTER VARYING(10) 10
77 FFDS_SORT_RES_COD_TAB_I7 CHARACTER VARYING(10) 10
78 FFDS_SORT_RES_COD_TAB_I8 CHARACTER VARYING(10) 10
79 FFDS_SORT_RES_COD_TAB_I9 CHARACTER VARYING(10) 10
80 FFDS_SORT_RES_COD_TAB_I10 CHARACTER VARYING(10) 10
81 FFDS_SORT_RES_COD_TAB_I11 CHARACTER VARYING(10) 10
82 FFDS_SORT_RES_COD_TAB_I12 CHARACTER VARYING(10) 10
83 FFDS_SORT_RES_COD_TAB_I13 CHARACTER VARYING(10) 10
84 FFDS_SORT_RES_COD_TAB_I14 CHARACTER VARYING(10) 10
85 FFDS_SORT_RES_COD_TAB_I15 CHARACTER VARYING(10) 10
86 FFDS_SORT_RES_COD_TAB_I16 CHARACTER VARYING(10) 10
87 FFDS_SORT_RES_COD_TAB_I17 CHARACTER VARYING(10) 10
88 FFDS_SORT_RES_COD_TAB_I18 CHARACTER VARYING(10) 10
89 FFDS_SORT_RES_COD_TAB_I19 CHARACTER VARYING(10) 10
90 FFDS_SORT_RES_COD_TAB_I20 CHARACTER VARYING(10) 10
91 FFDS_SORT_RES_COD_TAB_I21 CHARACTER VARYING(10) 10
92 FFDS_SORT_RES_COD_TAB_I22 CHARACTER VARYING(10) 10
93 FFDS_SORT_RES_COD_TAB_I23 CHARACTER VARYING(10) 10
94 FFDS_SORT_RES_COD_TAB_I24 CHARACTER VARYING(10) 10
95 FFDS_SORT_RES_COD_TAB_I25 CHARACTER VARYING(10) 10
96 FFDS_SORTED_DEC_TABLE_I1 CHARACTER VARYING(50) 50
97 FFDS_SORTED_DEC_TABLE_I2 CHARACTER VARYING(50) 50
98 FFDS_SORTED_DEC_TABLE_I3 CHARACTER VARYING(50) 50
99 FFDS_SORTED_DEC_TABLE_I4 CHARACTER VARYING(50) 50
100 FFDS_SORTED_DEC_TABLE_I5 CHARACTER VARYING(50) 50
101 FFDS_SORTED_DEC_TABLE_I6 CHARACTER VARYING(50) 50
102 FFDS_SORTED_DEC_TABLE_I7 CHARACTER VARYING(50) 50
103 FFDS_SORTED_DEC_TABLE_I8 CHARACTER VARYING(50) 50
104 FFDS_SORTED_DEC_TABLE_I9 CHARACTER VARYING(50) 50
105 FFDS_SORTED_DEC_TABLE_I10 CHARACTER VARYING(50) 50
106 FFDS_SORTED_DEC_TABLE_I11 CHARACTER VARYING(50) 50
107 FFDS_SORTED_DEC_TABLE_I12 CHARACTER VARYING(50) 50
108 FFDS_SORTED_DEC_TABLE_I13 CHARACTER VARYING(50) 50
109 FFDS_SORTED_DEC_TABLE_I14 CHARACTER VARYING(50) 50
110 FFDS_SORTED_DEC_TABLE_I15 CHARACTER VARYING(50) 50
111 FFDS_SORTED_DEC_TABLE_I16 CHARACTER VARYING(50) 50
112 FFDS_SORTED_DEC_TABLE_I17 CHARACTER VARYING(50) 50
113 FFDS_SORTED_DEC_TABLE_I18 CHARACTER VARYING(50) 50
114 FFDS_SORTED_DEC_TABLE_I19 CHARACTER VARYING(50) 50
115 FFDS_SORTED_DEC_TABLE_I20 CHARACTER VARYING(50) 50
116 FFDS_SORTED_DEC_TABLE_I21 CHARACTER VARYING(50) 50
117 FFDS_SORTED_DEC_TABLE_I22 CHARACTER VARYING(50) 50
118 FFDS_SORTED_DEC_TABLE_I23 CHARACTER VARYING(50) 50
119 FFDS_SORTED_DEC_TABLE_I24 CHARACTER VARYING(50) 50
120 FFDS_SORTED_DEC_TABLE_I25 CHARACTER VARYING(50) 50
121 FFRS_SCORE NUMERIC(20,2) 19
122 FFRS_SCORE_INDEX NUMERIC(20,2) 19
123 FFRG_FFAC_RISKGRADE NUMERIC(20,2) 19
124 FFRSSP1_SCORE NUMERIC(20,2) 19
125 FFRSSP1_SCORE_INDEX NUMERIC(20,2) 19
126 FFRGSP1_FFAC_RISKGRADE_SPARE1 NUMERIC(20,2) 19
127 FFRSSP2_SCORE NUMERIC(20,2) 19
128 FFRSSP2_SCORE_INDEX NUMERIC(20,2) 19
129 FFRGSP2_FFAC_RISKGRADE_SPARE2 NUMERIC(20,2) 19
130 MI_REQUIRED_FLAG CHARACTER VARYING(1) 1
131 MI_INSURANCE_TYPE NUMERIC(20,2) 19
132 MLVLR_LIMIT_REQUESTED NUMERIC(20,2) 19
133 MLVLR_FINAL_LIMIT_REQ NUMERIC(20,2) 19
134 MLVLR_MAX_UNSEC_EXP NUMERIC(20,2) 19
135 MLVLR_UNSEC_EXP NUMERIC(20,2) 19
136 MLVLR_TOTAL_EXP NUMERIC(20,2) 19
137 MLVLR_MAX_TOTAL_EXP NUMERIC(20,2) 19
138 MLVTE_TOTAL_EXP NUMERIC(20,2) 19
139 MLVTE_MAX_TOTAL_EXP NUMERIC(20,2) 19
140 MLV_LVR_MAX_LVR NUMERIC(20,2) 19
141 MLV_LVR_MAX_LVR_PERC NUMERIC(20,2) 19
142 CTR_CAPACITY_TO_REPAY CHARACTER VARYING(3) 3
143 CTR_REPAYMENT_AMOUNT NUMERIC(20,2) 19
144 CTR_SEN_REPAY_AMOUNT NUMERIC(20,2) 19
145 CTR_EXST_LN_COMMITMENT NUMERIC(20,2) 19
146 CTR_PROP_LN_COMMITMENT NUMERIC(20,2) 19
147 CTR_EXST_LN_INT_RATE NUMERIC(20,2) 19
148 CTR_EXST_LN_SEN_INT_RATE NUMERIC(20,2) 19
149 CTR_PROP_LN_INT_RATE NUMERIC(20,2) 19
150 CTR_PROP_LN_SEN_INT_RATE NUMERIC(20,2) 19
151 SPARE_S1 CHARACTER VARYING(30) 30
152 SPARE_S2 CHARACTER VARYING(30) 30
153 SPARE_S3 CHARACTER VARYING(30) 30
154 SPARE_S4 CHARACTER VARYING(30) 30
155 SPARE_S5 CHARACTER VARYING(30) 30
156 SPARE_S6 CHARACTER VARYING(30) 30
157 SPARE_S7 CHARACTER VARYING(30) 30
158 SPARE_S8 CHARACTER VARYING(30) 30
159 SPARE_S9 CHARACTER VARYING(30) 30
160 SPARE_S10 CHARACTER VARYING(30) 30
161 SPARE_S11 CHARACTER VARYING(30) 30
162 SPARE_S12 CHARACTER VARYING(30) 30
163 SPARE_S13 CHARACTER VARYING(30) 30
164 SPARE_S14 CHARACTER VARYING(30) 30
165 SPARE_S15 CHARACTER VARYING(30) 30
166 SPARE_S16 CHARACTER VARYING(30) 30
167 SPARE_S17 CHARACTER VARYING(30) 30
168 SPARE_S18 CHARACTER VARYING(30) 30
169 SPARE_S19 CHARACTER VARYING(30) 30
170 SPARE_S20 CHARACTER VARYING(30) 30
171 SPARE_F1 NUMERIC(20,2) 19
172 SPARE_F2 NUMERIC(20,2) 19
173 SPARE_F3 NUMERIC(20,2) 19
174 SPARE_F4 NUMERIC(20,2) 19
175 SPARE_F5 NUMERIC(20,2) 19
176 SPARE_F6 NUMERIC(20,2) 19
177 SPARE_F7 NUMERIC(20,2) 19
178 SPARE_F8 NUMERIC(20,2) 19
179 SPARE_F9 NUMERIC(20,2) 19
180 SPARE_F10 NUMERIC(20,2) 19
181 SPARE_F11 NUMERIC(20,2) 19
182 SPARE_F12 NUMERIC(20,2) 19
183 SPARE_F13 NUMERIC(20,2) 19
184 SPARE_F14 NUMERIC(20,2) 19
185 SPARE_F15 NUMERIC(20,2) 19
186 SPARE_F16 NUMERIC(20,2) 19
187 SPARE_F17 NUMERIC(20,2) 19
188 SPARE_F18 NUMERIC(20,2) 19
189 SPARE_F19 NUMERIC(20,2) 19
190 SPARE_F20 NUMERIC(20,2) 19
191 DECISIONCR CHARACTER VARYING(10) 10
192 FFDS_CR_DEC_TEXT CHARACTER VARYING(20) 20
193 FFDS_CR_DEC_REASON_CODE CHARACTER VARYING(10) 10
194 FFDS_CR_DEC_CATEGORY CHARACTER VARYING(10) 10
195 FFDS_CR_DEC_TABLE_I1 CHARACTER VARYING(50) 50
196 FFDS_CR_DEC_TABLE_I2 CHARACTER VARYING(50) 50
197 FFDS_CR_DEC_TABLE_I3 CHARACTER VARYING(50) 50
198 FFDS_CR_DEC_TABLE_I4 CHARACTER VARYING(50) 50
199 FFDS_CR_DEC_TABLE_I5 CHARACTER VARYING(50) 50
200 FFDS_CR_DEC_TABLE_I6 CHARACTER VARYING(50) 50
201 FFDS_CR_DEC_TABLE_I7 CHARACTER VARYING(50) 50
202 FFDS_CR_DEC_TABLE_I8 CHARACTER VARYING(50) 50
203 FFDS_CR_DEC_TABLE_I9 CHARACTER VARYING(50) 50
204 FFDS_CR_DEC_TABLE_I10 CHARACTER VARYING(50) 50
205 FFDS_CR_DEC_TABLE_I11 CHARACTER VARYING(50) 50
206 FFDS_CR_DEC_TABLE_I12 CHARACTER VARYING(50) 50
207 FFDS_CR_DEC_TABLE_I13 CHARACTER VARYING(50) 50
208 FFDS_CR_DEC_TABLE_I14 CHARACTER VARYING(50) 50
209 FFDS_CR_DEC_TABLE_I15 CHARACTER VARYING(50) 50
210 FFDS_CR_DEC_TABLE_I16 CHARACTER VARYING(50) 50
211 FFDS_CR_DEC_TABLE_I17 CHARACTER VARYING(50) 50
212 FFDS_CR_DEC_TABLE_I18 CHARACTER VARYING(50) 50
213 FFDS_CR_DEC_TABLE_I19 CHARACTER VARYING(50) 50
214 FFDS_CR_DEC_TABLE_I20 CHARACTER VARYING(50) 50
215 FFDS_CR_DEC_TABLE_I21 CHARACTER VARYING(50) 50
216 FFDS_CR_DEC_TABLE_I22 CHARACTER VARYING(50) 50
217 FFDS_CR_DEC_TABLE_I23 CHARACTER VARYING(50) 50
218 FFDS_CR_DEC_TABLE_I24 CHARACTER VARYING(50) 50
219 FFDS_CR_DEC_TABLE_I25 CHARACTER VARYING(10) 10
220 FFDS_CR_DEC_RSN_CDE_I1 CHARACTER VARYING(10) 10
221 FFDS_CR_DEC_RSN_CDE_I2 CHARACTER VARYING(10) 10
222 FFDS_CR_DEC_RSN_CDE_I3 CHARACTER VARYING(10) 10
223 FFDS_CR_DEC_RSN_CDE_I4 CHARACTER VARYING(10) 10
224 FFDS_CR_DEC_RSN_CDE_I5 CHARACTER VARYING(10) 10
225 FFDS_CR_DEC_RSN_CDE_I6 CHARACTER VARYING(10) 10
226 FFDS_CR_DEC_RSN_CDE_I7 CHARACTER VARYING(10) 10
227 FFDS_CR_DEC_RSN_CDE_I8 CHARACTER VARYING(10) 10
228 FFDS_CR_DEC_RSN_CDE_I9 CHARACTER VARYING(10) 10
229 FFDS_CR_DEC_RSN_CDE_I10 CHARACTER VARYING(10) 10
230 FFDS_CR_DEC_RSN_CDE_I11 CHARACTER VARYING(10) 10
231 FFDS_CR_DEC_RSN_CDE_I12 CHARACTER VARYING(10) 10
232 FFDS_CR_DEC_RSN_CDE_I13 CHARACTER VARYING(10) 10
233 FFDS_CR_DEC_RSN_CDE_I14 CHARACTER VARYING(10) 10
234 FFDS_CR_DEC_RSN_CDE_I15 CHARACTER VARYING(10) 10
235 FFDS_CR_DEC_RSN_CDE_I16 CHARACTER VARYING(10) 10
236 FFDS_CR_DEC_RSN_CDE_I17 CHARACTER VARYING(10) 10
237 FFDS_CR_DEC_RSN_CDE_I18 CHARACTER VARYING(10) 10
238 FFDS_CR_DEC_RSN_CDE_I19 CHARACTER VARYING(10) 10
239 FFDS_CR_DEC_RSN_CDE_I20 CHARACTER VARYING(10) 10
240 FFDS_CR_DEC_RSN_CDE_I21 CHARACTER VARYING(10) 10
241 FFDS_CR_DEC_RSN_CDE_I22 CHARACTER VARYING(10) 10
242 FFDS_CR_DEC_RSN_CDE_I23 CHARACTER VARYING(10) 10
243 FFDS_CR_DEC_RSN_CDE_I24 CHARACTER VARYING(10) 10
244 FFDS_CR_DEC_RSN_CDE_I25 CHARACTER VARYING(10) 10
245 FFRG_CR_RISK_GRADE CHARACTER VARYING(30) 30
246 FFRS_CR_RISK_SCORE CHARACTER VARYING(30) 30
247 FFRS_CR_RISK_SCORE_INDEX CHARACTER VARYING(30) 30
248 FF_CR_MTG_DIS_LIMIT CHARACTER VARYING(30) 30
249 FF_CR_PL_DIS_LIMIT CHARACTER VARYING(30) 30
250 FF_CR_CC_DIS_LIMIT CHARACTER VARYING(30) 30
251 FF_CR_LEASED_DIS_LIMIT CHARACTER VARYING(30) 30
252 FF_CR_DIS_LIMIT_RATE CHARACTER VARYING(30) 30
253 FF_CR_TOTAL_DIS_LIMIT CHARACTER VARYING(30) 30