FCT_BNK_CRHDS_EXPR_POST_SEC_SHAR_UNSEC_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian loan security data for unsecured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 U_SINGLE_LOAN_FLG_463 CHARACTER VARYING(1) 1
3 U_OWNER_EST_OF_SEC_464 CHARACTER VARYING(32) 32
4 U_NVP_EXCLUSIONS_465 CHARACTER VARYING(4) 4
5 U_RESIDEX_ESTIMATE_466 CHARACTER VARYING(32) 32
6 U_LOAN2PRCH_PRICE_PCT_481 CHARACTER VARYING(32) 32
7 U_LOAN_REGULATED_FLG_533 CHARACTER VARYING(1) 1
8 U_AGG_LVR_536 CHARACTER VARYING(32) 32
9 U_N_ACCPT_SEC_A_APPL_537 CHARACTER VARYING(10) 10
10 U_SPARE_119_538 CHARACTER VARYING(5) 5
11 U_MTGE_INS_STATUS_541 CHARACTER VARYING(1) 1
12 U_ACCEPTABLE_LOC_FLG_556 CHARACTER VARYING(1) 1
13 U_ACCEPTABLE_SEC_FLG_557 CHARACTER VARYING(1) 1
14 U_EXIST_VALUATION_AMT_560 CHARACTER VARYING(32) 32
15 U_SECURITY_LAND_AREA_561 CHARACTER VARYING(32) 32
16 U_SECURITY_POST_CODE_562 CHARACTER VARYING(4) 4
17 U_SECURITY_RESDT_AREA_563 CHARACTER VARYING(32) 32
18 U_SECURITY_TYPE_564 CHARACTER VARYING(3) 3
19 U_SECURITY_ZONING_565 CHARACTER VARYING(5) 5
20 U_T_SINCE_LST_VALUTN_566 CHARACTER VARYING(10) 10
21 U_TOT_VALUATION_AMT_567 CHARACTER VARYING(32) 32
22 U_SECURITY_WAIVER_FLG_568 CHARACTER VARYING(1) 1
23 U_OVERALLVAR2PPRCPCT_569 CHARACTER VARYING(32) 32
24 U_MX_NEGVAR2PPRICEPCT_570 CHARACTER VARYING(32) 32
25 U_SECURITY_TYPES_1179 CHARACTER VARYING(60) 60
26 U_COARSE_PRIMARY_ROLE_395 CHARACTER VARYING(3) 3
27 U_FINE_PRIMARY_ROLE_396 CHARACTER VARYING(3) 3
28 U_PARTY_TYPE_397 CHARACTER VARYING(1) 1
29 U_EXIST_CUST_FLG_398 CHARACTER VARYING(1) 1
30 U_EXIST_LNDG_CUST_399 CHARACTER VARYING(1) 1
31 U_EXIST_CUST_FLG_438 CHARACTER VARYING(1) 1
32 U_EXIST_LNDG_CUST_FLG_439 CHARACTER VARYING(1) 1
33 U_OVERSEAS_BORROWER_441 CHARACTER VARYING(1) 1
34 U_SUSPECTED_FRAUD_FLG_444 CHARACTER VARYING(1) 1
35 U_ASSETS_TO_LIAB_R_468 CHARACTER VARYING(32) 32
36 U_ASSETS_TO_LIAB_R_469 CHARACTER VARYING(32) 32
37 U_ASSETS_TO_LIAB_R_470 CHARACTER VARYING(32) 32
38 U_TOT_CUST_EXPOSURE_504 CHARACTER VARYING(32) 32
39 U_TOT_CUST_EXPOSURE_505 CHARACTER VARYING(32) 32
40 U_TOT_OTH_SPLIT_AMT_507 CHARACTER VARYING(32) 32
41 U_TOT_OSPL_AM_BUS_BNK_508 CHARACTER VARYING(32) 32
42 U_TOT_CUS_EXP_BUS_BNK_509 CHARACTER VARYING(32) 32
43 U_TOT_LIABILITIES_511 CHARACTER VARYING(32) 32
44 U_SPARE_118_520 CHARACTER VARYING(4) 4
45 U_ADD_LOAN_FLG_523 CHARACTER VARYING(1) 1
46 U_LOAN_CLASS_525 CHARACTER VARYING(1) 1
47 U_LOAN_AMT_OR_LIM_RQ_530 CHARACTER VARYING(32) 32
48 U_LOAN_PRODUCT_TYPE_531 CHARACTER VARYING(5) 5
49 U_LOAN_PURPOSE_532 CHARACTER VARYING(3) 3
50 U_LOAN_SUB_PURPOSE_535 CHARACTER VARYING(2) 2
51 U_PRCH_PRICE_550 CHARACTER VARYING(32) 32
52 U_WRST_EXIST_ACCT_GRD_621 CHARACTER VARYING(10) 10
53 U_WRST_EXIST_ACCT_GRD_622 CHARACTER VARYING(10) 10
54 U_WRST_EXIST_ACCT_GRD_623 CHARACTER VARYING(10) 10
55 U_WRST_EXIST_ACCT_GRD_624 CHARACTER VARYING(10) 10
56 U_WRST_EXIST_ACCT_GRD_625 CHARACTER VARYING(10) 10
57 U_WRST_EXIST_ACCT_GRD_627 CHARACTER VARYING(10) 10
58 U_WRST_EXIST_ACCT_GRD_628 CHARACTER VARYING(10) 10
59 U_WRST_EXIST_ACCT_GRD_629 CHARACTER VARYING(10) 10
60 U_WRST_EXIST_ACCT_GRD_630 CHARACTER VARYING(10) 10
61 U_WRST_CUS_RISK_GRADE_631 CHARACTER VARYING(10) 10
62 U_WRST_EXIST_ACCT_GRD_632 CHARACTER VARYING(10) 10
63 U_WRST_EXIST_ACCT_GRD_633 CHARACTER VARYING(10) 10
64 U_WRST_EXIST_ACCT_GRD_634 CHARACTER VARYING(10) 10
65 U_WRST_EXIST_ACCT_GRD_635 CHARACTER VARYING(10) 10
66 U_WRST_EXIST_ACCT_GRD_636 CHARACTER VARYING(10) 10
67 U_WRST_EXIST_ACCT_GRD_637 CHARACTER VARYING(10) 10
68 U_WRST_EXIST_ACCT_GRD_638 CHARACTER VARYING(10) 10
69 U_WRST_EXIST_ACCT_GRD_639 CHARACTER VARYING(10) 10
70 U_WRST_EXIST_ACCT_GRD_640 CHARACTER VARYING(10) 10
71 U_WRST_CUS_RISK_GRADE_641 CHARACTER VARYING(10) 10
72 U_T_MOST_REC_FINCLS_959 CHARACTER VARYING(10) 10
73 U_NUM_OF_DEFS_960 CHARACTER VARYING(10) 10
74 U_NUM_OF_DEFS_961 CHARACTER VARYING(10) 10
75 U_NUM_NON_UTIL_ENQ_962 CHARACTER VARYING(10) 10
76 U_CALCULATED_SSV_963 CHARACTER VARYING(32) 32
77 U_SPARE_6_964 CHARACTER VARYING(10) 10
78 U_SPARE_7_965 CHARACTER VARYING(10) 10
79 U_SPARE_8_966 CHARACTER VARYING(10) 10
80 U_LOW_DOC_FLG_979 CHARACTER VARYING(1) 1
81 U_FIELD_USD_SUNLOANS1_980 CHARACTER VARYING(1) 1
82 U_FIELD_USD_SUNLOANS2_981 CHARACTER VARYING(1) 1
83 U_ACCEPTABLE_SEC_FLG_982 CHARACTER VARYING(1) 1
84 U_SPARE_25_983 CHARACTER VARYING(1) 1
85 U_SPARE_26_984 CHARACTER VARYING(1) 1
86 U_MX_SEC_LAND_AREA_1009 CHARACTER VARYING(10) 10
87 U_SPARE_52_1010 CHARACTER VARYING(32) 32
88 U_SPARE_53_1011 CHARACTER VARYING(32) 32
89 U_SPARE_54_1012 CHARACTER VARYING(32) 32
90 U_SPARE_55_1013 CHARACTER VARYING(32) 32
91 U_SPARE_56_1014 CHARACTER VARYING(10) 10
92 U_SPARE_57_1015 CHARACTER VARYING(10) 10
93 U_SPARE_58_1016 CHARACTER VARYING(10) 10
94 U_LOAN_SUB_PROD_TYPE_1029 CHARACTER VARYING(3) 3
95 U_SPARE_72_1030 CHARACTER VARYING(4) 4
96 U_SPARE_73_1031 CHARACTER VARYING(4) 4
97 U_SPARE_74_1032 CHARACTER VARYING(4) 4
98 U_SPARE_92_1050 CHARACTER VARYING(8) 8
99 U_SPARE_93_1051 CHARACTER VARYING(8) 8
100 U_SPARE_94_1052 CHARACTER VARYING(8) 8
101 U_SPARE_95_1053 CHARACTER VARYING(8) 8
102 U_WITHDRAWN_STATUS CHARACTER VARYING(1) 1
103 U_OVERRIDE_FLG CHARACTER VARYING(1) 1
104 U_OVERRIDE_RSN_CODE CHARACTER VARYING(4) 4
105 U_OVERRIDE_UID CHARACTER VARYING(7) 7
106 U_OVERRIDE_UID_DATE TIMESTAMP 8
107 U_OVERALL_DEC_DATE TIMESTAMP 8
108 U_OVERALL_DEC CHARACTER VARYING(1) 1
109 U_EPMI_FINAL_DEC CHARACTER VARYING(1) 1
110 U_FULFILMENT_FLAG CHARACTER VARYING(1) 1
111 U_APP_DATE TIMESTAMP 8
112 U_FINAL_DECISION CHARACTER VARYING(1) 1