OBP24_HST_FLX_LM_CVAL_PROPERTY_RES
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_HST_FLX_LM_CVAL_PROPERTY_RES
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REPORT_REFERENCE | CHARACTER VARYING(16) | 16 |
| 2 | LCY_EQUIVALENT | DOUBLE PRECISION | 8 |
| 3 | VALUE_CURRENCY_CODE | CHARACTER VARYING(3) | 3 |
| 4 | LAND_MKT_VALUE | DOUBLE PRECISION | 8 |
| 5 | BUILDING_MKT_VALUE | DOUBLE PRECISION | 8 |
| 6 | OTHER_VALUE | DOUBLE PRECISION | 8 |
| 7 | RANGE_LOW | DOUBLE PRECISION | 8 |
| 8 | RANGE_HIGH | DOUBLE PRECISION | 8 |
| 9 | MKT_VALUE_KERBSIDE | DOUBLE PRECISION | 8 |
| 10 | NEXT_STAGE_PROGRESS_PAY | DOUBLE PRECISION | 8 |
| 11 | YEAR_BUILD | DOUBLE PRECISION | 8 |
| 12 | TOTAL_STOREYS | DOUBLE PRECISION | 8 |
| 13 | TOTAL_BED_ROOMS | DOUBLE PRECISION | 8 |
| 14 | OTHER_ROOMS | DOUBLE PRECISION | 8 |
| 15 | ROOF_TYPE | CHARACTER VARYING(20) | 20 |
| 16 | WALL_MATERIAL | CHARACTER VARYING(20) | 20 |
| 17 | GARAGE_OR_CARPOT_NO | DOUBLE PRECISION | 8 |
| 18 | OTHER_DESCRIPTION | CHARACTER VARYING(2000) | 2000 |
| 19 | DIMENSION_LENGTH | DOUBLE PRECISION | 8 |
| 20 | DIMENSION_WIDTH | DOUBLE PRECISION | 8 |
| 21 | AREA_OF_LAND | DOUBLE PRECISION | 8 |
| 22 | AREA_OF_BUILDING | DOUBLE PRECISION | 8 |
| 23 | TOTAL_VALUE | DOUBLE PRECISION | 8 |
| 24 | UNFURNISHED_RENTAL | DOUBLE PRECISION | 8 |
| 25 | POWER_AVAILABLE | CHARACTER VARYING(3) | 3 |
| 26 | INTERNAL_CONDITION | CHARACTER VARYING(20) | 20 |
| 27 | EXTERNAL_CONDITION | CHARACTER VARYING(20) | 20 |
| 28 | LIVING_AREA | DOUBLE PRECISION | 8 |
| 29 | SITE_AREA | DOUBLE PRECISION | 8 |
| 30 | UNITS_OF_SITE | CHARACTER VARYING(20) | 20 |
| 31 | ZONING_EFFECT | CHARACTER VARYING(20) | 20 |
| 32 | DETRACTIVE_FEATURES | CHARACTER VARYING(20) | 20 |
| 33 | VALUATION_DAY | DOUBLE PRECISION | 8 |
| 34 | VALUATION_MONTH | DOUBLE PRECISION | 8 |
| 35 | VALUATION_YEAR | DOUBLE PRECISION | 8 |
| 36 | NEIGHBOURHOOD | CHARACTER VARYING(20) | 20 |
| 37 | LAND | CHARACTER VARYING(20) | 20 |
| 38 | ENVIRONMENT_ISSUES | CHARACTER VARYING(20) | 20 |
| 39 | IMPROVEMENTS | CHARACTER VARYING(20) | 20 |
| 40 | REDUCED_VAL_NEXT_YEAR | CHARACTER VARYING(20) | 20 |
| 41 | MARKET_VOLATILITY | CHARACTER VARYING(20) | 20 |
| 42 | LOCAL_ECONOMY_IMPACT | CHARACTER VARYING(20) | 20 |
| 43 | MARKET_SEGMENT_CONDITION | CHARACTER VARYING(20) | 20 |
| 44 | CONSTRUCTION | CHARACTER VARYING(1) | 1 |
| 45 | STAGE | CHARACTER VARYING(40) | 40 |
| 46 | ESTIMATED_REALIZABLE_VALUE | DOUBLE PRECISION | 8 |
| 47 | BICOE_STAGE | CHARACTER VARYING(40) | 40 |
| 48 | BICOE_COMMENTS | CHARACTER VARYING(2000) | 2000 |
| 49 | REAL_ESTATE_CONTRACT_PRICE | DOUBLE PRECISION | 8 |
| 50 | RURAL_USAGE | CHARACTER VARYING(2000) | 2000 |
| 51 | RESIDENTIAL_TYPE | CHARACTER VARYING(40) | 40 |
| 52 | SALES_EVIDENCE_PRICE | DOUBLE PRECISION | 8 |
| 53 | COMPARABLES_SALE_ACCP | CHARACTER VARYING(2) | 2 |
| 54 | SALES_EVIDENCE_DATE | TIMESTAMP | 8 |
| 55 | VACANT_LAND | CHARACTER VARYING(1) | 1 |
| 56 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 57 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 58 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 59 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |