dim_bnk_crai_source_product_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 source_product_dim_id character varying 75
2 source_system_code character varying 36
3 product_type character varying 90
4 product_code character varying 312
5 load_status_flag character varying 3
6 insert_run_audit_id character varying 75
7 update_run_audit_id character varying 75
8 product_description character varying 768
9 product_division character varying 768
10 pd_id character varying 75
11 product_customer_type character varying 450
12 asset_line_flag character varying 450
13 prod_bnk_rltnp_code character varying 450
14 source_product_code_tm1 character varying 450
15 valid_tm1_code character varying 450
16 obp_product_code character varying 450
17 offer_code character varying 150
18 interest_rate_type character varying 150
19 rate_term_months_from character varying 150
20 rate_term_months_to character varying 600
21 rate_term_years character varying 600
22 cdc_source_system_code character varying 450
23 cdc_record_type character varying 450
24 cdc_commit_timestamp character varying 600
25 cdc_extract_timestamp character varying 600