Vault Product

Global table sourced from Vault product catalog.

Global ODS Field Field Type

Source Data

Connector: Vault

Table: product_ods__v

composite_key__v varchar(100)

|source_connector_name__v|souce_table_name__v|native_id__v|

native_id__v varchar(100) product_ods__v.vault_product_id__v
source_connector_name__v varchar(100) Extracted from Internal Admin Console
source_table_name__v varchar(100) product_ods__v
source_system_id__v varchar(18) Extracted from Internal Admin Console
global_product_name__v varchar(384) product_ods__v.product_name__v
status__v varchar(1280) product_ods__v.status__v
therapeutic_area__v varchar(1280) product_ods__v.therapeutic_area__v
external_id__v varchar(150) produt_ods__v.external_id_vod__v
start_date__v timestamp product_ods__v.start_date__v
end_date__v timestamp product_ods__v.end_date__v
last_modified_date__v timestamp product_ods__v.modified_date__v