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 connector 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 connector.
- 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. |