JDBC Driver for Veeva Vault

Build 22.0.8462

AuditHistory

Retrieve complete audit history for a single document or for a single object record.

View Specific Information

Either the DocumentId column or the ObjectName and ObjectRecordId columns must be specified in order to query this view.

The driver will use the Veeva Vault API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.

  • DocumentId supports the '=' operator.
  • ObjectName supports the '=' operator.
  • ObjectRecordId supports the '=' operator.
  • StartDate supports the '=' operator.
  • EndDate supports the '=' operator.

For example, the following queries are processed server-side:

SELECT * FROM AuditHistory WHERE DocumentId= '8'
SELECT * FROM AuditHistory WHERE ObjectName = 'product__v' AND ObjectRecordId = '00P000000000601'
SELECT * FROM AuditHistory WHERE DocumentId = '3258' AND StartDate = '2020-01-01T01:13:36' AND EndDate = '2020-01-06T01:3:32'

Columns

Name Type Description
DocumentId String Identifier of the document.
ObjectName String The object Name.
ObjectRecordId String Identifier of the object record.
Id [KEY] String Identifier of the audit record.
Timestamp Datetime The time and date of the preformed action.
UserName String The name of the user responsible for the preformed action.
FullName String The full name of the user responsible for the preformed action.
Action String The name of the action performed on the object record or on the document.
Item String The type and name of the affected record or the number field value of the affected Document.
FieldName String The name of the affected field.
OldValue String The previous field value before the executed action.
NewValue String The actual field value after the executed action.
ObjectLabel String The label of the affected object.
MigrationMode Bool Indicates that the object record was created using the X-VaultAPI-MigrationMode header with a specified state__v value.
WorkflowName String The name of the workflow that preformed the action.
TaskName String The name of the preformed workflow task.
Verdict String The verdict of the workflow task action.
Reason String The reason of the workflow task action verdict.
Capacity String The approval capacity of the workflow that preformed the action.
SignatureMeaning String The reason a signature was required for any manifested signature.
ViewLicense String Returns a value of View-Based User only when the user is assigned that license type. Otherwise, returns an empty string.
JobInstanceId String The Id of the Job Instance that preformed the action.
Version String The version of the affected Document.
DocumentUrl String The URL of the affected Document.
EventDescription String Description of the action that occurred.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer more granular control over the tuples that are returned from the data source.

Name Type Description
StartDate Datetime Specify a start date to retrieve audit history. This date cannot be more than 30 days ago. IIf not stated, defaults to the vault's creation date.
EndDate Datetime Specify an end date to retrieve audit history. This date cannot be more than 30 days ago. If not stated, defaults to today's date.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462