FCT_BNK_CRHDS_EXPR_BASEL_SCORE_SEC_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian Credit Decision Secured BASEL with multiple risk scores for secured loans

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 CHARACTER VARYING(10) 10
5 S_RISK_SCORE_SCORECD_NAME CHARACTER VARYING(20) 20
6 S_RISK_SCORE_INDEX CHARACTER VARYING(10) 10
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 CHARACTER VARYING(10) 10
13 S_CRGS_SCORE_SCORECD_N CHARACTER VARYING(20) 20
14 S_CRGS_SCORE_INDEX CHARACTER VARYING(10) 10
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 CHARACTER VARYING(10) 10
21 S_SCORE_SPARE_1_SCORECD_N CHARACTER VARYING(20) 20
22 S_SCORE_SPARE_1_INDEX CHARACTER VARYING(10) 10
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 CHARACTER VARYING(10) 10
29 S_SCORE_SPARE_2_SCORECD_N CHARACTER VARYING(20) 20
30 S_SCORE_SPARE_2_INDEX CHARACTER VARYING(10) 10
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 CHARACTER VARYING(10) 10
35 S_RISK_GRADE_F_A_R_GR_RS CHARACTER VARYING(10) 10
36 S_CRGS_SCORE_CRGS_SC_RS CHARACTER VARYING(10) 10
37 S_CRGS_GRADE_F_CRGS_GR_RS CHARACTER VARYING(10) 10
38 S_SCORE_SPARE1_SC1_RS CHARACTER VARYING(10) 10
39 S_GRADE_SPARE1_F_GR1_RS CHARACTER VARYING(10) 10
40 S_SCORE_SPARE2_SC2_RS CHARACTER VARYING(10) 10
41 S_GRADE_SPARE2_F_GR2_RS CHARACTER VARYING(10) 10
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 CHARACTER VARYING(10) 10
73 S_RISK_GRADE_F_A_R_GR_RB CHARACTER VARYING(10) 10
74 S_CRGS_SCORE_CRGS_SC_RB CHARACTER VARYING(10) 10
75 S_CRGS_GRADE_F_CRGS_GR_RB CHARACTER VARYING(10) 10
76 S_SCORE_SPARE1_SC1_RB CHARACTER VARYING(10) 10
77 S_GRADE_SPARE1_F_GR1_RB CHARACTER VARYING(10) 10
78 S_SCORE_SPARE2_SC2_RB CHARACTER VARYING(10) 10
79 S_GRADE_SPARE2_F_GR2_RB CHARACTER VARYING(10) 10