Power BI Connector for Vault CRM

Build 25.0.9454

Users

Contains metadata for Vault users, including system identifiers, authentication details, user preferences, and role mappings used for login and operational tracking.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the user record within the Veeva Vault system.

Name String True

Full name of the user as displayed in the Vault interface.

Status String True

Current status of the user account, such as Active, Inactive, or Locked.

Created By String True

User or system that originally created this user record.

Created Date Datetime True

Timestamp indicating when the user record was first created in the system.

Last Modified By String True

User or system that last updated the user record.

Last Modified Date Datetime True

Timestamp of the most recent modification to this user record.

Domain Admin Bool False

Indicates whether the user has domain administrator privileges, which grant elevated access across the Vault domain.

Email String False

User's primary email address used for notifications and authentication.

User Name String False

Login username used by the user to access the Vault platform.

First Name String False

User's first name, typically used in personalization or display contexts.

Last Name String False

User's last name, typically used in personalization or display contexts.

Image String False

Reference to the user's profile image or avatar used in Vault.

Manager String False

Identifier or reference to the user's manager within the organization, often used for hierarchy-based workflows.

Language String False

Preferred language for the user interface, used to localize the Vault experience.

License Type String False

Type of license assigned to the user, which determines feature access and permissions.

Locale String False

User's regional locale settings, which influence number, date, and time formatting.

Timezone String False

Time zone assigned to the user, used for scheduling and displaying time-specific data.

Alias String False

Alternative name or nickname used for the user within Vault.

Company String False

Name of the company or organizational unit associated with the user.

Title String False

Job title of the user, used for reporting or display in organizational structures.

Mobile String False

User's mobile phone number, used for contact and optional multi-factor authentication.

Office Phone String False

User's office phone number, typically used for internal contact purposes.

Fax String False

User's fax number, if applicable, primarily for legacy communication contexts.

Location String False

User's physical location or office address, used for regional assignments or compliance.

Federated ID String False

Federated identity string used when integrating with external identity providers (for example, SAML, OAuth).

Favorite New Content Bool False

Indicates whether the user has opted to be notified when new content is added to their favorite documents.

Favorite Document New Comment Bool False

Indicates whether the user receives alerts for new comments added to their favorite documents.

Favorite Document New Status Bool False

Indicates whether the user is notified when a favorite document changes status.

Product Announcement Emails Bool False

Indicates whether the user is subscribed to receive emails about product announcements and feature updates from the Veeva platform.

Service Availability Notifications Bool False

Specifies whether the user is configured to receive alerts regarding system maintenance, service outages, or availability updates.

Security Profile String False

The name of the security profile assigned to the user, which defines access permissions and data visibility rules across the application.

Last Login Datetime True

Records the most recent date and time the user successfully logged into the Vault system.

Security Policy String False

The security policy applied to the user account, determining password rules, session timeouts, and other authentication behaviors.

Salesforce Username String False

Stores the username used by the user to access integrated Salesforce systems, if applicable.

Lifecycle String True

Represents the lifecycle configuration assigned to the user, governing user status progression such as activation, deactivation, or archiving.

Lifecycle State String True

Denotes the current state within the assigned lifecycle, such as Active, Inactive, or Suspended.

Preferred Currency String False

Indicates the user's preferred currency for transactional views, budgeting, or pricing-related data.

Activation Date Date False

Date on which the user account is activated and becomes eligible for login and system interaction.

Inactivation Date Date True

Date on which the user account is deactivated, rendering the user unable to access the system.

Send Welcome Email on Activation Date Bool False

Indicates whether a welcome email should be automatically sent to the user upon activation.

Global ID String True

Globally unique identifier for the user, used for cross-system referencing and synchronization.

Link String False

System-generated URL or reference linking to the user profile or associated user resources.

System Owned User Bool True

Specifies whether the user account is owned and managed by the system rather than manually created.

Tasks String False

List of task identifiers or labels currently assigned to the user for workflow or document-related actions.

User Mentions String False

References where the user has been tagged or mentioned, commonly used in collaborative annotations or comments.

Shared Views String False

Identifiers or names of saved views that have been shared by this user with others in the system.

Send As Link String False

Specifies the delivery format of shared documents, typically a URL link sent via email rather than as an attachment.

Landing Tab String False

The default tab displayed when the user logs in, such as Home, Tasks, or Library.

Holiday Schedule String False

The holiday calendar assigned to the user, used in scheduling tasks and avoiding deadline conflicts.

Preferred Tab Collection String False

The user's preferred set of tabs displayed in the interface, providing quick access to frequently used features.

Annotation Replies String False

Tracks whether the user is permitted to reply to annotations in documents, based on permission settings.

Alternate CDN String False

Name or identifier of the alternate Content Delivery Network used for serving content to this user.

Analytics Admin Bool False

Indicates whether the user has administrative privileges to manage or access system analytics and reporting dashboards.

Andi FTP Admin Bool False

Specifies whether the user has administrative access to the Andi FTP interface for data imports or exports.

Approved Email Admin Bool False

Denotes whether the user can configure and administer Approved Email features within the platform.

Available String False

Reflects the current availability status of the user, often used for delegation, visibility, or calendar coordination.

Clear Client Sync Errors Bool False

Determines whether the user has permission to manually clear client-side synchronization errors.

Concur UserID String False

External identifier linking the user account to the SAP Concur system, typically used for travel and expense management integration.

Consent Admin Bool False

Indicates whether the user has administrative permissions to manage consent-related operations in the system.

Content Admin Bool False

Specifies whether the user has administrative rights to manage content, such as documents, presentations, and media assets.

Custom Application String False

Identifies the custom application associated with the user, typically configured for specialized workflows or features.

Engage Connect Group Request String False

References a user's pending request to be added to an Engage Connect Group, which facilitates virtual meetings and collaboration.

Engage Connect Group String False

Denotes the Engage Connect Group that the user is currently associated with for virtual interactions and group management.

Engage Connect Group Provisioning Status String False

Represents the provisioning status of the user's Engage Connect Group, such as requested, in progress, or completed.

Enable CLM Testing Features Bool False

Indicates whether Closed Loop Marketing (CLM) testing features are enabled for the user to validate presentations and interactions.

Engage Group String False

Specifies the Engage Group linked to the user, which supports structured virtual engagement and event coordination.

Engage Group Provisioning Status String False

Shows the current status of Engage Group provisioning for the user, such as pending, active, or failed.

Engage Group Request String False

Captures a request initiated by the user to join or create an Engage Group for digital engagement purposes.

Facetime Email String False

Stores the user's email address registered for use with FaceTime-based interactions or virtual calls.

Facetime Phone String False

Contains the user's phone number designated for FaceTime video conferencing or virtual meeting functionality.

Force Full Refresh Bool False

Indicates whether the user has triggered or requires a full refresh of mobile Customer Relationship Management (CRM) data, typically used to resolve sync issues.

Last iPad Connect Version String False

Records the version of the iPad Connect app most recently used by the user to access the platform.

Last iPad Connect Datetime False

Captures the timestamp of the user's most recent connection using the iPad Connect application.

Last iPad Sync Datetime False

Indicates the last time the user successfully synchronized data from their iPad device with the system.

Last iPad iOS Version String False

Displays the version of iOS installed on the user's iPad during their most recent system interaction.

Last iPhone Connect Version String False

Records the most recent version of the iPhone Connect app used by the user to access the CRM platform.

Last iPhone Connect Datetime False

Logs the last date and time the user connected to the platform using the iPhone Connect application.

Last iPhone Sync Datetime False

Represents the latest sync timestamp from the user's iPhone, ensuring their local data is up-to-date.

Last iPhone iOS Version String False

Shows the iOS version on the user's iPhone at the time of their most recent app usage or sync.

MCCP Admin Bool False

Indicates whether the user has administrative access to manage My Call Cycle Plans (MCCP), which define field force activity plans.

Master Align Id String False

Unique identifier used to associate the user with a master alignment record, often related to territory or account assignment structures.

Mobile CRM App Access Disabled Bool False

Indicates whether access to the mobile CRM application is currently disabled for the user, either temporarily or permanently.

NAS Filters String False

Contains filters or configuration values related to Network Address Services (NAS), used to define access scopes or visibility rules.

Network Additional Countries String False

Lists additional countries configured in the user's network profile, separated by commas with 1 space after each comma.

Network Admin Bool False

Specifies whether the user has administrative permissions for managing Veeva Network configurations and reference data.

Override Timestamp Datetime False

Indicates a system-generated timestamp used to override standard modification times for audit or synchronization purposes.

Primary Territory String False

Specifies the user's primary sales territory, which determines default geography, customer assignments, and reporting hierarchy.

Raise Logging Level String False

Designates the user-specific logging level, used to increase diagnostic detail for troubleshooting purposes.

Remote Meeting Host Id String False

Unique identifier associated with the user for hosting remote meetings within the system, typically used for integration with third-party virtual meeting platforms.

Remote Meeting Host Token String False

Authentication token used by the user to securely host remote meetings. Enables integration with remote conferencing tools while preserving secure access.

Send Detailed Log Bool False

Indicates whether the user has enabled the sending of detailed application logs for troubleshooting or audit purposes.

Share Team String False

Team or group with whom the user's data or records are shared. Helps in managing collaborative access and permissions.

Upload VTrans Bool False

Boolean flag that determines whether the user has permission to upload Veeva CRM CLM (VTrans) content to the platform.

User Identifier String False

A system-generated or user-provided unique string used to identify the user across modules and integrations within Veeva Vault.

User Type String False

Specifies the classification of the user, such as internal employee, contractor, or external partner, used for access control and reporting.

Webinar Host Id String False

Identifier linked to the user's webinar hosting profile. Typically used for managing user-hosted webinars within integrated systems.

Webinar Host Token String False

Secure token granting webinar host permissions to the user, supporting authentication for webinar-related activities.

Last CRM Desktop Mac Sync Datetime False

Timestamp of the most recent sync between the user's Mac CRM desktop client and the Vault system.

Last CRM Desktop Mac Version String False

Version number of the CRM desktop application installed on the user's Mac at the time of the last synchronization.

Last CRM Desktop Windows Sync Datetime False

Timestamp recording when the user's Windows-based CRM desktop application last synchronized with the Vault platform.

Last CRM Desktop Windows Version String False

Version of the CRM desktop application on Windows used by the user during the most recent sync operation.

Address String False

Full formatted address of the user, often used for location-based features, correspondence, or compliance requirements.

City String False

City component of the user's address, used for geographic classification and location-based filtering.

Department String False

Department or organizational unit to which the user belongs, commonly used for reporting and access management.

Geocode Accuracy String False

Specifies the accuracy level of the geolocation coordinates associated with the user's address, such as rooftop, range interpolated, or approximate.

Active Bool False

Indicates whether the user's account is currently active. Inactive users typically cannot log in or access system features.

Zip/Postal Code String False

Postal code portion of the user's address, used for address validation, geolocation, and regional reporting.

Photo String False

URL pointing to the user's profile photo, typically displayed in user directories or communication interfaces.

State/Province String False

State or province portion of the user's address, relevant for regional compliance and categorization.

Street String False

Street-level detail of the user's address, supporting geocoding and accurate physical location records.

Nickname String False

The community nickname or informal name chosen by the user for display within collaborative or social modules.

Role ID String False

Identifier of the user's assigned role in the system, used to determine access permissions and functional responsibilities.

Account ID String False

Identifier linking the user to a specific account, typically representing the organization or customer entity they belong to.

Country String False

Specifies the user's primary country of operation, typically aligned with their region-specific permissions and compliance settings. Maps to the country__v field in Vault.

Delegated Approver ID String False

The unique identifier for a user authorized to act as a delegated approver on behalf of the primary user in workflows requiring approvals. Maps to delegatedapproverid__v.

Profile Name String True

The name of the user's assigned profile, which defines the user's roles, permissions, and access levels within the Vault system. Maps to profile_name__v.

Country2 String True

Stores the two-letter ISO country code associated with the user's location, useful for integrations and filtering. Maps to country_code__v.

Legacy CRM Id String False

Represents the user ID from a previous or external CRM system, retained for reference or migration purposes. Maps to legacy_crm_id__v.

Enable Microsoft Outlook Calendar Bool False

Indicates whether the user's Vault account is integrated with Microsoft Outlook Calendar to sync events and availability. Maps to enable_ms_outlook_calendar__v.

Enable Microsoft Teams Bool False

Specifies whether the user has Microsoft Teams integration enabled for collaboration and meeting features. Maps to enable_ms_teams__v.

Last Android Connect Version String False

Stores the version number of the Veeva Android Connect app last used by the user. Maps to last_android_connect_version__v.

Last Android Connect Datetime False

Timestamp of the user's most recent connection using the Veeva Android Connect app. Maps to last_android_connect__v.

Last Android OS Version String False

Captures the version of the Android operating system on the user's device at the time of last sync. Maps to last_android_os_version__v.

Last Android Sync Datetime False

The date and time of the user's last successful data synchronization on an Android device. Maps to last_android_sync__v.

Last CRM Desktop Mac Connect Version String False

Indicates the version of the CRM Desktop client for macOS used during the user's last connection. Maps to last_crmdesktop_mac_conn_ver__v.

Last CRM Desktop Mac Connect Datetime False

Timestamp of the most recent connection using the CRM Desktop client for macOS. Maps to last_crmdesktop_mac_connect__v.

Last CRM Desktop Windows Connect Version String False

Specifies the version of the CRM Desktop client for Windows last used by the user. Maps to last_crmdesktop_windows_conn_ver__v.

Last CRM Desktop Windows Connect Datetime False

The most recent connection timestamp for the CRM Desktop client on a Windows machine. Maps to last_crmdesktop_windows_connect__v.

MS Graph API Authorized? Bool False

Indicates whether the user has successfully authorized access to the Microsoft Graph API, enabling advanced Office 365 features. Maps to ms_graph_api_authorized__v.

MS Outlook Last Pull Activity Datetime False

The timestamp of the last data pull operation from Microsoft Outlook, showing when information was last imported. Maps to ms_outlook_last_pull_activity__v.

MS Outlook Last Push Activity Datetime False

The timestamp of the last data push operation to Microsoft Outlook, showing when Vault last updated Outlook. Maps to ms_outlook_last_push_activity__v.

Vault CRM Events Management String False

Indicates whether the user is licensed for Vault CRM's Events Management module, used for planning and managing Healthcare Professional (HCP) events. Maps to license_vaultcrmeventsmanagement__sys.

Vault CRM Service Center String False

Specifies whether the user is licensed for the Vault CRM Service Center module, which supports customer service workflows. Maps to license_vaultcrmservicecenter__sys.

Layout Profile String False

Denotes the system layout profile assigned to the user, controlling the structure and appearance of UI components in Vault. Maps to layout_profile__sys.

Vault CRM Core CRM String False

Represents licensing status for the Vault CRM Core module, which provides foundational CRM capabilities. Maps to license_vaultcrmcore__sys.

Product Expertise String False

Details the specific products or therapeutic areas where the user holds subject-matter expertise, influencing content delivery or targeting. Maps to product_expertise__v.

Vault CRM Approved Email String False

Indicates whether the user is licensed for the Vault CRM Approved Email module, used for compliant email communications. Maps to license_vaultcrmapprovedemail__sys.

Vault CRM Engage String False

Indicates whether the user has an active license for Vault CRM: Engage, enabling interaction management functionalities for customer engagement.

Last iPad Updates Applied Datetime False

Timestamp of the most recent updates applied to the Veeva CRM iPad app for the user, useful for mobile deployment tracking.

Last iPhone Updates Applied Datetime False

Timestamp of the most recent updates applied to the Veeva CRM iPhone app for the user, indicating version currency for iOS devices.

Employee Number String False

The user's unique employee identification number as maintained in the organization's HR system, used for personnel tracking and reporting.

Locked User Bool False

Boolean flag indicating if the user account is currently locked due to failed login attempts or administrative action.

Inventory Order Allocation Group String False

Represents the group assigned to manage inventory order allocations for the user, influencing product distribution workflows.

VCountry String False

The virtual country code associated with the user, used for region-specific configurations, permissions, and reporting.

Language Code String True

The user's preferred language for UI and communications, based on ISO language codes such as en, fr, or de.

CCaaS External User ID String False

The external identifier used to associate the user with a Contact Center as a Service (CCaaS) platform, supporting cross-system integration.

OmniConnect Integration String False

Indicates whether the user is enabled for OmniConnect integration, allowing access to third-party platforms via Veeva's integration layer.

Vault CRM Campaign Manager String False

Specifies whether the user is licensed for Vault CRM: Campaign Manager, which supports campaign planning and execution activities.

Application Profile String False

The application profile assigned to the user, defining UI layout, feature access, and device-specific behavior across Veeva Vault products.

Vault CRM Patient CRM String False

Indicates whether the user has an active license for Vault CRM: Patient CRM, enabling patient engagement and case tracking functionalities.

Locale Code String True

Specifies the user's full locale setting including language and region (such as en_US or fr_FR), which governs formatting and localization behavior.

Original User String True

System field referencing the initial user who created or owned the user record before any reassignment or replication.

Favorite Documents String False

A list or reference to documents marked as favorites by the user, enabling quick access to frequently used Vault content.

Summary Email Interval String False

Specifies how frequently the user receives summary email notifications (such as daily, weekly), configured via system settings.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454