Concept: Prism Audit Report
Workday enables you to view audits of modifications to Prism artifacts, such as datasets and tables, using the
Prism Audit Report
report. You can run this report on any dataset or table to view all upstream changes that affect the dataset or table that you audit. This increases your productivity by providing a single location to view all upstream changes affecting a published dataset instead of viewing audit trail Prism snapshots for each dataset and table.You must have access to the
System Auditing
domain to run the Prism Audit Report
.The report returns changes to Prism artifacts that are in the upstream lineage of the Prism artifact that you're auditing. Each record in the report represents a different edit to the audited artifact or one of its upstream artifacts.
The
Prism Audit Report
includes changes made to these Prism artifacts:
- Datasets
- Tables
- Data change tasks, including activities
- The datasets and tables that are upstream from a data change task that uses a dataset or table as its source.
Each record includes the details of every change, including the:
- Before value.
- After value.
- Difference between the before and after values.
- User who made the change.
- Time stamp.
- Category and sub-category.
- Additional information to help you find the location of the change in the entire lineage, such as:
- Artifact Name
- Stage ID
- Stage Type
- Pipeline segment. This field describes in which Prism pipeline the artifact resides. Workday describes the pipeline segment using the name of either the data change task that modifies data in a table or the most downstream derived dataset.
Workday organizes each record into a different category to help you filter the report to view only the changes you’re interested in. Each category has different sub-categories to provide more context for the type of change, and to help you find where the change was made.
The report uses these categories:
Prism Audit Category | Description |
|---|---|
Data | Not applicable. Workday doesn’t include any changes in this category. |
Data Operation | Includes activities that add, remove, or update data, such as truncate table operations, data change activities, publishing a dataset, or enabling a table for analysis. |
Documentation | Includes changes to the Prism artifact that describe or document some aspect of the artifact, such as a field name or dataset description. |
Error | Includes system errors only. |
Security | Not applicable. Workday doesn’t include any changes in this category. |
Summary | Summarizes how other changes can affect the Prism artifact as whole, such as the final list of all output fields, or summarizing the final order of dataset stages. |
Transformation | Includes changes to the Prism artifact that can transform existing data, such as a Prism calculated field or a dataset Join stage. |