FCT_BNK_CRHDS_EXPR_BUREAU_UNSEC_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian Credit Bureau loan evaluation data with payment history defaults and legal history for unsecured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 U_CRAA_ENQ_PERF_FLG_106 CHARACTER VARYING(1) 1
3 U_MOST_INFO_ENQ_PERF_107 CHARACTER VARYING(8) 8
4 U_TOT_STRONG_MATCHES_108 CHARACTER VARYING(10) 10
5 U_TOT_NUM_NO_MATCHES_109 CHARACTER VARYING(10) 10
6 U_TOT_POSS_MATCHES_110 CHARACTER VARYING(10) 10
7 U_TOT_CROSSREFERENCES_111 CHARACTER VARYING(10) 10
8 U_FILE_NOTES_FLG_112 CHARACTER VARYING(1) 1
9 U_CURR_BNKRPT_FLG_113 CHARACTER VARYING(1) 1
10 U_MX_NUM_JUDGEMENTS_116 CHARACTER VARYING(10) 10
11 U_MX_WRITS_SUMMONSES_117 CHARACTER VARYING(10) 10
12 U_MX_NUM_OF_DEFS_122 CHARACTER VARYING(10) 10
13 U_MX_NUM_DEFS_L24M_124 CHARACTER VARYING(10) 10
14 U_MX_NUM_PAID_DEFS_126 CHARACTER VARYING(10) 10
15 U_MX_PAID_DEFS_L24M_128 CHARACTER VARYING(10) 10
16 U_MX_NUM_UNPAID_DEFS_130 CHARACTER VARYING(10) 10
17 U_MX_UNPAID_DEFS_L24M_132 CHARACTER VARYING(10) 10
18 U_MX_NUM_NUTIL_DEFS_134 CHARACTER VARYING(10) 10
19 U_MX_NUTL_DFS_L24M_136 CHARACTER VARYING(10) 10
20 U_MX_NUTL_UPD_DFS_137 CHARACTER VARYING(10) 10
21 U_MX_NUTL_UP_DFS_L24M_138 CHARACTER VARYING(10) 10
22 U_MX_VAL_UNPD_DEFS_143 CHARACTER VARYING(10) 10
23 U_MX_VAL_NUTL_UPD_DFS_147 CHARACTER VARYING(10) 10
24 U_MN_CONS_NUTL_EN_L3M_153 CHARACTER VARYING(10) 10
25 U_MX_CONS_NUTL_EN_L3M_154 CHARACTER VARYING(10) 10
26 U_MN_CONS_NUTL_EN_L6M_155 CHARACTER VARYING(10) 10
27 U_MX_CONS_NUTL_EN_L6M_156 CHARACTER VARYING(10) 10
28 U_MN_CONS_NUTL_E_L12M_157 CHARACTER VARYING(10) 10
29 U_MX_CONS_NUTL_E_L12M_158 CHARACTER VARYING(10) 10
30 U_MX_SAME_PROD_EN_L3M_164 CHARACTER VARYING(10) 10
31 U_SPARE_101_165 CHARACTER VARYING(10) 10
32 U_MX_SAME_PROD_E_L12M_166 CHARACTER VARYING(10) 10
33 U_MN_T_CRAA_FILE_OMMM_167 CHARACTER VARYING(10) 10
34 U_MN_T_BNKRPT_DIS_MMM_168 CHARACTER VARYING(10) 10
35 U_MN_T_LST_DEF_MMM_169 CHARACTER VARYING(10) 10
36 U_MN_T_LSTCONS_NUTL_E_171 CHARACTER VARYING(10) 10
37 U_MN_T_LST_CONS_UTL_E_172 CHARACTER VARYING(10) 10
38 U_MN_T_LST_SAMEPRD_EN_173 CHARACTER VARYING(10) 10
39 U_MX_CURR_DIRECTRSHPS_174 CHARACTER VARYING(10) 10
40 U_DISQUAL_DIR_FLG_175 CHARACTER VARYING(1) 1
41 U_WORST_AREA_RISK_IND_180 CHARACTER VARYING(10) 10
42 U_BEST_AREA_RISK_IND_181 CHARACTER VARYING(10) 10
43 U_VERICHK_SUITE_R_FLG_187 CHARACTER VARYING(1) 1
44 U_VERICHK_RESULT_IND_188 CHARACTER VARYING(2) 2
45 U_VERICHK_ADDRESS_IND_189 CHARACTER VARYING(1) 1
46 U_VERICHK_ER_IND_CURR_190 CHARACTER VARYING(1) 1
47 U_VERICHK_DRIVS_L_IND_191 CHARACTER VARYING(1) 1
48 U_FRAUD_PHONE_192 CHARACTER VARYING(1) 1
49 U_FRAUD_2ND_PHONE_193 CHARACTER VARYING(1) 1
50 U_FRAUD_EMPLOYER_PH_194 CHARACTER VARYING(1) 1
51 U_FRAUD_GUARANTOR_PH_195 CHARACTER VARYING(1) 1
52 U_FRAUD_REFEREE_PHONE_196 CHARACTER VARYING(1) 1
53 U_FRAUD_ADDRESS_197 CHARACTER VARYING(1) 1
54 U_FRAUD_EMPLOYER_198 CHARACTER VARYING(1) 1
55 U_FRAUD_DRIVERS_LIC_199 CHARACTER VARYING(1) 1
56 U_FRAUD_PASSPORT_200 CHARACTER VARYING(1) 1
57 U_DFAT_FLG_201 CHARACTER VARYING(1) 1
58 U_MX_NUTL_P_DFS_1063 CHARACTER VARYING(10) 10
59 U_MX_NUTL_P_DFS_L24M_1064 CHARACTER VARYING(10) 10
60 U_MX_UTL_DEFS_1065 CHARACTER VARYING(10) 10
61 U_MX_UTL_DEFS_L24M_1066 CHARACTER VARYING(10) 10
62 U_MX_UTL_UP_DFS_1067 CHARACTER VARYING(10) 10
63 U_MX_UTL_UP_DFS_L24M_1068 CHARACTER VARYING(10) 10
64 U_MX_UTL_PD_DFS_1069 CHARACTER VARYING(10) 10
65 U_MX_UTL_PD_DFS_L24M_1070 CHARACTER VARYING(10) 10
66 U_MX_TRD_F_DFS_1071 CHARACTER VARYING(10) 10
67 U_MX_TRD_F_DFS_L24M_1072 CHARACTER VARYING(10) 10
68 U_MX_TRD_F_UPD_DFS_1073 CHARACTER VARYING(10) 10
69 U_MX_TR_F_UPDFS_L24M_1074 CHARACTER VARYING(10) 10
70 U_MX_TRD_FIN_PD_DFS_1075 CHARACTER VARYING(10) 10
71 U_MX_TR_F_P_DFS_L24M_1076 CHARACTER VARYING(10) 10
72 U_MX_VAL_PD_DEFS_1077 CHARACTER VARYING(10) 10
73 U_MX_VAL_NUTL_P_DEFS_1078 CHARACTER VARYING(10) 10
74 U_MX_VAL_UTL_UP_DEFS_1079 CHARACTER VARYING(10) 10
75 U_MX_VAL_UTL_P_DEFS_1080 CHARACTER VARYING(10) 10
76 U_MX_VAL_TR_F_UP_DFS_1081 CHARACTER VARYING(10) 10
77 U_MX_VAL_TR_F_P_DFS_1082 CHARACTER VARYING(10) 10
78 U_MN_CONS_UTL_EN_L3M_1083 CHARACTER VARYING(10) 10
79 U_MX_CONS_UTL_EN_L3M_1084 CHARACTER VARYING(10) 10
80 U_MN_CONS_UTL_EN_L6M_1085 CHARACTER VARYING(10) 10
81 U_MX_CONS_UTL_EN_L6M_1086 CHARACTER VARYING(10) 10
82 U_MN_CONS_UTL_E_L12M_1087 CHARACTER VARYING(10) 10
83 U_MX_CONS_UTL_E_L12M_1088 CHARACTER VARYING(10) 10
84 U_MN_COM_NUTL_EN_L3M_1089 CHARACTER VARYING(10) 10
85 U_MX_COM_NUTL_EN_L3M_1090 CHARACTER VARYING(10) 10
86 U_MN_COM_NUTL_EN_L6M_1091 CHARACTER VARYING(10) 10
87 U_MX_COM_NUTL_EN_L6M_1092 CHARACTER VARYING(10) 10
88 U_MN_COM_NUTL_E_L12M_1093 CHARACTER VARYING(10) 10
89 U_MX_COM_NUTL_E_L12M_1094 CHARACTER VARYING(10) 10
90 U_MN_COM_UTL_E_L3M_1095 CHARACTER VARYING(10) 10
91 U_MX_COM_UTL_E_L3M_1096 CHARACTER VARYING(10) 10
92 U_MN_COM_UTL_E_L6M_1097 CHARACTER VARYING(10) 10
93 U_MX_COM_UTL_E_L6M_1098 CHARACTER VARYING(10) 10
94 U_MN_COM_UTL_E_L12M_1099 CHARACTER VARYING(10) 10
95 U_MX_COM_UTL_E_L12M_1100 CHARACTER VARYING(10) 10
96 U_MN_COM_TR_F_E_L3M_1101 CHARACTER VARYING(10) 10
97 U_MX_COM_TR_F_E_L3M_1102 CHARACTER VARYING(10) 10
98 U_MN_COM_TR_F_E_L6M_1103 CHARACTER VARYING(10) 10
99 U_MX_COM_TR_F_E_L6M_1104 CHARACTER VARYING(10) 10
100 U_MN_COM_TR_F_E_L12M_1105 CHARACTER VARYING(10) 10
101 U_MX_COM_TR_F_E_L12M_1106 CHARACTER VARYING(10) 10
102 U_MX_SAME_PRD_E_L1M_1107 CHARACTER VARYING(10) 10
103 U_MX_SAME_PRD_E_L24M_1108 CHARACTER VARYING(10) 10
104 U_MN_T_LST_NUTL_UPDF_1109 CHARACTER VARYING(10) 10
105 U_MN_T_LST_NUTIL_PDF_1110 CHARACTER VARYING(10) 10
106 U_MN_T_LST_UTL_UPDDF_1111 CHARACTER VARYING(10) 10
107 U_MN_T_LST_UTL_PDDF_1112 CHARACTER VARYING(10) 10
108 U_MN_T_LST_TRDFUPDDF_1113 CHARACTER VARYING(10) 10
109 U_MN_T_LST_TRDFPDDF_1114 CHARACTER VARYING(10) 10
110 U_MN_T_LST_C_NUTIL_E_1115 CHARACTER VARYING(10) 10
111 U_MN_TIME_LST_COM_E_1116 CHARACTER VARYING(10) 10
112 U_MX_PREV_DIRS_HELD_1117 CHARACTER VARYING(10) 10
113 U_DISQU_DIR_FLG_CURR_1118 CHARACTER VARYING(1) 1
114 U_DISQU_DIR_FLG_PREV_1119 CHARACTER VARYING(1) 1
115 U_DIRSHIP_ORGS_A_FLG_1120 CHARACTER VARYING(1) 1
116 U_SCORECARD_NAME_1121 CHARACTER VARYING(14) 14
117 U_REL_RISK_FACTOR_1122 CHARACTER VARYING(10) 10
118 U_REL_RISK_INDEX_1123 CHARACTER VARYING(10) 10
119 U_RISK_ODDS_1124 CHARACTER VARYING(10) 10
120 U_SCORECARD_NAME_IND_1125 CHARACTER VARYING(100) 100
121 U_REL_RISK_FACTOR_1126 CHARACTER VARYING(10) 10
122 U_REL_RISK_INDEX_1127 CHARACTER VARYING(10) 10
123 U_RISK_ODDS_1128 CHARACTER VARYING(10) 10
124 U_SCORECARD_NAME_1129 CHARACTER VARYING(100) 100
125 U_REL_RISK_FACTOR_1130 CHARACTER VARYING(10) 10
126 U_REL_RISK_INDEX_1131 CHARACTER VARYING(10) 10
127 U_RISK_ODDS_1132 CHARACTER VARYING(10) 10
128 U_VERICHK_ADDR_IND_1133 CHARACTER VARYING(1) 1
129 U_VERICHK_ER_IND_CUR_1134 CHARACTER VARYING(1) 1
130 U_VERICHK_ER_IND_PRE_1135 CHARACTER VARYING(1) 1
131 U_VERICHK_ER_IND_PRE_1136 CHARACTER VARYING(1) 1
132 U_VERICHK_D_LIC_IND_1137 CHARACTER VARYING(1) 1
133 U_MX_PRE_ORGSS_NAMES_1138 CHARACTER VARYING(10) 10
134 U_MX_DIRECTORS_1139 CHARACTER VARYING(10) 10
135 U_MX_SHAREHOLDERS_1140 CHARACTER VARYING(10) 10
136 U_MX_PROPRIETORSHIPS_1141 CHARACTER VARYING(10) 10
137 U_MX_PROPRIETORS_1142 CHARACTER VARYING(10) 10
138 U_WINDUP_PET_FLG_1143 CHARACTER VARYING(1) 1
139 U_EXT_ADM_FLG_CURR_1144 CHARACTER VARYING(1) 1
140 U_EXT_ADM_FLG_PREV_1145 CHARACTER VARYING(1) 1
141 U_BUSINESS_STAT_CODE_1146 CHARACTER VARYING(4) 4
142 U_ORG_STATUS_CODE_1147 CHARACTER VARYING(4) 4
143 U_MN_TIME_LST_COLL_E_1148 CHARACTER VARYING(10) 10
144 U_MX_COLL_E_EVER_1149 CHARACTER VARYING(10) 10
145 U_MX_COLL_E_L12M_1150 CHARACTER VARYING(10) 10
146 U_MX_COLL_E_L24M_1151 CHARACTER VARYING(10) 10
147 U_MX_VAL_COLL_E_EVER_1152 CHARACTER VARYING(10) 10
148 U_MX_VAL_COLL_E_L12M_1153 CHARACTER VARYING(10) 10
149 U_MX_VAL_COLL_E_L24M_1154 CHARACTER VARYING(10) 10
150 U_OVERSEAS_RESID_FLG_1155 CHARACTER VARYING(1) 1
151 U_MX_NUM_EXIST_SEC_1156 CHARACTER VARYING(10) 10
152 U_ASIC_TYPE_1157 CHARACTER VARYING(4) 4
153 U_ORG_TYPE_1158 CHARACTER VARYING(3) 3
154 U_TOT_PAID_UP_CAP_1159 CHARACTER VARYING(10) 10
155 U_MX_CREDIT_REV_EVER_1160 CHARACTER VARYING(10) 10
156 U_MX_CREDIT_REV_L12M_1161 CHARACTER VARYING(10) 10
157 U_MX_CREDIT_REV_L24M_1162 CHARACTER VARYING(10) 10
158 U_MX_COM_BROK_E_EVR_1163 CHARACTER VARYING(10) 10
159 U_MX_COM_BROK_E_L12M_1164 CHARACTER VARYING(10) 10
160 U_MX_COM_BROK_E_L24M_1165 CHARACTER VARYING(10) 10
161 U_MX_CONS_BROK_E_EVR_1166 CHARACTER VARYING(10) 10
162 U_MX_CONS_BRO_E_L12M_1167 CHARACTER VARYING(10) 10
163 U_MX_CONS_BRO_E_L24M_1168 CHARACTER VARYING(10) 10
164 U_BAYCORP_T_CUR_ADD_1169 CHARACTER VARYING(10) 10
165 U_BAYCORP_T_CUR_ADD_1170 CHARACTER VARYING(10) 10
166 U_BAYCORP_T_CUR_EMP_1171 CHARACTER VARYING(10) 10
167 U_BAYCORP_T_CUR_EMP_1172 CHARACTER VARYING(10) 10
168 U_MX_CUR_CR_PROVID_1173 CHARACTER VARYING(10) 10
169 U_MX_T_CUR_CR_PROVID_1174 CHARACTER VARYING(10) 10
170 U_SERIOUS_CR_I_FLG_1175 CHARACTER VARYING(1) 1
171 U_DISCHAR_BNKRPT_FLG_1176 CHARACTER VARYING(1) 1
172 U_VERICHK_RESULT_IND_1178 CHARACTER VARYING(2) 2