OBP24_HST_CZ_SC_OR_EXPR_POST_SEC_SHAR

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_SINGLE_LOAN_FLG_463 CHARACTER VARYING(1) 1
3 S_OWNER_EST_OF_SEC_464 INTEGER 4
4 S_NVP_EXCLUSIONS_465 CHARACTER VARYING(4) 4
5 S_RESIDEX_ESTIMATE_466 INTEGER 4
6 S_LOAN2PRCH_PRICE_PCT_481 SMALLINT 2
7 S_LOAN_REGULATED_FLG_533 CHARACTER VARYING(1) 1
8 S_AGG_LVR_536 NUMERIC(7,2) 19
9 S_N_ACCPT_SEC_A_APPL_537 BYTEINT 1
10 S_SPARE_119_538 CHARACTER VARYING(5) 5
11 S_MTGE_INS_STATUS_541 CHARACTER VARYING(1) 1
12 S_ACCEPTABLE_LOC_FLG_556 CHARACTER VARYING(1) 1
13 S_ACCEPTABLE_SEC_FLG_557 CHARACTER VARYING(1) 1
14 S_EXIST_VALUATION_AMT_560 INTEGER 4
15 S_SECURITY_LAND_AREA_561 INTEGER 4
16 S_SECURITY_POST_CODE_562 CHARACTER VARYING(4) 4
17 S_SECURITY_RESDT_AREA_563 INTEGER 4
18 S_SECURITY_TYPE_564 CHARACTER VARYING(3) 3
19 S_SECURITY_ZONING_565 CHARACTER VARYING(5) 5
20 S_T_SINCE_LST_VALUTN_566 SMALLINT 2
21 S_TOT_VALUATION_AMT_567 INTEGER 4
22 S_SECURITY_WAIVER_FLG_568 CHARACTER VARYING(1) 1
23 S_OVERALLVAR2PPRCPCT_569 NUMERIC(9,2) 19
24 S_MX_NEGVAR2PPRICEPCT_570 NUMERIC(9,2) 19
25 S_SECURITY_TYPES_1179 CHARACTER VARYING(60) 60
26 S_COARSE_PRIMARY_ROLE_395 CHARACTER VARYING(3) 3
27 S_FINE_PRIMARY_ROLE_396 CHARACTER VARYING(3) 3
28 S_PARTY_TYPE_397 CHARACTER VARYING(1) 1
29 S_EXIST_CUST_FLG_398 CHARACTER VARYING(1) 1
30 S_EXIST_LNDG_CUST_399 CHARACTER VARYING(1) 1
31 S_EXIST_CUST_FLG_438 CHARACTER VARYING(1) 1
32 S_EXIST_LNDG_CUST_FLG_439 CHARACTER VARYING(1) 1
33 S_OVERSEAS_BORROWER_441 CHARACTER VARYING(1) 1
34 S_SUSPECTED_FRAUD_FLG_444 CHARACTER VARYING(1) 1
35 S_ASSETS_TO_LIAB_R_468 NUMERIC(9,2) 19
36 S_ASSETS_TO_LIAB_R_469 NUMERIC(9,2) 19
37 S_ASSETS_TO_LIAB_R_470 NUMERIC(9,2) 19
38 S_TOT_CUST_EXPOSURE_504 INTEGER 4
39 S_TOT_CUST_EXPOSURE_505 INTEGER 4
40 S_TOT_OTH_SPLIT_AMT_507 INTEGER 4
41 S_TOT_OSPL_AM_BUS_BNK_508 INTEGER 4
42 S_TOT_CUS_EXP_BUS_BNK_509 INTEGER 4
43 S_TOT_LIABILITIES_511 INTEGER 4
44 S_SPARE_118_520 CHARACTER VARYING(4) 4
45 S_ADD_LOAN_FLG_523 CHARACTER VARYING(1) 1
46 S_LOAN_CLASS_525 CHARACTER VARYING(1) 1
47 S_LOAN_AMT_OR_LIM_RQ_530 INTEGER 4
48 S_LOAN_PRODUCT_TYPE_531 CHARACTER VARYING(5) 5
49 S_LOAN_PURPOSE_532 CHARACTER VARYING(3) 3
50 S_LOAN_SUB_PURPOSE_535 CHARACTER VARYING(2) 2
51 S_PRCH_PRICE_550 INTEGER 4
52 S_WRST_EXIST_ACCT_GRD_621 SMALLINT 2
53 S_WRST_EXIST_ACCT_GRD_622 SMALLINT 2
54 S_WRST_EXIST_ACCT_GRD_623 SMALLINT 2
55 S_WRST_EXIST_ACCT_GRD_624 SMALLINT 2
56 S_WRST_EXIST_ACCT_GRD_625 SMALLINT 2
57 S_WRST_EXIST_ACCT_GRD_627 SMALLINT 2
58 S_WRST_EXIST_ACCT_GRD_628 SMALLINT 2
59 S_WRST_EXIST_ACCT_GRD_629 SMALLINT 2
60 S_WRST_EXIST_ACCT_GRD_630 SMALLINT 2
61 S_WRST_CUS_RISK_GRADE_631 SMALLINT 2
62 S_WRST_EXIST_ACCT_GRD_632 SMALLINT 2
63 S_WRST_EXIST_ACCT_GRD_633 SMALLINT 2
64 S_WRST_EXIST_ACCT_GRD_634 SMALLINT 2
65 S_WRST_EXIST_ACCT_GRD_635 SMALLINT 2
66 S_WRST_EXIST_ACCT_GRD_636 SMALLINT 2
67 S_WRST_EXIST_ACCT_GRD_637 SMALLINT 2
68 S_WRST_EXIST_ACCT_GRD_638 SMALLINT 2
69 S_WRST_EXIST_ACCT_GRD_639 SMALLINT 2
70 S_WRST_EXIST_ACCT_GRD_640 SMALLINT 2
71 S_WRST_CUS_RISK_GRADE_641 SMALLINT 2
72 S_T_MOST_REC_FINCLS_959 SMALLINT 2
73 S_NUM_OF_DEFS_960 SMALLINT 2
74 S_NUM_OF_DEFS_961 SMALLINT 2
75 S_NUM_NON_UTIL_ENQ_962 SMALLINT 2
76 S_CALCULATED_SSV_963 SMALLINT 2
77 S_SPARE_6_964 SMALLINT 2
78 S_SPARE_7_965 SMALLINT 2
79 S_SPARE_8_966 SMALLINT 2
80 S_LOW_DOC_FLG_979 CHARACTER VARYING(1) 1
81 S_FIELD_USD_SUNLOANS1_980 CHARACTER VARYING(1) 1
82 S_FIELD_USD_SUNLOANS2_981 CHARACTER VARYING(1) 1
83 S_ACCEPTABLE_SEC_FLG_982 CHARACTER VARYING(1) 1
84 S_SPARE_25_983 CHARACTER VARYING(1) 1
85 S_SPARE_26_984 CHARACTER VARYING(1) 1
86 S_MX_SEC_LAND_AREA_1009 BIGINT 8
87 S_SPARE_52_1010 BIGINT 8
88 S_SPARE_53_1011 BIGINT 8
89 S_SPARE_54_1012 BIGINT 8
90 S_SPARE_55_1013 NUMERIC(15,2) 19
91 S_SPARE_56_1014 BIGINT 8
92 S_SPARE_57_1015 BIGINT 8
93 S_SPARE_58_1016 BIGINT 8
94 S_LOAN_SUB_PROD_TYPE_1029 CHARACTER VARYING(3) 3
95 S_SPARE_72_1030 CHARACTER VARYING(4) 4
96 S_SPARE_73_1031 CHARACTER VARYING(4) 4
97 S_SPARE_74_1032 CHARACTER VARYING(4) 4
98 S_SPARE_92_1050 CHARACTER VARYING(8) 8
99 S_SPARE_93_1051 CHARACTER VARYING(8) 8
100 S_SPARE_94_1052 CHARACTER VARYING(8) 8
101 S_SPARE_95_1053 CHARACTER VARYING(8) 8
102 S_WITHDRAWN_STATUS CHARACTER VARYING(1) 1
103 S_OVERRIDE_FLG CHARACTER VARYING(1) 1
104 S_OVERRIDE_RSN_CODE CHARACTER VARYING(4) 4
105 S_OVERRIDE_UID CHARACTER VARYING(7) 7
106 S_OVERRIDE_UID_DATE TIMESTAMP 8
107 S_OVERALL_DEC_DATE TIMESTAMP 8
108 S_OVERALL_DEC CHARACTER VARYING(1) 1
109 S_EPMI_FINAL_DEC CHARACTER VARYING(1) 1
110 S_FULFILMENT_FLAG CHARACTER VARYING(1) 1
111 S_APP_DATE TIMESTAMP 8
112 S_FINAL_DECISION CHARACTER VARYING(1) 1
113 U_SINGLE_LOAN_FLG_463 CHARACTER VARYING(1) 1
114 U_OWNER_EST_OF_SEC_464 INTEGER 4
115 U_NVP_EXCLUSIONS_465 CHARACTER VARYING(4) 4
116 U_RESIDEX_ESTIMATE_466 INTEGER 4
117 U_LOAN2PRCH_PRICE_PCT_481 SMALLINT 2
118 U_LOAN_REGULATED_FLG_533 CHARACTER VARYING(1) 1
119 U_AGG_LVR_536 NUMERIC(7,2) 19
120 U_N_ACCPT_SEC_A_APPL_537 BYTEINT 1
121 U_SPARE_119_538 CHARACTER VARYING(5) 5
122 U_MTGE_INS_STATUS_541 CHARACTER VARYING(1) 1
123 U_ACCEPTABLE_LOC_FLG_556 CHARACTER VARYING(1) 1
124 U_ACCEPTABLE_SEC_FLG_557 CHARACTER VARYING(1) 1
125 U_EXIST_VALUATION_AMT_560 INTEGER 4
126 U_SECURITY_LAND_AREA_561 INTEGER 4
127 U_SECURITY_POST_CODE_562 CHARACTER VARYING(4) 4
128 U_SECURITY_RESDT_AREA_563 INTEGER 4
129 U_SECURITY_TYPE_564 CHARACTER VARYING(3) 3
130 U_SECURITY_ZONING_565 CHARACTER VARYING(5) 5
131 U_T_SINCE_LST_VALUTN_566 SMALLINT 2
132 U_TOT_VALUATION_AMT_567 INTEGER 4
133 U_SECURITY_WAIVER_FLG_568 CHARACTER VARYING(1) 1
134 U_OVERALLVAR2PPRCPCT_569 NUMERIC(9,2) 19
135 U_MX_NEGVAR2PPRICEPCT_570 NUMERIC(9,2) 19
136 U_SECURITY_TYPES_1179 CHARACTER VARYING(60) 60
137 U_COARSE_PRIMARY_ROLE_395 CHARACTER VARYING(3) 3
138 U_FINE_PRIMARY_ROLE_396 CHARACTER VARYING(3) 3
139 U_PARTY_TYPE_397 CHARACTER VARYING(1) 1
140 U_EXIST_CUST_FLG_398 CHARACTER VARYING(1) 1
141 U_EXIST_LNDG_CUST_399 CHARACTER VARYING(1) 1
142 U_EXIST_CUST_FLG_438 CHARACTER VARYING(1) 1
143 U_EXIST_LNDG_CUST_FLG_439 CHARACTER VARYING(1) 1
144 U_OVERSEAS_BORROWER_441 CHARACTER VARYING(1) 1
145 U_SUSPECTED_FRAUD_FLG_444 CHARACTER VARYING(1) 1
146 U_ASSETS_TO_LIAB_R_468 NUMERIC(9,2) 19
147 U_ASSETS_TO_LIAB_R_469 NUMERIC(9,2) 19
148 U_ASSETS_TO_LIAB_R_470 NUMERIC(9,2) 19
149 U_TOT_CUST_EXPOSURE_504 INTEGER 4
150 U_TOT_CUST_EXPOSURE_505 INTEGER 4
151 U_TOT_OTH_SPLIT_AMT_507 INTEGER 4
152 U_TOT_OSPL_AM_BUS_BNK_508 INTEGER 4
153 U_TOT_CUS_EXP_BUS_BNK_509 INTEGER 4
154 U_TOT_LIABILITIES_511 INTEGER 4
155 U_SPARE_118_520 CHARACTER VARYING(4) 4
156 U_ADD_LOAN_FLG_523 CHARACTER VARYING(1) 1
157 U_LOAN_CLASS_525 CHARACTER VARYING(1) 1
158 U_LOAN_AMT_OR_LIM_RQ_530 INTEGER 4
159 U_LOAN_PRODUCT_TYPE_531 CHARACTER VARYING(5) 5
160 U_LOAN_PURPOSE_532 CHARACTER VARYING(3) 3
161 U_LOAN_SUB_PURPOSE_535 CHARACTER VARYING(2) 2
162 U_PRCH_PRICE_550 INTEGER 4
163 U_WRST_EXIST_ACCT_GRD_621 SMALLINT 2
164 U_WRST_EXIST_ACCT_GRD_622 SMALLINT 2
165 U_WRST_EXIST_ACCT_GRD_623 SMALLINT 2
166 U_WRST_EXIST_ACCT_GRD_624 SMALLINT 2
167 U_WRST_EXIST_ACCT_GRD_625 SMALLINT 2
168 U_WRST_EXIST_ACCT_GRD_627 SMALLINT 2
169 U_WRST_EXIST_ACCT_GRD_628 SMALLINT 2
170 U_WRST_EXIST_ACCT_GRD_629 SMALLINT 2
171 U_WRST_EXIST_ACCT_GRD_630 SMALLINT 2
172 U_WRST_CUS_RISK_GRADE_631 SMALLINT 2
173 U_WRST_EXIST_ACCT_GRD_632 SMALLINT 2
174 U_WRST_EXIST_ACCT_GRD_633 SMALLINT 2
175 U_WRST_EXIST_ACCT_GRD_634 SMALLINT 2
176 U_WRST_EXIST_ACCT_GRD_635 SMALLINT 2
177 U_WRST_EXIST_ACCT_GRD_636 SMALLINT 2
178 U_WRST_EXIST_ACCT_GRD_637 SMALLINT 2
179 U_WRST_EXIST_ACCT_GRD_638 SMALLINT 2
180 U_WRST_EXIST_ACCT_GRD_639 SMALLINT 2
181 U_WRST_EXIST_ACCT_GRD_640 SMALLINT 2
182 U_WRST_CUS_RISK_GRADE_641 SMALLINT 2
183 U_T_MOST_REC_FINCLS_959 SMALLINT 2
184 U_NUM_OF_DEFS_960 SMALLINT 2
185 U_NUM_OF_DEFS_961 SMALLINT 2
186 U_NUM_NON_UTIL_ENQ_962 SMALLINT 2
187 U_CALCULATED_SSV_963 SMALLINT 2
188 U_SPARE_6_964 SMALLINT 2
189 U_SPARE_7_965 SMALLINT 2
190 U_SPARE_8_966 SMALLINT 2
191 U_LOW_DOC_FLG_979 CHARACTER VARYING(1) 1
192 U_FIELD_USD_SUNLOANS1_980 CHARACTER VARYING(1) 1
193 U_FIELD_USD_SUNLOANS2_981 CHARACTER VARYING(1) 1
194 U_ACCEPTABLE_SEC_FLG_982 CHARACTER VARYING(1) 1
195 U_SPARE_25_983 CHARACTER VARYING(1) 1
196 U_SPARE_26_984 CHARACTER VARYING(1) 1
197 U_MX_SEC_LAND_AREA_1009 BIGINT 8
198 U_SPARE_52_1010 BIGINT 8
199 U_SPARE_53_1011 BIGINT 8
200 U_SPARE_54_1012 BIGINT 8
201 U_SPARE_55_1013 NUMERIC(15,2) 19
202 U_SPARE_56_1014 BIGINT 8
203 U_SPARE_57_1015 BIGINT 8
204 U_SPARE_58_1016 BIGINT 8
205 U_LOAN_SUB_PROD_TYPE_1029 CHARACTER VARYING(3) 3
206 U_SPARE_72_1030 CHARACTER VARYING(4) 4
207 U_SPARE_73_1031 CHARACTER VARYING(4) 4
208 U_SPARE_74_1032 CHARACTER VARYING(4) 4
209 U_SPARE_92_1050 CHARACTER VARYING(8) 8
210 U_SPARE_93_1051 CHARACTER VARYING(8) 8
211 U_SPARE_94_1052 CHARACTER VARYING(8) 8
212 U_SPARE_95_1053 CHARACTER VARYING(8) 8
213 U_WITHDRAWN_STATUS CHARACTER VARYING(1) 1
214 U_OVERRIDE_FLG CHARACTER VARYING(1) 1
215 U_OVERRIDE_RSN_CODE CHARACTER VARYING(4) 4
216 U_OVERRIDE_UID CHARACTER VARYING(7) 7
217 U_OVERRIDE_UID_DATE TIMESTAMP 8
218 U_OVERALL_DEC_DATE TIMESTAMP 8
219 U_OVERALL_DEC CHARACTER VARYING(1) 1
220 U_EPMI_FINAL_DEC CHARACTER VARYING(1) 1
221 U_FULFILMENT_FLAG CHARACTER VARYING(1) 1
222 U_APP_DATE TIMESTAMP 8
223 U_FINAL_DECISION CHARACTER VARYING(1) 1
224 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
225 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
226 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
227 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8