JDBC Driver for Vault CRM

Build 25.0.9434

CyclePlanDetails

Provides granular data for cycle plan execution, including the allocation of objectives, timelines, and targets at the individual level. This is useful for field force planning and performance tracking.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the cycle plan detail record, used as the primary key for internal reference.

Global ID String True

System-generated global identifier that ensures uniqueness across all Veeva Vault environments and tenants.

Link String False

URL or system-specific reference link that provides a direct path to the cycle plan detail record in the Veeva Vault interface.

Name String True

User-defined name or title of the cycle plan detail, typically used for display and reporting purposes.

Status String False

Current lifecycle status of the cycle plan detail record, such as Active, Inactive, or Archived.

Created By String True

Username or system account that initially created the cycle plan detail record.

Created Date Datetime True

Timestamp indicating when the cycle plan detail record was first created in the system.

Last Modified By String True

Username or system account that last updated the cycle plan detail record.

Last Modified Date Datetime True

Timestamp of the most recent modification to the cycle plan detail record.

Actual Details Decimal False

The actual number of completed interactions or touchpoints associated with this cycle plan detail.

Mobile ID String False

Identifier used by mobile platforms or devices to reference this specific cycle plan detail record.

Planned_Details Decimal False

The number of planned interactions or activities assigned to this cycle plan detail.

Priority Decimal False

Numerical value representing the importance or urgency level assigned to the cycle plan detail.

Scheduled Details Decimal False

The number of interactions or visits that have been scheduled in the plan but not yet completed.

Actual Total Details Decimal False

Cumulative count of all actual interactions associated with the entire cycle plan for this detail.

Planned Total Details Decimal False

Total number of planned interactions across the entire cycle plan that includes this detail.

Scheduled Total Details Decimal False

Total number of scheduled interactions associated with the broader cycle plan this detail is part of.

Target String False

Reference to the intended target entity for the cycle plan detail, such as an account, territory, or HCP.

Product Catalog String False

Identifier for the product or product catalog item associated with this cycle plan detail.

Attainment Double True

Percentage or value indicating the level of goal achievement based on actual versus planned details for this record.

Remaining Decimal True

Number of interactions or actions still pending completion within the scope of this specific detail.

Attainment Total Double True

Overall percentage or value of attainment calculated for the entire cycle plan involving this detail.

Remaining Total Decimal True

Aggregate number of remaining actions or visits across all related cycle plan details.

Legacy CRM Id String False

Identifier carried over from a legacy Customer Relationship Management (CRM) system used for data mapping or historical reference.

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