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