Global Customer Interaction Repository (CIR)
Provides a conformed table with activity information Veeva CRM. Mappings are delivered enabled by default.
| Global ODS Field | Type |
Source Data Connector: CRM Table: call2_vod_ods__v |
Source Data Connector: CRM Table: call2_detail_vod_ods__v |
Source Dat a Connector: CRM Table: sent_email_vod_ods__v |
Source Data Connector: CRM Table: call2_key_message_vod_ods__v |
Source Data Connector: CRM Table: remote_meeting_attendee_vod_ods__v |
Source Data Connector: CRM Table: event_attendee_vod_ods__v |
Source Data Connector: CRM Table: em_attendee_vod_ods__v |
Source Data Connector: CRM Table: medica_inquiry_vod_ods__v |
Source Data Connector: CRM Table: call2_sample_vod_ods__v |
|---|---|---|---|---|---|---|---|---|---|---|
| composite_key__v | varchar(125) | |connector_name__v|crm_call2_vod_id__v|start_date__v|end_date__v| | |connector_name__v|call2_detail_vod_id__v|start_date__v|end_date__v| | |connector_name__v|crm_sent_email_vod_id__v| start_date__v|end_date__v| | |connector_name__v|crm_call2_key_message_vod_id__v| start_date__v|end_date__v| | |connector_name__v|crm_remote_meeting_attendee_vod_id__v| start_date__v|end_date__v| | |connector_name__v|crm_event_attendee_vod_id__v| start_date__v|end_date__v| | |connector_name__v|crm_em_attendee_vod_id__v| start_date__v|end_date__v| | |connector_name__v|crm_medical_inquiry_vod__v| start_date__v|end_date__v| | |connector_name__v|crm_call2_sample_vod_id__v|start_date__v|end_date__v| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | CRM Org ID |
| native_id__v | varchar(18) | crm_call2_vod_id__v | call2_detail_vod_id__v | crm_sent_email_vod_id__v | crm_call2_key_message_vod_id__v | crm_remote_meeting_attendee_vod_id__v | crm_event_attendee_vod_id__v | crm_em_attendee_vod__v | crm_medical_inquiry_vod__v | crm_call2_sample_vod_id__v |
| source_connector_name__v | varchar(100) | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name where data resides |
| source_table_name__v | varchar(100) | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | call2_sample_vod_ods__v |
| account__v | varchar(18) | account_vod__v | related call2_vod__v record:call2_vod__v.account_vod__v | account_vod__v | related call2_vod__v record:call2_vod__v.account_vod__v | related call2_vod__v record:call2_vod__v.account_vod__v | account_vod__v | account_vod__v | account_vod__v | account_vod__v |
| date__v | date | call_date_vod__v | related call2_vod__v record:call2_vod__v.call_date_vod__v | sent_date_vod__vmay be null | related call2_vod__v record:call2_vod__v.call_date_vod__v | related call2_vod__v record:call2_vod__v.call_date_vod__v | createddate__v | createddate__v | createddate__v | call_date_vod__v |
| user__v | varchar(18) | ownerid__v | related call2_vod__v record:call2_vod__v.owner__v | ownerid__v | related call2_vod__v record:call2_vod__v.owner__v | related call2_vod__v record:call2_vod__v.owner__v | related medical_event_vod__v record:medical_event_vod__v.ownerid__v | related em_event_vod__v record:em_event_vod__v.ownerid__v | createdbyid__v | call2_vod__v.owner__v |
| product__v | varchar(18) | null | product_vod__v | product_vod__v | product_vod__v | call2_detail_vod__v record:product_vod__v | null | null | product_vod__v (may be null) | product_vod__v |
| veeva_activity_channel__v | varchar(25) | remote_meeting_vod__vif populated = Engageif null = F2F | related call2_vod__v.remote_meeting_vod__vif populated = Engageif null = F2F | Approved Email | related call2_vod__v.remote_meeting_vod__vif populated = Engageif null = F2F | Engage | If em_attendee_vod__v is populated: Events ManagementIf em_attendee_vod__v is null: Medical Event | Events Management | Medical Inquiry | Sample |
| configurable_channel__v | varchar(25) | remote_meeting_vod__vif populated = Engageif null = F2F | related call2_vod__v.remote_meeting_vod__vif populated = Engageif null = F2F | Approved Email | related call2_vod__v.remote_meeting_vod__vif populated = Engageif null = F2F | Engage | If em_attendee_vod__v is populated: Events ManagementIf em_attendee_vod__v is null: Medical Event | Events Management | Medical Inquiry | Sample |
| status__v | varchar(765) | status_vod__v | related call2_vod__v record:call2_vod__v.status_vod__v | status_vod__v | related call2_vod__v record:call2_vod__v.status_vod__v | related remote_meeting_vod__v record:meeting_outcome_status_vod__v | related medical_event_vod__v record:medical_event_vod__v.status_vod__v | related em_event_vod__v record:em_event_vod__v.status_vod__v | status_vod__v | delivery_status_vod__v |
| activity_type__v | varchar(765) | call_type_vod__v | related call2_vod__v record:call2_vod__v. call_type_vod__v | sent_email_vod_recordtype__v = record_type__v.crm_record_type_id__vrecord_type__v.name__v | related call2_vod__v record:call2_vod__v. call_type_vod__v | related call2_vod__v record:call2_vod__v. call_type_vod__v | null | related record_type__v record:record_type__v.name__v | delivery_method_vod__v | call2_vod__v.call_type__v |
| territory_name_stamped__v | varchar(300) | territory_vod__v | territory_vod__v | territory_vod__v | related call2_vod__v record:territory_vod__v | related call2_vod__v record:territory_vod__v | null | null | null | call2_vod__v.territory_vod__v |
| remote_meeting_id__v | varchar(18) | remote_meeting_vod__v | related call2_vod__v record:remote_meeting_vod__v | null | related call2_vod__v record:remote_meeting_vod__v | remote_meeting_vod__v | null | null | null | call_vod__v.remote_meeting_vod__v |
| is_parent_activity__v | numeric(18) | is_parent_call_vod__v | is_parent_call_vod__v | null | related call2_vod__v record:is_parent_call_vod__v | related call2_vod__v record:is_parent_call_vod__v | null | related em_event_vod__v record:if em_event_vod__v.parent_event_vod__v has value then "1" if null then "0" | null | is_parent_call_vod__v |
| parent_activity__v | varchar(18) | parent_call_vod__v | related call2_vod__v record:call2_vod__v.parent_call_vod__v | null | related call2_vod__v record:call2_vod__v.parent_call_vod__v | related call2_vod__v record:call2_vod__v.parent_call_vod__v | null | related em_event_vod__v record:em_event_vod__v.parent_event_vod__v | null | call2_vod__v.parent_call_vod__v |
| call2_vod__v | varchar(18) | null | call2_vod__v | call2_vod__v | call2_vod__v | call2_vod__v | null | null | call2_vod__v | call2_vod__v |
| isdeleted__v | boolean | isdeleted__v | related call2_vod__v record:call2_vod__v.isdeleted__v | isdeleted__v | isdeleted__v | isdeleted__v | isdeleted__v | isdeleted__v | isdeleted__v | isdeleted__v |
| template_name__v | varchar(18) | null | null | crm_approved_document_vod_id__v | null | null | null | null | null | |
| presentation_name__v | varchar(240) | null | null | null | Join from call2_key_message to clm_presentation:clm_presentation_vod__v.clm_presentation_vod_name__v | null | null | null | null | |
| key_message_name__v | varchar(240) | null | null | null | key_message_vod__v | null | null | null | null | |
| vault_document_id__v | varchar(300) | null | null | related approved_document_vod_v records: approved_document_vod__v.document_id_vod__vValue info after first __ | related key_message_vod__v records: key_message_vod__v.vault_doc_id__v | null | null | null | null | |
| vault_document_version__v | varchar(300) | null | null | related approved_document_vod_v records: approved_document_vod__v.document_id_vod__vValue info after second __ | related key_message_vod__v records: key_message_vod__v.slide_version_vod__v | null | null | null | ||
| vault_instance_id__v | varchar(300) | null | null | related approved_document_vod_v records: approved_document_vod__v.vault_instance_id__v | related key_message_vod__v records: key_message_vod__v.vault_dns_vod__v | null | null | null | null | |
| vault_guid__v | varchar(300) | null | null | null | related key_message_vod__v records: key_message_vod__v.vault_guid__v | null | null | null | ||
| opened_vod__v | numeric(18) | null | null | opened_vod__v | null | null | null | null | null | |
| click_count_vod__v | numeric(18) | null | null | click_count_vod__v | null | null | null | null | null | |
| content_displayed__v | boolean | clm_vod__v | null | null | field: clm_id_vod__vif contains value = Trueif null = False | null | null | null | null | |
| duration__v | numeric(14) | null | null | null | duration_vod__v | meeting_duration_vod__v | null | null | null | |
| attendee_type__v | numeric(18) | null | null | null | null | attendee_type_vod__v | attendee_type_vod__v | attendee_type_vod__v | null | |
| lot_number__v | varchar(240) | null | null | null | null | null | null | null | null | lot_vod__v |
| quantity__v | numeric(6) | null | null | null | null | null | null | null | null | quantity_vod__v |
| start_date__v | timestamp | start_date__v | start_date__v | start_date__v | start_date__v | start_date__v | start_date__v | start_date__v | start_date__v | start_date__v |
| end_date__v | timestamp | end_date__v | end_date__v | end_date__v | end_date__v | end_date__v | end_date__v | end_date__v | end_date__v | end_date__v |
