JDBC Driver for Vault CRM

Build 25.0.9434

ClinicalSites

Houses information about individual clinical trial sites participating in studies, including site location, investigators, IRB details, and activation status for trial execution and regulatory tracking.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the clinical site record within the Vault system. This value is system-generated and immutable.

Clinical Site Type String True

Specifies the type or classification of the clinical site, based on the object type defined in the Vault configuration.

Global ID String True

System-level global identifier used to ensure cross-environment uniqueness for the clinical site record.

Link String False

System-generated URL link that provides direct access to the clinical site record within Vault.

Site Identifier String False

Unique name or identifier assigned to the clinical site, often used for referencing the site in study documentation.

Status String False

Current operational status of the clinical site, such as Active, Inactive, or Pending Approval.

Created By String True

Username of the Vault user who initially created the clinical site record.

Created Date Datetime True

Timestamp indicating when the clinical site record was first created in the system.

Last Modified By String True

Username of the Vault user who last modified the clinical site record.

Last Modified Date Datetime True

Timestamp indicating when the clinical site record was most recently updated.

Lifecycle State String False

Current lifecycle state of the clinical site record, such as Draft, Approved, or Archived, based on the defined workflow.

Principal Investigator String False

Text entry capturing the name of the primary investigator overseeing activities at the clinical site.

Site Name String False

Text value representing the name of the clinical site for display and reporting purposes.

Site Number String False

Numeric or alphanumeric identifier assigned to the site by the sponsor or regulatory authority.

Vault Clinical External ID String False

External identifier used by Vault Clinical systems to link and synchronize clinical site data across applications.

Vault Clinical Organization External ID String False

External identifier that links the clinical site to a parent organization within Vault Clinical, enabling organization-level tracking and rollups.

Vault Clinical Status String False

Status value used by Vault Clinical to track the site's operational or regulatory readiness, such as Ready for Activation or Closed.

Legacy CRM Id String False

Identifier referencing the clinical site record in a legacy Customer Relationship Management (CRM) system, allowing for cross-platform data alignment.

Principal Investigator2 String False

Lookup field referencing a principal investigator object or record, enabling structured linkage instead of plain text.

Site Name2 String False

Lookup field referencing a predefined site name object, allowing for consistent site naming and reuse.

Study String False

Reference to the associated clinical study record within Vault, linking the site to a specific trial or research initiative.

Country String False

Country in which the clinical site is geographically located, based on standardized country values in the Vault system.

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