FCT_BNK_CRHDS_EXPR_CRGS_UNSEC_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian charges data with assets debts incomes expenses and risk scores for unsecured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 U_SPARE_106_400 CHARACTER VARYING(10) 10
3 U_HOME_TELEPHONE_FLG_401 CHARACTER VARYING(1) 1
4 U_EMAIL_ADDRESS_FLG_402 CHARACTER VARYING(1) 1
5 U_FAX_FLG_403 CHARACTER VARYING(1) 1
6 U_REV_FCLTY_OTH_ORGS_404 CHARACTER VARYING(10) 10
7 U_NREV_FCLTY_OTH_ORGS_405 CHARACTER VARYING(10) 10
8 U_EXIST_SM_NREV_FCLTY_406 CHARACTER VARYING(10) 10
9 U_EXIST_SM_REV_FCLTY_407 CHARACTER VARYING(10) 10
10 U_S_M_TCE_408 CHARACTER VARYING(32) 32
11 U_TIME_CUR_ADDR_MMM_410 CHARACTER VARYING(10) 10
12 U_TIME_PREV_ADDR_MMM_411 CHARACTER VARYING(10) 10
13 U_TOT_TIME_ADD_MMM_412 CHARACTER VARYING(10) 10
14 U_BUSINESS_POST_CODE_414 CHARACTER VARYING(4) 4
15 U_STATE_OF_REG_LOC_415 CHARACTER VARYING(4) 4
16 U_MOBILE_TELEPH_FLG_420 CHARACTER VARYING(1) 1
17 U_BUSINESS_TYPE_425 CHARACTER VARYING(3) 3
18 U_NATURE_OF_BUSINESS_427 CHARACTER VARYING(4) 4
19 U_APP_CUST_TYPE_428 CHARACTER VARYING(3) 3
20 U_T_BUSINESS_COMMENCE_429 CHARACTER VARYING(10) 10
21 U_TOT_BENEF_SHAREHOLD_432 CHARACTER VARYING(10) 10
22 U_RE_FINANCE_FLG_487 CHARACTER VARYING(1) 1
23 U_SERVICING_ACCPT_FLG_498 CHARACTER VARYING(1) 1
24 U_SERVICING_AMT_513 CHARACTER VARYING(32) 32
25 U_WORST_CURRENT_DELQ_554 CHARACTER VARYING(10) 10
26 U_TRANSACTION_TYPE_699 CHARACTER VARYING(3) 3
27 U_WORKING_CAPITAL_AMT_710 CHARACTER VARYING(10) 10
28 U_WORKING_CAPITAL_PCT_711 CHARACTER VARYING(10) 10
29 U_GOODS_AMT_712 CHARACTER VARYING(10) 10
30 U_REST_GOODS_TYP_FLG_713 CHARACTER VARYING(1) 1
31 U_REST_GOODS_LOC_FLG_714 CHARACTER VARYING(1) 1
32 U_AGG_GOODS_RISK_AMT_715 CHARACTER VARYING(10) 10
33 U_AGG_A_BACKING_AMT_716 CHARACTER VARYING(10) 10
34 U_AGG_A_RISK_EX_PCT_717 CHARACTER VARYING(10) 10
35 U_GOODS_TYPE_729 CHARACTER VARYING(4) 4
36 U_SUBGROUP_OF_GOODS_730 CHARACTER VARYING(4) 4
37 U_SUPPL_OF_GOODS_IND_731 CHARACTER VARYING(1) 1
38 U_B2BAY_SPARE_67_732 CHARACTER VARYING(1) 1
39 U_RESTRICTED_PRODUCT_733 CHARACTER VARYING(1) 1
40 U_B2BAY_SPARE_69_734 CHARACTER VARYING(1) 1
41 U_MIN_T_IN_BUSINESS_735 CHARACTER VARYING(10) 10
42 U_GTOR_MISMATCH_FLG_737 CHARACTER VARYING(1) 1
43 U_S_M_DIRECTOR_FLG_738 CHARACTER VARYING(1) 1
44 U_B2BAY_SPARE_68_741 CHARACTER VARYING(1) 1
45 U_PROB_STRONG_CUSRSHP_744 CHARACTER VARYING(10) 10
46 U_PROB_WRST_CUSRISKG_748 CHARACTER VARYING(10) 10
47 U_PROB_BEST_CUSRISKG_749 CHARACTER VARYING(10) 10
48 U_PROB_WRST_CUSGB_FLG_751 CHARACTER VARYING(1) 1
49 U_PRO_WRSCUS_O_C_G1_754 CHARACTER VARYING(10) 10
50 U_PRO_BSTCUS_O_C_G1_755 CHARACTER VARYING(10) 10
51 U_PRO_WRSCUS_O_C_G2_758 CHARACTER VARYING(10) 10
52 U_PRO_BSTCUS_O_C_G2_759 CHARACTER VARYING(10) 10
53 U_PRO_WRSCUS_O_C_G3_762 CHARACTER VARYING(10) 10
54 U_PRO_BSTCUS_O_C_G3_763 CHARACTER VARYING(10) 10
55 U_PROB_MX_CUS_TOT_CCL_764 CHARACTER VARYING(10) 10
56 U_PROB_MX_CUS_A_RULC_765 CHARACTER VARYING(10) 10
57 U_PRO_MX_CUS_JNT_CCL_766 CHARACTER VARYING(10) 10
58 U_PROB_MX_CUS_REV_LIM_767 CHARACTER VARYING(10) 10
59 U_PRO_MX_CUS_J_REVLIM_768 CHARACTER VARYING(10) 10
60 U_PRO_MX_CUS_FTERMLIM_769 CHARACTER VARYING(10) 10
61 U_PRO_MX_CUS_J_FTLIM_770 CHARACTER VARYING(10) 10
62 U_PROB_MX_CUS_SEC_LIM_771 CHARACTER VARYING(10) 10
63 U_PRO_CU_UNSQUAL_S_F_772 CHARACTER VARYING(1) 1
64 U_PRO_CU_UNSQUAL_B_F_773 CHARACTER VARYING(1) 1
65 U_PRO_CU_UNSQUAL_IV_F_774 CHARACTER VARYING(1) 1
66 U_PRO_CU_UNSQUAL_FA_F_775 CHARACTER VARYING(1) 1
67 U_PRO_CU_UNSQUAL_SA_F_776 CHARACTER VARYING(1) 1
68 U_PRO_CU_UNSQUAL_JO_F_777 CHARACTER VARYING(1) 1
69 U_PRO_CUS_SECQUAL_S_F_778 CHARACTER VARYING(1) 1
70 U_PRO_CUS_SECQUAL_B_F_779 CHARACTER VARYING(1) 1
71 U_PRO_CU_SECQUAL_IV_F_780 CHARACTER VARYING(1) 1
72 U_PRO_CU_SECQUAL_FA_F_781 CHARACTER VARYING(1) 1
73 U_PRO_CU_SECQUAL_SA_F_782 CHARACTER VARYING(1) 1
74 U_PRO_CU_SECQUAL_JO_F_783 CHARACTER VARYING(1) 1
75 U_PRO_CU_EXIST_PRCMOD_784 CHARACTER VARYING(10) 10
76 U_TOT_CURMPAY2WCAPPCT_800 CHARACTER VARYING(32) 32
77 U_TOT_PROMPAY2WCAPPCT_801 CHARACTER VARYING(32) 32
78 U_INTEREST_COVER_R_802 CHARACTER VARYING(32) 32
79 U_EQUITY_RATIO_803 CHARACTER VARYING(32) 32
80 U_CURRENT_RATIO_804 CHARACTER VARYING(32) 32
81 U_QUICK_RATIO_805 CHARACTER VARYING(32) 32
82 U_ROA_806 CHARACTER VARYING(32) 32
83 U_ROE_807 CHARACTER VARYING(32) 32
84 U_CREDITOR_DAYS_808 CHARACTER VARYING(32) 32
85 U_DEBTOR_DAYS_809 CHARACTER VARYING(10) 10
86 U_Z_SCORE_810 CHARACTER VARYING(10) 10
87 U_ANZSIC_CODE_811 CHARACTER VARYING(10) 10
88 U_AMORTISATION_812 CHARACTER VARYING(32) 32
89 U_B2BAY_SPARE_70_813 CHARACTER VARYING(10) 10
90 U_AVG_STOCK_814 CHARACTER VARYING(10) 10
91 U_BARGAIN_POW_OF_CUST_815 CHARACTER VARYING(2) 2
92 U_BARGAIN_POW_OF_T_816 CHARACTER VARYING(2) 2
93 U_CRGS_SCORECARD_SEL_817 CHARACTER VARYING(3) 3
94 U_SALES_PERFORM_L36M_818 CHARACTER VARYING(10) 10
95 U_STOCK_TURNOVER_819 CHARACTER VARYING(10) 10
96 U_NET_OPERATING_INC_820 CHARACTER VARYING(10) 10
97 U_B2BAY_SPARE_25_821 CHARACTER VARYING(10) 10
98 U_B2BAY_SPARE_26_822 CHARACTER VARYING(10) 10
99 U_CAPCTY_ON_HIST_RES_823 CHARACTER VARYING(10) 10
100 U_CPCTY_ON_PRJCTD_RES_824 CHARACTER VARYING(10) 10
101 U_CAP_REINVST_ALLOW_825 CHARACTER VARYING(10) 10
102 U_B2BAY_SPARE_27_826 CHARACTER VARYING(10) 10
103 U_CATEGORY_OF_BUILDER_827 CHARACTER VARYING(6) 6
104 U_CFB_OPERATING_SALES_828 CHARACTER VARYING(10) 10
105 U_B2BAY_SPARE_28_829 CHARACTER VARYING(10) 10
106 U_B2BAY_SPARE_29_830 CHARACTER VARYING(10) 10
107 U_B2BAY_SPARE_30_831 CHARACTER VARYING(10) 10
108 U_B2BAY_SPARE_31_832 CHARACTER VARYING(10) 10
109 U_B2BAY_SPARE_32_833 CHARACTER VARYING(10) 10
110 U_B2BAY_SPARE_33_834 CHARACTER VARYING(10) 10
111 U_B2BAY_SPARE_34_835 CHARACTER VARYING(10) 10
112 U_B2BAY_SPARE_35_836 CHARACTER VARYING(10) 10
113 U_B2BAY_SPARE_36_837 CHARACTER VARYING(10) 10
114 U_B2BAY_SPARE_37_838 CHARACTER VARYING(10) 10
115 U_COND_PRE_EXI_LOANS_839 CHARACTER VARYING(2) 2
116 U_STAGE_OF_CONSTRUCT_840 CHARACTER VARYING(10) 10
117 U_B2BAY_SPARE_71_841 CHARACTER VARYING(10) 10
118 U_B2BAY_SPARE_38_842 CHARACTER VARYING(10) 10
119 U_TOT_CURR_ASSETS_843 CHARACTER VARYING(32) 32
120 U_TOT_CURR_LIAB_844 CHARACTER VARYING(32) 32
121 U_B2BAY_SPARE_39_845 CHARACTER VARYING(10) 10
122 U_DEBT_SERV_COVER_R_846 CHARACTER VARYING(32) 32
123 U_DEBT_SERV_REQ_847 CHARACTER VARYING(32) 32
124 U_DEPRECIATION_848 CHARACTER VARYING(32) 32
125 U_B2BAY_SPARE_40_849 CHARACTER VARYING(10) 10
126 U_DEV_OR_PROP_PSTCODE_850 CHARACTER VARYING(10) 10
127 U_DEV_RELATED_COMMITS_851 CHARACTER VARYING(32) 32
128 U_B2BAY_SPARE_41_852 CHARACTER VARYING(10) 10
129 U_B2BAY_SPARE_42_853 CHARACTER VARYING(10) 10
130 U_EXTRAORD_EXPENSES_854 CHARACTER VARYING(32) 32
131 U_EXTRAORD_INCOME_855 CHARACTER VARYING(32) 32
132 U_EXTRAORD_ITEMS_856 CHARACTER VARYING(32) 32
133 U_FINANCE_LEASE_EXP_857 CHARACTER VARYING(32) 32
134 U_FIT_WITH_NEIGHRHD_858 CHARACTER VARYING(2) 2
135 U_GEOINDUSTRY_SECTOR_859 CHARACTER VARYING(7) 7
136 U_GROSS_REAL_V_EX_GST_860 CHARACTER VARYING(32) 32
137 U_GROSS_RENTAL_INCOME_861 CHARACTER VARYING(32) 32
138 U_EXPERIENCE_862 CHARACTER VARYING(10) 10
139 U_INTANGIBLE_ASSETS_863 CHARACTER VARYING(32) 32
140 U_INTEREST_EXPENSE_864 CHARACTER VARYING(32) 32
141 U_INTERNAL_RATEOFRET_865 CHARACTER VARYING(32) 32
142 U_INVENTORY_866 CHARACTER VARYING(32) 32
143 U_B2BAY_SPARE_43_867 CHARACTER VARYING(10) 10
144 U_B2BAY_SPARE_44_868 CHARACTER VARYING(10) 10
145 U_B2BAY_SPARE_45_869 CHARACTER VARYING(10) 10
146 U_LIVING_ALLOWANCE_870 CHARACTER VARYING(32) 32
147 U_MGMT_INTEGRITY_871 CHARACTER VARYING(2) 2
148 U_MATURITY_CURR_T_872 CHARACTER VARYING(10) 10
149 U_B2BAY_SPARE_46_873 CHARACTER VARYING(10) 10
150 U_B2BAY_SPARE_72_874 CHARACTER VARYING(10) 10
151 U_B2BAY_SPARE_47_875 CHARACTER VARYING(10) 10
152 U_B2BAY_SPARE_66_876 CHARACTER VARYING(10) 10
153 U_NON_CURRENT_ASSETS_877 CHARACTER VARYING(32) 32
154 U_B2BAY_SPARE_48_878 CHARACTER VARYING(10) 10
155 U_NONOPERATING_EXP_879 CHARACTER VARYING(32) 32
156 U_NONOPERATING_INCOME_880 CHARACTER VARYING(32) 32
157 U_N_PROJ_UNDRTN_PRINC_881 CHARACTER VARYING(10) 10
158 U_N_SUCPRJ_COMP_PRINC_882 CHARACTER VARYING(10) 10
159 U_OFFICERS_COMPENS_883 CHARACTER VARYING(32) 32
160 U_B2BAY_SPARE_49_884 CHARACTER VARYING(10) 10
161 U_PAST_PROJ_SUC_R_PCT_885 CHARACTER VARYING(32) 32
162 U_PHY_ATTR_RISK_MGM_P_886 CHARACTER VARYING(7) 7
163 U_B2BAY_SPARE_50_887 CHARACTER VARYING(10) 10
164 U_B2BAY_SPARE_51_888 CHARACTER VARYING(10) 10
165 U_B2BAY_SPARE_52_889 CHARACTER VARYING(10) 10
166 U_B2BAY_SPARE_53_890 CHARACTER VARYING(10) 10
167 U_POST_DDSOP_SM_OBLOC_891 CHARACTER VARYING(32) 32
168 U_POST_DDSOP_SM_PAYAD_892 CHARACTER VARYING(32) 32
169 U_B2BAY_SPARE_54_893 CHARACTER VARYING(10) 10
170 U_B2BAY_SPARE_55_894 CHARACTER VARYING(10) 10
171 U_POST_DDSOP_TOT_NCA_895 CHARACTER VARYING(32) 32
172 U_POST_DDSOP_TOT_NCL_896 CHARACTER VARYING(32) 32
173 U_PRESALES_AMOUNT_897 CHARACTER VARYING(32) 32
174 U_B2BAY_SPARE_73_898 CHARACTER VARYING(10) 10
175 U_PROJECT_COST_899 CHARACTER VARYING(32) 32
176 U_PROJ_COST2GRV_RATIO_900 CHARACTER VARYING(32) 32
177 U_PROJ_GEARING_POS_901 CHARACTER VARYING(32) 32
178 U_PROJECTD_DEBTCOV_R_902 CHARACTER VARYING(32) 32
179 U_PROJECTD_FNDS_ADS_903 CHARACTER VARYING(32) 32
180 U_PROPERTY_CONDITION_904 CHARACTER VARYING(2) 2
181 U_B2BAY_SPARE_56_905 CHARACTER VARYING(10) 10
182 U_B2BAY_SPARE_57_906 CHARACTER VARYING(10) 10
183 U_PRESALES2LOAN_RATIO_907 CHARACTER VARYING(32) 32
184 U_RELTD_PARTYLOANS_A_908 CHARACTER VARYING(32) 32
185 U_RELTD_PARTY_LOANS_L_909 CHARACTER VARYING(32) 32
186 U_RENT_ARREARS_910 CHARACTER VARYING(32) 32
187 U_RENT_ARREARS_PCT_911 CHARACTER VARYING(32) 32
188 U_RENTAL_INCOME_PERF_912 CHARACTER VARYING(32) 32
189 U_SALES_913 CHARACTER VARYING(32) 32
190 U_SIMILARITY_PRE_PROJ_914 CHARACTER VARYING(2) 2
191 U_SRC_OF_SPONSOR_EQ_915 CHARACTER VARYING(2) 2
192 U_TANGIBLE_ASSETS_916 CHARACTER VARYING(32) 32
193 U_TANGIBLE_NET_WORTH_917 CHARACTER VARYING(32) 32
194 U_TRG_SALES2INVST_PCT_918 CHARACTER VARYING(32) 32
195 U_TENANCY_MIX_919 CHARACTER VARYING(7) 7
196 U_TERM_OF_THE_PROJECT_920 CHARACTER VARYING(10) 10
197 U_TOT_LIABILITIES_921 CHARACTER VARYING(32) 32
198 U_TOT_ASSETS_922 CHARACTER VARYING(32) 32
199 U_B2BAY_SPARE_58_923 CHARACTER VARYING(10) 10
200 U_TOT_EXPENSES_924 CHARACTER VARYING(32) 32
201 U_B2BAY_SPARE_59_925 CHARACTER VARYING(10) 10
202 U_B2BAY_SPARE_60_926 CHARACTER VARYING(10) 10
203 U_B2BAY_SPARE_61_927 CHARACTER VARYING(10) 10
204 U_B2BAY_SPARE_62_928 CHARACTER VARYING(10) 10
205 U_TOT_MOTOR_VEHICLE_A_929 CHARACTER VARYING(32) 32
206 U_B2BAY_SPARE_63_930 CHARACTER VARYING(10) 10
207 U_B2BAY_SPARE_64_931 CHARACTER VARYING(10) 10
208 U_B2BAY_SPARE_65_932 CHARACTER VARYING(10) 10
209 U_TOT_PLANT_EQUIP_A_933 CHARACTER VARYING(32) 32
210 U_TRADE_CREDITORS_934 CHARACTER VARYING(32) 32
211 U_VACANCY_PCT_935 CHARACTER VARYING(32) 32
212 U_WRKNG_CAP2SALES_PCT_936 CHARACTER VARYING(32) 32
213 U_WORKING_WITHIN_BUD_937 CHARACTER VARYING(32) 32
214 U_YRS_AS_SELFEMP_DEVL_938 CHARACTER VARYING(32) 32
215 U_ASSET_REVALUATIONS_939 CHARACTER VARYING(32) 32
216 U_COST_OF_GOODS_SOLD_940 CHARACTER VARYING(32) 32
217 U_NET_PRO_B_INT_A_TAX_941 CHARACTER VARYING(32) 32
218 U_PRO_B_TAX_EXTORD_I_942 CHARACTER VARYING(32) 32
219 U_B2BAY_SPARE_5_943 CHARACTER VARYING(10) 10
220 U_B2BAY_SPARE_6_944 CHARACTER VARYING(10) 10
221 U_B2BAY_SPARE_7_945 CHARACTER VARYING(10) 10
222 U_B2BAY_SPARE_8_946 CHARACTER VARYING(10) 10
223 U_B2BAY_SPARE_9_947 CHARACTER VARYING(10) 10
224 U_B2BAY_SPARE_10_948 CHARACTER VARYING(10) 10
225 U_B2BAY_SPARE_11_949 CHARACTER VARYING(10) 10
226 U_B2BAY_SPARE_12_950 CHARACTER VARYING(10) 10
227 U_B2BAY_SPARE_13_951 CHARACTER VARYING(10) 10
228 U_B2BAY_SPARE_14_952 CHARACTER VARYING(10) 10
229 U_B2BAY_SPARE_15_953 CHARACTER VARYING(10) 10
230 U_SUBGROUP_OF_GOODS2_954 CHARACTER VARYING(4) 4
231 U_B2BAY_SPARE_17_955 CHARACTER VARYING(4) 4
232 U_B2BAY_SPARE_18_956 CHARACTER VARYING(4) 4
233 U_B2BAY_SPARE_19_957 CHARACTER VARYING(4) 4
234 U_B2BAY_SPARE_20_958 CHARACTER VARYING(4) 4
235 U_SERVICING_AMT_1061 CHARACTER VARYING(32) 32
236 U_OVERWRITE_DEC_CAT_1062 CHARACTER VARYING(1) 1
237 U_SELFEMP_INC_VAR_1177 CHARACTER VARYING(32) 32