FCT_BNK_QRM_VALUATION_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

Collateral Extract consumed by QRM provinding valuation information per collateral

Columns
# Name Data Type Length
1 VALUATION_ID CHARACTER VARYING(16) 16
2 VALUATION_REQ_REFERENCE CHARACTER VARYING(16) 16
3 VALUER_REFERENCE CHARACTER VARYING(40) 40
4 COLLATERAL_ID CHARACTER VARYING(18) 18
5 COLLATERAL_TYPE CHARACTER VARYING(50) 50
6 COLLATERAL_CATEGORY CHARACTER VARYING(50) 50
7 COLLATERAL_SUB_CATEGORY CHARACTER VARYING(50) 50
8 REPORT_DATE TIMESTAMP 8
9 VERIFICATION_STATUS CHARACTER VARYING(20) 20
10 VALID_TILL TIMESTAMP 8
11 VALUER_COMMENTS CHARACTER VARYING(2000) 2000
12 VALUATION_FEE_AMOUNT BIGINT 8
13 VALUATION_FEE_CURRENCY CHARACTER VARYING(3) 3
14 VALUATION_FEE_DESCRIPTION CHARACTER VARYING(40) 40
15 VALUATION_TYPE CHARACTER VARYING(3) 3
16 VALUATION_MODE CHARACTER VARYING(3) 3
17 DATE_AND_TIME TIMESTAMP 8
18 MARKET_VALUE DOUBLE PRECISION 8
19 COLLATERAL_CCY CHARACTER VARYING(3) 3
20 REPORT_URL CHARACTER VARYING(2000) 2000
21 INVOICE_URL CHARACTER VARYING(2000) 2000
22 PHOTOS_URL CHARACTER VARYING(2000) 2000
23 MAKER_NAME CHARACTER VARYING(254) 254
24 MAKER_DATE TIMESTAMP 8
25 CHECKER_NAME CHARACTER VARYING(254) 254
26 CHECKER_DATE TIMESTAMP 8
27 RECORD_STATUS_TYPE CHARACTER VARYING(1) 1
28 VERSION_NUMBER DOUBLE PRECISION 8
29 LCY_EQUIVALENT DOUBLE PRECISION 8
30 LAND_MARKET_VALUE DOUBLE PRECISION 8
31 BUILDING_MARKET_VALUE DOUBLE PRECISION 8
32 OTHER_VALUE DOUBLE PRECISION 8
33 RANGE_LOW DOUBLE PRECISION 8
34 RANGE_HIGH DOUBLE PRECISION 8
35 MARKET_VALUE_KERBSIDE DOUBLE PRECISION 8
36 NEXT_STAGE_PROGRESS_PAY DOUBLE PRECISION 8
37 YEAR_BUILD DOUBLE PRECISION 8
38 TOTAL_STOREYS DOUBLE PRECISION 8
39 TOTAL_BED_ROOMS DOUBLE PRECISION 8
40 OTHER_ROOMS DOUBLE PRECISION 8
41 ROOF_TYPE CHARACTER VARYING(20) 20
42 WALL_MATERIAL CHARACTER VARYING(20) 20
43 GARAGE_CARPOT_NUMBER DOUBLE PRECISION 8
44 OTHER_DESCRIPTION CHARACTER VARYING(2000) 2000
45 DIMENSION_LENGTH DOUBLE PRECISION 8
46 DIMENSION_WIDTH DOUBLE PRECISION 8
47 AREA_OF_LAND DOUBLE PRECISION 8
48 AREA_OF_BUILDING DOUBLE PRECISION 8
49 TOTAL_VALUE DOUBLE PRECISION 8
50 UNFURNISHED_RENTAL DOUBLE PRECISION 8
51 POWER_AVAILABLE CHARACTER VARYING(3) 3
52 INTERNAL_CONDITION CHARACTER VARYING(20) 20
53 EXTERNAL_CONDITION CHARACTER VARYING(20) 20
54 LIVING_AREA DOUBLE PRECISION 8
55 SITE_AREA DOUBLE PRECISION 8
56 UNITS_OF_SITE CHARACTER VARYING(20) 20
57 ZONING_EFFECT CHARACTER VARYING(20) 20
58 DETRACTIVE_FEATURES CHARACTER VARYING(20) 20
59 VALUATION_DAY DOUBLE PRECISION 8
60 VALUATION_MONTH DOUBLE PRECISION 8
61 VALUATION_YEAR DOUBLE PRECISION 8
62 NEIGHBOURHOOD CHARACTER VARYING(20) 20
63 LAND CHARACTER VARYING(20) 20
64 ENVIRONMENT_ISSUES CHARACTER VARYING(20) 20
65 IMPROVEMENTS CHARACTER VARYING(20) 20
66 REDUCED_VAL_NEXT_YEAR CHARACTER VARYING(20) 20
67 MARKET_VOLATILITY CHARACTER VARYING(20) 20
68 LOCAL_ECONOMY_IMPACT CHARACTER VARYING(20) 20
69 MARKET_SEGMENT_CONDITION CHARACTER VARYING(20) 20
70 CONSTRUCTION CHARACTER VARYING(1) 1
71 STAGE CHARACTER VARYING(40) 40
72 ESTIMATED_REALIZABLE_VALUE DOUBLE PRECISION 8
73 BICOE_STAGE CHARACTER VARYING(40) 40
74 BICOE_COMMENTS CHARACTER VARYING(2000) 2000
75 REAL_ESTATE_CONTRACT_PRICE DOUBLE PRECISION 8
76 RURAL_USAGE CHARACTER VARYING(2000) 2000
77 RESIDENTIAL_TYPE CHARACTER VARYING(40) 40
78 SALES_EVIDENCE_PRICE NUMERIC(18,2) 19
79 COMPARABLES_SALE_ACCP CHARACTER VARYING(2) 2
80 SALES_EVIDENCE_DATE TIMESTAMP 8
81 VACANT_LAND CHARACTER VARYING(1) 1
82 VALUER_ID CHARACTER VARYING(1) 1
83 VALUERS_NAME CHARACTER VARYING(1) 1
84 SHADED_VALUE CHARACTER VARYING(1) 1