OBP24_HST_CZ_SC_OR_EXPR_U_RSLT_CAL_VER

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

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 SMALLINT 2
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 INTEGER 4
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 INTEGER 4
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 INTEGER 4
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 INTEGER 4
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_ORG_DEC_CAT CHARACTER VARYING(1) 1
96 U_FIN_DEC_ORG_DEC_RSNCODE CHARACTER VARYING(4) 4
97 U_FIN_DEC_POL_DEC_CAT CHARACTER VARYING(1) 1
98 U_FIN_DEC_POL_RSN_CODE1 CHARACTER VARYING(4) 4
99 U_FIN_DEC_FIN_DEC_CAT CHARACTER VARYING(1) 1
100 U_FIN_MX_LOAN_LIM_REQ INTEGER 4
101 U_FIN_MX_LOAN_FIN_LIM_REQ INTEGER 4
102 U_FIN_MX_LOAN_UNSEC_EX INTEGER 4
103 U_FIN_MX_LOAN_MX_UNSEC_EX INTEGER 4
104 U_FIN_MX_LOAN_MX_TOT_EXP INTEGER 4
105 U_FIN_MX_LOAN_TOT_EXP INTEGER 4
106 U_FULL_BUR_REQ_A_B_R_FLG CHARACTER VARYING(1) 1
107 U_FULL_BUR_REQ_G_B_R_FLG CHARACTER VARYING(1) 1
108 U_FULL_BUR_SERV_B_SERV1 CHARACTER VARYING(1) 1
109 U_FULL_BUR_SERV_B_SERV2 CHARACTER VARYING(1) 1
110 U_FULL_BUR_SERV_B_SERV3 CHARACTER VARYING(1) 1
111 U_FULL_BUR_SERV_B_SERV4 CHARACTER VARYING(1) 1
112 U_FULL_BUR_SERV_B_SERV5 CHARACTER VARYING(1) 1
113 U_FULL_BUR_SERV_B_SERV6 CHARACTER VARYING(1) 1
114 U_FULL_BUR_SERV_B_SERV7 CHARACTER VARYING(1) 1
115 U_FULL_BUR_SERV_B_SERV8 CHARACTER VARYING(1) 1
116 U_FULL_BUR_SERV_B_SERV9 CHARACTER VARYING(1) 1
117 U_FULL_BUR_SERV_B_SERV10 CHARACTER VARYING(1) 1
118 U_FULL_MX_LOAN_AMT_C_M_LA CHARACTER VARYING(1) 1
119 U_FULL_MX_LOAN_AMT_MN_S_V INTEGER 4
120 U_FULL_MX_LOAN_AMT_L_E_F NUMERIC(15,2) 19
121 U_FULL_MX_LOAN_AMT_MX_E_A INTEGER 4
122 U_FULL_MX_LOAN_AMT_MN_E_A INTEGER 4
123 U_FULL_MX_LOAN_AMT_MN_L_V INTEGER 4
124 U_FULL_MX_LOAN_AMT_R_F NUMERIC(15,2) 19
125 U_FULL_MX_LOAN_AMT_MX_L_A INTEGER 4
126 U_FULL_MX_LOAN_AMT_AVAL_S INTEGER 4
127 U_FULL_MX_LOAN_AMT_S_MX INTEGER 4
128 U_FULL_MX_LOAN_AMT_L_E_FM INTEGER 4
129 U_FULL_MX_LOAN_AMT_L_E_M INTEGER 4
130 U_FULL_LOAN_PARA_INT_R_A NUMERIC(15,2) 19
131 U_FULL_LOAN_PARA_LOAN_R_P SMALLINT 2
132 U_FULL_XSELL_ELIGIBIL_FLG CHARACTER VARYING(1) 1
133 U_FULL_XSELL_PROD_CODE1 CHARACTER VARYING(6) 6
134 U_FULL_XSELL_PROD_CODE2 CHARACTER VARYING(6) 6
135 U_FULL_XSELL_PROD_CODE3 CHARACTER VARYING(6) 6
136 U_FULL_XSELL_PROD_CODE4 CHARACTER VARYING(6) 6
137 U_FULL_NEXT_CALL_TYPE_NCT SMALLINT 2
138 U_FULL_NEXT_CALL_TYPE_S_F CHARACTER VARYING(4) 4
139 U_FULL_SCORE_APP_SCORE INTEGER 4
140 U_FULL_RISK_GRADE_A_R_G SMALLINT 2
141 U_FULL_SCORE_SPARE1_SC1 INTEGER 4
142 U_FULL_GRADE_SPARE1_GRD1 SMALLINT 2
143 U_FULL_SCORE_SPARE2_SC2 INTEGER 4
144 U_FULL_GRADE_SPARE2_GRD2 SMALLINT 2
145 U_FULL_CRGS_SCORE_SCORE INTEGER 4
146 U_FULL_CRGS_GRADE_GRADE SMALLINT 2
147 U_FULL_DEC_FIN_RSN_CODE1 CHARACTER VARYING(4) 4
148 U_FIN_MX_LOAN_MAX_LVR INTEGER 4
149 U_FIN_MX_LOAN_MX_LVR_P NUMERIC(15,2) 19
150 U_FIN_DEC_POL_RSN_CODE2 CHARACTER VARYING(4) 4
151 U_FIN_DEC_POL_RSN_CODE3 CHARACTER VARYING(4) 4
152 U_FIN_DEC_POL_RSN_CODE4 CHARACTER VARYING(4) 4
153 U_FIN_DEC_POL_RSN_CODE5 CHARACTER VARYING(4) 4
154 U_FIN_DEC_POL_RSN_CODE6 CHARACTER VARYING(4) 4
155 U_FIN_DEC_POL_RSN_CODE7 CHARACTER VARYING(4) 4
156 U_FIN_DEC_POL_RSN_CODE8 CHARACTER VARYING(4) 4
157 U_FIN_DEC_POL_RSN_CODE9 CHARACTER VARYING(4) 4
158 U_FIN_DEC_POL_RSN_CODE10 CHARACTER VARYING(4) 4
159 U_FIN_DEC_POL_RSN_CODE11 CHARACTER VARYING(4) 4
160 U_FIN_DEC_POL_RSN_CODE12 CHARACTER VARYING(4) 4
161 U_FIN_DEC_POL_RSN_CODE13 CHARACTER VARYING(4) 4
162 U_FIN_DEC_POL_RSN_CODE14 CHARACTER VARYING(4) 4
163 U_FIN_DEC_POL_RSN_CODE15 CHARACTER VARYING(4) 4
164 U_FIN_DEC_POL_RSN_CODE16 CHARACTER VARYING(4) 4
165 U_FIN_DEC_POL_RSN_CODE17 CHARACTER VARYING(4) 4
166 U_FIN_DEC_POL_RSN_CODE18 CHARACTER VARYING(4) 4
167 U_FIN_DEC_POL_RSN_CODE19 CHARACTER VARYING(4) 4
168 U_FIN_DEC_POL_RSN_CODE20 CHARACTER VARYING(4) 4
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_DEC_FIN_DEC_CAT CHARACTER VARYING(1) 1
218 U_FULL_DEC_FIN_RSN_CODE2 CHARACTER VARYING(4) 4
219 U_FULL_DEC_FIN_RSN_CODE3 CHARACTER VARYING(4) 4
220 U_FULL_DEC_FIN_RSN_CODE4 CHARACTER VARYING(4) 4
221 U_FULL_DEC_FIN_RSN_CODE5 CHARACTER VARYING(4) 4
222 U_FULL_DEC_FIN_RSN_CODE6 CHARACTER VARYING(4) 4
223 U_FULL_DEC_FIN_RSN_CODE7 CHARACTER VARYING(4) 4
224 U_FULL_DEC_FIN_RSN_CODE8 CHARACTER VARYING(4) 4
225 U_FULL_DEC_FIN_RSN_CODE9 CHARACTER VARYING(4) 4
226 U_FULL_DEC_FIN_RSN_CODE10 CHARACTER VARYING(4) 4
227 U_FULL_DEC_FIN_RSN_CODE11 CHARACTER VARYING(4) 4
228 U_FULL_DEC_FIN_RSN_CODE12 CHARACTER VARYING(4) 4
229 U_FULL_DEC_FIN_RSN_CODE13 CHARACTER VARYING(4) 4
230 U_FULL_DEC_FIN_RSN_CODE14 CHARACTER VARYING(4) 4
231 U_FULL_DEC_FIN_RSN_CODE15 CHARACTER VARYING(4) 4
232 U_FULL_DEC_FIN_RSN_CODE16 CHARACTER VARYING(4) 4
233 U_FULL_DEC_FIN_RSN_CODE17 CHARACTER VARYING(4) 4
234 U_FULL_DEC_FIN_RSN_CODE18 CHARACTER VARYING(4) 4
235 U_FULL_DEC_FIN_RSN_CODE19 CHARACTER VARYING(4) 4
236 U_FULL_DEC_FIN_RSN_CODE20 CHARACTER VARYING(4) 4
237 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
238 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
239 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
240 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8