FCT_BNK_CRHDS_EXPR_BASEL_SCORE_UNSEC_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian Credit Decision Unsecured BASEL with multiple risk scores for unsecured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 U_RISK_SCORE_ON CHARACTER VARYING(20) 20
3 U_RISK_SCORE_TGN CHARACTER VARYING(10) 10
4 U_RISK_SCORE_SCORECD_ID CHARACTER VARYING(10) 10
5 U_RISK_SCORE_SCORECD_NAME CHARACTER VARYING(20) 20
6 U_RISK_SCORE_INDEX CHARACTER VARYING(10) 10
7 U_RISK_GRADE_ON CHARACTER VARYING(20) 20
8 U_RISK_GRADE_TGN CHARACTER VARYING(10) 10
9 U_RISK_GRADE_TEN CHARACTER VARYING(20) 20
10 U_CRGS_SCORE_ON CHARACTER VARYING(20) 20
11 U_CRGS_SCORE_TGN CHARACTER VARYING(10) 10
12 U_CRGS_SCORE_SCORECD_ID CHARACTER VARYING(10) 10
13 U_CRGS_SCORE_SCORECD_N CHARACTER VARYING(20) 20
14 U_CRGS_SCORE_INDEX CHARACTER VARYING(10) 10
15 U_CRGS_GRADE_ON CHARACTER VARYING(20) 20
16 U_CRGS_GRADE_TGN CHARACTER VARYING(10) 10
17 U_CRGS_GRADE_TEN CHARACTER VARYING(20) 20
18 U_SCORE_SPARE_1_ON CHARACTER VARYING(20) 20
19 U_SCORE_SPARE_1_TGN CHARACTER VARYING(10) 10
20 U_SCORE_SPARE_1_SCORECDID CHARACTER VARYING(10) 10
21 U_SCORE_SPARE_1_SCORECD_N CHARACTER VARYING(20) 20
22 U_SCORE_SPARE_1_INDEX CHARACTER VARYING(10) 10
23 U_GRADE_SPARE_1_ON CHARACTER VARYING(20) 20
24 U_GRADE_SPARE_1_TGN CHARACTER VARYING(10) 10
25 U_GRADE_SPARE_1_TEN CHARACTER VARYING(20) 20
26 U_SCORE_SPARE_2_ON CHARACTER VARYING(20) 20
27 U_SCORE_SPARE_2_TGN CHARACTER VARYING(10) 10
28 U_SCORE_SPARE_2_SCORECDID CHARACTER VARYING(10) 10
29 U_SCORE_SPARE_2_SCORECD_N CHARACTER VARYING(20) 20
30 U_SCORE_SPARE_2_INDEX CHARACTER VARYING(10) 10
31 U_GRADE_SPARE_2_ON CHARACTER VARYING(20) 20
32 U_GRADE_SPARE_2_TGN CHARACTER VARYING(10) 10
33 U_GRADE_SPARE_2_TEN CHARACTER VARYING(20) 20
34 U_RISK_SCORE_APP_SC_RS INTEGER 4
35 U_RISK_GRADE_F_A_R_GR_RS CHARACTER VARYING(10) 10
36 U_CRGS_SCORE_CRGS_SC_RS CHARACTER VARYING(10) 10
37 U_CRGS_GRADE_F_CRGS_GR_RS CHARACTER VARYING(10) 10
38 U_SCORE_SPARE1_SCORE1_RS CHARACTER VARYING(10) 10
39 U_GRADE_SPARE1_F_GR1_RS CHARACTER VARYING(10) 10
40 U_SCORE_SPARE2_SCORE2_RS CHARACTER VARYING(10) 10
41 U_GRADE_SPARE2_F_GR2_RS CHARACTER VARYING(10) 10
42 U_IN_DEFAULT_FLAG_ON CHARACTER VARYING(20) 20
43 U_IN_DEFAULT_FLAG_TGN CHARACTER VARYING(10) 10
44 U_IN_DEFAULT_FLAG_TEN CHARACTER VARYING(20) 20
45 U_PD_ON CHARACTER VARYING(20) 20
46 U_PD_TGN CHARACTER VARYING(10) 10
47 U_PD_TEN CHARACTER VARYING(20) 20
48 U_RISK_POOL_SETTING_ON CHARACTER VARYING(20) 20
49 U_RISK_POOL_SETTING_TGN CHARACTER VARYING(10) 10
50 U_RISK_POOL_SETTING_TEN CHARACTER VARYING(20) 20
51 U_CCF_DD_ON CHARACTER VARYING(20) 20
52 U_CCF_DD_TGN CHARACTER VARYING(10) 10
53 U_EAD_O_N CHARACTER VARYING(20) 20
54 U_EAD_TGN CHARACTER VARYING(10) 10
55 U_EAD_TEN CHARACTER VARYING(20) 20
56 U_LGD_ON CHARACTER VARYING(20) 20
57 U_LGD_TGN CHARACTER VARYING(10) 10
58 U_LGD_TEN CHARACTER VARYING(20) 20
59 U_LGD_RISK_GRADE_ON CHARACTER VARYING(20) 20
60 U_LGD_RISK_GRADE_TGN CHARACTER VARYING(10) 10
61 U_LGD_RISK_GRADE_TEN CHARACTER VARYING(20) 20
62 U_EL_DD_ON CHARACTER VARYING(20) 20
63 U_EL_DD_TGN CHARACTER VARYING(10) 10
64 U_EL_RISK_GRADE_ON CHARACTER VARYING(20) 20
65 U_EL_RISK_GRADE_TGN CHARACTER VARYING(10) 10
66 U_EL_RISK_GRADE_TEN CHARACTER VARYING(20) 20
67 U_RWA_ON CHARACTER VARYING(20) 20
68 U_RWA_TGN CHARACTER VARYING(10) 10
69 U_SPARE_RISK_POOL_ON CHARACTER VARYING(20) 20
70 U_SPARE_RISK_POOL_TGN CHARACTER VARYING(10) 10
71 U_SPARE_RISK_POOL_TEN CHARACTER VARYING(20) 20
72 U_RISK_SCORE_APP_SC_RB CHARACTER VARYING(10) 10
73 U_RISK_GRADE_F_A_R_GR_RB CHARACTER VARYING(10) 10
74 U_CRGS_SCORE_CRGS_SC_RB CHARACTER VARYING(10) 10
75 U_CRGS_GRADE_F_CRGS_GR_RB CHARACTER VARYING(10) 10
76 U_SCORE_SPARE1_SCORE1_RB CHARACTER VARYING(10) 10
77 U_GRADE_SPARE1_F_GR1_RB CHARACTER VARYING(10) 10
78 U_SCORE_SPARE2_SCORE2_RB CHARACTER VARYING(10) 10
79 U_GRADE_SPARE2_F_GR2_RB CHARACTER VARYING(10) 10