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