fct_obp_crai_collateral_insight

Database

prod_bank_wealth

Schema

sor_bdw

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 6000
6 bank_haircut_value character varying 1500
7 categorized_haircut_value character varying 30
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 character varying 75
15 ccy_code character varying 9
16 owner_estimated_value character varying 75
17 capitalization_value character varying 75
18 bank_value_relied_on character varying 75
19 market_value character varying 75
20 bank_value character varying 75
21 repossess_required character varying 3
22 contract_of_sale_value character varying 75
23 contract_of_sale_date character varying 60
24 ownership_type character varying 30
25 exclusive_charge character varying 3
26 valuation_frequency character varying 60
27 dedupe_text character varying 75
28 address_line1 character varying 105
29 address_line2 character varying 105
30 address_line3 character varying 105
31 address_line4 character varying 105
32 address_city character varying 150
33 address_state character varying 90
34 address_country character varying 90
35 address_zip character varying 90
36 object_status_flag character varying 30
37 cdc_record_type character varying 48
38 cdc_source_system_code character varying 30
39 cdc_extract_timestamp character varying 600
40 effective_start_timestamp character varying 600
41 effective_end_timestamp character varying 600
42 comments character varying 765
43 is_current_for_end_of_day character varying 30
44 business_end_of_day_date date
45 is_current character varying 30