CLL_TCLLF_VALUATION
Description
Synonyms
SDSNZP02_BANK..QRMCGN_CLL_TCLLF_VALUATION
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | VALUATION_ID | BIGINT | 8 |
| 2 | VALUATIONMETHOD | CHARACTER VARYING(10) | 10 |
| 3 | VALUATIONSOURCE | CHARACTER VARYING(10) | 10 |
| 4 | VALUATION_DATE | TIMESTAMP | 8 |
| 5 | VACANT_LAND_FLAG | CHARACTER VARYING(1) | 1 |
| 6 | NUMBER_OF_BEDROOMS | BYTEINT | 1 |
| 7 | NUMBER_OF_BATHROOMS | BYTEINT | 1 |
| 8 | LIVING_FLOOR_AREA | SMALLINT | 2 |
| 9 | INTERNAL_CONDITION | CHARACTER VARYING(10) | 10 |
| 10 | EXTERNAL_CONDITION | CHARACTER VARYING(10) | 10 |
| 11 | YR_RENOVATION_COMPLETED | SMALLINT | 2 |
| 12 | ZONING | CHARACTER VARYING(40) | 40 |
| 13 | EXPECTED_COMPLETION_DATE | TIMESTAMP | 8 |
| 14 | YEAR_OF_CONSTRUCTION | SMALLINT | 2 |
| 15 | MAIN_BUILDING_DESC | CHARACTER VARYING(10) | 10 |
| 16 | VEHICLE_ACCOMODATION_DESC | CHARACTER VARYING(10) | 10 |
| 17 | LAND | NUMERIC(15,2) | 19 |
| 18 | IMPROVEMENT_VALUE | NUMERIC(15,2) | 19 |
| 19 | COLL_MRKT_VALUATION | NUMERIC(15,2) | 19 |
| 20 | BALANCESHEET_VALUE | NUMERIC(15,2) | 19 |
| 21 | INDEX_VALUATION | NUMERIC(15,2) | 19 |
| 22 | TOTAL_CONSTRUCTION_COST | NUMERIC(15,2) | 19 |
| 23 | ONCOMPLETION_VALUE | NUMERIC(15,2) | 19 |
| 24 | VALUER_REPORT_RANGE_MIN | NUMERIC(15,2) | 19 |
| 25 | VALUER_REPORT_RANGE_MAX | NUMERIC(15,2) | 19 |
| 26 | RESIDEX_SECURITY_VALUE | NUMERIC(15,2) | 19 |
| 27 | WATER_ALLOCATION | NUMERIC(15,2) | 19 |
| 28 | STOCK_CROP_VALUE | NUMERIC(15,2) | 19 |
| 29 | LEASE | NUMERIC(15,2) | 19 |
| 30 | BALANCE_OF_ACCOUNT | NUMERIC(15,2) | 19 |
| 31 | MARKET_VALUE_PERSHARE | NUMERIC(15,2) | 19 |
| 32 | BOOK_DEBT | NUMERIC(15,2) | 19 |
| 33 | LONG_SHORTTERM_SECURITY | NUMERIC(15,2) | 19 |
| 34 | ASSET_VALUE | NUMERIC(15,2) | 19 |
| 35 | PURCHASE_PRICE | NUMERIC(15,2) | 19 |
| 36 | BASE_VALUE | NUMERIC(15,2) | 19 |
| 37 | HARD_COST | NUMERIC(15,2) | 19 |
| 38 | SOFT_COST | NUMERIC(15,2) | 19 |
| 39 | GLASSESGUIDE_RANGE_TRDLOW | NUMERIC(15,2) | 19 |
| 40 | GLASSESGUIDE_RANGE_TRADE | NUMERIC(15,2) | 19 |
| 41 | REPLACEMENT_INS_VALUE | NUMERIC(15,2) | 19 |
| 42 | DELETED_FLAG | CHARACTER VARYING(1) | 1 |
| 43 | VALUER_ID | BIGINT | 8 |
| 44 | VALUERS_NAME | CHARACTER VARYING(65) | 65 |
| 45 | SHADED_VALUE | NUMERIC(15,2) | 19 |
| 46 | CREATED_BY | CHARACTER VARYING(7) | 7 |
| 47 | NEXT_VALUATION_DATE | TIMESTAMP | 8 |
| 48 | CREATED_DATE | TIMESTAMP | 8 |
| 49 | MODIFIED_BY | CHARACTER VARYING(7) | 7 |
| 50 | MODIFIED_DATE | TIMESTAMP | 8 |
| 51 | NEIGHBOURHOOD | CHARACTER VARYING(10) | 10 |
| 52 | ENVIRONMENTAL_ISSUES | CHARACTER VARYING(10) | 10 |
| 53 | REDUCED_VALUE | CHARACTER VARYING(10) | 10 |
| 54 | LOCAL_ECONOMY_IMPACT | CHARACTER VARYING(10) | 10 |
| 55 | LAND_VALUE | CHARACTER VARYING(10) | 10 |
| 56 | IMPROVEMENT | CHARACTER VARYING(10) | 10 |
| 57 | MARKET_VOLATILITY | CHARACTER VARYING(10) | 10 |
| 58 | MARKET_SEGMENT_CONDITION | CHARACTER VARYING(10) | 10 |
| 59 | VERSION_NO | INTEGER | 4 |
| 60 | CONTACT_PHONE_NO | CHARACTER VARYING(15) | 15 |
| 61 | OTHER_VALUE | NUMERIC(15,2) | 19 |
| 62 | OTHER_SSV | NUMERIC(15,2) | 19 |
| 63 | OTHER_SSV_PERC | NUMERIC(5,2) | 19 |
| 64 | LAND_SSV | NUMERIC(15,2) | 19 |
| 65 | LAND_SSV_PERC | NUMERIC(5,2) | 19 |
| 66 | BALANCE_AREA_VALUE_SSV | NUMERIC(15,2) | 19 |
| 67 | BALANCE_AREA_VALUE_SSV_PERC | NUMERIC(5,2) | 19 |
| 68 | BALANCE_AREA_VALUE | NUMERIC(15,2) | 19 |
| 69 | ONCOMPLETION_SSV | NUMERIC(15,2) | 19 |
| 70 | ONCOMPLETION_SSV_PERC | NUMERIC(5,2) | 19 |
| 71 | IMPROVEMENTS_SSV | NUMERIC(15,2) | 19 |
| 72 | IMPROVEMENTS_SSV_PERC | NUMERIC(5,2) | 19 |
| 73 | TOTAL_CONST_SSV | NUMERIC(15,2) | 19 |
| 74 | TOTAL_CONST_SSV_PERC | NUMERIC(5,2) | 19 |
| 75 | WATER_ALLOCATION_SSV | NUMERIC(15,2) | 19 |
| 76 | WATER_ALLOCATION_SSV_PERC | NUMERIC(5,2) | 19 |