FCT_BNK_CRHDS_EXPR_RESULT_CAL_UNSEC

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 U_INIT_BUR_SERV_TEN CHARACTER VARYING(20) 20
3 U_INIT_NEXT_CALL_TYPE_ON CHARACTER VARYING(20) 20
4 U_INIT_NEXT_CALL_TYPE_TGN CHARACTER VARYING(10) 10
5 U_INIT_NEXT_CALL_TYPE_TEN CHARACTER VARYING(20) 20
6 U_INIT_DEC_ORIG_DEC_CAT CHARACTER VARYING(1) 1
7 U_INIT_DEC_ORIG_DEC_RCODE CHARACTER VARYING(4) 4
8 U_INIT_DEC_POL_DEC_CAT CHARACTER VARYING(1) 1
9 U_INIT_DEC_POL_RSN_CODE1 CHARACTER VARYING(4) 4
10 U_INIT_DEC_POL_RSN_CODE2 CHARACTER VARYING(4) 4
11 U_INIT_DEC_POL_RSN_CODE3 CHARACTER VARYING(4) 4
12 U_INIT_DEC_POL_RSN_CODE4 CHARACTER VARYING(4) 4
13 U_INIT_DEC_POL_RSN_CODE5 CHARACTER VARYING(4) 4
14 U_INIT_DEC_POL_RSN_CODE6 CHARACTER VARYING(4) 4
15 U_INIT_DEC_POL_RSN_CODE7 CHARACTER VARYING(4) 4
16 U_INIT_DEC_POL_RSN_CODE8 CHARACTER VARYING(4) 4
17 U_INIT_DEC_POL_RSN_CODE9 CHARACTER VARYING(4) 4
18 U_INIT_DEC_POL_RSN_CODE10 CHARACTER VARYING(4) 4
19 U_INIT_DEC_POL_RSN_CODE11 CHARACTER VARYING(4) 4
20 U_INIT_DEC_POL_RSN_CODE12 CHARACTER VARYING(4) 4
21 U_INIT_DEC_POL_RSN_CODE13 CHARACTER VARYING(4) 4
22 U_INIT_DEC_POL_RSN_CODE14 CHARACTER VARYING(4) 4
23 U_INIT_DEC_POL_RSN_CODE15 CHARACTER VARYING(4) 4
24 U_INIT_DEC_POL_RSN_CODE16 CHARACTER VARYING(4) 4
25 U_INIT_DEC_POL_RSN_CODE17 CHARACTER VARYING(4) 4
26 U_INIT_DEC_POL_RSN_CODE18 CHARACTER VARYING(4) 4
27 U_INIT_DEC_POL_RSN_CODE19 CHARACTER VARYING(4) 4
28 U_INIT_DEC_POL_RSN_CODE20 CHARACTER VARYING(4) 4
29 U_INIT_DEC_FINAL_DEC_CAT CHARACTER VARYING(1) 1
30 U_BUR_REQ_A_BUR_RQ_FLG CHARACTER VARYING(1) 1
31 U_BUR_REQ_G_BUR_RQ_FLG CHARACTER VARYING(1) 1
32 U_BUREAU_SER_BUR_SER1 CHARACTER VARYING(1) 1
33 U_BUREAU_SER_BUR_SER2 CHARACTER VARYING(1) 1
34 U_BUREAU_SER_BUR_SER3 CHARACTER VARYING(1) 1
35 U_BUREAU_SER_BUR_SER4 CHARACTER VARYING(1) 1
36 U_BUREAU_SER_BUR_SER5 CHARACTER VARYING(1) 1
37 U_BUREAU_SER_BUR_SER6 CHARACTER VARYING(1) 1
38 U_BUREAU_SER_BUR_SER7 CHARACTER VARYING(1) 1
39 U_BUREAU_SER_BUR_SER8 CHARACTER VARYING(1) 1
40 U_BUREAU_SER_BUR_SER9 CHARACTER VARYING(1) 1
41 U_BUREAU_SER_BUR_SER10 CHARACTER VARYING(1) 1
42 U_INIT_NXTCALLTYP_N_C_T CHARACTER VARYING(10) 10
43 U_INIT_NXTCALL_TYPSCREENF CHARACTER VARYING(4) 4
44 U_FIN_MX_LOAN_LIM_RQ_E_ON CHARACTER VARYING(20) 20
45 U_FIN_MX_LOAN_LIM_R_E_TGN CHARACTER VARYING(10) 10
46 U_FIN_MX_LOAN_LIM_R_E_TEN CHARACTER VARYING(20) 20
47 U_FIN_MX_LOAN_TOT_EXP_ON CHARACTER VARYING(20) 20
48 U_FIN_MX_LOAN_TOT_EXP_TGN CHARACTER VARYING(10) 10
49 U_FIN_MX_LOAN_TOT_EXP_TEN CHARACTER VARYING(20) 20
50 U_FIN_DECISION_ON CHARACTER VARYING(20) 20
51 U_FIN_DECISION_TGN CHARACTER VARYING(10) 10
52 U_FULL_BUREAU_REQUIRED_ON CHARACTER VARYING(20) 20
53 U_FULL_BUREAU_REQ_TGN CHARACTER VARYING(10) 10
54 U_FULL_BUREAU_REQ_TEN CHARACTER VARYING(20) 20
55 U_FULL_BUREAU_SERV_ON CHARACTER VARYING(20) 20
56 U_FULL_BUREAU_SERV_TGN CHARACTER VARYING(10) 10
57 U_FULL_BUREAU_SERV_TEN CHARACTER VARYING(20) 20
58 U_FULL_MAX_LOAN_AMT_ON CHARACTER VARYING(20) 20
59 U_FULL_MAX_LOAN_AMT_TGN CHARACTER VARYING(10) 10
60 U_FULL_MAX_LOAN_AMT_TEN CHARACTER VARYING(20) 20
61 U_FULL_LOAN_PARA_ON CHARACTER VARYING(20) 20
62 U_FULL_LOAN_PARA_TGN CHARACTER VARYING(10) 10
63 U_FULL_LOAN_PARA_TEN CHARACTER VARYING(20) 20
64 U_FULL_XSELL_ELIGIBLE_ON CHARACTER VARYING(20) 20
65 U_FULL_XSELL_ELIGIBLE_TGN CHARACTER VARYING(10) 10
66 U_FULL_XSELL_ELIGIBLE_TEN CHARACTER VARYING(20) 20
67 U_FULL_NEXT_CALL_TYPE_ON CHARACTER VARYING(20) 20
68 U_FULL_NEXT_CALL_TYPE_TGN CHARACTER VARYING(10) 10
69 U_FULL_NEXT_CALL_TYPE_TEN CHARACTER VARYING(20) 20
70 U_FINAL_RESULTS_O_N CHARACTER VARYING(20) 20
71 U_FINAL_RESULTS_TGN CHARACTER VARYING(10) 10
72 U_FULL_RISK_SCORE_ON CHARACTER VARYING(20) 20
73 U_FULL_RISK_SCORE_S_ID CHARACTER VARYING(10) 10
74 U_FULL_RISK_SCORE_SN CHARACTER VARYING(20) 20
75 U_FULL_RISK_GRADE_ON CHARACTER VARYING(20) 20
76 U_FULL_RISK_GRADE_TEN CHARACTER VARYING(20) 20
77 U_FULL_SCORE_SPARE1_ON CHARACTER VARYING(20) 20
78 U_FULL_SCORE_SPARE1_S_ID CHARACTER VARYING(10) 10
79 U_FULL_SCORE_SPARE1_SN CHARACTER VARYING(20) 20
80 U_FULL_GRADE_SPARE1_ON CHARACTER VARYING(20) 20
81 U_FULL_GRADE_SPARE1_TEN CHARACTER VARYING(20) 20
82 U_FULL_SCORE_SPARE2_ON CHARACTER VARYING(20) 20
83 U_FULL_SCORE_SPARE2_S_ID CHARACTER VARYING(10) 10
84 U_FULL_SCORE_SPARE2_SN CHARACTER VARYING(20) 20
85 U_FULL_GRADE_SPARE2_ON CHARACTER VARYING(20) 20
86 U_FULL_GRADE_SPARE2_TEN CHARACTER VARYING(20) 20
87 U_FULL_CRGS_SCORE_ON CHARACTER VARYING(20) 20
88 U_FULL_CRGS_SCORE_S_ID CHARACTER VARYING(10) 10
89 U_FULL_CRGS_SCORE_SN CHARACTER VARYING(20) 20
90 U_FULL_CRGS_GRADE_ON CHARACTER VARYING(20) 20
91 U_FULL_CRGS_GRADE_TEN CHARACTER VARYING(20) 20
92 U_FIN_MX_LOAN_LVR_ON CHARACTER VARYING(20) 20
93 U_FIN_MX_LOAN_LVR_TGN CHARACTER VARYING(10) 10
94 U_FIN_MX_LOAN_LVR_TEN CHARACTER VARYING(20) 20
95 U_FIN_DEC_FIN_DEC_CAT CHARACTER VARYING(1) 1
96 U_FIN_DEC_ORG_DEC_CAT CHARACTER VARYING(1) 1
97 U_FIN_DEC_ORG_DEC_RSNCODE CHARACTER VARYING(4) 4
98 U_FIN_DEC_POL_DEC_CAT CHARACTER VARYING(1) 1
99 U_FIN_DEC_POL_RSN_CODE1 CHARACTER VARYING(4) 4
100 U_FIN_DEC_POL_RSN_CODE10 CHARACTER VARYING(4) 4
101 U_FIN_DEC_POL_RSN_CODE11 CHARACTER VARYING(4) 4
102 U_FIN_DEC_POL_RSN_CODE12 CHARACTER VARYING(4) 4
103 U_FIN_DEC_POL_RSN_CODE13 CHARACTER VARYING(4) 4
104 U_FIN_DEC_POL_RSN_CODE14 CHARACTER VARYING(4) 4
105 U_FIN_DEC_POL_RSN_CODE15 CHARACTER VARYING(4) 4
106 U_FIN_DEC_POL_RSN_CODE16 CHARACTER VARYING(4) 4
107 U_FIN_DEC_POL_RSN_CODE17 CHARACTER VARYING(4) 4
108 U_FIN_DEC_POL_RSN_CODE18 CHARACTER VARYING(4) 4
109 U_FIN_DEC_POL_RSN_CODE19 CHARACTER VARYING(4) 4
110 U_FIN_DEC_POL_RSN_CODE2 CHARACTER VARYING(4) 4
111 U_FIN_DEC_POL_RSN_CODE20 CHARACTER VARYING(4) 4
112 U_FIN_DEC_POL_RSN_CODE3 CHARACTER VARYING(4) 4
113 U_FIN_DEC_POL_RSN_CODE4 CHARACTER VARYING(4) 4
114 U_FIN_DEC_POL_RSN_CODE5 CHARACTER VARYING(4) 4
115 U_FIN_DEC_POL_RSN_CODE6 CHARACTER VARYING(4) 4
116 U_FIN_DEC_POL_RSN_CODE7 CHARACTER VARYING(4) 4
117 U_FIN_DEC_POL_RSN_CODE8 CHARACTER VARYING(4) 4
118 U_FIN_DEC_POL_RSN_CODE9 CHARACTER VARYING(4) 4
119 U_FIN_MX_LOAN_FIN_LIM_REQ CHARACTER VARYING(32) 32
120 U_FIN_MX_LOAN_LIM_REQ CHARACTER VARYING(32) 32
121 U_FIN_MX_LOAN_MAX_LVR CHARACTER VARYING(32) 32
122 U_FIN_MX_LOAN_MX_LVR_P CHARACTER VARYING(32) 32
123 U_FIN_MX_LOAN_MX_TOT_EXP CHARACTER VARYING(32) 32
124 U_FIN_MX_LOAN_MX_UNSEC_EX CHARACTER VARYING(32) 32
125 U_FIN_MX_LOAN_TOT_EXP CHARACTER VARYING(32) 32
126 U_FIN_MX_LOAN_UNSEC_EX CHARACTER VARYING(32) 32
127 U_FULL_BUR_REQ_A_B_R_FLG CHARACTER VARYING(1) 1
128 U_FULL_BUR_REQ_G_B_R_FLG CHARACTER VARYING(1) 1
129 U_FULL_BUR_SERV_B_SERV1 CHARACTER VARYING(1) 1
130 U_FULL_BUR_SERV_B_SERV10 CHARACTER VARYING(1) 1
131 U_FULL_BUR_SERV_B_SERV2 CHARACTER VARYING(1) 1
132 U_FULL_BUR_SERV_B_SERV3 CHARACTER VARYING(1) 1
133 U_FULL_BUR_SERV_B_SERV4 CHARACTER VARYING(1) 1
134 U_FULL_BUR_SERV_B_SERV5 CHARACTER VARYING(1) 1
135 U_FULL_BUR_SERV_B_SERV6 CHARACTER VARYING(1) 1
136 U_FULL_BUR_SERV_B_SERV7 CHARACTER VARYING(1) 1
137 U_FULL_BUR_SERV_B_SERV8 CHARACTER VARYING(1) 1
138 U_FULL_BUR_SERV_B_SERV9 CHARACTER VARYING(1) 1
139 U_FULL_CRGS_GRADE_GRADE CHARACTER VARYING(10) 10
140 U_FULL_CRGS_SCORE_SCORE CHARACTER VARYING(10) 10
141 U_FULL_DEC_FIN_DEC_CAT CHARACTER VARYING(1) 1
142 U_FULL_DEC_FIN_RSN_CODE1 CHARACTER VARYING(4) 4
143 U_FULL_DEC_FIN_RSN_CODE10 CHARACTER VARYING(4) 4
144 U_FULL_DEC_FIN_RSN_CODE11 CHARACTER VARYING(4) 4
145 U_FULL_DEC_FIN_RSN_CODE12 CHARACTER VARYING(4) 4
146 U_FULL_DEC_FIN_RSN_CODE13 CHARACTER VARYING(4) 4
147 U_FULL_DEC_FIN_RSN_CODE14 CHARACTER VARYING(4) 4
148 U_FULL_DEC_FIN_RSN_CODE15 CHARACTER VARYING(4) 4
149 U_FULL_DEC_FIN_RSN_CODE16 CHARACTER VARYING(4) 4
150 U_FULL_DEC_FIN_RSN_CODE17 CHARACTER VARYING(4) 4
151 U_FULL_DEC_FIN_RSN_CODE18 CHARACTER VARYING(4) 4
152 U_FULL_DEC_FIN_RSN_CODE19 CHARACTER VARYING(4) 4
153 U_FULL_DEC_FIN_RSN_CODE2 CHARACTER VARYING(4) 4
154 U_FULL_DEC_FIN_RSN_CODE20 CHARACTER VARYING(4) 4
155 U_FULL_DEC_FIN_RSN_CODE3 CHARACTER VARYING(4) 4
156 U_FULL_DEC_FIN_RSN_CODE4 CHARACTER VARYING(4) 4
157 U_FULL_DEC_FIN_RSN_CODE5 CHARACTER VARYING(4) 4
158 U_FULL_DEC_FIN_RSN_CODE6 CHARACTER VARYING(4) 4
159 U_FULL_DEC_FIN_RSN_CODE7 CHARACTER VARYING(4) 4
160 U_FULL_DEC_FIN_RSN_CODE8 CHARACTER VARYING(4) 4
161 U_FULL_DEC_FIN_RSN_CODE9 CHARACTER VARYING(4) 4
162 U_FULL_GRADE_SPARE1_GRD1 CHARACTER VARYING(10) 10
163 U_FULL_GRADE_SPARE2_GRD2 CHARACTER VARYING(10) 10
164 U_FULL_LOAN_PARA_INT_R_A CHARACTER VARYING(32) 32
165 U_FULL_LOAN_PARA_LOAN_R_P CHARACTER VARYING(32) 32
166 U_FULL_MX_LOAN_AMT_AVAL_S CHARACTER VARYING(32) 32
167 U_FULL_MX_LOAN_AMT_C_M_LA CHARACTER VARYING(1) 1
168 U_FULL_MX_LOAN_AMT_L_E_F CHARACTER VARYING(32) 32
169 U_FULL_VER_FIN_EMP_ON CHARACTER VARYING(20) 20
170 U_FULL_VER_FIN_EMP_TGN CHARACTER VARYING(10) 10
171 U_FULL_VER_FIN_EMP_TEN CHARACTER VARYING(20) 20
172 U_FULL_VER_CR_R_HIST_ON CHARACTER VARYING(20) 20
173 U_FULL_VER_CR_R_HIST_TGN CHARACTER VARYING(10) 10
174 U_FULL_VER_CR_R_HIST_TEN CHARACTER VARYING(20) 20
175 U_FULL_VER_B_CONTR_P_ON CHARACTER VARYING(20) 20
176 U_FULL_VER_B_CONTR_P_TGN CHARACTER VARYING(10) 10
177 U_FULL_VER_B_CONTR_P_TEN CHARACTER VARYING(20) 20
178 U_FULL_VER_GEN_SAVING_ON CHARACTER VARYING(20) 20
179 U_FULL_VER_GEN_SAVING_TGN CHARACTER VARYING(10) 10
180 U_FULL_VER_GEN_SAVING_TEN CHARACTER VARYING(20) 20
181 U_FULL_VER_A_REALEST_ON CHARACTER VARYING(20) 20
182 U_FULL_VER_A_REALEST_TGN CHARACTER VARYING(10) 10
183 U_FULL_VER_A_REALESTA_TEN CHARACTER VARYING(20) 20
184 U_FULL_VER_A_OTHER_ON CHARACTER VARYING(20) 20
185 U_FULL_VER_A_OTHER_TGN CHARACTER VARYING(10) 10
186 U_FULL_VERI_A_OTHER_TEN CHARACTER VARYING(20) 20
187 U_FULL_VER_RENT_EXP_ON CHARACTER VARYING(20) 20
188 U_FULL_VER_RENT_EXP_TGN CHARACTER VARYING(10) 10
189 U_FULL_VER_RENT_EXP_TEN CHARACTER VARYING(20) 20
190 U_FULL_VER_CR_REPORT_ON CHARACTER VARYING(20) 20
191 U_FULL_VER_CR_REPORT_TGN CHARACTER VARYING(10) 10
192 U_FULL_VER_CR_REPORT_TEN CHARACTER VARYING(20) 20
193 U_FULL_VER_RES_ADDR_ON CHARACTER VARYING(20) 20
194 U_FULL_VER_RES_ADDR_TGN CHARACTER VARYING(10) 10
195 U_FULL_VER_RES_ADDR_TEN CHARACTER VARYING(20) 20
196 U_FULL_VER_OTH1_ON CHARACTER VARYING(20) 20
197 U_FULL_VER_OTH1_TGN CHARACTER VARYING(10) 10
198 U_FULL_VER_OTH1_TEN CHARACTER VARYING(20) 20
199 U_FULL_VER_OTH2_ON CHARACTER VARYING(20) 20
200 U_FULL_VER_OTH2_TGN CHARACTER VARYING(10) 10
201 U_FULL_VER_OTH2_TEN CHARACTER VARYING(20) 20
202 U_FULL_VER_OTH3_ON CHARACTER VARYING(20) 20
203 U_FULL_VER_OTH3_TGN CHARACTER VARYING(10) 10
204 U_FULL_VER_OTH3_TEN CHARACTER VARYING(20) 20
205 U_FULL_VER_FIN_EMP_FLG CHARACTER VARYING(1) 1
206 U_FULL_VER_CR_R_HIST_FLG CHARACTER VARYING(1) 1
207 U_FULL_VER_B_CONTR_P_FLG CHARACTER VARYING(1) 1
208 U_FULL_VER_GEN_SAVING_FLG CHARACTER VARYING(1) 1
209 U_FULL_VER_A_REALEST_FLG CHARACTER VARYING(1) 1
210 U_FULL_VER_ASSET_OTH_FLG CHARACTER VARYING(1) 1
211 U_FULL_VER_RENTAL_EXP_FLG CHARACTER VARYING(1) 1
212 U_FULL_VER_CREDIT_REP_FLG CHARACTER VARYING(1) 1
213 U_FULL_VER_RES_ADD_FLG CHARACTER VARYING(1) 1
214 U_FULL_VER_OTH1_FLAG CHARACTER VARYING(1) 1
215 U_FULL_VER_OTH2_FLAG CHARACTER VARYING(1) 1
216 U_FULL_VER_OTH3_FLAG CHARACTER VARYING(1) 1
217 U_FULL_MX_LOAN_AMT_L_E_FM CHARACTER VARYING(32) 32
218 U_FULL_MX_LOAN_AMT_L_E_M CHARACTER VARYING(32) 32
219 U_FULL_MX_LOAN_AMT_MN_E_A CHARACTER VARYING(32) 32
220 U_FULL_MX_LOAN_AMT_MN_L_V CHARACTER VARYING(32) 32
221 U_FULL_MX_LOAN_AMT_MN_S_V CHARACTER VARYING(32) 32
222 U_FULL_MX_LOAN_AMT_MX_E_A CHARACTER VARYING(32) 32
223 U_FULL_MX_LOAN_AMT_MX_L_A CHARACTER VARYING(32) 32
224 U_FULL_MX_LOAN_AMT_R_F CHARACTER VARYING(32) 32
225 U_FULL_MX_LOAN_AMT_S_MX CHARACTER VARYING(32) 32
226 U_FULL_NEXT_CALL_TYPE_NCT CHARACTER VARYING(10) 10
227 U_FULL_NEXT_CALL_TYPE_S_F CHARACTER VARYING(4) 4
228 U_FULL_RISK_GRADE_A_R_G CHARACTER VARYING(10) 10
229 U_FULL_SCORE_APP_SCORE CHARACTER VARYING(10) 10
230 U_FULL_SCORE_SPARE1_SC1 CHARACTER VARYING(10) 10
231 U_FULL_SCORE_SPARE2_SC2 CHARACTER VARYING(10) 10
232 U_FULL_XSELL_ELIGIBIL_FLG CHARACTER VARYING(1) 1
233 U_FULL_XSELL_PROD_CODE1 CHARACTER VARYING(6) 6
234 U_FULL_XSELL_PROD_CODE2 CHARACTER VARYING(6) 6
235 U_FULL_XSELL_PROD_CODE3 CHARACTER VARYING(6) 6
236 U_FULL_XSELL_PROD_CODE4 CHARACTER VARYING(6) 6