CLL_TCLLF_REALPROPERTY_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ASSET_ID | BIGINT | 8 |
| 2 | INSTRUMENT_NO | CHARACTER VARYING(20) | 20 |
| 3 | REGD_COVANENT_NO | CHARACTER VARYING(100) | 100 |
| 4 | RESTRICT_MINING_RIGHTS_TFR | CHARACTER VARYING(100) | 100 |
| 5 | DEVELOPMENT_ACT_DETAIL | CHARACTER VARYING(100) | 100 |
| 6 | FREEHOLD_OVERLEASE_NO | CHARACTER VARYING(10) | 10 |
| 7 | STATE_LEASE_NO | CHARACTER VARYING(10) | 10 |
| 8 | LEASE_DATE | TIMESTAMP | 8 |
| 9 | LEASE_MATURITY_DATE | TIMESTAMP | 8 |
| 10 | SUBTO_LAND_TAX_FLAG | CHARACTER VARYING(1) | 1 |
| 11 | LAND_SIZE | BIGINT | 8 |
| 12 | BASEL_USE | CHARACTER VARYING(10) | 10 |
| 13 | USE | CHARACTER VARYING(10) | 10 |
| 14 | REVALUATION_PERIOD | BYTEINT | 1 |
| 15 | PROP_UNDER_CONSTRUCT_FLAG | CHARACTER VARYING(1) | 1 |
| 16 | ENVIRONMENT_RISK_FLAG | CHARACTER VARYING(1) | 1 |
| 17 | DISPOSAL_COSTPCT | NUMERIC(5,2) | 19 |
| 18 | TITLE_REFERENCE | BIGINT | 8 |
| 19 | FOLIO_IDENTIFIER | CHARACTER VARYING(15) | 15 |
| 20 | VOLUME | INTEGER | 4 |
| 21 | FOLIO | CHARACTER VARYING(4) | 4 |
| 22 | DWELLING_IND | CHARACTER VARYING(1) | 1 |
| 23 | OCCUPANCY | CHARACTER VARYING(15) | 15 |