obp24_hst_flx_lm_collateral_all_b

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 collateral_id character varying 54
2 collateral_type character varying 150
3 collateral_category character varying 150
4 collateral_sub_category character varying 150
5 collateral_description character varying 765
6 bank_haircut_value smallint 16
7 categorized_haircut_value smallint 16
8 begin_date timestamp without time zone
9 end_date timestamp without time zone
10 review_date timestamp without time zone
11 revaluation_required character varying 3
12 revaluation_date timestamp without time zone
13 available_flag character varying 3
14 categorization_value double precision 53
15 ccy_code character varying 9
16 owner_estimated_value double precision 53
17 capitalization_value double precision 53
18 bank_value_relied_on double precision 53
19 market_value double precision 53
20 bank_value double precision 53
21 repossess_required character varying 3
22 contract_of_sale_value double precision 53
23 contract_of_sale_date timestamp without time zone
24 ownership_type character varying 3
25 exclusive_charge character varying 3
26 valuation_frequency character varying 60
27 address_line1 character varying 105
28 address_line2 character varying 105
29 address_line3 character varying 105
30 address_line4 character varying 105
31 address_city character varying 150
32 address_state character varying 90
33 address_country character varying 90
34 address_zip character varying 90
35 created_by character varying 762
36 creation_date timestamp without time zone
37 last_updated_by character varying 762
38 last_update_date timestamp without time zone
39 object_version_number integer 32
40 object_status_flag character varying 3
41 domain_object_extn character varying 300
42 dedupe_text character varying 4096
43 doc_checklist_id character varying 120
44 parent_collaterals character varying 360
45 address_line5 character varying 360
46 address_line6 character varying 360
47 address_line7 character varying 360
48 address_line8 character varying 360
49 address_line9 character varying 360
50 address_line10 character varying 360
51 address_line11 character varying 360
52 address_line12 character varying 360
53 cdc_source_system_code character varying 12
54 cdc_record_type character varying 48
55 cdc_commit_timestamp timestamp without time zone
56 cdc_extract_timestamp timestamp without time zone