FCT_BNK_CRHDS_EXPR_BUREAU_SEC_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 secured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_CRAA_ENQ_PERF_FLG_106 CHARACTER VARYING(1) 1
3 S_MOST_INFO_ENQ_PERF_107 CHARACTER VARYING(8) 8
4 S_TOT_STRONG_MATCHES_108 CHARACTER VARYING(10) 10
5 S_TOT_NUM_NO_MATCHES_109 CHARACTER VARYING(10) 10
6 S_TOT_POSS_MATCHES_110 CHARACTER VARYING(10) 10
7 S_TOT_CROSSREFERENCES_111 CHARACTER VARYING(10) 10
8 S_FILE_NOTES_FLG_112 CHARACTER VARYING(1) 1
9 S_CURR_BNKRPT_FLG_113 CHARACTER VARYING(1) 1
10 S_MX_NUM_JUDGEMENTS_116 CHARACTER VARYING(10) 10
11 S_MX_WRITS_SUMMONSES_117 CHARACTER VARYING(10) 10
12 S_MX_NUM_OF_DEFS_122 CHARACTER VARYING(10) 10
13 S_MX_NUM_DEFS_L24M_124 CHARACTER VARYING(10) 10
14 S_MX_NUM_PAID_DEFS_126 CHARACTER VARYING(10) 10
15 S_MX_PAID_DEFS_L24M_128 CHARACTER VARYING(10) 10
16 S_MX_NUM_UNPAID_DEFS_130 CHARACTER VARYING(10) 10
17 S_MX_UNPAID_DEFS_L24M_132 CHARACTER VARYING(10) 10
18 S_MX_NUM_NUTIL_DEFS_134 CHARACTER VARYING(10) 10
19 S_MX_NUTL_DFS_L24M_136 CHARACTER VARYING(10) 10
20 S_MX_NUTL_UPD_DFS_137 CHARACTER VARYING(10) 10
21 S_MX_NUTL_UP_DFS_L24M_138 CHARACTER VARYING(10) 10
22 S_MX_VAL_UNPD_DEFS_143 CHARACTER VARYING(10) 10
23 S_MX_VAL_NUTL_UPD_DFS_147 CHARACTER VARYING(10) 10
24 S_MN_CONS_NUTL_EN_L3M_153 CHARACTER VARYING(10) 10
25 S_MX_CONS_NUTL_EN_L3M_154 CHARACTER VARYING(10) 10
26 S_MN_CONS_NUTL_EN_L6M_155 CHARACTER VARYING(10) 10
27 S_MX_CONS_NUTL_EN_L6M_156 CHARACTER VARYING(10) 10
28 S_MN_CONS_NUTL_E_L12M_157 CHARACTER VARYING(10) 10
29 S_MX_CONS_NUTL_E_L12M_158 CHARACTER VARYING(10) 10
30 S_MX_SAME_PROD_EN_L3M_164 CHARACTER VARYING(10) 10
31 S_SPARE_101_165 CHARACTER VARYING(10) 10
32 S_MX_SAME_PROD_E_L12M_166 CHARACTER VARYING(10) 10
33 S_MN_T_CRAA_FILE_OMMM_167 CHARACTER VARYING(10) 10
34 S_MN_T_BNKRPT_DIS_MMM_168 CHARACTER VARYING(10) 10
35 S_MN_T_LST_DEF_MMM_169 CHARACTER VARYING(10) 10
36 S_MN_T_LSTCONS_NUTL_E_171 CHARACTER VARYING(10) 10
37 S_MN_T_LST_CONS_UTL_E_172 CHARACTER VARYING(10) 10
38 S_MN_T_LST_SAMEPRD_EN_173 CHARACTER VARYING(10) 10
39 S_MX_CURR_DIRECTRSHPS_174 CHARACTER VARYING(10) 10
40 S_DISQUAL_DIR_FLG_175 CHARACTER VARYING(1) 1
41 S_WORST_AREA_RISK_IND_180 CHARACTER VARYING(10) 10
42 S_BEST_AREA_RISK_IND_181 CHARACTER VARYING(10) 10
43 S_VERICHK_SUITE_R_FLG_187 CHARACTER VARYING(1) 1
44 S_VERICHK_RESULT_IND_188 CHARACTER VARYING(2) 2
45 S_VERICHK_ADDRESS_IND_189 CHARACTER VARYING(1) 1
46 S_VERICHK_ER_IND_CURR_190 CHARACTER VARYING(1) 1
47 S_VERICHK_DRIVS_L_IND_191 CHARACTER VARYING(1) 1
48 S_FRAUD_PHONE_192 CHARACTER VARYING(1) 1
49 S_FRAUD_2ND_PHONE_193 CHARACTER VARYING(1) 1
50 S_FRAUD_EMPLOYER_PH_194 CHARACTER VARYING(1) 1
51 S_FRAUD_GUARANTOR_PH_195 CHARACTER VARYING(1) 1
52 S_FRAUD_REFEREE_PHONE_196 CHARACTER VARYING(1) 1
53 S_FRAUD_ADDRESS_197 CHARACTER VARYING(1) 1
54 S_FRAUD_EMPLOYER_198 CHARACTER VARYING(1) 1
55 S_FRAUD_DRIVERS_LIC_199 CHARACTER VARYING(1) 1
56 S_FRAUD_PASSPORT_200 CHARACTER VARYING(1) 1
57 S_DFAT_FLG_201 CHARACTER VARYING(1) 1
58 S_MX_NUTL_P_DFS_1063 CHARACTER VARYING(10) 10
59 S_MX_NUTL_P_DFS_L24M_1064 CHARACTER VARYING(10) 10
60 S_MX_UTL_DEFS_1065 CHARACTER VARYING(10) 10
61 S_MX_UTL_DEFS_L24M_1066 CHARACTER VARYING(10) 10
62 S_MX_UTL_UP_DFS_1067 CHARACTER VARYING(10) 10
63 S_MX_UTL_UP_DFS_L24M_1068 CHARACTER VARYING(10) 10
64 S_MX_UTL_PD_DFS_1069 CHARACTER VARYING(10) 10
65 S_MX_UTL_PD_DFS_L24M_1070 CHARACTER VARYING(10) 10
66 S_MX_TRD_F_DFS_1071 CHARACTER VARYING(10) 10
67 S_MX_TRD_F_DFS_L24M_1072 CHARACTER VARYING(10) 10
68 S_MX_TRD_F_UPD_DFS_1073 CHARACTER VARYING(10) 10
69 S_MX_TR_F_UPDFS_L24M_1074 CHARACTER VARYING(10) 10
70 S_MX_TRD_FIN_PD_DFS_1075 CHARACTER VARYING(10) 10
71 S_MX_TR_F_P_DFS_L24M_1076 CHARACTER VARYING(10) 10
72 S_MX_VAL_PD_DEFS_1077 CHARACTER VARYING(10) 10
73 S_MX_VAL_NUTL_P_DEFS_1078 CHARACTER VARYING(10) 10
74 S_MX_VAL_UTL_UP_DEFS_1079 CHARACTER VARYING(10) 10
75 S_MX_VAL_UTL_P_DEFS_1080 CHARACTER VARYING(10) 10
76 S_MX_VAL_TR_F_UP_DFS_1081 CHARACTER VARYING(10) 10
77 S_MX_VAL_TR_F_P_DFS_1082 CHARACTER VARYING(10) 10
78 S_MN_CONS_UTL_EN_L3M_1083 CHARACTER VARYING(10) 10
79 S_MX_CONS_UTL_EN_L3M_1084 CHARACTER VARYING(10) 10
80 S_MN_CONS_UTL_EN_L6M_1085 CHARACTER VARYING(10) 10
81 S_MX_CONS_UTL_EN_L6M_1086 CHARACTER VARYING(10) 10
82 S_MN_CONS_UTL_E_L12M_1087 CHARACTER VARYING(10) 10
83 S_MX_CONS_UTL_E_L12M_1088 CHARACTER VARYING(10) 10
84 S_MN_COM_NUTL_EN_L3M_1089 CHARACTER VARYING(10) 10
85 S_MX_COM_NUTL_EN_L3M_1090 CHARACTER VARYING(10) 10
86 S_MN_COM_NUTL_EN_L6M_1091 CHARACTER VARYING(10) 10
87 S_MX_COM_NUTL_EN_L6M_1092 CHARACTER VARYING(10) 10
88 S_MN_COM_NUTL_E_L12M_1093 CHARACTER VARYING(10) 10
89 S_MX_COM_NUTL_E_L12M_1094 CHARACTER VARYING(10) 10
90 S_MN_COM_UTL_E_L3M_1095 CHARACTER VARYING(10) 10
91 S_MX_COM_UTL_E_L3M_1096 CHARACTER VARYING(10) 10
92 S_MN_COM_UTL_E_L6M_1097 CHARACTER VARYING(10) 10
93 S_MX_COM_UTL_E_L6M_1098 CHARACTER VARYING(10) 10
94 S_MN_COM_UTL_E_L12M_1099 CHARACTER VARYING(10) 10
95 S_MX_COM_UTL_E_L12M_1100 CHARACTER VARYING(10) 10
96 S_MN_COM_TR_F_E_L3M_1101 CHARACTER VARYING(10) 10
97 S_MX_COM_TR_F_E_L3M_1102 CHARACTER VARYING(10) 10
98 S_MN_COM_TR_F_E_L6M_1103 CHARACTER VARYING(10) 10
99 S_MX_COM_TR_F_E_L6M_1104 CHARACTER VARYING(10) 10
100 S_MN_COM_TR_F_E_L12M_1105 CHARACTER VARYING(10) 10
101 S_MX_COM_TR_F_E_L12M_1106 CHARACTER VARYING(10) 10
102 S_MX_SAME_PRD_E_L1M_1107 CHARACTER VARYING(10) 10
103 S_MX_SAME_PRD_E_L24M_1108 CHARACTER VARYING(10) 10
104 S_MN_T_LST_NUTL_UPDF_1109 CHARACTER VARYING(10) 10
105 S_MN_T_LST_NUTIL_PDF_1110 CHARACTER VARYING(10) 10
106 S_MN_T_LST_UTL_UPDDF_1111 CHARACTER VARYING(10) 10
107 S_MN_T_LST_UTL_PDDF_1112 CHARACTER VARYING(10) 10
108 S_MN_T_LST_TRDFUPDDF_1113 CHARACTER VARYING(10) 10
109 S_MN_T_LST_TRDFPDDF_1114 CHARACTER VARYING(10) 10
110 S_MN_T_LST_C_NUTIL_E_1115 CHARACTER VARYING(10) 10
111 S_MN_TIME_LST_COM_E_1116 CHARACTER VARYING(10) 10
112 S_MX_PREV_DIRS_HELD_1117 CHARACTER VARYING(10) 10
113 S_DISQU_DIR_FLG_CURR_1118 CHARACTER VARYING(1) 1
114 S_DISQU_DIR_FLG_PREV_1119 CHARACTER VARYING(1) 1
115 S_DIRSHIP_ORGS_A_FLG_1120 CHARACTER VARYING(1) 1
116 S_SCORECARD_NAME_1121 CHARACTER VARYING(14) 14
117 S_REL_RISK_FACTOR_1122 CHARACTER VARYING(10) 10
118 S_REL_RISK_INDEX_1123 CHARACTER VARYING(10) 10
119 S_RISK_ODDS_1124 CHARACTER VARYING(10) 10
120 S_SCORECARD_NAME_IND_1125 CHARACTER VARYING(100) 100
121 S_REL_RISK_FACTOR_1126 CHARACTER VARYING(10) 10
122 S_REL_RISK_INDEX_1127 CHARACTER VARYING(10) 10
123 S_RISK_ODDS_1128 CHARACTER VARYING(10) 10
124 S_SCORECARD_NAME_1129 CHARACTER VARYING(100) 100
125 S_REL_RISK_FACTOR_1130 CHARACTER VARYING(10) 10
126 S_REL_RISK_INDEX_1131 CHARACTER VARYING(10) 10
127 S_RISK_ODDS_1132 CHARACTER VARYING(10) 10
128 S_VERICHK_ADDR_IND_1133 CHARACTER VARYING(1) 1
129 S_VERICHK_ER_IND_CUR_1134 CHARACTER VARYING(1) 1
130 S_VERICHK_ER_IND_PRE_1135 CHARACTER VARYING(1) 1
131 S_VERICHK_ER_IND_PRE_1136 CHARACTER VARYING(1) 1
132 S_VERICHK_D_LIC_IND_1137 CHARACTER VARYING(1) 1
133 S_MX_PRE_ORGSS_NAMES_1138 CHARACTER VARYING(10) 10
134 S_MX_DIRECTORS_1139 CHARACTER VARYING(10) 10
135 S_MX_SHAREHOLDERS_1140 CHARACTER VARYING(10) 10
136 S_MX_PROPRIETORSHIPS_1141 CHARACTER VARYING(10) 10
137 S_MX_PROPRIETORS_1142 CHARACTER VARYING(10) 10
138 S_WINDUP_PET_FLG_1143 CHARACTER VARYING(1) 1
139 S_EXT_ADM_FLG_CURR_1144 CHARACTER VARYING(1) 1
140 S_EXT_ADM_FLG_PREV_1145 CHARACTER VARYING(1) 1
141 S_BUSINESS_STAT_CODE_1146 CHARACTER VARYING(4) 4
142 S_ORG_STATUS_CODE_1147 CHARACTER VARYING(4) 4
143 S_MN_TIME_LST_COLL_E_1148 CHARACTER VARYING(10) 10
144 S_MX_COLL_E_EVER_1149 CHARACTER VARYING(10) 10
145 S_MX_COLL_E_L12M_1150 CHARACTER VARYING(10) 10
146 S_MX_COLL_E_L24M_1151 CHARACTER VARYING(10) 10
147 S_MX_VAL_COLL_E_EVER_1152 CHARACTER VARYING(10) 10
148 S_MX_VAL_COLL_E_L12M_1153 CHARACTER VARYING(10) 10
149 S_MX_VAL_COLL_E_L24M_1154 CHARACTER VARYING(10) 10
150 S_OVERSEAS_RESID_FLG_1155 CHARACTER VARYING(1) 1
151 S_MX_NUM_EXIST_SEC_1156 CHARACTER VARYING(10) 10
152 S_ASIC_TYPE_1157 CHARACTER VARYING(4) 4
153 S_ORG_TYPE_1158 CHARACTER VARYING(3) 3
154 S_TOT_PAID_UP_CAP_1159 CHARACTER VARYING(10) 10
155 S_MX_CREDIT_REV_EVER_1160 CHARACTER VARYING(10) 10
156 S_MX_CREDIT_REV_L12M_1161 CHARACTER VARYING(10) 10
157 S_MX_CREDIT_REV_L24M_1162 CHARACTER VARYING(10) 10
158 S_MX_COM_BROK_E_EVR_1163 CHARACTER VARYING(10) 10
159 S_MX_COM_BROK_E_L12M_1164 CHARACTER VARYING(10) 10
160 S_MX_COM_BROK_E_L24M_1165 CHARACTER VARYING(10) 10
161 S_MX_CONS_BROK_E_EVR_1166 CHARACTER VARYING(10) 10
162 S_MX_CONS_BRO_E_L12M_1167 CHARACTER VARYING(10) 10
163 S_MX_CONS_BRO_E_L24M_1168 CHARACTER VARYING(10) 10
164 S_BAYCORP_T_CUR_ADD_1169 CHARACTER VARYING(10) 10
165 S_BAYCORP_T_CUR_ADD_1170 CHARACTER VARYING(10) 10
166 S_BAYCORP_T_CUR_EMP_1171 CHARACTER VARYING(10) 10
167 S_BAYCORP_T_CUR_EMP_1172 CHARACTER VARYING(10) 10
168 S_MX_CUR_CR_PROVID_1173 CHARACTER VARYING(10) 10
169 S_MX_T_CUR_CR_PROVID_1174 CHARACTER VARYING(10) 10
170 S_SERIOUS_CR_I_FLG_1175 CHARACTER VARYING(1) 1
171 S_DISCHAR_BNKRPT_FLG_1176 CHARACTER VARYING(1) 1
172 S_VERICHK_RESULT_IND_1178 CHARACTER VARYING(2) 2