FCT_BNK_CRHDS_EXPR_POST_SEC_SHAR_SEC_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Monthly extract of Experian loan security data for secured loans

Columns
# Name Data Type Length
1 MASTER_KEY CHARACTER VARYING(100) 100
2 S_SINGLE_LOAN_FLG_463 CHARACTER VARYING(1) 1
3 S_OWNER_EST_OF_SEC_464 CHARACTER VARYING(32) 32
4 S_NVP_EXCLUSIONS_465 CHARACTER VARYING(4) 4
5 S_RESIDEX_ESTIMATE_466 CHARACTER VARYING(32) 32
6 S_LOAN2PRCH_PRICE_PCT_481 CHARACTER VARYING(32) 32
7 S_LOAN_REGULATED_FLG_533 CHARACTER VARYING(1) 1
8 S_AGG_LVR_536 CHARACTER VARYING(32) 32
9 S_N_ACCPT_SEC_A_APPL_537 CHARACTER VARYING(10) 10
10 S_SPARE_119_538 CHARACTER VARYING(5) 5
11 S_MTGE_INS_STATUS_541 CHARACTER VARYING(1) 1
12 S_ACCEPTABLE_LOC_FLG_556 CHARACTER VARYING(1) 1
13 S_ACCEPTABLE_SEC_FLG_557 CHARACTER VARYING(1) 1
14 S_EXIST_VALUATION_AMT_560 CHARACTER VARYING(32) 32
15 S_SECURITY_LAND_AREA_561 CHARACTER VARYING(32) 32
16 S_SECURITY_POST_CODE_562 CHARACTER VARYING(4) 4
17 S_SECURITY_RESDT_AREA_563 CHARACTER VARYING(32) 32
18 S_SECURITY_TYPE_564 CHARACTER VARYING(3) 3
19 S_SECURITY_ZONING_565 CHARACTER VARYING(5) 5
20 S_T_SINCE_LST_VALUTN_566 CHARACTER VARYING(10) 10
21 S_TOT_VALUATION_AMT_567 CHARACTER VARYING(32) 32
22 S_SECURITY_WAIVER_FLG_568 CHARACTER VARYING(1) 1
23 S_OVERALLVAR2PPRCPCT_569 CHARACTER VARYING(32) 32
24 S_MX_NEGVAR2PPRICEPCT_570 CHARACTER VARYING(32) 32
25 S_SECURITY_TYPES_1179 CHARACTER VARYING(60) 60
26 S_COARSE_PRIMARY_ROLE_395 CHARACTER VARYING(3) 3
27 S_FINE_PRIMARY_ROLE_396 CHARACTER VARYING(3) 3
28 S_PARTY_TYPE_397 CHARACTER VARYING(1) 1
29 S_EXIST_CUST_FLG_398 CHARACTER VARYING(1) 1
30 S_EXIST_LNDG_CUST_399 CHARACTER VARYING(1) 1
31 S_EXIST_CUST_FLG_438 CHARACTER VARYING(1) 1
32 S_EXIST_LNDG_CUST_FLG_439 CHARACTER VARYING(1) 1
33 S_OVERSEAS_BORROWER_441 CHARACTER VARYING(1) 1
34 S_SUSPECTED_FRAUD_FLG_444 CHARACTER VARYING(1) 1
35 S_ASSETS_TO_LIAB_R_468 CHARACTER VARYING(32) 32
36 S_ASSETS_TO_LIAB_R_469 CHARACTER VARYING(32) 32
37 S_ASSETS_TO_LIAB_R_470 CHARACTER VARYING(32) 32
38 S_TOT_CUST_EXPOSURE_504 CHARACTER VARYING(32) 32
39 S_TOT_CUST_EXPOSURE_505 CHARACTER VARYING(32) 32
40 S_TOT_OTH_SPLIT_AMT_507 CHARACTER VARYING(32) 32
41 S_TOT_OSPL_AM_BUS_BNK_508 CHARACTER VARYING(32) 32
42 S_TOT_CUS_EXP_BUS_BNK_509 CHARACTER VARYING(32) 32
43 S_TOT_LIABILITIES_511 CHARACTER VARYING(32) 32
44 S_SPARE_118_520 CHARACTER VARYING(4) 4
45 S_ADD_LOAN_FLG_523 CHARACTER VARYING(1) 1
46 S_LOAN_CLASS_525 CHARACTER VARYING(1) 1
47 S_LOAN_AMT_OR_LIM_RQ_530 CHARACTER VARYING(32) 32
48 S_LOAN_PRODUCT_TYPE_531 CHARACTER VARYING(5) 5
49 S_LOAN_PURPOSE_532 CHARACTER VARYING(3) 3
50 S_LOAN_SUB_PURPOSE_535 CHARACTER VARYING(2) 2
51 S_PRCH_PRICE_550 CHARACTER VARYING(32) 32
52 S_WRST_EXIST_ACCT_GRD_621 CHARACTER VARYING(10) 10
53 S_WRST_EXIST_ACCT_GRD_622 CHARACTER VARYING(10) 10
54 S_WRST_EXIST_ACCT_GRD_623 CHARACTER VARYING(10) 10
55 S_WRST_EXIST_ACCT_GRD_624 CHARACTER VARYING(10) 10
56 S_WRST_EXIST_ACCT_GRD_625 CHARACTER VARYING(10) 10
57 S_WRST_EXIST_ACCT_GRD_627 CHARACTER VARYING(10) 10
58 S_WRST_EXIST_ACCT_GRD_628 CHARACTER VARYING(10) 10
59 S_WRST_EXIST_ACCT_GRD_629 CHARACTER VARYING(10) 10
60 S_WRST_EXIST_ACCT_GRD_630 CHARACTER VARYING(10) 10
61 S_WRST_CUS_RISK_GRADE_631 CHARACTER VARYING(10) 10
62 S_WRST_EXIST_ACCT_GRD_632 CHARACTER VARYING(10) 10
63 S_WRST_EXIST_ACCT_GRD_633 CHARACTER VARYING(10) 10
64 S_WRST_EXIST_ACCT_GRD_634 CHARACTER VARYING(10) 10
65 S_WRST_EXIST_ACCT_GRD_635 CHARACTER VARYING(10) 10
66 S_WRST_EXIST_ACCT_GRD_636 CHARACTER VARYING(10) 10
67 S_WRST_EXIST_ACCT_GRD_637 CHARACTER VARYING(10) 10
68 S_WRST_EXIST_ACCT_GRD_638 CHARACTER VARYING(10) 10
69 S_WRST_EXIST_ACCT_GRD_639 CHARACTER VARYING(10) 10
70 S_WRST_EXIST_ACCT_GRD_640 CHARACTER VARYING(10) 10
71 S_WRST_CUS_RISK_GRADE_641 CHARACTER VARYING(10) 10
72 S_T_MOST_REC_FINCLS_959 CHARACTER VARYING(10) 10
73 S_NUM_OF_DEFS_960 CHARACTER VARYING(10) 10
74 S_NUM_OF_DEFS_961 CHARACTER VARYING(10) 10
75 S_NUM_NON_UTIL_ENQ_962 CHARACTER VARYING(10) 10
76 S_CALCULATED_SSV_963 CHARACTER VARYING(32) 32
77 S_SPARE_6_964 CHARACTER VARYING(10) 10
78 S_SPARE_7_965 CHARACTER VARYING(10) 10
79 S_SPARE_8_966 CHARACTER VARYING(10) 10
80 S_LOW_DOC_FLG_979 CHARACTER VARYING(1) 1
81 S_FIELD_USD_SUNLOANS1_980 CHARACTER VARYING(1) 1
82 S_FIELD_USD_SUNLOANS2_981 CHARACTER VARYING(1) 1
83 S_ACCEPTABLE_SEC_FLG_982 CHARACTER VARYING(1) 1
84 S_SPARE_25_983 CHARACTER VARYING(1) 1
85 S_SPARE_26_984 CHARACTER VARYING(1) 1
86 S_MX_SEC_LAND_AREA_1009 CHARACTER VARYING(10) 10
87 S_SPARE_52_1010 CHARACTER VARYING(32) 32
88 S_SPARE_53_1011 CHARACTER VARYING(32) 32
89 S_SPARE_54_1012 CHARACTER VARYING(32) 32
90 S_SPARE_55_1013 CHARACTER VARYING(32) 32
91 S_SPARE_56_1014 CHARACTER VARYING(10) 10
92 S_SPARE_57_1015 CHARACTER VARYING(10) 10
93 S_SPARE_58_1016 CHARACTER VARYING(10) 10
94 S_LOAN_SUB_PROD_TYPE_1029 CHARACTER VARYING(3) 3
95 S_SPARE_72_1030 CHARACTER VARYING(4) 4
96 S_SPARE_73_1031 CHARACTER VARYING(4) 4
97 S_SPARE_74_1032 CHARACTER VARYING(4) 4
98 S_SPARE_92_1050 CHARACTER VARYING(8) 8
99 S_SPARE_93_1051 CHARACTER VARYING(8) 8
100 S_SPARE_94_1052 CHARACTER VARYING(8) 8
101 S_SPARE_95_1053 CHARACTER VARYING(8) 8
102 S_WITHDRAWN_STATUS CHARACTER VARYING(1) 1
103 S_OVERRIDE_FLG CHARACTER VARYING(1) 1
104 S_OVERRIDE_RSN_CODE CHARACTER VARYING(4) 4
105 S_OVERRIDE_UID CHARACTER VARYING(7) 7
106 S_OVERRIDE_UID_DATE TIMESTAMP 8
107 S_OVERALL_DEC_DATE TIMESTAMP 8
108 S_OVERALL_DEC CHARACTER VARYING(1) 1
109 S_EPMI_FINAL_DEC CHARACTER VARYING(1) 1
110 S_FULFILMENT_FLAG CHARACTER VARYING(1) 1
111 S_APP_DATE TIMESTAMP 8
112 S_FINAL_DECISION CHARACTER VARYING(1) 1