JDBC Driver for Vault CRM

Build 25.0.9434

MCCyclePlans

Defines a coordinated multichannel engagement plan for a specific period or campaign.

Columns

Name Type ReadOnly Description
ID [KEY] String True

A unique identifier for the cycle plan record, used as the primary key in the database to reference and retrieve the cycle plan.

MC Cycle Plan Type String True

The type of the marketing communication (MC) cycle plan, indicating the classification or category of the campaign or strategy.

Global ID String True

A globally unique identifier used to consistently identify this cycle plan product across different systems and platforms.

Link String False

A URL or hyperlink pointing to an external resource or document related to the cycle plan, such as a webpage or file repository.

Cycle Plan Name String False

The name or title of the cycle plan, used to uniquely identify and reference the specific marketing campaign or cycle in the system.

Status String False

The current status of the cycle plan, indicating whether it is active, completed, in progress, or in any other stage of its lifecycle.

Created By String True

The name or identifier of the person or system that created the cycle plan record, providing accountability for the record creation.

Created Date Datetime True

The timestamp indicating when the cycle plan was created, useful for tracking the age and lifecycle of the plan.

Last Modified By String True

The name or identifier of the individual or system that last modified the cycle plan record, ensuring traceability of changes.

Last Modified Date Datetime True

The timestamp of the most recent modification made to the cycle plan, reflecting the last update to the data.

Channel Interaction Attainment Double False

The percentage or measure of how much of the target channel interaction goal has been achieved in the cycle plan.

Channel Interaction Status String False

The current status of the channel interactions, such as completed, in progress, or pending, to track the interaction process.

Channel Interactions Earned Double False

The number of interactions earned or completed in the cycle plan across the specified channels, showing engagement.

Channel Interactions Goal Double False

The target number of interactions to be achieved across channels in the cycle plan, used to measure campaign success.

Days Remaining Decimal False

The number of days remaining in the cycle plan, indicating how much time is left to complete the planned activities.

Days Total Decimal False

The total number of days allocated for the cycle plan, representing the full duration from start to end.

Description String False

A detailed description of the cycle plan, including its objectives, strategies, and key components for reference.

External ID String False

An identifier from an external system used to track the cycle plan, facilitating integration with other platforms or databases.

Goal Edit Status String False

The status of any edits or adjustments made to the cycle plan's goals, such as whether they have been updated or finalized.

Last Calculated Datetime False

The timestamp when the cycle plan data or performance metrics were last calculated or reviewed, reflecting the latest update.

Lock Bool False

A flag indicating whether the cycle plan record is locked to prevent further changes or edits, ensuring data integrity.

Master Align Id String False

An identifier linking this cycle plan to a master alignment record, ensuring synchronization and consistency across related marketing strategies.

% Cycle Completed Double False

The percentage of the cycle plan that has been completed, calculated based on progress towards goals and activities.

Product Interaction Attainment Double False

The percentage of the product interaction goal achieved within the cycle plan, measuring how well the product engagement goals are met.

Product Interaction Status String False

The current status of the product interactions in the cycle plan, showing whether the interactions are on track, delayed, or completed.

Product Interactions Earned Double False

The total number of product interactions earned in the cycle plan, providing a measure of product engagement and activity.

Product Interactions Goal Double False

The target number of product interactions set for the cycle plan, used to assess the effectiveness of product engagement strategies.

MC Cycle Plan Status String False

The status of the entire marketing communication cycle plan, indicating its overall progress or completion.

Team Channel Attainment Double False

The percentage of the channel interaction goal achieved by the team in the cycle plan, reflecting team performance on channel activities.

Team Channel Interactions Earned Double False

The number of interactions earned by the team through their activities across the specified channels in the cycle plan.

Team Channel Interactions Goal Double False

The target number of interactions set for the team in the cycle plan, used to assess team performance in achieving channel interaction goals.

Team Channel Status String False

The current status of the team's work on channel interactions within the cycle plan, such as in progress or completed.

Team Product Attainment Double False

The percentage of the product interaction goal achieved by the team within the cycle plan, measuring team success in reaching product engagement targets.

Team Product Interactions Earned Double False

The number of product interactions earned by the team during the cycle plan, providing a measure of the team's engagement with the product.

Team Product Interactions Goal Double False

The target number of product interactions set for the team, used to track progress toward team product engagement objectives.

Team Product Status String False

The status of the product within the team's activities in the cycle plan, indicating if the product's goals are on track or facing challenges.

Territory String False

The geographical or market territory that the cycle plan targets, used to define the region or audience for the marketing activities.

Veeva External ID String False

An identifier from the Veeva Vault system, used to uniquely reference this cycle plan product in the Veeva ecosystem.

Cycle String False

The specific cycle or iteration of the marketing communication plan, representing one instance of the larger campaign strategy.

Owner String False

The identifier of the individual or team responsible for managing and overseeing the cycle plan, ensuring accountability.

End Date Date True

The date when the cycle plan is scheduled to end, indicating the planned conclusion of activities and objectives.

Start Date Date True

The date when the cycle plan is scheduled to start, marking the beginning of the campaign or strategy timeline.

Legacy CRM Id String False

An identifier from a legacy CRM system that was used to reference the cycle plan product, ensuring continuity during system transitions.

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