AccountPlans
Holds strategic planning data for stakeholder accounts, including objectives, tactics, and key performance indicators, as defined in the 'account_plan__v' object.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
Unique identifier for the account plan record within the Veeva Vault system. This value is system-generated and immutable. |
| Account Plan Type | String | True |
Indicates the type of account plan being created or referenced. This can define the strategic purpose or classification, such as territory-specific or product-focused plans. |
| Global ID | String | True |
System-assigned globally unique identifier used to distinguish this account plan across multiple Vault environments or integrations. |
| Link | String | False |
URL or reference link to access the account plan directly within the Vault interface. This is useful for UI integration and quick navigation. |
| Account Plan Name | String | False |
Human-readable name of the account plan, used to identify it in dashboards, reports, and user interfaces. |
| Status | String | False |
Current lifecycle status of the account plan, such as 'In Progress', 'Completed', or 'Cancelled'. This is used to control user interactions and reporting. |
| Created By | String | True |
User who originally created the account plan. Stores the Vault username or ID of the creator. |
| Created Date | Datetime | True |
Timestamp representing when the account plan record was first created in the Vault system. |
| Last Modified By | String | True |
User who last modified the account plan. This is useful for tracking recent updates or changes. |
| Last Modified Date | Datetime | True |
Timestamp of the most recent modification to the account plan. Enables auditing and synchronization. |
| Active | Bool | False |
Indicates whether the account plan is currently active. Active plans are considered for reporting and planning purposes. |
| Completed Plan Tactics | Decimal | False |
Total number of plan tactics (sub-actions or initiatives) that have been marked as completed under this account plan. |
| Description | String | False |
Free-text field for describing the purpose, scope, and objectives of the account plan. |
| Health | String | False |
Qualitative assessment of the account plan's overall health, such as 'Good', 'At Risk', or 'Poor'. Often used for visual tracking and executive summaries. |
| Mobile ID | String | False |
Identifier used by mobile applications to track and synchronize the account plan record in offline mode or across devices. |
| Opportunities | String | False |
Reference to associated sales opportunities linked to the account plan. May contain multiple IDs or concatenated strings representing opportunity records. |
| % Complete | Double | False |
Percentage indicating the completion status of the plan based on completed versus total tactics. Reflects overall plan progress. |
| Plan Tactic Progress | Double | False |
Detailed metric showing the progress of all plan tactics within this account plan. May consider weights or priorities. |
| Progress | Double | False |
General progress percentage for the account plan, factoring in multiple elements such as tasks, tactics, and milestones. |
| Account Plan Status | String | False |
Business-level categorization of the account plan's current state. Distinct from system 'Status' and can reflect strategic evaluation stages. |
| Strengths | String | False |
Text field for capturing identified strengths in the account strategy, such as relationships, product fit, or prior success. |
| Threats | String | False |
Text field describing perceived or known threats that could hinder the success of the account plan. |
| Total Plan Tactics | Decimal | False |
Total number of tactics defined within the account plan. This includes both completed and pending items. |
| Type | String | False |
Custom classification field used to group or segment account plans based on business needs, such as 'KOL Engagement' or 'Market Development'. |
| Weaknesses | String | False |
Narrative description of any strategic or operational weaknesses identified during the planning process. |
| Account | String | False |
Reference to the primary account of the Healthcare Organization (HCO) or Healthcare Professional (HCP) associated with this plan, typically linking to the account master record. |
| Clones | String | False |
Reference to duplicated versions of the account plan, useful for tracking derived strategies or plan versioning. |
| Owner | String | False |
User or role responsible for executing and maintaining the account plan. Usually corresponds to a field team member or account manager. |
| Legacy CRM Id | String | False |
Identifier used in legacy Customer Relationship Management (CRM) systems for cross-platform mapping and historical data integrity during migration. |
| End Date | Date | False |
Planned or actual end date of the account plan lifecycle. This is used for filtering and analytics. |
| Start Date | Date | False |
Planned or actual start date of the account plan. Helps define the reporting and execution window. |
| User Country | String | False |
Country associated with the user who owns or created the plan. Often used for regional segmentation or compliance filtering. |