Veeva Vault
Explore the interactive ERD
Table & Field Reference
group_security_profile
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
group_id | Unknown | PKFK |
security_profile | Unknown |
group_member
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
group_id | Unknown | PKFK |
member | Unknown | FK |
implied_member
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
id | Unknown | PKFK |
source_name | Unknown | |
source_type | Unknown |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
active | Unknown | |
allow_delegation_among_member | Unknown | |
created_date | Unknown | |
editable | Unknown | |
group_description | Unknown | |
label | Unknown | |
modified_by | Unknown | |
modified_date | Unknown | |
name | Unknown | |
system_group | Unknown | |
type | Unknown |
bulk_workflow_action_control_prompt
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
label | Unknown | |
multi_value | Unknown | |
name | Unknown | |
required | Unknown |
bulk_workflow_action_detail
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
label | Unknown | |
name | Unknown | |
type | Unknown |
workflow_action_control
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
current_values | Json | |
label | Unknown | |
prompts | Json | |
type | Unknown |
workflow_action
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
workflow_id | Unknown | PKFK |
label | Unknown | |
name | Unknown |
object_record_role_user
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
users | Unknown | FK |
object_record_role_group
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
groups | Unknown | FK |
object_record_role
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
object_record_id | Unknown | PK |
name | Unknown | FK |
assignment_type | Unknown |
workflow_task_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workflow_task_id | Unknown | PKFK |
status | Unknown |
workflow_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
assignee | Unknown | FK |
object | Unknown | FK |
record_id | Unknown | FK |
workflow_id | Unknown | FK |
assigned_date | Unknown | |
completed_date | Unknown | |
created_date | Unknown | |
instructions | Unknown | |
label | Unknown | |
workflow_class | Unknown |
document_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
languages | Unknown |
document_medicinal_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
medicinal_product | Unknown |
document_application
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
application | Unknown |
document_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
product | Unknown |
document_matching
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
ready_for_matching | Unknown |
document_labeling_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
labeling_category | Unknown |
document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
annotations_all | Unknown | |
annotations_anchors | Unknown | |
annotations_approved | Unknown | |
annotations_auto | Unknown | |
annotations_claim | Unknown | |
annotations_lines | Unknown | |
annotations_links | Unknown | |
annotations_notes | Unknown | |
annotations_permalink | Unknown | |
annotations_resolved | Unknown | |
annotations_suggested | Unknown | |
annotations_unresolved | Unknown | |
application | Json | |
approved_date | Unknown | |
attachment_version_date_for_submission | Unknown | |
attachment_version_for_submission | Unknown | |
binder | Unknown | |
bookmarks_edited | Unknown | |
classification | Unknown | |
clinical_site | Json | |
clinical_study | Json | |
country | Json | |
crosslink | Unknown | |
document_creation_date | Unknown | |
document_number | Unknown | |
drug_product | Json | |
drug_substance | Json | |
excipient | Json | |
filename | Unknown | |
format | Unknown | |
global_id | Unknown | |
global_version_id | Unknown | |
is_a_translation | Unknown | |
language_for_submission | Unknown | |
last_modified_by | Unknown | |
lifecycle | Unknown | |
locked | Unknown | |
major_version_number | Unknown | |
manufacturer | Json | |
md_5_checksum | Unknown | |
minor_version_number | Unknown | |
name | Unknown | |
nonclinical_study | Json | |
pages | Unknown | |
product_detail | Json | |
ready_for_publishing | Unknown | |
region | Json | |
size | Unknown | |
stage | Unknown | |
state_stage_id | Unknown | |
status | Unknown | |
submission | Json | |
subtype | Unknown | |
suppress_rendition | Unknown | |
type | Unknown | |
version_created_by | Unknown | |
version_creation_date | Unknown | |
version_id | Unknown | |
version_modified_date | Unknown |
document_group
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
groups | Unknown | FK |
type | String |
document_user
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
users | Unknown | FK |
type | String |
user_vault
| Column | Type | Keys |
|---|---|---|
vault_id | Unknown | PK |
user_id | Unknown | PKFK |
user_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
active | Unknown | |
created_date | Unknown | |
domain_active | Unknown | |
domain_id | Unknown | |
domain_name | Unknown | |
email | Unknown | |
first_name | Unknown | |
is_domain_admin | Unknown | |
last_login | Unknown | |
last_name | Unknown | |
license_type | Unknown | |
locale | Unknown | |
modified_by | Unknown | |
modified_date | Unknown | |
name | Unknown | |
security_policy_id | Unknown | |
security_profile | Unknown | |
timezone | Unknown | |
user_language | Unknown | |
user_needs_to_change_password | Unknown |
workflow_task_action_control
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
label | Unknown | |
type | Unknown |
workflow_task_action_detail
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
workflow_id | Unknown | PKFK |
description | Unknown | |
label | Unknown | |
name | Unknown | |
type | Unknown |
object_collection_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
object_name | Unknown | PKFK |
status | Unknown |
object_collection
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
configuration_state | Unknown | |
in_menu | Unknown | |
label | Unknown | |
label_plural | Unknown | |
orders | Unknown | |
prefix | Unknown | |
source | Unknown | |
url | Unknown |
object_record_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
created_by | Unknown | FK |
created_date | Unknown | |
modified_by | Unknown | |
modified_date | Unknown | |
name | Unknown |
object_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | FK |
object_metadata_relationship
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
object_name | Unknown | FK |
field | Unknown | |
relationship_deletion | Unknown | |
relationship_label | Unknown | |
relationship_name | Unknown | |
relationship_type | Unknown |
object_metadata_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
created_by | Unknown | FK |
create_object_inline | Unknown | |
created_date | Unknown | |
editable | Unknown | |
encrypted | Unknown | |
help_content | Unknown | |
label | Unknown | |
list_column | Unknown | |
lookup_relationship_name | Unknown | |
lookup_source_field | Unknown | |
max_length | Unknown | |
modified_by | Unknown | |
modified_date | Unknown | |
multi_value | Unknown | |
name | Unknown | |
no_copy | Unknown | |
object_label | Unknown | |
object_label_plural | Unknown | |
object_name | Unknown | |
object_prefix | Unknown | |
object_url | Unknown | |
orders | Unknown | |
picklist | Unknown | |
relationship_criteria | Unknown | |
relationship_deep_copy | Unknown | |
relationship_deletion | Unknown | |
relationship_inbound_label | Unknown | |
relationship_inbound_name | Unknown | |
relationship_outbound_name | Unknown | |
relationship_type | Unknown | |
required | Unknown | |
secure_relationship | Unknown | |
sequential_naming | Unknown | |
source | Unknown | |
system_managed_name | Unknown | |
type | Unknown | |
uniques | Unknown | |
value_format | Unknown |
object_metadata_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
status | Unknown |
object_metadata
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
created_by | Unknown | FK |
name | Unknown | FK |
url_metadata | Unknown | FK |
allow_attachment | Unknown | |
allow_type | Unknown | |
auditable | Unknown | |
available_lifecycles | Json | |
created_date | Unknown | |
data_store | Unknown | |
default_obj_type | Unknown | |
description | Unknown | |
dynamic_security | Unknown | |
enable_e_signature | Unknown | |
help_content | Unknown | |
in_menu | Unknown | |
label | Unknown | |
label_plural | Unknown | |
modified_by | Unknown | |
modified_date | Unknown | |
multi_select | Unknown | |
object_class | Unknown | |
orders | Unknown | |
prefix | Unknown | |
prevent_record_overwrite | Unknown | |
role_override | Unknown | |
secure_attachment | Unknown | |
secure_audit_trail | Unknown | |
secure_sharing_setting | Unknown | |
source | Unknown | |
system_managed | Unknown | |
url_field | Unknown | |
url_list | Unknown | |
url_record | Unknown | |
user_role_label | Unknown | |
user_role_label_plural | Unknown | |
user_role_name | Unknown | |
user_role_prefix | Unknown | |
user_role_setup_object | Unknown | |
user_role_url | Unknown |
workflow_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workflow_id | Unknown | PKFK |
status | Unknown |
workflow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
initiator | Unknown | FK |
object | Unknown | FK |
record_id | Unknown | FK |
completed_date | Unknown | |
label | Unknown | |
started_date | Unknown |