Product

Global dimensional table for Product sourced from CRM.

Global DDS Field Field Type

Source Data

Connector: Global

Table: crm_product_gbl_ods__v

Source Data

Connector: Global

Table: crm_product_gbl_ods__v

&

map_crm_product_gbl_ods__v

dim_global_product_id__v bigint n/a n/a
native_id__v varchar(18) |crm_product_vod_id__v|related_id__v|related_source__v| |crm_product_vod_id__v|||
global_product_name__v varchar(240) parent_product_name__vIf no dim_global_product__v.parent_product_name__v, use crm_product_gbl_ods__v.global_product_name__v

parent_product_name__vproduct_type__v = detail (case insensitive) If no dim_global_product__v.parent_product_name__v, use crm_product_gbl_ods__v.global_product_name__v

raw_product_name__v varchar(240) global_product_name__v global_product_name__v
brand__v varchar(240) map_crm_product_gbl_ods__v.display_name__v  
product_country__v varchar(240) map_crm_product_gbl_ods__v.country__v  
product_type__v varchar(765) product_type__v product_type__v
parent_product_id__v varchar(765) parent_product__v parent_product__v
parent_product_name__v varchar(765) global_product_name__v for corresponding record where parent_product__v=native_id__v (look up to same table)&end_date__v is null for lookup

global_product_name__v for corresponding recordwhere parent_product__v=native_id__v(look up to same table)&end_date__v isnull for lookup

therapeutic_area__v varchar(765) therapeutic_area__v therapeutic_area__v
market_name__v varchar(110) map_crm_product_gbl_ods__v.market_name__v  
market_id__v varchar(18) map_crm_product_gbl_ods__v.market_id__v  
therapeutic_class__v varchar(765) therapeutic_class__v therapeutic_class__v
company_product__v boolean company_product__v company_product__v
display_in_reports__v boolean map_crm_product_gbl_ods__v.display_in_reports__v  
last_modifed_date__v timestamp last_modifed_date__v last_modifed_date__v
start_date__v date start_date__v start_date__v
end_date__v date end_date__v end_date__v