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 |
