JDBC Driver for Vault CRM

Build 25.0.9434

Campaigns

Central repository for campaign records, capturing metadata such as campaign name, type, start and end dates, objective, and status, providing a foundational dataset for managing and tracking marketing or outreach initiatives.

Columns

Name Type ReadOnly Description
ID [KEY] String True

System-generated unique identifier for the campaign record within the Veeva Vault system.

Campaign Type String True

Indicates the specific type or classification of the campaign, such as Email, Digital, or Field, based on object_type__v.

Global ID String True

A globally unique identifier assigned to the campaign, used for cross-system tracking and synchronization.

Link String False

System-generated URL or hyperlink reference pointing to the campaign record within the Veeva Vault user interface.

Campaign Name String False

The official name or title of the campaign, typically used for display and reporting purposes.

Status String False

The current lifecycle status of the campaign (such as Planned, Active, or Completed), tracked through status__v.

Created By String True

The user ID or username of the individual who initially created the campaign record.

Created Date Datetime True

The exact date and timestamp when the campaign record was first created in the system.

Last Modified By String True

The user ID or username of the individual who most recently updated the campaign record.

Last Modified Date Datetime True

The date and time of the last modification made to the campaign record.

Description String False

A detailed narrative or summary providing additional context or background about the campaign's purpose or content.

End Date Date False

The date when the campaign is scheduled to end or was officially concluded.

Start Date Date False

The date when the campaign is scheduled to start or was officially launched.

Owner String False

The user ID of the person responsible for overseeing or managing the campaign, as defined in ownerid__v.

Legacy CRM Id String False

Identifier from the legacy Customer Relationship Management (CRM) system for migration or historical reference.

External ID String False

An external system identifier for referencing this campaign in third-party platforms or integration tools.

Objectives String False

The strategic goals or intended outcomes of the campaign, such as increasing awareness or driving product adoption.

Campaign Status String False

Detailed indicator of the campaign's execution status within the workflow, separate from general lifecycle state.

Product Group String False

Identifies the therapeutic area or grouping of related products associated with the campaign, derived from detail_group__v.

Parent String False

Reference to a parent campaign if this campaign is part of a larger multi-phase or hierarchical campaign structure.

Product String False

Primary product associated with the campaign, usually referenced by product__v.

User Country String False

The country in which the campaign owner or user managing the campaign is located.

Country Code String False

Standardized country code corresponding to the user's or campaign's geographic location.

Country String False

Full name of the country where the campaign is being executed or targeted, mapped from vcountry__v.

Steps String False

Defined sequence of activities or workflow steps involved in executing the campaign, such as Planning, Execution, and Review.

Campaign Notes String False

Supplementary notes or observations recorded about the campaign by users, including strategic comments or field updates.

Target List Description String False

Narrative summary describing the group of accounts, contacts, or entities being targeted in the campaign.

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