OBP24_HST_CZ_SC_OR_EXPR_RSLT_BASL_SCOR

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_RISK_SCORE_ON CHARACTER VARYING(20) 20
3 S_RISK_SCORE_TGN CHARACTER VARYING(10) 10
4 S_RISK_SCORE_SCORECD_ID INTEGER 4
5 S_RISK_SCORE_SCORECD_NAME CHARACTER VARYING(20) 20
6 S_RISK_SCORE_INDEX SMALLINT 2
7 S_RISK_GRADE_ON CHARACTER VARYING(20) 20
8 S_RISK_GRADE_TGN CHARACTER VARYING(10) 10
9 S_RISK_GRADE_TEN CHARACTER VARYING(20) 20
10 S_CRGS_SCORE_ON CHARACTER VARYING(20) 20
11 S_CRGS_SCORE_TGN CHARACTER VARYING(10) 10
12 S_CRGS_SCORE_SCORECD_ID INTEGER 4
13 S_CRGS_SCORE_SCORECD_N CHARACTER VARYING(20) 20
14 S_CRGS_SCORE_INDEX SMALLINT 2
15 S_CRGS_GRADE_ON CHARACTER VARYING(20) 20
16 S_CRGS_GRADE_TGN CHARACTER VARYING(10) 10
17 S_CRGS_GRADE_TEN CHARACTER VARYING(20) 20
18 S_SCORE_SPARE_1_ON CHARACTER VARYING(20) 20
19 S_SCORE_SPARE_1_TGN CHARACTER VARYING(10) 10
20 S_SCORE_SPARE_1_SCORECDID INTEGER 4
21 S_SCORE_SPARE_1_SCORECD_N CHARACTER VARYING(20) 20
22 S_SCORE_SPARE_1_INDEX SMALLINT 2
23 S_GRADE_SPARE_1_ON CHARACTER VARYING(20) 20
24 S_GRADE_SPARE_1_TGN CHARACTER VARYING(10) 10
25 S_GRADE_SPARE_1_TEN CHARACTER VARYING(20) 20
26 S_SCORE_SPARE_2_ON CHARACTER VARYING(20) 20
27 S_SCORE_SPARE_2_TGN CHARACTER VARYING(10) 10
28 S_SCORE_SPARE_2_SCORECDID INTEGER 4
29 S_SCORE_SPARE_2_SCORECD_N CHARACTER VARYING(20) 20
30 S_SCORE_SPARE_2_INDEX SMALLINT 2
31 S_GRADE_SPARE_2_ON CHARACTER VARYING(20) 20
32 S_GRADE_SPARE_2_TGN CHARACTER VARYING(10) 10
33 S_GRADE_SPARE_2_TEN CHARACTER VARYING(20) 20
34 S_RISK_SCORE_APP_SC_RS INTEGER 4
35 S_RISK_GRADE_F_A_R_GR_RS SMALLINT 2
36 S_CRGS_SCORE_CRGS_SC_RS INTEGER 4
37 S_CRGS_GRADE_F_CRGS_GR_RS SMALLINT 2
38 S_SCORE_SPARE1_SC1_RS INTEGER 4
39 S_GRADE_SPARE1_F_GR1_RS SMALLINT 2
40 S_SCORE_SPARE2_SC2_RS INTEGER 4
41 S_GRADE_SPARE2_F_GR2_RS SMALLINT 2
42 S_IN_DEFAULT_FLAG_ON CHARACTER VARYING(20) 20
43 S_IN_DEFAULT_FLAG_TGN CHARACTER VARYING(10) 10
44 S_IN_DEFAULT_FLAG_TEN CHARACTER VARYING(20) 20
45 S_PD_ON CHARACTER VARYING(20) 20
46 S_PD_TGN CHARACTER VARYING(10) 10
47 S_PD_TEN CHARACTER VARYING(20) 20
48 S_RISK_POOL_SETTING_ON CHARACTER VARYING(20) 20
49 S_RISK_POOL_SETTING_TGN CHARACTER VARYING(10) 10
50 S_RISK_POOL_SETTING_TEN CHARACTER VARYING(20) 20
51 S_CCF_DD_ON CHARACTER VARYING(20) 20
52 S_CCF_DD_TGN CHARACTER VARYING(10) 10
53 S_EAD_O_N CHARACTER VARYING(20) 20
54 S_EAD_TGN CHARACTER VARYING(10) 10
55 S_EAD_TEN CHARACTER VARYING(20) 20
56 S_LGD_ON CHARACTER VARYING(20) 20
57 S_LGD_TGN CHARACTER VARYING(10) 10
58 S_LGD_TEN CHARACTER VARYING(20) 20
59 S_LGD_RISK_GRADE_ON CHARACTER VARYING(20) 20
60 S_LGD_RISK_GRADE_TGN CHARACTER VARYING(10) 10
61 S_LGD_RISK_GRADE_TEN CHARACTER VARYING(20) 20
62 S_EL_DD_ON CHARACTER VARYING(20) 20
63 S_EL_DD_TGN CHARACTER VARYING(10) 10
64 S_EL_RISK_GRADE_ON CHARACTER VARYING(20) 20
65 S_EL_RISK_GRADE_TGN CHARACTER VARYING(10) 10
66 S_EL_RISK_GRADE_TEN CHARACTER VARYING(20) 20
67 S_RWA_ON CHARACTER VARYING(20) 20
68 S_RWA_TGN CHARACTER VARYING(10) 10
69 S_SPARE_RISK_POOL_ON CHARACTER VARYING(20) 20
70 S_SPARE_RISK_POOL_TGN CHARACTER VARYING(10) 10
71 S_SPARE_RISK_POOL_TEN CHARACTER VARYING(20) 20
72 S_RISK_SCORE_APP_SC_RB INTEGER 4
73 S_RISK_GRADE_F_A_R_GR_RB SMALLINT 2
74 S_CRGS_SCORE_CRGS_SC_RB INTEGER 4
75 S_CRGS_GRADE_F_CRGS_GR_RB SMALLINT 2
76 S_SCORE_SPARE1_SC1_RB INTEGER 4
77 S_GRADE_SPARE1_F_GR1_RB SMALLINT 2
78 S_SCORE_SPARE2_SC2_RB INTEGER 4
79 S_GRADE_SPARE2_F_GR2_RB SMALLINT 2
80 U_RISK_SCORE_ON CHARACTER VARYING(20) 20
81 U_RISK_SCORE_TGN CHARACTER VARYING(10) 10
82 U_RISK_SCORE_SCORECD_ID INTEGER 4
83 U_RISK_SCORE_SCORECD_NAME CHARACTER VARYING(20) 20
84 U_RISK_SCORE_INDEX SMALLINT 2
85 U_RISK_GRADE_ON CHARACTER VARYING(20) 20
86 U_RISK_GRADE_TGN CHARACTER VARYING(10) 10
87 U_RISK_GRADE_TEN CHARACTER VARYING(20) 20
88 U_CRGS_SCORE_ON CHARACTER VARYING(20) 20
89 U_CRGS_SCORE_TGN CHARACTER VARYING(10) 10
90 U_CRGS_SCORE_SCORECD_ID INTEGER 4
91 U_CRGS_SCORE_SCORECD_N CHARACTER VARYING(20) 20
92 U_CRGS_SCORE_INDEX SMALLINT 2
93 U_CRGS_GRADE_ON CHARACTER VARYING(20) 20
94 U_CRGS_GRADE_TGN CHARACTER VARYING(10) 10
95 U_CRGS_GRADE_TEN CHARACTER VARYING(20) 20
96 U_SCORE_SPARE_1_ON CHARACTER VARYING(20) 20
97 U_SCORE_SPARE_1_TGN CHARACTER VARYING(10) 10
98 U_SCORE_SPARE_1_SCORECDID INTEGER 4
99 U_SCORE_SPARE_1_SCORECD_N CHARACTER VARYING(20) 20
100 U_SCORE_SPARE_1_INDEX SMALLINT 2
101 U_GRADE_SPARE_1_ON CHARACTER VARYING(20) 20
102 U_GRADE_SPARE_1_TGN CHARACTER VARYING(10) 10
103 U_GRADE_SPARE_1_TEN CHARACTER VARYING(20) 20
104 U_SCORE_SPARE_2_ON CHARACTER VARYING(20) 20
105 U_SCORE_SPARE_2_TGN CHARACTER VARYING(10) 10
106 U_SCORE_SPARE_2_SCORECDID INTEGER 4
107 U_SCORE_SPARE_2_SCORECD_N CHARACTER VARYING(20) 20
108 U_SCORE_SPARE_2_INDEX SMALLINT 2
109 U_GRADE_SPARE_2_ON CHARACTER VARYING(20) 20
110 U_GRADE_SPARE_2_TGN CHARACTER VARYING(10) 10
111 U_GRADE_SPARE_2_TEN CHARACTER VARYING(20) 20
112 U_RISK_SCORE_APP_SC_RS INTEGER 4
113 U_RISK_GRADE_F_A_R_GR_RS SMALLINT 2
114 U_CRGS_SCORE_CRGS_SC_RS INTEGER 4
115 U_CRGS_GRADE_F_CRGS_GR_RS SMALLINT 2
116 U_SCORE_SPARE1_SCORE1_RS INTEGER 4
117 U_GRADE_SPARE1_F_GR1_RS SMALLINT 2
118 U_SCORE_SPARE2_SCORE2_RS INTEGER 4
119 U_GRADE_SPARE2_F_GR2_RS SMALLINT 2
120 U_IN_DEFAULT_FLAG_ON CHARACTER VARYING(20) 20
121 U_IN_DEFAULT_FLAG_TGN CHARACTER VARYING(10) 10
122 U_IN_DEFAULT_FLAG_TEN CHARACTER VARYING(20) 20
123 U_PD_ON CHARACTER VARYING(20) 20
124 U_PD_TGN CHARACTER VARYING(10) 10
125 U_PD_TEN CHARACTER VARYING(20) 20
126 U_RISK_POOL_SETTING_ON CHARACTER VARYING(20) 20
127 U_RISK_POOL_SETTING_TGN CHARACTER VARYING(10) 10
128 U_RISK_POOL_SETTING_TEN CHARACTER VARYING(20) 20
129 U_CCF_DD_ON CHARACTER VARYING(20) 20
130 U_CCF_DD_TGN CHARACTER VARYING(10) 10
131 U_EAD_O_N CHARACTER VARYING(20) 20
132 U_EAD_TGN CHARACTER VARYING(10) 10
133 U_EAD_TEN CHARACTER VARYING(20) 20
134 U_LGD_ON CHARACTER VARYING(20) 20
135 U_LGD_TGN CHARACTER VARYING(10) 10
136 U_LGD_TEN CHARACTER VARYING(20) 20
137 U_LGD_RISK_GRADE_ON CHARACTER VARYING(20) 20
138 U_LGD_RISK_GRADE_TGN CHARACTER VARYING(10) 10
139 U_LGD_RISK_GRADE_TEN CHARACTER VARYING(20) 20
140 U_EL_DD_ON CHARACTER VARYING(20) 20
141 U_EL_DD_TGN CHARACTER VARYING(10) 10
142 U_EL_RISK_GRADE_ON CHARACTER VARYING(20) 20
143 U_EL_RISK_GRADE_TGN CHARACTER VARYING(10) 10
144 U_EL_RISK_GRADE_TEN CHARACTER VARYING(20) 20
145 U_RWA_ON CHARACTER VARYING(20) 20
146 U_RWA_TGN CHARACTER VARYING(10) 10
147 U_SPARE_RISK_POOL_ON CHARACTER VARYING(20) 20
148 U_SPARE_RISK_POOL_TGN CHARACTER VARYING(10) 10
149 U_SPARE_RISK_POOL_TEN CHARACTER VARYING(20) 20
150 U_RISK_SCORE_APP_SC_RB INTEGER 4
151 U_RISK_GRADE_F_A_R_GR_RB SMALLINT 2
152 U_CRGS_SCORE_CRGS_SC_RB INTEGER 4
153 U_CRGS_GRADE_F_CRGS_GR_RB SMALLINT 2
154 U_SCORE_SPARE1_SCORE1_RB INTEGER 4
155 U_GRADE_SPARE1_F_GR1_RB SMALLINT 2
156 U_SCORE_SPARE2_SCORE2_RB INTEGER 4
157 U_GRADE_SPARE2_F_GR2_RB SMALLINT 2
158 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
159 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
160 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
161 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8