| 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 |