FCT_BNK_CRHDS_RESP_APPL_OUT_INSIGHT

Database

INSNZP01_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 DECISION CHARACTER VARYING(30) 30
5 ADS_DEC_TEXT CHARACTER VARYING(20) 20
6 ADS_DEC_REASON_CODE CHARACTER VARYING(10) 10
7 ADS_DEC_CATEGORY CHARACTER VARYING(20) 20
8 ADS_SOR_RES_COD_TAB_I1 CHARACTER VARYING(10) 10
9 ADS_SOR_RES_COD_TAB_I2 CHARACTER VARYING(10) 10
10 ADS_SOR_RES_COD_TAB_I3 CHARACTER VARYING(10) 10
11 ADS_SOR_RES_COD_TAB_I4 CHARACTER VARYING(10) 10
12 ADS_SOR_RES_COD_TAB_I5 CHARACTER VARYING(10) 10
13 ADS_SOR_RES_COD_TAB_I6 CHARACTER VARYING(10) 10
14 ADS_SOR_RES_COD_TAB_I7 CHARACTER VARYING(10) 10
15 ADS_SOR_RES_COD_TAB_I8 CHARACTER VARYING(10) 10
16 ADS_SOR_RES_COD_TAB_I9 CHARACTER VARYING(10) 10
17 ADS_SOR_RES_COD_TAB_I10 CHARACTER VARYING(10) 10
18 ADS_SOR_RES_COD_TAB_I11 CHARACTER VARYING(10) 10
19 ADS_SOR_RES_COD_TAB_I12 CHARACTER VARYING(10) 10
20 ADS_SOR_RES_COD_TAB_I13 CHARACTER VARYING(10) 10
21 ADS_SOR_RES_COD_TAB_I14 CHARACTER VARYING(10) 10
22 ADS_SOR_RES_COD_TAB_I15 CHARACTER VARYING(10) 10
23 ADS_SOR_RES_COD_TAB_I16 CHARACTER VARYING(10) 10
24 ADS_SOR_RES_COD_TAB_I17 CHARACTER VARYING(10) 10
25 ADS_SOR_RES_COD_TAB_I18 CHARACTER VARYING(10) 10
26 ADS_SOR_RES_COD_TAB_I19 CHARACTER VARYING(10) 10
27 ADS_SOR_RES_COD_TAB_I20 CHARACTER VARYING(10) 10
28 ADS_SOR_RES_COD_TAB_I21 CHARACTER VARYING(10) 10
29 ADS_SOR_RES_COD_TAB_I22 CHARACTER VARYING(10) 10
30 ADS_SOR_RES_COD_TAB_I23 CHARACTER VARYING(10) 10
31 ADS_SOR_RES_COD_TAB_I24 CHARACTER VARYING(10) 10
32 ADS_SOR_RES_COD_TAB_I25 CHARACTER VARYING(10) 10
33 ADS_SOR_DEC_TAB_I1 CHARACTER VARYING(50) 50
34 ADS_SOR_DEC_TAB_I2 CHARACTER VARYING(50) 50
35 ADS_SOR_DEC_TAB_I3 CHARACTER VARYING(50) 50
36 ADS_SOR_DEC_TAB_I4 CHARACTER VARYING(50) 50
37 ADS_SOR_DEC_TAB_I5 CHARACTER VARYING(50) 50
38 ADS_SOR_DEC_TAB_I6 CHARACTER VARYING(50) 50
39 ADS_SOR_DEC_TAB_I7 CHARACTER VARYING(50) 50
40 ADS_SOR_DEC_TAB_I8 CHARACTER VARYING(50) 50
41 ADS_SOR_DEC_TAB_I9 CHARACTER VARYING(50) 50
42 ADS_SOR_DEC_TAB_I10 CHARACTER VARYING(50) 50
43 ADS_SOR_DEC_TAB_I11 CHARACTER VARYING(50) 50
44 ADS_SOR_DEC_TAB_I12 CHARACTER VARYING(50) 50
45 ADS_SOR_DEC_TAB_I13 CHARACTER VARYING(50) 50
46 ADS_SOR_DEC_TAB_I14 CHARACTER VARYING(50) 50
47 ADS_SOR_DEC_TAB_I15 CHARACTER VARYING(50) 50
48 ADS_SOR_DEC_TAB_I16 CHARACTER VARYING(50) 50
49 ADS_SOR_DEC_TAB_I17 CHARACTER VARYING(50) 50
50 ADS_SOR_DEC_TAB_I18 CHARACTER VARYING(50) 50
51 ADS_SOR_DEC_TAB_I19 CHARACTER VARYING(50) 50
52 ADS_SOR_DEC_TAB_I20 CHARACTER VARYING(50) 50
53 ADS_SOR_DEC_TAB_I21 CHARACTER VARYING(50) 50
54 ADS_SOR_DEC_TAB_I22 CHARACTER VARYING(50) 50
55 ADS_SOR_DEC_TAB_I23 CHARACTER VARYING(50) 50
56 ADS_SOR_DEC_TAB_I24 CHARACTER VARYING(50) 50
57 ADS_SOR_DEC_TAB_I25 CHARACTER VARYING(50) 50
58 ARS_SCORE NUMERIC(20,2) 19
59 ARS_SCORE_INDEX NUMERIC(20,2) 19
60 ARG_RISK_GRADE NUMERIC(20,2) 19
61 FADS_DEC_TEXT CHARACTER VARYING(20) 20
62 FADS_DEC_REASON_CODE CHARACTER VARYING(10) 10
63 FADS_DEC_CATEGORY CHARACTER VARYING(20) 20
64 FADS_SOR_RES_COD_TAB_I1 CHARACTER VARYING(10) 10
65 FADS_SOR_RES_COD_TAB_I2 CHARACTER VARYING(10) 10
66 FADS_SOR_RES_COD_TAB_I3 CHARACTER VARYING(10) 10
67 FADS_SOR_RES_COD_TAB_I4 CHARACTER VARYING(10) 10
68 FADS_SOR_RES_COD_TAB_I5 CHARACTER VARYING(10) 10
69 FADS_SOR_RES_COD_TAB_I6 CHARACTER VARYING(10) 10
70 FADS_SOR_RES_COD_TAB_I7 CHARACTER VARYING(10) 10
71 FADS_SOR_RES_COD_TAB_I8 CHARACTER VARYING(10) 10
72 FADS_SOR_RES_COD_TAB_I9 CHARACTER VARYING(10) 10
73 FADS_SOR_RES_COD_TAB_I10 CHARACTER VARYING(10) 10
74 FADS_SOR_RES_COD_TAB_I11 CHARACTER VARYING(10) 10
75 FADS_SOR_RES_COD_TAB_I12 CHARACTER VARYING(10) 10
76 FADS_SOR_RES_COD_TAB_I13 CHARACTER VARYING(10) 10
77 FADS_SOR_RES_COD_TAB_I14 CHARACTER VARYING(10) 10
78 FADS_SOR_RES_COD_TAB_I15 CHARACTER VARYING(10) 10
79 FADS_SOR_RES_COD_TAB_I16 CHARACTER VARYING(10) 10
80 FADS_SOR_RES_COD_TAB_I17 CHARACTER VARYING(10) 10
81 FADS_SOR_RES_COD_TAB_I18 CHARACTER VARYING(10) 10
82 FADS_SOR_RES_COD_TAB_I19 CHARACTER VARYING(10) 10
83 FADS_SOR_RES_COD_TAB_I20 CHARACTER VARYING(10) 10
84 FADS_SOR_RES_COD_TAB_I21 CHARACTER VARYING(10) 10
85 FADS_SOR_RES_COD_TAB_I22 CHARACTER VARYING(10) 10
86 FADS_SOR_RES_COD_TAB_I23 CHARACTER VARYING(10) 10
87 FADS_SOR_RES_COD_TAB_I24 CHARACTER VARYING(10) 10
88 FADS_SOR_RES_COD_TAB_I25 CHARACTER VARYING(10) 10
89 FADS_SOR_DEC_TAB_I1 CHARACTER VARYING(50) 50
90 FADS_SOR_DEC_TAB_I2 CHARACTER VARYING(50) 50
91 FADS_SOR_DEC_TAB_I3 CHARACTER VARYING(50) 50
92 FADS_SOR_DEC_TAB_I4 CHARACTER VARYING(50) 50
93 FADS_SOR_DEC_TAB_I5 CHARACTER VARYING(50) 50
94 FADS_SOR_DEC_TAB_I6 CHARACTER VARYING(50) 50
95 FADS_SOR_DEC_TAB_I7 CHARACTER VARYING(50) 50
96 FADS_SOR_DEC_TAB_I8 CHARACTER VARYING(50) 50
97 FADS_SOR_DEC_TAB_I9 CHARACTER VARYING(50) 50
98 FADS_SOR_DEC_TAB_I10 CHARACTER VARYING(50) 50
99 FADS_SOR_DEC_TAB_I11 CHARACTER VARYING(50) 50
100 FADS_SOR_DEC_TAB_I12 CHARACTER VARYING(50) 50
101 FADS_SOR_DEC_TAB_I13 CHARACTER VARYING(50) 50
102 FADS_SOR_DEC_TAB_I14 CHARACTER VARYING(50) 50
103 FADS_SOR_DEC_TAB_I15 CHARACTER VARYING(50) 50
104 FADS_SOR_DEC_TAB_I16 CHARACTER VARYING(50) 50
105 FADS_SOR_DEC_TAB_I17 CHARACTER VARYING(50) 50
106 FADS_SOR_DEC_TAB_I18 CHARACTER VARYING(50) 50
107 FADS_SOR_DEC_TAB_I19 CHARACTER VARYING(50) 50
108 FADS_SOR_DEC_TAB_I20 CHARACTER VARYING(50) 50
109 FADS_SOR_DEC_TAB_I21 CHARACTER VARYING(50) 50
110 FADS_SOR_DEC_TAB_I22 CHARACTER VARYING(50) 50
111 FADS_SOR_DEC_TAB_I23 CHARACTER VARYING(50) 50
112 FADS_SOR_DEC_TAB_I24 CHARACTER VARYING(50) 50
113 FADS_SOR_DEC_TAB_I25 CHARACTER VARYING(50) 50
114 FARS_SCORE NUMERIC(20,2) 19
115 FARS_SCORE_INDEX NUMERIC(20,2) 19
116 FARG_RISK_GRADE NUMERIC(20,2) 19
117 MAL_CALC_MAX_LN_AMT_FLAG CHARACTER VARYING(1) 1
118 MAL_MIN_SURPLUS_VAL NUMERIC(20,2) 19
119 MAL_LIMIT_EXT_FACTOR NUMERIC(20,2) 19
120 MAL_MAX_EXT_AMT NUMERIC(20,2) 19
121 MAL_MIN_EXT_AMT NUMERIC(20,2) 19
122 MAL_MIN_LOAN_VAL NUMERIC(20,2) 19
123 MAL_ROUNDING_FACTOR NUMERIC(20,2) 19
124 MAL_MAX_LOAN_AMT NUMERIC(20,2) 19
125 MAL_AVL_SURPLUS NUMERIC(20,2) 19
126 MAL_SURPLUS_MAX NUMERIC(20,2) 19
127 MAL_LIMIT_EXT_FACTOR_MAX NUMERIC(20,2) 19
128 MAL_LIMIT_EXT_MAX NUMERIC(20,2) 19
129 LP_INT_RATE_ADJUSTMENT NUMERIC(20,2) 19
130 LP_LOAN_REVIEW_PERIOD NUMERIC(20,2) 19
131 XE_ELIGIBILITY_FLAG CHARACTER VARYING(1) 1
132 XE_PRODUCT_1 CHARACTER VARYING(6) 6
133 XE_PRODUCT_2 CHARACTER VARYING(6) 6
134 XE_PRODUCT_3 CHARACTER VARYING(6) 6
135 XE_PRODUCT_4 CHARACTER VARYING(6) 6
136 CTR_CAPACITY_TO_REPAY CHARACTER VARYING(3) 3
137 CTR_REPAYMENT_AMOUNT NUMERIC(20,2) 19
138 CTR_SENS_REPAY_AMOUNT NUMERIC(20,2) 19
139 CTR_TOT_AVL_INCOME NUMERIC(20,2) 19
140 CTR_TOT_EXP_INCL_PER_LIV_EXP NUMERIC(20,2) 19
141 CTR_TOT_EXP_EXCL_PER_LIV_EXP NUMERIC(20,2) 19
142 CTR_DISC_INCOME NUMERIC(20,2) 19
143 CTR_GROSS_SALARY NUMERIC(20,2) 19
144 CTR_OTH_NET_INCOME NUMERIC(20,2) 19
145 CTR_INV_INCOME NUMERIC(20,2) 19
146 CTR_BUS_INCOME NUMERIC(20,2) 19
147 CTR_BUS_SALARY NUMERIC(20,2) 19
148 CTR_TAX_WITH_HELD NUMERIC(20,2) 19
149 CTR_NEG_GEAR_BENEFIT NUMERIC(20,2) 19
150 CTR_CREDIT_CARD_EXP NUMERIC(20,2) 19
151 CTR_MARGIN_LEND_EXP NUMERIC(20,2) 19
152 CTR_REGULAR_EXPENSES NUMERIC(20,2) 19
153 CTR_TOT_DEC_LIV_EXP NUMERIC(20,2) 19
154 CTR_TOT_HEM_LIV_EXP NUMERIC(20,2) 19
155 CTR_LIVING_EXPENSES NUMERIC(20,2) 19
156 SPARE_S1 CHARACTER VARYING(30) 30
157 SPARE_S2 CHARACTER VARYING(30) 30
158 SPARE_S3 CHARACTER VARYING(30) 30
159 SPARE_S4 CHARACTER VARYING(30) 30
160 SPARE_S5 CHARACTER VARYING(30) 30
161 SPARE_S6 CHARACTER VARYING(30) 30
162 SPARE_S7 CHARACTER VARYING(30) 30
163 SPARE_S8 CHARACTER VARYING(30) 30
164 SPARE_S9 CHARACTER VARYING(30) 30
165 SPARE_S10 CHARACTER VARYING(30) 30
166 SPARE_S11 CHARACTER VARYING(30) 30
167 SPARE_S12 CHARACTER VARYING(30) 30
168 SPARE_S13 CHARACTER VARYING(30) 30
169 SPARE_S14 CHARACTER VARYING(30) 30
170 SPARE_S15 CHARACTER VARYING(30) 30
171 SPARE_S16 CHARACTER VARYING(30) 30
172 SPARE_S17 CHARACTER VARYING(30) 30
173 SPARE_S18 CHARACTER VARYING(30) 30
174 SPARE_S19 CHARACTER VARYING(30) 30
175 SPARE_S20 CHARACTER VARYING(30) 30
176 SPARE_F1 NUMERIC(20,2) 19
177 SPARE_F2 NUMERIC(20,2) 19
178 SPARE_F3 NUMERIC(20,2) 19
179 SPARE_F4 NUMERIC(20,2) 19
180 SPARE_F5 NUMERIC(20,2) 19
181 SPARE_F6 NUMERIC(20,2) 19
182 SPARE_F7 NUMERIC(20,2) 19
183 SPARE_F8 NUMERIC(20,2) 19
184 SPARE_F9 NUMERIC(20,2) 19
185 SPARE_F10 NUMERIC(20,2) 19
186 SPARE_F11 NUMERIC(20,2) 19
187 SPARE_F12 NUMERIC(20,2) 19
188 SPARE_F13 NUMERIC(20,2) 19
189 SPARE_F14 NUMERIC(20,2) 19
190 SPARE_F15 NUMERIC(20,2) 19
191 SPARE_F16 NUMERIC(20,2) 19
192 SPARE_F17 NUMERIC(20,2) 19
193 SPARE_F18 NUMERIC(20,2) 19
194 SPARE_F19 NUMERIC(20,2) 19
195 SPARE_F20 NUMERIC(20,2) 19