FCT_BNK_CRHDS_EXPR_CRGS_SEC_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

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

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_SPARE_106_400 CHARACTER VARYING(10) 10
3 S_HOME_TELEPHONE_FLG_401 CHARACTER VARYING(1) 1
4 S_EMAIL_ADDRESS_FLG_402 CHARACTER VARYING(1) 1
5 S_FAX_FLG_403 CHARACTER VARYING(1) 1
6 S_REV_FCLTY_OTH_ORGS_404 CHARACTER VARYING(10) 10
7 S_NREV_FCLTY_OTH_ORGS_405 CHARACTER VARYING(10) 10
8 S_EXIST_SM_NREV_FCLTY_406 CHARACTER VARYING(10) 10
9 S_EXIST_SM_REV_FCLTY_407 CHARACTER VARYING(10) 10
10 S_S_M_TCE_408 CHARACTER VARYING(32) 32
11 S_TIME_CUR_ADDR_MMM_410 CHARACTER VARYING(10) 10
12 S_TIME_PREV_ADDR_MMM_411 CHARACTER VARYING(10) 10
13 S_TOT_TIME_ADD_MMM_412 CHARACTER VARYING(10) 10
14 S_BUSINESS_POST_CODE_414 CHARACTER VARYING(4) 4
15 S_STATE_OF_REG_LOC_415 CHARACTER VARYING(4) 4
16 S_MOBILE_TELEPH_FLG_420 CHARACTER VARYING(1) 1
17 S_BUSINESS_TYPE_425 CHARACTER VARYING(3) 3
18 S_NATURE_OF_BUSINESS_427 CHARACTER VARYING(4) 4
19 S_APP_CUST_TYPE_428 CHARACTER VARYING(3) 3
20 S_T_BUSINESS_COMMENCE_429 CHARACTER VARYING(10) 10
21 S_TOT_BENEF_SHAREHOLD_432 CHARACTER VARYING(10) 10
22 S_RE_FINANCE_FLG_487 CHARACTER VARYING(1) 1
23 S_SERVICING_ACCPT_FLG_498 CHARACTER VARYING(1) 1
24 S_SERVICING_AMT_513 CHARACTER VARYING(32) 32
25 S_WORST_CURRENT_DELQ_554 CHARACTER VARYING(10) 10
26 S_TRANSACTION_TYPE_699 CHARACTER VARYING(3) 3
27 S_WORKING_CAPITAL_AMT_710 CHARACTER VARYING(10) 10
28 S_WORKING_CAPITAL_PCT_711 CHARACTER VARYING(10) 10
29 S_GOODS_AMT_712 CHARACTER VARYING(10) 10
30 S_REST_GOODS_TYP_FLG_713 CHARACTER VARYING(1) 1
31 S_REST_GOODS_LOC_FLG_714 CHARACTER VARYING(1) 1
32 S_AGG_GOODS_RISK_AMT_715 CHARACTER VARYING(10) 10
33 S_AGG_A_BACKING_AMT_716 CHARACTER VARYING(10) 10
34 S_AGG_A_RISK_EX_PCT_717 CHARACTER VARYING(10) 10
35 S_GOODS_TYPE_729 CHARACTER VARYING(4) 4
36 S_SUBGROUP_OF_GOODS_730 CHARACTER VARYING(4) 4
37 S_SUPPL_OF_GOODS_IND_731 CHARACTER VARYING(1) 1
38 S_B2BAY_SPARE_67_732 CHARACTER VARYING(1) 1
39 S_RESTRICTED_PRODUCT_733 CHARACTER VARYING(1) 1
40 S_B2BAY_SPARE_69_734 CHARACTER VARYING(1) 1
41 S_MIN_T_IN_BUSINESS_735 CHARACTER VARYING(10) 10
42 S_GTOR_MISMATCH_FLG_737 CHARACTER VARYING(1) 1
43 S_S_M_DIRECTOR_FLG_738 CHARACTER VARYING(1) 1
44 S_B2BAY_SPARE_68_741 CHARACTER VARYING(1) 1
45 S_PROB_STRONG_CUSRSHP_744 CHARACTER VARYING(10) 10
46 S_PROB_WRST_CUSRISKG_748 CHARACTER VARYING(10) 10
47 S_PROB_BEST_CUSRISKG_749 CHARACTER VARYING(10) 10
48 S_PROB_WRST_CUSGB_FLG_751 CHARACTER VARYING(1) 1
49 S_PRO_WRSCUS_O_C_G1_754 CHARACTER VARYING(10) 10
50 S_PRO_BSTCUS_O_C_G1_755 CHARACTER VARYING(10) 10
51 S_PRO_WRSCUS_O_C_G2_758 CHARACTER VARYING(10) 10
52 S_PRO_BSTCUS_O_C_G2_759 CHARACTER VARYING(10) 10
53 S_PRO_WRSCUS_O_C_G3_762 CHARACTER VARYING(10) 10
54 S_PRO_BSTCUS_O_C_G3_763 CHARACTER VARYING(10) 10
55 S_PROB_MX_CUS_TOT_CCL_764 CHARACTER VARYING(10) 10
56 S_PROB_MX_CUS_A_RULC_765 CHARACTER VARYING(10) 10
57 S_PRO_MX_CUS_JNT_CCL_766 CHARACTER VARYING(10) 10
58 S_PROB_MX_CUS_REV_LIM_767 CHARACTER VARYING(10) 10
59 S_PRO_MX_CUS_J_REVLIM_768 CHARACTER VARYING(10) 10
60 S_PRO_MX_CUS_FTERMLIM_769 CHARACTER VARYING(10) 10
61 S_PRO_MX_CUS_J_FTLIM_770 CHARACTER VARYING(10) 10
62 S_PROB_MX_CUS_SEC_LIM_771 CHARACTER VARYING(10) 10
63 S_PRO_CU_UNSQUAL_S_F_772 CHARACTER VARYING(1) 1
64 S_PRO_CU_UNSQUAL_B_F_773 CHARACTER VARYING(1) 1
65 S_PRO_CU_UNSQUAL_IV_F_774 CHARACTER VARYING(1) 1
66 S_PRO_CU_UNSQUAL_FA_F_775 CHARACTER VARYING(1) 1
67 S_PRO_CU_UNSQUAL_SA_F_776 CHARACTER VARYING(1) 1
68 S_PRO_CU_UNSQUAL_JO_F_777 CHARACTER VARYING(1) 1
69 S_PRO_CUS_SECQUAL_S_F_778 CHARACTER VARYING(1) 1
70 S_PRO_CUS_SECQUAL_B_F_779 CHARACTER VARYING(1) 1
71 S_PRO_CU_SECQUAL_IV_F_780 CHARACTER VARYING(1) 1
72 S_PRO_CU_SECQUAL_FA_F_781 CHARACTER VARYING(1) 1
73 S_PRO_CU_SECQUAL_SA_F_782 CHARACTER VARYING(1) 1
74 S_PRO_CU_SECQUAL_JO_F_783 CHARACTER VARYING(1) 1
75 S_PRO_CU_EXIST_PRCMOD_784 CHARACTER VARYING(10) 10
76 S_TOT_CURMPAY2WCAPPCT_800 CHARACTER VARYING(32) 32
77 S_TOT_PROMPAY2WCAPPCT_801 CHARACTER VARYING(32) 32
78 S_INTEREST_COVER_R_802 CHARACTER VARYING(32) 32
79 S_EQUITY_RATIO_803 CHARACTER VARYING(32) 32
80 S_CURRENT_RATIO_804 CHARACTER VARYING(32) 32
81 S_QUICK_RATIO_805 CHARACTER VARYING(32) 32
82 S_ROA_806 CHARACTER VARYING(32) 32
83 S_ROE_807 CHARACTER VARYING(32) 32
84 S_CREDITOR_DAYS_808 CHARACTER VARYING(32) 32
85 S_DEBTOR_DAYS_809 CHARACTER VARYING(10) 10
86 S_Z_SCORE_810 CHARACTER VARYING(10) 10
87 S_ANZSIC_CODE_811 CHARACTER VARYING(10) 10
88 S_AMORTISATION_812 CHARACTER VARYING(32) 32
89 S_B2BAY_SPARE_70_813 CHARACTER VARYING(10) 10
90 S_AVG_STOCK_814 CHARACTER VARYING(10) 10
91 S_BARGAIN_POW_OF_CUST_815 CHARACTER VARYING(2) 2
92 S_BARGAIN_POW_OF_T_816 CHARACTER VARYING(2) 2
93 S_CRGS_SCORECARD_SEL_817 CHARACTER VARYING(3) 3
94 S_SALES_PERFORM_L36M_818 CHARACTER VARYING(10) 10
95 S_STOCK_TURNOVER_819 CHARACTER VARYING(10) 10
96 S_NET_OPERATING_INC_820 CHARACTER VARYING(10) 10
97 S_B2BAY_SPARE_25_821 CHARACTER VARYING(10) 10
98 S_B2BAY_SPARE_26_822 CHARACTER VARYING(10) 10
99 S_CAPCTY_ON_HIST_RES_823 CHARACTER VARYING(10) 10
100 S_CPCTY_ON_PRJCTD_RES_824 CHARACTER VARYING(10) 10
101 S_CAP_REINVST_ALLOW_825 CHARACTER VARYING(10) 10
102 S_B2BAY_SPARE_27_826 CHARACTER VARYING(10) 10
103 S_CATEGORY_OF_BUILDER_827 CHARACTER VARYING(6) 6
104 S_CFB_OPERATING_SALES_828 CHARACTER VARYING(10) 10
105 S_B2BAY_SPARE_28_829 CHARACTER VARYING(10) 10
106 S_B2BAY_SPARE_29_830 CHARACTER VARYING(10) 10
107 S_B2BAY_SPARE_30_831 CHARACTER VARYING(10) 10
108 S_B2BAY_SPARE_31_832 CHARACTER VARYING(10) 10
109 S_B2BAY_SPARE_32_833 CHARACTER VARYING(10) 10
110 S_B2BAY_SPARE_33_834 CHARACTER VARYING(10) 10
111 S_B2BAY_SPARE_34_835 CHARACTER VARYING(10) 10
112 S_B2BAY_SPARE_35_836 CHARACTER VARYING(10) 10
113 S_B2BAY_SPARE_36_837 CHARACTER VARYING(10) 10
114 S_B2BAY_SPARE_37_838 CHARACTER VARYING(10) 10
115 S_COND_PRE_EXI_LOANS_839 CHARACTER VARYING(2) 2
116 S_STAGE_OF_CONSTRUCT_840 CHARACTER VARYING(10) 10
117 S_B2BAY_SPARE_71_841 CHARACTER VARYING(10) 10
118 S_B2BAY_SPARE_38_842 CHARACTER VARYING(10) 10
119 S_TOT_CURR_ASSETS_843 CHARACTER VARYING(32) 32
120 S_TOT_CURR_LIAB_844 CHARACTER VARYING(32) 32
121 S_B2BAY_SPARE_39_845 CHARACTER VARYING(10) 10
122 S_DEBT_SERV_COVER_R_846 CHARACTER VARYING(32) 32
123 S_DEBT_SERV_REQ_847 CHARACTER VARYING(32) 32
124 S_DEPRECIATION_848 CHARACTER VARYING(32) 32
125 S_B2BAY_SPARE_40_849 CHARACTER VARYING(10) 10
126 S_DEV_OR_PROP_PSTCODE_850 CHARACTER VARYING(10) 10
127 S_DEV_RELATED_COMMITS_851 CHARACTER VARYING(32) 32
128 S_B2BAY_SPARE_41_852 CHARACTER VARYING(10) 10
129 S_B2BAY_SPARE_42_853 CHARACTER VARYING(10) 10
130 S_EXTRAORD_EXPENSES_854 CHARACTER VARYING(32) 32
131 S_EXTRAORD_INCOME_855 CHARACTER VARYING(32) 32
132 S_EXTRAORD_ITEMS_856 CHARACTER VARYING(32) 32
133 S_FINANCE_LEASE_EXP_857 CHARACTER VARYING(32) 32
134 S_FIT_WITH_NEIGHRHD_858 CHARACTER VARYING(2) 2
135 S_GEOINDUSTRY_SECTOR_859 CHARACTER VARYING(7) 7
136 S_GROSS_REAL_V_EX_GST_860 CHARACTER VARYING(32) 32
137 S_GROSS_RENTAL_INCOME_861 CHARACTER VARYING(32) 32
138 S_EXPERIENCE_862 CHARACTER VARYING(10) 10
139 S_INTANGIBLE_ASSETS_863 CHARACTER VARYING(32) 32
140 S_INTEREST_EXPENSE_864 CHARACTER VARYING(32) 32
141 S_INTERNAL_RATEOFRET_865 CHARACTER VARYING(32) 32
142 S_INVENTORY_866 CHARACTER VARYING(32) 32
143 S_B2BAY_SPARE_43_867 CHARACTER VARYING(10) 10
144 S_B2BAY_SPARE_44_868 CHARACTER VARYING(10) 10
145 S_B2BAY_SPARE_45_869 CHARACTER VARYING(10) 10
146 S_LIVING_ALLOWANCE_870 CHARACTER VARYING(32) 32
147 S_MGMT_INTEGRITY_871 CHARACTER VARYING(2) 2
148 S_MATURITY_CURR_T_872 CHARACTER VARYING(10) 10
149 S_B2BAY_SPARE_46_873 CHARACTER VARYING(10) 10
150 S_B2BAY_SPARE_72_874 CHARACTER VARYING(10) 10
151 S_B2BAY_SPARE_47_875 CHARACTER VARYING(10) 10
152 S_B2BAY_SPARE_66_876 CHARACTER VARYING(10) 10
153 S_NON_CURRENT_ASSETS_877 CHARACTER VARYING(32) 32
154 S_B2BAY_SPARE_48_878 CHARACTER VARYING(10) 10
155 S_NONOPERATING_EXP_879 CHARACTER VARYING(32) 32
156 S_NONOPERATING_INCOME_880 CHARACTER VARYING(32) 32
157 S_N_PROJ_UNDRTN_PRINC_881 CHARACTER VARYING(10) 10
158 S_N_SUCPRJ_COMP_PRINC_882 CHARACTER VARYING(10) 10
159 S_OFFICERS_COMPENS_883 CHARACTER VARYING(32) 32
160 S_B2BAY_SPARE_49_884 CHARACTER VARYING(10) 10
161 S_PAST_PROJ_SUC_R_PCT_885 CHARACTER VARYING(32) 32
162 S_PHY_ATTR_RISK_MGM_P_886 CHARACTER VARYING(7) 7
163 S_B2BAY_SPARE_50_887 CHARACTER VARYING(10) 10
164 S_B2BAY_SPARE_51_888 CHARACTER VARYING(10) 10
165 S_B2BAY_SPARE_52_889 CHARACTER VARYING(10) 10
166 S_B2BAY_SPARE_53_890 CHARACTER VARYING(10) 10
167 S_POST_DDSOP_SM_OBLOC_891 CHARACTER VARYING(32) 32
168 S_POST_DDSOP_SM_PAYAD_892 CHARACTER VARYING(32) 32
169 S_B2BAY_SPARE_54_893 CHARACTER VARYING(10) 10
170 S_B2BAY_SPARE_55_894 CHARACTER VARYING(10) 10
171 S_POST_DDSOP_TOT_NCA_895 CHARACTER VARYING(32) 32
172 S_POST_DDSOP_TOT_NCL_896 CHARACTER VARYING(32) 32
173 S_PRESALES_AMOUNT_897 CHARACTER VARYING(32) 32
174 S_B2BAY_SPARE_73_898 CHARACTER VARYING(10) 10
175 S_PROJECT_COST_899 CHARACTER VARYING(32) 32
176 S_PROJ_COST2GRV_RATIO_900 CHARACTER VARYING(32) 32
177 S_PROJ_GEARING_POS_901 CHARACTER VARYING(32) 32
178 S_PROJECTD_DEBTCOV_R_902 CHARACTER VARYING(32) 32
179 S_PROJECTD_FNDS_ADS_903 CHARACTER VARYING(32) 32
180 S_PROPERTY_CONDITION_904 CHARACTER VARYING(2) 2
181 S_B2BAY_SPARE_56_905 CHARACTER VARYING(10) 10
182 S_B2BAY_SPARE_57_906 CHARACTER VARYING(10) 10
183 S_PRESALES2LOAN_RATIO_907 CHARACTER VARYING(32) 32
184 S_RELTD_PARTYLOANS_A_908 CHARACTER VARYING(32) 32
185 S_RELTD_PARTY_LOANS_L_909 CHARACTER VARYING(32) 32
186 S_RENT_ARREARS_910 CHARACTER VARYING(32) 32
187 S_RENT_ARREARS_PCT_911 CHARACTER VARYING(32) 32
188 S_RENTAL_INCOME_PERF_912 CHARACTER VARYING(32) 32
189 S_SALES_913 CHARACTER VARYING(32) 32
190 S_SIMILARITY_PRE_PROJ_914 CHARACTER VARYING(2) 2
191 S_SRC_OF_SPONSOR_EQ_915 CHARACTER VARYING(2) 2
192 S_TANGIBLE_ASSETS_916 CHARACTER VARYING(32) 32
193 S_TANGIBLE_NET_WORTH_917 CHARACTER VARYING(32) 32
194 S_TRG_SALES2INVST_PCT_918 CHARACTER VARYING(32) 32
195 S_TENANCY_MIX_919 CHARACTER VARYING(7) 7
196 S_TERM_OF_THE_PROJECT_920 CHARACTER VARYING(10) 10
197 S_TOT_LIABILITIES_921 CHARACTER VARYING(32) 32
198 S_TOT_ASSETS_922 CHARACTER VARYING(32) 32
199 S_B2BAY_SPARE_58_923 CHARACTER VARYING(10) 10
200 S_TOT_EXPENSES_924 CHARACTER VARYING(32) 32
201 S_B2BAY_SPARE_59_925 CHARACTER VARYING(10) 10
202 S_B2BAY_SPARE_60_926 CHARACTER VARYING(10) 10
203 S_B2BAY_SPARE_61_927 CHARACTER VARYING(10) 10
204 S_B2BAY_SPARE_62_928 CHARACTER VARYING(10) 10
205 S_TOT_MOTOR_VEHICLE_A_929 CHARACTER VARYING(32) 32
206 S_B2BAY_SPARE_63_930 CHARACTER VARYING(10) 10
207 S_B2BAY_SPARE_64_931 CHARACTER VARYING(10) 10
208 S_B2BAY_SPARE_65_932 CHARACTER VARYING(10) 10
209 S_TOT_PLANT_EQUIP_A_933 CHARACTER VARYING(32) 32
210 S_TRADE_CREDITORS_934 CHARACTER VARYING(32) 32
211 S_VACANCY_PCT_935 CHARACTER VARYING(32) 32
212 S_WRKNG_CAP2SALES_PCT_936 CHARACTER VARYING(32) 32
213 S_WORKING_WITHIN_BUD_937 CHARACTER VARYING(32) 32
214 S_YRS_AS_SELFEMP_DEVL_938 CHARACTER VARYING(32) 32
215 S_ASSET_REVALUATIONS_939 CHARACTER VARYING(32) 32
216 S_COST_OF_GOODS_SOLD_940 CHARACTER VARYING(32) 32
217 S_NET_PRO_B_INT_A_TAX_941 CHARACTER VARYING(32) 32
218 S_PRO_B_TAX_EXTORD_I_942 CHARACTER VARYING(32) 32
219 S_B2BAY_SPARE_5_943 CHARACTER VARYING(10) 10
220 S_B2BAY_SPARE_6_944 CHARACTER VARYING(10) 10
221 S_B2BAY_SPARE_7_945 CHARACTER VARYING(10) 10
222 S_B2BAY_SPARE_8_946 CHARACTER VARYING(10) 10
223 S_B2BAY_SPARE_9_947 CHARACTER VARYING(10) 10
224 S_B2BAY_SPARE_10_948 CHARACTER VARYING(10) 10
225 S_B2BAY_SPARE_11_949 CHARACTER VARYING(10) 10
226 S_B2BAY_SPARE_12_950 CHARACTER VARYING(10) 10
227 S_B2BAY_SPARE_13_951 CHARACTER VARYING(10) 10
228 S_B2BAY_SPARE_14_952 CHARACTER VARYING(10) 10
229 S_B2BAY_SPARE_15_953 CHARACTER VARYING(10) 10
230 S_SUBGROUP_OF_GOODS2_954 CHARACTER VARYING(4) 4
231 S_B2BAY_SPARE_17_955 CHARACTER VARYING(4) 4
232 S_B2BAY_SPARE_18_956 CHARACTER VARYING(4) 4
233 S_B2BAY_SPARE_19_957 CHARACTER VARYING(4) 4
234 S_B2BAY_SPARE_20_958 CHARACTER VARYING(4) 4
235 S_SERVICING_AMT_1061 CHARACTER VARYING(32) 32
236 S_OVERWRITE_DEC_CAT_1062 CHARACTER VARYING(1) 1
237 S_SELFEMP_INC_VAR_1177 CHARACTER VARYING(32) 32