SSIS Components for Veeva Vault

Build 24.0.9060

DocumentUserActions

Retrieve all available user actions on specific versions of multiple documents or binders.

View Specific Information

DocumentId, MajorVersion and MinorVersion must be specified in order to query this view. To find these values, you can execute the following query:

SELECT version_id FROM Documents
And version_id values are of this pattern: {DocumentId}_{MajorVersion}_{MinorVersion}

Some query examples:
SELECT * FROM DocumentUserActions WHERE SourceDocumentId = '122' AND MajorVersion = 1 AND MinorVersion = 0
SELECT * FROM DocumentUserActions WHERE SourceDocumentId = '101' AND MajorVersion = 0 AND MinorVersion = 1

Columns

Name Type Description
DocumentId String Name of the action.
Name String Name of the action.
Label String Label of the action.
ActionType String Type of the action.
Lifecycle String Name of the lifecycle.
State String State before the action is initialized.
MajorVersion Integer Major version of the source document.
MinorVersion Integer Minor version of the source document.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060