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 Data 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 | Source Data Connector: CRM Table: medical_discussion_vod_ods__v | Source Data Connector: CRM Table: medical_insight_vod_ods__v | Source Data Connector: CRM Table: survey_vod_ods__v | Source Data Connector: CRM Table: survey_target_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| | |connector_name__v|crm_medical_discussion_vod_id__v|start_date__v|end_date__v| | |connector_name__v|crm_medical_insight_vod_id__v|start_date__v|end_date__v| | |connector_name__v|crm_survey_vod_id__v|start_date__v|end_date__v| | |connector_name__v|crm_survey_target_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 | CRM Org ID | CRM Org ID | CRM Org 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 | crm_medical_discussion_vod_id__v | crm_medical_insight_vod_id__v | crm_survey_vod_id__v | crm_survey_target_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 | Connector Name | Connector Name | Connector Name | Connector Name |
| 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 | medical_discussion_vod_ods__v | medical_insight_vod_ods__v | survey_vod_ods__v | survey_target_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 | 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 | call_date_vod__v | date_vod__v | createddate__v | completed_datetime_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 | ownerid__v | ownerid__v | ownerid__v | ownerid__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 | product_vod__v | product_vod__v | 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 | related call2_vod__v.remote_meeting_vod__v if populated = "Engage" if null = "F2F" | "Medical Insights" | "Survey" | "Survey Target" |
| 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 | related call2_vod__v.remote_meeting_vod__v if populated = "Engage" if null = "F2F" | "Medical Insights" | "Survey" | "Survey Target" |
| 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 | related call2_vod__v record:call2_vod__v.status_vod__v join from medical_discussion_vod__v.interaction_vod__v to call2_vod__v.crm_call2_vod__v | status_vod__v | status_vod__v | 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 | related: call2_vod__v record:call2_vod__v. call_type_vod__vjoin from medical_discussion_vod__v.interaction_vod__v to call2_vod__v.crm_call2_vod__v | medical_insight_vod_recordtype__v need to join to recordtype__v to get recordtype__v.name__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 | related call2_vod__v record:call2_vod__v.territory_vod__v join from medical_discussion_vod__v.interaction_vod__v to call2_vod__v.crm_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 | related call2_vod__v record: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 | related call2_vod__v record:call2_vod__v.is_parent_call_vod__vjoin from medical_discussion_vod__v.interaction_vod__v to call2_vod__v.crm_call2_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 | related call2_vod__v record: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 | interaction_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 | 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 | survey_vod_name__v | related survey_vod__v record: survey_vod__v.survey_vod_name__v | |||
| 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 | target_type_vod__v | ||||
| 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 | ||||
| veeva_standard_channel__v | varchar(765) | call_channel_vod__v | related call2_vod__v record:call_channel_vod__v | null | related call2_vod__v record:call_channel_vod__v | related call2_vod__v record:call_channel_vod__v | null | null | null | related call2_vod__v record:call_channel_vod__v | related call2_vod__v record:call_channel_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 | 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 | end_date__v | end_date__v | end_date__v | end_date__v |
