obp24_hst_flx_lm_realestate

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 collateral_id character varying 54
2 adverse_arrears_comments character varying 6000
3 doc_description character varying 6000
4 area_of_land numeric 24
5 building_size numeric 24
6 number_of_garages double precision 53
7 number_of_stories double precision 53
8 other_room character varying 60
9 dimension_length numeric 24
10 dimension_width numeric 24
11 land_size double precision 53
12 purchase_date timestamp without time zone
13 roof_type character varying 60
14 wall_material character varying 60
15 year_built double precision 53
16 area_unit_code character varying 60
17 underconstruction_flag character varying 3
18 income_producing_flag character varying 3
19 restricted_flag character varying 3
20 basel_use_type character varying 150
21 lease_number character varying 30
22 lease_date timestamp without time zone
23 lease_maturity_date timestamp without time zone
24 lease_rent_paid_date timestamp without time zone
25 lease_term double precision 53
26 lease_term_days double precision 53
27 lease_term_months double precision 53
28 landlord_name character varying 150
29 landlord_address character varying 900
30 cdc_source_system_code character varying 12
31 cdc_record_type character varying 48
32 cdc_commit_timestamp timestamp without time zone
33 cdc_extract_timestamp timestamp without time zone