WLC_WEM_CRGS_MONTHLY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 WEM_CRGS_MONTHLY_ID BIGINT 8
2 FT_MODEL_ID INTEGER 4
3 SCORECARD CHARACTER VARYING(100) 100
4 GROUP_NO INTEGER 4
5 GROUP_NAME CHARACTER VARYING(300) 300
6 BORROWER_NO CHARACTER VARYING(50) 50
7 BORROWER_NAME CHARACTER VARYING(300) 300
8 BORROWER_BRANCH CHARACTER VARYING(250) 250
9 LEAD_NUMBER CHARACTER VARYING(50) 50
10 LOAN_ACCOUNT_NUMBER CHARACTER VARYING(50) 50
11 DIVISION CHARACTER VARYING(50) 50
12 PURPOSE CHARACTER VARYING(255) 255
13 CORPORATE_FACILITY CHARACTER VARYING(50) 50
14 CROSSCOLLAT CHARACTER VARYING(50) 50
15 USER_ID CHARACTER VARYING(60) 60
16 USER_LOCATION CHARACTER VARYING(100) 100
17 USER_DATE CHARACTER VARYING(20) 20
18 USER_TIMESTAMP CHARACTER VARYING(20) 20
19 ACCOUNT_OVERRIDE_FLAG INTEGER 4
20 ACCOUNT_OVERRIDE_REASON CHARACTER VARYING(100) 100
21 ACCOUNT_OVERRIDE_SOURCE CHARACTER VARYING(100) 100
22 ACCOUNT_OVERRIDE_USERID CHARACTER VARYING(100) 100
23 ACCOUNT_OVERRIDE_CDR CHARACTER VARYING(100) 100
24 ACCOUNT_OVERRIDE_DATE CHARACTER VARYING(100) 100
25 BORROWER_OVERRIDE_FLAG INTEGER 4
26 BORROWER_OVERRIDE_REASON CHARACTER VARYING(100) 100
27 BORROWER_OVERRIDE_SOURCE CHARACTER VARYING(100) 100
28 BORROWER_OVERRIDE_USER_ID CHARACTER VARYING(100) 100
29 BORROWER_OVERRIDE_CDR CHARACTER VARYING(100) 100
30 BORROWER_OVERRIDE_DATE CHARACTER VARYING(100) 100
31 GROUP_OVERRIDE_FLAG INTEGER 4
32 GROUP_OVERRIDE_REASON CHARACTER VARYING(100) 100
33 GROUP_OVERRIDE_SOURCE CHARACTER VARYING(100) 100
34 GROUP_OVERRIDE_USER_ID CHARACTER VARYING(100) 100
35 GROUP_OVERRIDE_CDR CHARACTER VARYING(100) 100
36 GROUP_OVERRIDE_DATE CHARACTER VARYING(100) 100
37 TCE NUMERIC(18,2) 19
38 SSV NUMERIC(18,2) 19
39 CAT_A_SECURITY NUMERIC(18,2) 19
40 CAT_B_SECURITY NUMERIC(18,2) 19
41 TCE_SSV NUMERIC(18,2) 19
42 CRITTOTOVERALL_ACCOUNT_LDR1 CHARACTER VARYING(5) 5
43 CALCSCORE_ACCOUNT_LDR1 CHARACTER VARYING(5) 5
44 CRITTOTOVERALL_ACCOUNT_CR1 CHARACTER VARYING(5) 5
45 CALCSCORE_ACCOUNT_CR1 CHARACTER VARYING(5) 5
46 CRITTOTOVERALL_BORROWER_CDR2 CHARACTER VARYING(5) 5
47 CALCSCORE_BORROWER_CDR2 CHARACTER VARYING(5) 5
48 CRITTOTOVERALL_BORROWER_CR2 CHARACTER VARYING(5) 5
49 CALCSCORE_BORROWER_CR2 CHARACTER VARYING(5) 5
50 CRITTOTOVERALL_GROUP_CDR3 CHARACTER VARYING(5) 5
51 CALCSCORE_GROUP_CDR3 CHARACTER VARYING(5) 5
52 CRITTOTOVERALL_GROUP_CR3 CHARACTER VARYING(5) 5
53 CALCSCORE_GROUP_CR3 CHARACTER VARYING(5) 5
54 RISK_MODEL_CODE INTEGER 4
55 QUESTION_1 CHARACTER VARYING(500) 500
56 QUESTION_1_RAW CHARACTER VARYING(500) 500
57 QUESTION_1_FORMULA CHARACTER VARYING(500) 500
58 QUESTION_1_WEIGHTING CHARACTER VARYING(500) 500
59 QUESTION_1_POINTS CHARACTER VARYING(15) 15
60 QUESTION_2 CHARACTER VARYING(500) 500
61 QUESTION_2_RAW CHARACTER VARYING(500) 500
62 QUESTION_2_FORMULA CHARACTER VARYING(500) 500
63 QUESTION_2_WEIGHTING CHARACTER VARYING(500) 500
64 QUESTION_2_POINTS CHARACTER VARYING(15) 15
65 QUESTION_3 CHARACTER VARYING(500) 500
66 QUESTION_3_RAW CHARACTER VARYING(500) 500
67 QUESTION_3_FORMULA CHARACTER VARYING(500) 500
68 QUESTION_3_WEIGHTING CHARACTER VARYING(500) 500
69 QUESTION_3_POINTS CHARACTER VARYING(15) 15
70 QUESTION_4 CHARACTER VARYING(500) 500
71 QUESTION_4_RAW CHARACTER VARYING(500) 500
72 QUESTION_4_FORMULA CHARACTER VARYING(500) 500
73 QUESTION_4_WEIGHTING CHARACTER VARYING(500) 500
74 QUESTION_4_POINTS CHARACTER VARYING(15) 15
75 QUESTION_5 CHARACTER VARYING(500) 500
76 QUESTION_5_RAW CHARACTER VARYING(500) 500
77 QUESTION_5_FORMULA CHARACTER VARYING(500) 500
78 QUESTION_5_WEIGHTING CHARACTER VARYING(500) 500
79 QUESTION_5_POINTS CHARACTER VARYING(15) 15
80 QUESTION_6 CHARACTER VARYING(500) 500
81 QUESTION_6_RAW CHARACTER VARYING(500) 500
82 QUESTION_6_FORMULA CHARACTER VARYING(500) 500
83 QUESTION_6_WEIGHTING CHARACTER VARYING(500) 500
84 QUESTION_6_POINTS CHARACTER VARYING(15) 15
85 QUESTION_7 CHARACTER VARYING(500) 500
86 QUESTION_7_RAW CHARACTER VARYING(500) 500
87 QUESTION_7_FORMULA CHARACTER VARYING(500) 500
88 QUESTION_7_WEIGHTING CHARACTER VARYING(500) 500
89 QUESTION_7_POINTS CHARACTER VARYING(15) 15
90 QUESTION_8 CHARACTER VARYING(500) 500
91 QUESTION_8_RAW CHARACTER VARYING(500) 500
92 QUESTION_8_FORMULA CHARACTER VARYING(500) 500
93 QUESTION_8_WEIGHTING CHARACTER VARYING(500) 500
94 QUESTION_8_POINTS CHARACTER VARYING(15) 15
95 QUESTION_9 CHARACTER VARYING(500) 500
96 QUESTION_9_RAW CHARACTER VARYING(500) 500
97 QUESTION_9_FORMULA CHARACTER VARYING(500) 500
98 QUESTION_9_WEIGHTING CHARACTER VARYING(500) 500
99 QUESTION_9_POINTS CHARACTER VARYING(15) 15
100 QUESTION_10 CHARACTER VARYING(500) 500
101 QUESTION_10_RAW CHARACTER VARYING(500) 500
102 QUESTION_10_FORMULA CHARACTER VARYING(500) 500
103 QUESTION_10_WEIGHTING CHARACTER VARYING(500) 500
104 QUESTION_10_POINTS CHARACTER VARYING(15) 15
105 QUESTION_11 CHARACTER VARYING(500) 500
106 QUESTION_11_RAW CHARACTER VARYING(500) 500
107 QUESTION_11_FORMULA CHARACTER VARYING(500) 500
108 QUESTION_11_WEIGHTING CHARACTER VARYING(500) 500
109 QUESTION_11_POINTS CHARACTER VARYING(15) 15
110 QUESTION_12 CHARACTER VARYING(500) 500
111 QUESTION_12_RAW CHARACTER VARYING(500) 500
112 QUESTION_12_FORMULA CHARACTER VARYING(500) 500
113 QUESTION_12_WEIGHTING CHARACTER VARYING(500) 500
114 QUESTION_12_POINTS CHARACTER VARYING(15) 15
115 QUESTION_13 CHARACTER VARYING(500) 500
116 QUESTION_13_RAW CHARACTER VARYING(500) 500
117 QUESTION_13_FORMULA CHARACTER VARYING(500) 500
118 QUESTION_13_WEIGHTING CHARACTER VARYING(500) 500
119 QUESTION_13_POINTS CHARACTER VARYING(15) 15
120 QUESTION_14 CHARACTER VARYING(500) 500
121 QUESTION_14_RAW CHARACTER VARYING(500) 500
122 QUESTION_14_FORMULA CHARACTER VARYING(500) 500
123 QUESTION_14_WEIGHTING CHARACTER VARYING(500) 500
124 QUESTION_14_POINTS CHARACTER VARYING(15) 15
125 QUESTION_15 CHARACTER VARYING(500) 500
126 QUESTION_15_RAW CHARACTER VARYING(500) 500
127 QUESTION_15_FORMULA CHARACTER VARYING(500) 500
128 QUESTION_15_WEIGHTING CHARACTER VARYING(500) 500
129 QUESTION_15_POINTS CHARACTER VARYING(15) 15
130 QUESTION_16 CHARACTER VARYING(500) 500
131 QUESTION_16_RAW CHARACTER VARYING(500) 500
132 QUESTION_16_FORMULA CHARACTER VARYING(500) 500
133 QUESTION_16_WEIGHTING CHARACTER VARYING(500) 500
134 QUESTION_16_POINTS CHARACTER VARYING(15) 15
135 QUESTION_17 CHARACTER VARYING(500) 500
136 QUESTION_17_RAW CHARACTER VARYING(500) 500
137 QUESTION_17_FORMULA CHARACTER VARYING(500) 500
138 QUESTION_17_WEIGHTING CHARACTER VARYING(500) 500
139 QUESTION_17_POINTS CHARACTER VARYING(15) 15
140 QUESTION_18 CHARACTER VARYING(500) 500
141 QUESTION_18_RAW CHARACTER VARYING(500) 500
142 QUESTION_18_FORMULA CHARACTER VARYING(500) 500
143 QUESTION_18_WEIGHTING CHARACTER VARYING(500) 500
144 QUESTION_18_POINTS CHARACTER VARYING(15) 15
145 QUESTION_19 CHARACTER VARYING(500) 500
146 QUESTION_19_RAW CHARACTER VARYING(500) 500
147 QUESTION_19_FORMULA CHARACTER VARYING(500) 500
148 QUESTION_19_WEIGHTING CHARACTER VARYING(500) 500
149 QUESTION_19_POINTS CHARACTER VARYING(15) 15
150 QUESTION_20 CHARACTER VARYING(500) 500
151 QUESTION_20_RAW CHARACTER VARYING(500) 500
152 QUESTION_20_FORMULA CHARACTER VARYING(500) 500
153 QUESTION_20_WEIGHTING CHARACTER VARYING(500) 500
154 QUESTION_20_POINTS CHARACTER VARYING(15) 15
155 QUESTION_21 CHARACTER VARYING(500) 500
156 QUESTION_21_RAW CHARACTER VARYING(500) 500
157 QUESTION_21_FORMULA CHARACTER VARYING(500) 500
158 QUESTION_21_WEIGHTING CHARACTER VARYING(500) 500
159 QUESTION_21_POINTS CHARACTER VARYING(15) 15
160 QUESTION_22 CHARACTER VARYING(500) 500
161 QUESTION_22_RAW CHARACTER VARYING(500) 500
162 QUESTION_22_FORMULA CHARACTER VARYING(500) 500
163 QUESTION_22_WEIGHTING CHARACTER VARYING(500) 500
164 QUESTION_22_POINTS CHARACTER VARYING(15) 15
165 QUESTION_23 CHARACTER VARYING(500) 500
166 QUESTION_23_RAW CHARACTER VARYING(500) 500
167 QUESTION_23_FORMULA CHARACTER VARYING(500) 500
168 QUESTION_23_WEIGHTING CHARACTER VARYING(500) 500
169 QUESTION_23_POINTS CHARACTER VARYING(15) 15
170 QUESTION_24 CHARACTER VARYING(500) 500
171 QUESTION_24_RAW CHARACTER VARYING(500) 500
172 QUESTION_24_FORMULA CHARACTER VARYING(500) 500
173 QUESTION_24_WEIGHTING CHARACTER VARYING(500) 500
174 QUESTION_24_POINTS CHARACTER VARYING(15) 15
175 QUESTION_25 CHARACTER VARYING(500) 500
176 QUESTION_25_RAW CHARACTER VARYING(500) 500
177 QUESTION_25_FORMULA CHARACTER VARYING(500) 500
178 QUESTION_25_WEIGHTING CHARACTER VARYING(500) 500
179 QUESTION_25_POINTS CHARACTER VARYING(15) 15
180 Question_26 CHARACTER VARYING(500) 500
181 Question_26_RAW CHARACTER VARYING(500) 500
182 Question_26_Formula CHARACTER VARYING(500) 500
183 Question_26_Weighting CHARACTER VARYING(500) 500
184 Question_26_Points CHARACTER VARYING(15) 15
185 Question_27 CHARACTER VARYING(500) 500
186 Question_27_RAW CHARACTER VARYING(500) 500
187 Question_27_Formula CHARACTER VARYING(500) 500
188 Question_27_Weighting CHARACTER VARYING(500) 500
189 Question_27_Points CHARACTER VARYING(15) 15
190 Question_28 CHARACTER VARYING(500) 500
191 Question_28_RAW CHARACTER VARYING(500) 500
192 Question_28_Formula CHARACTER VARYING(500) 500
193 Question_28_Weighting CHARACTER VARYING(500) 500
194 Question_28_Points CHARACTER VARYING(15) 15
195 Question_29 CHARACTER VARYING(500) 500
196 Question_29_SICR CHARACTER VARYING(500) 500
197 Question_29_HistoricalCADesc CHARACTER VARYING(500) 500
198 Question_29_HistoricalTTCPD CHARACTER VARYING(500) 500
199 Question_29_Points CHARACTER VARYING(15) 15
200 TOTAL_SCORE NUMERIC(24,10) 19
201 REVIEWDATE TIMESTAMP 8
202 REVIEWDATE_CHECK INTEGER 4
203 DEFAULT_60D INTEGER 4
204 DEFAULT_90D INTEGER 4
205 PROVISION_ESTABLISHED INTEGER 4
206 WRITTEN_OFF INTEGER 4
207 NONRISKGRADED INTEGER 4
208 FINUPTODATE INTEGER 4
209 CREDITACTIONANZSIC CHARACTER VARYING(50) 50
210 CREDITACTIONCREATIONDATE TIMESTAMP 8
211 CREDITACTIONMODEL CHARACTER VARYING(40) 40
212 CREDITACTIONDESCRIPTION CHARACTER VARYING(40) 40
213 LASTSCOREDDATE TIMESTAMP 8
214 BANKDECISIONDATE TIMESTAMP 8
215 CLIENTADVISEDDATE TIMESTAMP 8
216 CLIENTACCEPTEDDATE TIMESTAMP 8
217 COMPLETEDAPPROVEDDATE TIMESTAMP 8
218 DCAOVERRIDE INTEGER 4
219 DCAOVERRIDESTMP TIMESTAMP 8
220 DCAOVERRIDEUSER CHARACTER VARYING(60) 60
221 SCOREBSDATEID INTEGER 4
222 SCOREBSDATEYN CHARACTER VARYING(15) 15
223 SCOREBSDATE TIMESTAMP 8
224 SCOREBSSCENARIO CHARACTER VARYING(50) 50
225 SCOREIEDATEID INTEGER 4
226 SCOREIEDATEYN CHARACTER VARYING(15) 15
227 SCOREIEDATE TIMESTAMP 8
228 SCOREIESCENARIO CHARACTER VARYING(50) 50
229 SCOREDEBTCOVACTUALIEDATEID INTEGER 4
230 SCOREDEBTCOVACTUALIEDATEYN CHARACTER VARYING(15) 15
231 SCOREDEBTCOVACTUALIEDATE TIMESTAMP 8
232 SCOREDEBTCOVACTUALIEDATESCENARIO CHARACTER VARYING(50) 50
233 SCOREDEBTCOVPROJIEDATEID INTEGER 4
234 SCOREDEBTCOVPROJIEDATEYN CHARACTER VARYING(15) 15
235 SCOREDEBTCOVPROJIEDATE TIMESTAMP 8
236 SCOREDEBTCOVPROJIEDATESCENARIO CHARACTER VARYING(50) 50
237 SCOREWCTOSALESIEDATEID INTEGER 4
238 SCOREWCTOSALESIEDATEYN CHARACTER VARYING(15) 15
239 SCOREWCTOSALESIEDATE TIMESTAMP 8
240 SCOREWCTOSALESIEDATESCENARIO CHARACTER VARYING(50) 50
241 SCEPCID INTEGER 4
242 SCEPCYN CHARACTER VARYING(15) 15
243 SCBSEPCDATE TIMESTAMP 8
244 SCBSEPCDATESCENARIO CHARACTER VARYING(30) 30
245 SCDSCRSAPPIACID INTEGER 4
246 SCDSCRSAPPIACYN CHARACTER VARYING(15) 15
247 SCCFIEDATESAPPIAC TIMESTAMP 8
248 SCCFIESAPPIDATEACSCENARIO CHARACTER VARYING(30) 30
249 SCICRACID INTEGER 4
250 SCICRACYN CHARACTER VARYING(15) 15
251 SCCFIEDATEICRAC TIMESTAMP 8
252 SCCFIEICRACDATESCENARIO CHARACTER VARYING(30) 30
253 SCDSCRSAPPIPRID INTEGER 4
254 SCDSCRSAPPIPRYN CHARACTER VARYING(15) 15
255 SCCFIESAPPIDATEPR TIMESTAMP 8
256 SCCFIESAPPIDATEPRSCENARIO CHARACTER VARYING(30) 30
257 FINANCIAL_SELECTION_INCOMPLETE_FLAG INTEGER 4
258 ANZSICREGION CHARACTER VARYING(10) 10
259 CREDITACTIONANZSICSCORE CHARACTER VARYING(500) 500
260 CREDITACTIONANZSICWEIGHT CHARACTER VARYING(500) 500
261 SCPREVIEID INTEGER 4
262 SCPREVIE TIMESTAMP 8
263 SCPREVIESCENARIO CHARACTER VARYING(30) 30
264 SCPREVIEYN CHARACTER VARYING(15) 15
265 DATA_DATE TIMESTAMP 8
266 LOAD_ID INTEGER 4
267 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
268 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
269 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
270 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8