MCP Server for Vault CRM

Build 25.0.9440

Accounts

Contains detailed records for customer accounts, including core profile information, identifiers, and associated metadata used for customer engagement and Customer Relationship Management (CRM) processes.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier assigned to each account record within the Vault system. This value is system-generated and used as the primary key for referencing the account.

Account Object Type String True

Specifies the object type of the account, such as Healthcare Professional (HCP), Healthcare Organization (HCO), or other supported entity classifications within the Veeva Vault data model.

Global ID String True

Globally unique identifier automatically assigned by the system to ensure cross-environment uniqueness for each account, used in integrations and global references.

Link String False

System-generated hyperlink that provides a direct reference or pointer to the full account record in the Vault user interface or API endpoint.

Name String False

The official name of the account, such as the name of a healthcare provider or organization, used for identification and searchability.

Record Status String False

Current lifecycle status of the account record, such as active, inactive, or under review. This status determines visibility and availability in workflows.

Created By String True

The user or system account that initially created the record. This value helps track data lineage and user activity.

Created Date Datetime True

Timestamp indicating when the account record was first created in the system, typically stored in UTC format for consistency across regions.

Last Modified By String True

Name or unique identifier of the user who last updated the account record. Tracks user actions for audit trails and change history within the system.

Last Modified Date Datetime True

Date and time when the account record was last modified. This is useful for identifying the most recent updates for data synchronization or auditing.

AHA # String False

Unique identifier assigned to the account by the American Hospital Association (AHA). Helps correlate Veeva Vault data with national healthcare databases.

ATL Last Update Datetime False

Timestamp indicating when the most recent data sync occurred from the Account Territory Locator (ATL) system. This is used to track territory updates.

Account Class String False

Categorization of the account based on strategic segmentation, such as hospital, clinic, or academic institution. Determines engagement rules and reporting logic.

Account Group String False

Defines the organizational grouping for the account, such as network affiliation or corporate parent. Enables grouping of related facilities or institutions.

Account Identifier String False

System-generated or externally sourced unique ID that serves as the primary business key for referencing the account across systems.

Account Type String False

Specifies the type of account such as HCP, HCO, payer, or distributor. Determines the account's behavior and available features in the Customer Relationship Management (CRM).

Alternate Name String False

Secondary or localized name used to identify the account in regional or language-specific contexts. Supports better user recognition and filtering.

Approved Email Consent String False

Indicates the consent status for receiving approved email communications, based on selections made by the account or via consent capture processes.

# Beds Decimal False

Total number of beds available at the healthcare facility. This is used to assess facility size, categorize accounts, and inform segmentation models.

Business Description String False

A detailed description of the business associated with the account, used to capture organizational focus, operational highlights, or industry relevance. This field can inform account segmentation and reporting.

CLM Opt Type String False

Specifies the Closed Loop Marketing (CLM) preference selected by the account, which can determine content delivery methods, consent preferences, or marketing channel configurations.

Call Reminder String False

Indicates whether call reminders are enabled for this account, used to schedule and notify users of upcoming customer engagement or follow-up activities.

Career Status String False

Captures the career status of the primary contact or representative associated with the account, such as Active, Retired, or On Leave. This helps in targeting and engagement planning.

Commercial Patient Days/1000 Decimal False

Represents the number of commercial patient days per 1,000 members, which is a healthcare utilization metric used for tracking service delivery within a defined population.

Commercial Premiums (PMPM) Decimal False

Indicates the Per Member Per Month (PMPM) value of commercial insurance premiums associated with this account. This financial metric aids in market analysis and revenue forecasting.

Commercial Premiums (PMPM) Corp Decimal True

Shows the corporate-specific PMPM value for commercial premiums. It is typically used for internal benchmarking, financial modeling, or portfolio evaluation.

Local Currency String False

Specifies the currency in which financial values for this account are recorded. This field supports multi-currency environments by enabling accurate reporting and currency conversion.

Contracts Process String False

Indicates the specific process or workflow used to manage contracts associated with the account, such as negotiation, approval, or execution stages. Mapped from the field 'contracts_process__c'.

Credentials String False

Stores any credential-related data or identifiers tied to the account, such as license numbers or registration codes, as referenced by 'credentials__v'.

Customer Master Status String False

Represents the current synchronization or approval status of the account within the Customer Master system, providing insight into whether the record is active, under review, or blocked. Originates from 'customer_master_status__v'.

Default Inventory Monitoring Type String False

Specifies the default approach or method used to monitor product inventory for the account, such as cycle counts, periodic audits, or system-generated checks. Pulled from 'default_inventory_monitoring_type__v'.

Default Order Type String False

Identifies the standard order classification automatically applied to the account's transactions, such as regular purchase, sample order, or consignment. Value sourced from 'default_order_type__v'.

# Departments Decimal False

Specifies the number of internal or associated departments linked to the account. This field can be deprecated or commented out in the current schema. Sourced from 'departments__c'.

Do Not Call? String False

Flag that designates whether outreach via phone is prohibited for this account, based on regulatory or customer preferences. Derived from 'do_not_call__v'.

Do Not Create Child Account Bool False

Boolean value indicating whether sub-accounts or child account relationships are allowed for this account. When set to true, prevents creation of dependent entities. Comes from 'do_not_create_child_account__v'.

Do Not Sync Sales Data Bool False

Boolean flag that determines whether sales-related data should be excluded from synchronization processes for this account, typically used to control data flow to CRM or analytics platforms. Based on 'do_not_sync_sales_data__v'.

Enable Restricted Products Bool False

Indicates whether this account is restricted from accessing certain product types or therapeutic classes, based on compliance or regulatory requirements. Corresponds to the enable_restricted_products__v field.

Exclude from Zip to Terr Processing Bool False

Flags whether the account should be excluded from ZIP-to-territory alignment processing, which is typically used in territory mapping and field force assignment. Corresponds to the exclude_from_zip_to_terr_processing__v field.

External ID String False

A unique identifier for the account that originates from an external system, enabling data synchronization and integration across platforms. Corresponds to the external_id__v field.

Furigana String False

A phonetic representation of the account's name in Japanese kana characters, used to ensure correct pronunciation and ordering in Japanese-language contexts. Corresponds to the furigana__v field.

Gender String False

Specifies the gender associated with the account, typically used for HCP accounts. Common values can include Male, Female, or Unknown. Corresponds to the gender__v field.

Group Specialty 1 String False

The primary medical or business specialty of the group to which the account belongs. This is used for segmentation and targeting in promotional activities. Corresponds to the group_specialty_1__v field.

Group Specialty 2 String False

The secondary specialty classification of the account's group, providing additional context for categorization and field operations. Corresponds to the group_specialty_2__v field.

HMO Market Shr Double False

Represents the Health Maintenance Organization (HMO) market share percentage associated with the account, used in payer analytics and reimbursement strategy planning. Corresponds to the hmo_market_shr__c field.

HMO/POS Decimal False

Represents the financial or enrollment data for Health Maintenance Organization (HMO) and Point of Service (POS) plans associated with the account. This is used in payer and access analysis within the healthcare network.

HMO Decimal False

Indicates the numerical data related to Health Maintenance Organization (HMO) plan affiliations or coverage under the account. Supports segmentation by insurance type.

Hospital Type String False

Specifies the category of hospital, such as academic, community, teaching, or specialty, that is linked to the account. Helps in classifying healthcare facilities for targeting and reporting.

ID2 String False

An alternate system-generated identifier for the account record, stored in the field id2__v. Commonly used for integrations or deduplication logic.

ID3 String False

The primary system identifier for the account, corresponding to the internal Vault record ID (id__v). This is used for unique identification and reference in related tables.

Inventory Monitoring Type String False

Defines the approach used to track inventory for the account, such as manual reporting, integrated EHR feeds, or third-party systems. Helps determine how inventory data is collected and updated.

Investigator Bool False

Indicates whether the account represents a clinical investigator participating in studies or trials. This is used in research tracking and regulatory reporting.

Key Opinion Leader Bool False

Flags whether the account is recognized as a Key Opinion Leader (KOL), typically used to identify influential professionals within a therapeutic area or market.

ME # String False

Unique identifier assigned to the medical entity (ME) within Veeva Vault, typically used to track provider-level data and alignments.

Master Align Id String False

Reference ID used for master alignment processes across account hierarchies, ensuring consistency in territory alignments and segmentation.

Medicaid Decimal False

Total Medicaid-related financial figures for the account, such as payments or reimbursements, relevant to government-sponsored healthcare programs.

Medical Expenses (PMPM) Decimal False

Per Member Per Month (PMPM) value representing average monthly medical expenses incurred by the account for enrolled individuals.

Medical Expenses (PMPM) Corp Decimal True

Corporate-level PMPM medical expenses, aggregating broader healthcare cost data from enterprise systems into this specific Vault object.

Medical Loss Ratio Double False

Ratio of medical claims paid to premiums collected, used to evaluate the efficiency and cost structure of the account in healthcare contexts.

Medicare Decimal False

Total Medicare-related financial figures tied to the account, capturing data linked to federal health insurance programs for eligible individuals.

Middle Name String False

Middle name or initial associated with the account contact or entity, typically sourced from the Veeva CDA (Customer Data Aggregation) layer.

Mobile ID String False

Unique identifier associated with the mobile record or device linked to the account, facilitating mobile integration and field activity tracking.

Model String False

Specifies the model classification associated with the account, typically used to define business structure or account segmentation such as solo practitioner, group practice, or hospital system.

National Company ID String False

A unique identifier assigned to the account by the national company registry. This value helps ensure consistent identification across multiple systems and business units.

National Healthcare ID String False

Represents the standardized national healthcare identifier for the account, enabling integration and tracking across healthcare-specific systems and regulatory reporting.

NPI # String False

The National Provider Identifier (NPI) assigned to the account, typically a healthcare provider or organization. This is a federally issued 10-digit identification number used for billing, claims, and administrative processes.

Net Income (Loss) (000) Decimal False

The reported net income or loss for the account, expressed in thousands of currency units. Reflects the overall profitability or deficit within a given financial period.

Net Income (Loss) (000) Corp Decimal True

Corporate-level reported net income or loss for the account, expressed in thousands of currency units. This is used primarily for consolidated financial reporting within corporate structures.

No Orders String False

Indicates whether the account has placed any orders. Commonly used as a flag for accounts with no purchasing activity during a specific period or lifecycle stage.

Offerings String False

Lists the available products or services associated with the account. This can include pharmaceutical products, medical devices, consulting packages, or subscription plans, separated by commas.

Order Type String False

Describes the classification of orders linked to the account. The values can include Standard, Rush, Sample, Refill, or Rebate depending on the business context.

PDRP Opt-Out Date Date False

Date on which the practitioner opted out of the Prescription Drug Reporting Program (PDRP), indicating when the individual's exclusion from data sharing or marketing communications became effective.

PDRP Opt-Out Bool False

Indicates whether the practitioner has opted out of the Prescription Drug Reporting Program (PDRP). It is true if the opt-out is active, false otherwise.

PMPM Income (Loss) (000) Decimal False

Represents the per member per month (PMPM) income or loss for the account in thousands of dollars, providing a normalized financial performance metric.

PMPM Income (Loss) (000) Corp Decimal True

Corporate-level per member per month (PMPM) income or loss in thousands of dollars, capturing financial performance from a corporate reporting perspective.

PPO/POS Decimal False

Revenue or cost metric associated with Preferred Provider Organization (PPO) and Point of Service (POS) plan participation, reflecting patient volume or reimbursement activity in these insurance models.

PPO Decimal False

Financial or operational value specifically associated with Preferred Provider Organization (PPO) activities, independent of other insurance types.

Payer Id String False

Unique identifier assigned to the payer organization (such as an insurance company or benefits administrator) that is linked to the account.

Photo String False

Path or identifier for the profile photo or avatar associated with the account, typically stored as a URL or document ID within the system.

Practice Near Hospital? Bool False

Indicates whether the healthcare provider's practice is geographically located near a hospital. This is true if in proximity, false if not.

Practice at Hospital? Bool False

Indicates whether the provider actively practices within a hospital setting. This is true if hospital-based practice is confirmed, false otherwise.

Preferred Name String False

The preferred or commonly used name of the individual associated with the account, which can differ from their legal or official name.

Regional Strategy String False

Custom-defined strategic classification assigned to the account based on geographic region, used to align with marketing, sales, or operational goals.

Restricted Products String False

List of products that are restricted for the account based on compliance, legal, or corporate policy. Restrictions can affect sales eligibility, marketing outreach, or product visibility.

Sample Default String False

Indicates the default sampling status for the account, sourced from the field sample_default__v in Veeva Vault. This can reflect whether the account is pre-set to receive sample materials.

Segmentations String False

Represents the segmentation classifications assigned to the account, as recorded in the segmentations__v field. Common segmentations can include territory grouping, business tier, or product alignment strategy.

Speaker? Bool False

Boolean flag that identifies whether the account has been designated as a speaker, typically for events, webinars, or professional engagements. Derived from speaker__c.

Specialty String False

Denotes the primary area of medical or professional specialization for the account, sourced from specialty_1__v. This could include cardiology, oncology, internal medicine, and others.

Specialty 2 String False

Captures the secondary specialty associated with the account, from the field specialty_2__v. This allows for tracking dual-specialty professionals where applicable.

Spend Amount String False

Indicates the total spend associated with the account, as recorded in spend_amount__c. This value typically reflects promotional, educational, or marketing spend in monetary terms.

Suffix String False

Displays any professional or academic suffix tied to the account, such as MD, DO, PhD, sourced from suffix_cda__v.

Target? Bool False

Boolean field indicating whether the account is actively targeted in sales or marketing campaigns. Based on the field target__c, this flag helps prioritize engagement.

Tax Status String False

Describes the account's tax classification or exemption status, retrieved from tax_status__c. This is useful for compliance and invoicing considerations.

Territory Test Veeva String False

Internal test field (territory_test__v) used to validate or simulate account-territory alignment scenarios within Veeva Vault environments.

Total # Lives Decimal False

Represents the estimated number of covered lives associated with the account, as captured in total_lives__c. Often used in payer or provider segmentation analysis.

Total # MDs/DOs Decimal False

Indicates the total number of licensed MDs and DOs affiliated with the account, from total_mds_dos__c. Supports capacity and reach assessments.

Total # Pharmacists Decimal False

Total number of pharmacists tied to the account, sourced from total_pharmacists__c. Often relevant in retail or hospital network settings.

Total # Physicians Enrolled Decimal False

The total count of physicians enrolled in programs, trials, or initiatives associated with the account, recorded in total_physicians_enrolled__c.

Total Revenue (000) Decimal False

Shows the total revenue generated by the account, expressed in thousands of dollars, from the field total_revenue_000__c. This metric supports financial and performance reporting.

Total Revenue (000) Corp Decimal True

Represents the total corporate revenue for the account, expressed in thousands. This value is typically aggregated from internal financial systems and can be used for reporting and segmentation purposes.

Veeva Link URL String False

Contains the direct URL linking this account record to its associated Veeva Link profile. This can be used for cross-referencing external reference data and enhanced insights.

Match ID String False

A unique identifier used during the account matching process to link this record with potential duplicates or external sources. Supports data deduplication and integrity checks.

WhatsApp String False

Captures the WhatsApp contact number associated with the account, if available. This is useful for tracking communication preferences or enabling messaging campaigns.

SMS String False

Stores the mobile number or short code designated for SMS communication with the account. Enables integration with messaging platforms and outreach initiatives.

Account Source String False

Indicates the origin of the account record, such as CRM import, data migration, or manual entry. Helps in data lineage tracking and record auditing.

Account Description String False

Provides a free-text description or narrative about the account, typically summarizing its key characteristics, purpose, or distinctions.

Fax String False

Contains the fax number associated with the account. Retained for use cases that still require traditional fax communication or historical records.

First Name String False

The given name of the individual associated with the account. This field is relevant when the account represents a person or HCP.

Is Person Account Bool True

Indicates whether the account is classified as a person account rather than a business entity. True for individual-based records such as HCPs.

Last Name String False

The family name or surname of the individual linked to the account. Relevant when the record type is a person account.

Asst. Phone String False

The contact phone number of the assistant or support person affiliated with the account, typically used for scheduling or administrative follow-ups.

Primary Email String False

The main email address associated with the account. Serves as the preferred email for communications, alerts, or correspondence.

Home Phone String False

Represents the home phone number of the person linked to the account. Generally applicable only to person accounts.

Mobile Phone String False

Captures the mobile or cellular phone number of the account, typically used for text messaging or on-the-go communication.

Other Phone String False

An additional or secondary phone number related to the account. This is used when more than one contact number is available.

Title String False

Indicates the professional title or designation of the individual account holder, such as 'Dr.', 'Manager', or 'Pharmacist'.

Office Phone String False

Represents the main office or work phone number associated with the account. Frequently used in Business-to-Business (B2B) or Healthcare Organization (HCO) contexts.

Account Rating String False

Indicates the qualitative or quantitative rating assigned to the account, typically used to assess its importance, potential, or priority within the organization.

Salutation String False

Stores the formal greeting or title for the individual account, such as Mr., Ms., Dr., used in communications and printed materials.

Account Type2 String False

Specifies the secondary classification of the account, helping to further segment accounts beyond the primary account type.

Business Professional Person String False

Flags whether the account is associated with a person who meets criteria for being classified as a business professional, based on industry regulations or internal definitions.

Country String False

Captures the country in which the account is registered or primarily operates, used for regional segmentation, reporting, and compliance.

Primary Parent String False

References the parent account that is hierarchically above this account in the organizational structure, typically used to model business relationships or ownership.

Owner String False

Identifies the internal system user who is currently assigned as the owner of this account, responsible for managing interactions and data updates.

Account Search Business String True

Stores a normalized version of the business name to improve search performance and consistency in lookup operations across the platform.

Account Search FirstLast String True

Stores a search-optimized concatenation of the account's first and last name, formatted as FirstName LastName, to support person-based account queries.

Account Search LastFirst String True

Stores a search-optimized concatenation of the account's name in LastName FirstName format, aiding reverse-name lookup functionality.

Color String True

Represents a color value associated with the account for visual categorization or UI customization within dashboards or reports.

Formatted Name String True

Provides the full formatted display name of the account as it should appear in UI components and formal communications.

Signature Page Display Name String True

Specifies the name that appears on signature pages in documents generated by the system, formatted for legal or professional presentation.

Spend Status Value String True

Contains a numeric or string code representing the account's spend status, used in financial segmentation and compliance workflows.

Spend Status String True

Describes the financial engagement level of the account, indicating whether it is actively spending, inactive, or under review.

Veeva Link String True

Provides a link to the corresponding account profile within Veeva Link, enabling users to access enriched reference data and relationship insights.

Legacy CRM Id String False

Stores the account identifier from a previous CRM system used before migrating to Veeva Vault, for reference and data mapping purposes.

Primary City String False

Captures the primary city associated with the account, typically used in address records and regional reporting.

Primary Country String False

Indicates the main country tied to the account's primary location, supporting geographical grouping and regulatory segmentation.

Primary State String False

Captures the state or province of the account's primary address, used for compliance, routing, and reporting purposes.

Primary Postal Code String False

Stores the zip or postal code of the account's primary address, used in mailings, territory assignment, and location-based analytics.

Engage Profile Status String False

Indicates the current status of the account's Engage profile, such as active, inactive, or pending, used to track digital communication readiness.

Veeva Network ID String False

Unique identifier assigned to the account in the Veeva Network system, used for integration and data synchronization across Veeva applications.

Medical Identifier String False

A standardized medical ID number or code associated with the healthcare professional, often used for credential verification or regulatory purposes.

Country Code String False

Two-letter ISO code representing the country associated with the account's address or licensure.

VCountry String False

Internal Veeva-specific representation of the country, used for localization or regional reporting customization.

Language String False

Preferred language of the healthcare professional or institution, used for content personalization and communication.

In Merge String True

System flag indicating whether the account is currently part of a merge operation or has been recently merged with another record.

HCP Facing Display Name String True

Formatted name string displayed to healthcare professionals in applications or communication materials, which can include honorifics, first name, last name, and suffix.

Veeva ID String False

System-generated unique identifier within Veeva Vault that distinguishes this account from all others.

Prefix String False

Honorific or courtesy title such as Dr., Mr., Ms., typically used in formal communications with the healthcare professional.

Prescriber Bool False

Boolean flag indicating whether the healthcare professional has prescribing authority according to regulatory or institutional guidelines.

Year of Birth Decimal False

Year the healthcare professional was born, used for demographic analysis or compliance segmentation.

Speaker Bool False

Boolean value that designates whether the healthcare professional serves as a speaker for events, webinars, or promotional activities.

Target Bool False

Indicates whether the healthcare professional is considered a strategic engagement target, based on marketing or medical criteria.

HCP Type String False

Defines the professional classification of the healthcare provider, such as physician, nurse practitioner, or pharmacist.

Primary Specialty String False

The main clinical specialty or area of practice for the healthcare professional, such as cardiology or oncology.

All Specialties String False

Comma-separated list of all clinical specialties the professional is associated with, allowing for broader categorization in segmentation.

Primary Specialty Group String False

High-level grouping that categorizes the primary specialty into broader medical fields for reporting purposes.

All Specialty Groups String False

Comma-separated list of all specialty groups applicable to the healthcare professional, supporting multi-specialty classification.

Primary Medical Degree String False

Highest medical degree earned, such as MD, DO, or MBBS, used for qualification and credential records.

All Medical Degrees String False

Comma-separated list of all medical degrees held by the healthcare professional, supporting detailed credential documentation.

Status String False

Current account status in the system, such as Active, Inactive, or Suspended, used for operational and compliance tracking.

Level String False

Categorization of account seniority or role importance, such as Tier 1 or National Key Opinion Leader (KOL).

Adopter Type String False

Indicates the healthcare professional's innovation adoption profile, such as Early Adopter, Majority, or Laggard, often used in marketing strategy.

Age Range String False

Estimated age bracket of the healthcare professional, typically expressed in ranges like 30-39 or 50-59 for demographic segmentation.

Clinical Researcher String False

Boolean value indicating whether the professional is involved in clinical research activities, used for investigator targeting and trial planning.

HCO Type String False

Indicates the classification of the Healthcare Organization (HCO) as defined in the Clinical Data Architecture (CDA). This field helps categorize the organization based on its role in the clinical or research setting.

Website String False

The official website URL of the Healthcare Organization, captured from the CDA system. This is used for reference, communication, and verification purposes.

Study Site Bool False

Boolean flag that specifies whether the Healthcare Organization is designated as an approved study site for clinical trials or research activities. A value of true indicates active participation.

HCO Name String True

The full legal name of the Healthcare Organization as recorded in the CDA system. This serves as the primary display identifier for reporting and data integration.

Primary Owner String False

The username or system identifier of the individual who holds ownership responsibility for the HCO record within Veeva Vault. This owner is typically accountable for data accuracy and updates.

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