Data Glossary for PIA & DPIA Automation Reports

OneTrust PIA & DPIA Automation helps streamline the collection of information regarding projects and inventories, automatically identify risks, and provide in-depth visualizations and reporting capabilities. PIA & DPIA Automation reports built from the data captured by the PIA & DPIA Automation module can be used to view assessment details, metadata related to individual assessments, assessment stage change information, and related risks associated with provided responses.

Available PIA & DPIA Automation Report Templates

The following report templates are available in the Reports Gallery when you select the PIA & DPIA Automation data source. You can view the available Reports Gallery templates by clicking the Create New button on the Reports screen. All templates will display by default, but can be narrowed down based on your selected data source or report type.

Report Name

Description

Data Source

Report Type

Data Type

Assessment Custom Report

Used to create an assessment report from scratch that you can customize to capture the information most relevant to your organization.

-

Column or PDF

-

Assessment Default PDF

Used to view details on a single assessment, address responses provided by respondents, and evaluate the related risks associated with those responses.

PIA & DPIA Automation

PDF

Any Template

Assessment Summary Details

Used to view all assessment details, metadata related to individual assessments, and assessment stage change information.

PIA & DPIA Automation

Column

Assessment

Available Data on PIA & DPIA Automation Reports

The following fields are available to be included on PIA & DPIA Automation reports. The fields that display in a report will automatically populate depending on the report template you selected when creating the report.

Field

Data Format

Classification

Description

Applicable Report Templates

ID

Number

Metadata

The assessment ID number.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Name

Hyperlink

Metadata

The name of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Organization

Multi

Metadata

The organizational group which is responsible for the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Stage

Multi

Metadata

The current stage of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Result

Multi

Metadata

Whether or not the assessment is approved or rejected.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Approver

User

Metadata

The approver of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Respondent

User

Metadata

The respondent of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Total Risks

Number

Metadata

The number amount of risk assessed.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Description

Text

Metadata

A brief description of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Deadline

Date/Time

Metadata

A due date for the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Creator

User

Metadata

The creator of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Date Created

Date/Time

Metadata

The date the assessment was created.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Template

Text

Metadata

A questionnaire used to send assessments.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Project Version

Number

Metadata

The version of a project.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Date Completed

Date/Time

Metadata

The date the assessment was completed.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Date Submitted

Date/Time

Metadata

The date the assessment was submitted.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Very High Risks

Number

Metadata

The total number of risks captured on an assessment with a very high risk level.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Note:

Assessment reports display only the following risk level columns: Low, Medium, High, and Very High. Zero or empty risk levels are not included as separate columns in the report.

High Risks

Number

Metadata

The total number of risks captured on an assessment with a high risk level.

Medium Risks

Number

Metadata

The total number of risks captured on an assessment with a medium risk level.

Low Risks

Number

Metadata

The total number of risks captured on an assessment with a low risk level.

Residual Risk Level

Multi

Metadata

The overall risk score after considering existing controls.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Primary Record Id

Number

Metadata

The number ID of the primary record.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Primary Record Name

Text

Metadata

The name of the primary record.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Template Version

Number

Metadata

The editable version of a published template.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

GUID

Text

Metadata

The unique number of the assessment ID field.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Residual Risk Score

Number

Metadata

The overall risk score.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Open Info Request

Number

Metadata

A need for more information request that hasn't been addressed.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Tags

Multi

Metadata

The tag(s) that best suit the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Open Risk Count

Number

Metadata

The amount of open risks that have not been addressed.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Pending Reviews

User

Metadata

The assessments that are waiting to be reviewed.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Result Comments

Text

Metadata

Comments that accompany the result of the assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Submission Progress (%)

Number

Metadata

The percentage of the assessment that has been completed.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Inherent Risk Level

Multi

Metadata

The overall risk score without considering existing controls.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Target Risk Level

Multi

Metadata

The desired risk level.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Inherent Risk Score

Number

Metadata

The overall inherent risk score.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Target Risk Score

Number

Metadata

The amount of risk accepted to grant an approved assessment.

  • Assessment Summary Details

  • Assessment Custom Report

  • Assessment Default PDF

Old Stage - Stage History

Multi

Metadata

The previous stage(s) that the assessment has gone through to date

  • Assessment Summary Details

New Stage - Stage History

Multi

Metadata

The latest stage(s) that the assessment has gone through to date.

  • Assessment Summary Details

Stage Change Date - Stage History

Date/Time

Metadata

The time stamps of all stage changes.

  • Assessment Summary Details

Stage Changed By - Stage History

User

Metadata

The user(s) who have made these stage changes.

  • Assessment Summary Details

Old Stage Date - Stage History

Date/Time

Metadata

The time stamps for stage(s) that are listed in the Old Stage column.

  • Assessment Summary Details

Cycle Number - Stage History

Number

Metadata

The number of times that an assessment has changed stage.

  • Assessment Summary Details

Days Spent In Old Stage - Stage History

Number

Metadata

The total number of days that the assessment stayed in the stage(s) listed in the Old Stage column.

  • Assessment Summary Details

Comment - Comments

Text

Metadata

The text of the comment.

  • Assessment Custom Report

Question Number - Comments

Number

Metadata

The question number where the comment is present.

  • Assessment Custom Report

Section Number - Comments

Number

Metadata

The section number where the comment is present.

  • Assessment Custom Report

Comment Added By - Comments

User

Metadata

The name of the user who added the comment.

  • Assessment Custom Report

Created Date - Comments

Date/Time

Metadata

The date the comment was created.

  • Assessment Custom Report

Question Name - Comments

Text

Metadata

The name of the question where the comment is present.

  • Assessment Custom Report

Note - Notes

Text

Metadata

The text of the note present on the assessment.

  • Assessment Custom Report

Note Added By - Notes

User

Metadata

The name of the user who left the comment.

  • Assessment Custom Report

Created date - Notes

Date/Time

Metadata

The date the note was created.

  • Assessment Custom Report

{Risk Category}: Inherent Risk Level - Categorical Risks

Multi

Custom

The inherent risk level defined by risk category.

  • Assessment Summary Details

{Risk Category}: Inherent Risk Score - Categorical Risks

Number

Custom

The overall inherent risk score defined by risk category.

  • Assessment Summary Details

{Risk Category}: Residual Risk Level - Categorical Risks

Multi

Custom

The residual risk level defined by risk category.

  • Assessment Summary Details

{Risk Category}: Residual Risk Score - Categorical Risks

Number

Custom

The overall residual risk score by risk category.

  • Assessment Summary Details

{Risk Category}: Target Risk Level - Categorical Risks

Multi

Custom

The desired risk level defined by risk categories.

  • Assessment Summary Details

{Risk Category}: Target Risk Score - Categorical Risks

Number

Custom

The desired risk score defined by risk categories.

  • Assessment Summary Details

Custom questions on templates - Date

Date/Time

Custom

The date question type is used to collect information about when a relationship or activity began or ended.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Multi-choice

Multi

Custom

The multi-choice question type is used to capture information based on a pre-set list of options.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Statement

Text

Custom

The statement question type is a free-form response field that does not collect information.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Text

Text

Custom

The text question type collects free-form responses which are entered by the respondent.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Yes/No

Multi

Custom

The Yes/No question types collect information about things in a yes or no format.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Inventory

Multi

Custom

The inventory question type, in combination with attribute questions, create and update information about inventory records such as assets, processing activities, and vendors.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Attribute

Text, Multi, Date/Time

Custom

The attribute question type, in combination with inventory questions capture information about the attributes of an inventory record.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Personal Data

Multi

Custom

The personal data question type is used to capture information about how data elements connect to data subjects.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Controls

Multi

Custom

The control question type is used to add controls to the associated inventory record.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Contract

Multi

Custom

The contract question type is used to answer questions about existing contracts or update their attributes.

  • Assessment Custom Report

  • Assessment Default PDF

Custom questions on templates - Engagements

Multi

Custom

The engagement question type is used to answer questions about existing engagements or update their attributes.

  • Assessment Custom Report

  • Assessment Default PDF

ID

Hyperlink

Default

The risk ID number.

  • Assessment Default PDF

Description

Text

Default

The description of the risk.

  • Assessment Default PDF

Organization

Multi

Attribute

The organization group that this risk is related to.

  • Assessment Default PDF

Source

Hyperlink

Attribute

The source or collection point of the data.

  • Assessment Default PDF

Controls

Hyperlink

Default

The related controls added to the risk.

  • Assessment Default PDF

Source Type

Multi

Default

The location in which the data was collected. Examples include: inventory, incident, etc.

  • Assessment Default PDF

Deadline

Date/Time

Default

The date by when the risk must be resolved.

  • Assessment Default PDF

Created Date

Date/Time

Default

The date the risk record was created.

  • Assessment Default PDF

Category

Multi

Attribute Array

The associated category that the risk is assigned to. Example categories include: financial, geographic, operational, regulatory/compliance, security

  • Assessment Default PDF

Risk Approver

User

Attribute Array

The name of the person responsible for approving the risk.

  • Assessment Default PDF

Treatment

Text

Default

The process by which the risk owner actively mitigates the risk.

  • Assessment Default PDF

Treatment Plan

Text

Default

The plan that includes completing specific tasks, assigning a risk owner, and adding controls to mitigate the risk.

  • Assessment Default PDF

Stage

Multi

Attribute

The current risk stage.

  • Assessment Default PDF

Treatment Status

Multi

Attribute

The current status of the treatment plan. Status options include: in progress, under review, exception requested, exception granted.

  • Assessment Default PDF

Result

Multi

Attribute

The action taken on the risk. Actions include: accepted, avoided, ignored, reduced, rejected, transferred

  • Assessment Default PDF

Inherent Level

Multi

Attribute

The inherent risk level determined by the risk matrix.

  • Assessment Default PDF

Inherent Impact Level

Multi

Attribute

The impact that a risk would have on an organization if it occurred without controls to mitigate.

  • Assessment Default PDF

Inherent Probability Level

Multi

Attribute

The probability of the risk occurring if there were no controls in place.

  • Assessment Default PDF

Inherent Score

Text

Default

The overall risk score without considering existing controls.

  • Assessment Default PDF

Target Level

Multi

Attribute

The desired risk level.

  • Assessment Default PDF

Target Impact Level

Multi

Attribute

The desired impact that a risk would have on an organization if it occurred.

  • Assessment Default PDF

Target Probability Level

Multi

Attribute

The desired probability of the risk occurring.

  • Assessment Default PDF

Target Score

Text

Default

The desired risk score.

  • Assessment Default PDF

Date Closed

Date

Default

The date in which the risk treatment status was approved, and the risk record closed.

  • Assessment Default PDF

Residual Level

Multi

Attribute

The risk level if it occurred with the current controls that are implemented.

  • Assessment Default PDF

Residual Impact Level

Multi

Attribute

The impact a risk would have on an organization if it occurred with the current controls that are implemented.

  • Assessment Default PDF

Residual Probability Level

Multi

Attribute

The probability of the risk occurring with the current controls that are implemented.

  • Assessment Default PDF

Residual Score

Text

Default

The overall risk score after considering existing controls.

  • Assessment Default PDF

Type

Multi

Default

The type of risk and select the specific asset, entity, processing activity, or vendor.

  • Assessment Default PDF

Threat

Multi

Attribute

The incident that has the potential to cause harm or expose vulnerabilities.

  • Assessment Default PDF

Vulnerability

Multi

Attribute Array

The known weakness that would allow attacks if not contained.

  • Assessment Default PDF

Risk Owners

User

Attribute Array

The name(s) of the individual(s) responsible for remedying the risk.

  • Assessment Default PDF

Risk GUID

UUID

Default

The unique number of the risk GUID ID field.

  • Assessment Default PDF

Risk Template

Multi

Attribute

The name of the risk template in the Risk Library.

  • Assessment Default PDF

Old Stage

Multi

Attribute

The previous stage(s) that the assessment has gone through to date.

  • Assessment Default PDF

New Stage

Multi

Attribute

The latest stage(s) that the assessment has gone through to date.

  • Assessment Default PDF

Stage Changed By

User

Attribute

The time stamps of all stage changes.

  • Assessment Default PDF

Stage Change Date

Date/Time

Default

The user(s) who have made these stage changes.

  • Assessment Default PDF

Old Stage Date

Date/Time

Default

The time stamps for stage(s) that are listed in the Old Stage column.

  • Assessment Default PDF

Sequence Number

Number

Default

The number of times that an assessment has changed stage.

  • Assessment Default PDF

Days Spent in Old Stage

Number

Default

The total number of days that the assessment stayed in the stage(s) listed in the Old Stage column.

  • Assessment Default PDF

ID

Hyperlink

Default

The unique identifier to support integration across applications.

  • Assessment Default PDF

Control Name

Text

Attribute

The name of the control.

  • Assessment Default PDF

Framework

Multi

Attribute

The frameworks in which you can add controls.

  • Assessment Default PDF

Description

Text

Default

A brief description of the control.

  • Assessment Default PDF

Category

Multi

Attribute

The associated category that the control is assigned to.

  • Assessment Default PDF

Status

Multi

Attribute

The current status of the control. Status options include: pending, implemented, not doing

  • Assessment Default PDF

Effectiveness

Multi

Attribute

The effectiveness of an implemented control. Options include: effective, ineffective, planned

  • Assessment Default PDF

Maturity

Multi

Attribute

The maturity of an implemented control.

  • Assessment Default PDF

Control Owner

User

Attribute Array

The user who is responsible for the control.

  • Assessment Default PDF

Deadline

Date

Default

The date by when the control must be implemented.

  • Assessment Default PDF

Information request data in Assessment Automation Reports

Note: The Information request data in Assessment Automation Reports is in Public Preview. Please contact OneTrust Support to request early access.

You can now access information request data directly through Assessment Automation reports, in addition to the Open info request count.

Assessment Automation reports will now contain the underlying information-request conversation data including the request, responses, status, question context, authors, and dates.

User leveraging information request data in their reports will see a new Information requests tab in their reports, which will feature the following information:
  • Info Request ID

  • Assessment ID

  • Assessment Name

  • Template

  • Section No

  • Section

  • Question #

  • Information Request

  • Message Type

  • Message Text

  • Author

  • Date

  • Status