Reporting

DCR History

Advanced reporting users can now query the details available in the DCR History for inbox tasks to report on all changes that occurred on DCRs.

This feature is not enabled by default.

Enable the feature

1. In the Admin console, click Settings > General Settings.

2. Click Edit.

3. Select the DCR History Reporting setting.

4. Save your changes.

Reports can now be run on the change request revision tables. Regardless of when the feature is enabled, revision data is available starting from December 2024.

Reporting tables

Two new reporting tables are available in the Revision History section in the SQL Query Editor.

Change Request Revision (change_request_revision)

This table contains the following columns:

• Change Request ID - The task ID.

• Revision - The version assigned to each change.

• Action - The updates applied to the task.

• Action By - The user that made the change.

• Reassigned To - The task was assigned to a user.

• Reason - The reason the version changed.

• Modified Time - The time that the change was made.

Example

Change Request Field Revision (change_request_field_revision)

This table contains all changes that occurred to fields on a task for each revision.

It contains the following columns:

• Change Request ID - The Task ID.

• Revision - The version assigned to each change.

• Object - The data model object.

• Field Name - The field that was changed in that revision.

• Saved Value - The final value that was saved in the revision.

• Field Change Status - The status of the field for the revision.

Example

Sample query

Use this query to view the time that Veeva OpenData processed DCRs.

SELECT
        change_request_id,
        revision,
        modified_time,
        ACTION
    FROM
        change_request_revision
    WHERE
        ACTION = 'MASTER_PROCESSED'

Results

For more details about the available revision data and actions that you can report on, see the DCR History topic in the Veeva Network Online Help.