Global Customer Interaction Repository (CIR) - Vault
Provides a conformed table with activity information Vault CRM. Mappings are delivered enabled by default.
| Global ODS Field | Type |
Source Data Connector: Vault CRM Table: call2__v |
Source Data Connector: Vault CRM Table: call2_detail__v |
Source Data Connector: Vault CRM Table: call2_key_message__v |
Source Data Connector: Vault CRM Table: sent_email__v |
Source Data Connector: Vault CRM Table: remote_meeting_attendee__v |
Source Data Connector: Vault CRM Table: event_attendee__v |
Source Data Connector: Vault CRM Table: medical_inquiry__v |
Source Data Connector: Vault CRM Table: medical_discussion__v |
Source Data Connector: Vault CRM Table: medical_insights__v |
Source Data Connector: Vault CRM Table: survey__v |
Source Data Connector: Vault CRM Table: survey_target__v |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| composite_key__v | varhcar(2550) | |connector_name__v|vault_call2_id__v|start_date__v|end_date__v| | |connector_name__v|vault_call2_detail_id__v|start_date__v|end_date__v| | |connector_name__v|vault_call2_key_message_id__v| start_date__v|end_date__v| | |connector_name__v|vault_sent_email_id__v| start_date__v|end_date__v| | |connector_name__v|vault_remote_meeting_attendee_id__v| start_date__v|end_date__v| | |connector_name__v|vault_event_attendee_id__v| start_date__v|end_date__v| | |connector_name__v|vault_medical_inquiry__v| start_date__v|end_date__v| | |connector_name__v|vault_medical_discussion_id__v|start_date__v|end_date__v| | |connector_name__v|vault_medical_insight_id__v|start_date__v|end_date__v| | |connector_name__v|vault_survey_id__v|start_date__v|end_date__v| | |connector_name__v|vault_survey_target_id__v|start_date__v|end_date__v| |
| source_system_id__v | varchar(500) | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID | Vault ID |
| native_id__v | varchar(1000) | vault_call2_id__v | vault_call2_detail_id__v | vault_call2_key_message_id__v | vault_sent_email_id__v | vault_remote_meeting_attendee_id__v | vault_event_attendee_id__v | vault_medical_inquiry__v | vault_medical_discussion_id__v | vault_medical_insight_id__v | vault_survey_id__v | vault_survey_target_id__v |
| source_connector_name__v | varchar(500) | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name | Connector Name |
| source_table_name__v | varchar(500) | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS |
| account__v | varchar(100) | account___v | related call2__v record:call2__v.account__v | related call2__v record:call2__v.account__v | account__v | related call2__v record:call2__v.account__v | account__v | account__v | account_vod__v | account__v | account__v | |
| date__v | date | call_date___v | related call2__v record:call2__v.call_date__v | related call2__v record:call2__v.call_date__v | sent_date__vmay be null | related call2__v record:call2__v.call_date__v | createddate__v | createddate__v | call_date_vod__v | date__v | createddate__v | completed_datetime__v |
| user__v | varchar(1000) | ownerid__v | related call2__v record:call2__v.ownerid__v | related call2__v record:call2__v.ownerid__v | ownerid__v | related call2__v record:call2__v.ownerid__v | related medical_event__v record:medical_event__v.ownerid__v | createdbyid__v | ownerid__v | ownerid__v | ownerid__v | ownerid__v |
| product__v | varchar(1000) | product_vod__v | product__v | product__v | call2_detail__v record:product__v | null | product__v (may be null) | product_vod__v | product__v | product__v | ||
| veeva_activity_channel__v | varchar(25) | remote_meeting__vif populated = Engageif null = F2F | related call2__v.remote_meeting__vif populated = Engageif null = F2F | related call2__v.remote_meeting__vif populated = Engageif null = F2F | Approved Email | Engage | If em_attendee__v is populated: Events ManagementIf em_attendee__v is null: Medical Event | Medical Inquiry | related call2_vod__v.remote_meeting_vod__v if populated = "Engage" if null = "F2F" | "Medical Insights" | "Survey" | "Survey Target" |
| configurable_channel__v | varchar(1000) | remote_meeting__vif populated = Engageif null = F2F | related call2__v.remote_meeting__vif populated = Engageif null = F2F | related call2__v.remote_meeting__vif populated = Engageif null = F2F | Approved Email | Engage | If em_attendee__v is populated: Events ManagementIf em_attendee__v is null: Medical Event | Medical Inquiry | related call2_vod__v.remote_meeting_vod__v if populated = "Engage" if null = "F2F" | "Medical Insights" | "Survey" | "Survey Target" |
| status__v | varchar(1280) | status__v | related call2__v record:call2__v.status__v | related call2__v record:call2__v.status__v | status__v | related remote_meeting__v record:meeting_outcome_status__v | status__v | status__v | related call2_vod__v record:call2_vod__v.status_vod__vjoin from medical_discussion_vod__v.interaction_vod__v to call2_vod__v.vault_call2_vod__v | status__v | status__v | status__v |
| activity_type__v | varchar(1280) | call_type__v | related call2__v record:call2__v.call_type__v | related call2__v record:call2__v.call_type__v | sent_email_object_type__v= object_type__v.vault_object_type_id__vobject_type__v.object_type_name__v | related call2__v record:call2__v.call_type__v | delivery_method__v | related: call2__v record:call2__v. call_type__vjoin from medical_discussion__v.interaction__v to call2__v.vault_call2__v | medical_insight_object_ype__v need to join to object_type__v to get object_type__v.object_type_name__v | |||
| territory_name_stamped__v | varchar(765) | territory__v | related call2__v record:call2__v.territory__v | related call2__v record:territory__v | related call2__v record:call2__v.territory__v | related call2__v record:territory__v | related call2__v record:call2__v.territory__v join from medical_discussion__v.interaction__v to call2__v.vault_call2__v | |||||
| remote_meeting_id__v | varchar(1000) | remote_meeting__v | related call2__v record:remote_meeting__v | related call2__v record:remote_meeting__v | remote_meeting__v | related call2__v record:remote_meeting__v | ||||||
| is_parent_activity__v | numeric(18) | is_parent_call__v | is_parent_call__v | related call2__v record:is_parent_call__v | related call2__v record:is_parent_call__v | related call2__v record:call2__v.is_parent_call__vjoin from medical_discussion__v.interaction__v to call2__v.vault_call2__v | ||||||
| parent_activity__v | varchar(1000) | parent_call__v | related call2__v record:call2__v.parent_call__v | related call2__v record:call2__v.parent_call__v | related call2__v record:call2__v.parent_call__v | related call2__v record:call2__v.parent_call__v | ||||||
| call2_vod__v | varchar(1000) | call2__v | call2__v | call2__v | call__v | call2__v | interaction__v | |||||
| isdeleted__v | ||||||||||||
| template_name__v | varchar(1000) | null | vault_approved_document_vod_id__v | |||||||||
| presentation_name__v | varchar(384) | Join from call2_key_message to clm_presentation t:clm_presentation__v.clm_presentation_name__v | survey_name__v | related survey__v record: survey__v.survey_name__v | ||||||||
| key_message_name__v | varchar(384) | key_message__v | ||||||||||
| vault_document_id__v | varchar(300) | related key_message__v records: key_message__v.vault_doc_id__v | related approved_document_v records: approved_document__v.document_id__vGrab info after first __ | |||||||||
| vault_document_version__v | varchar(300) | related key_message__v records: key_message__v.slide_version__v | related approved_document_v records: approved_document__v.document_id__vGrab info after second __ | |||||||||
| vault_instance_id__v | varchar(300) | related key_message__v records: key_message__v.vault_dns__v | related approved_document_v records: approved_document__v.vault_instance_id__v | |||||||||
| vault_guid__v | varchar(300) | related key_message__v records: key_message__v.vault_guid__v | ||||||||||
| opened_vod__v | numeric(18) | opened__v | ||||||||||
| click_count_vod__v | numeric(18) | click_count__v | ||||||||||
| content_displayed__v | boolean | clm__v | field: clm_id__vif contains value = Trueif null = False | |||||||||
| duration__v | numeric(14) | duration__v | meeting_duration__v | |||||||||
| attendee_type__v | varhcar(1280) | attendee_type__v | attendee_type__v | target_type__v | ||||||||
| lot_number__v | varchar(240) | |||||||||||
| quantity__v | numeric(6) | |||||||||||
| veeva_standard_channel__v | varchar(765) | call_channel__v | related call2__v record:call_channel__v | related call2__v record:call_channel__v | null | related call2__v record:call_channel__v | related call2__v record:call_channel__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 |
| 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 |
