Skip to main content

How create a report to return a list of field names that supports field encryption and private fields

This report is useful when you want to know which data fields supports data encryption and private fields.Start by creating a User Report Type with: Base Table = Data Dictionary Field and Data Sourc

Updated over 2 weeks ago

This report is useful when you want to know which data fields supports data encryption and private fields.

Start by creating a User Report Type with:

  • Base Table = Data Dictionary Field and

  • Data Source = Data Dictionary Table with the path Data Dictionary Field->Data Dictionary Table

Next create a User Report using the User Report Type "Data Dictionary Fields". Configure the report to include the following:

For Supported Encryption Fields:

Data Fields:

  • Data Dictionary Table: Name

  • Data Dictionary Field: Column name

  • Data Dictionary Field: Unique name

  • Data Dictionary Field: Supports Encryption

Filters:

  • Data Dictionary Field: Supports Encryption, Comparison = Is Equal To, Comparison Value = Yes

For Supported Private Fields:

Data Fields:

  • Data Dictionary Table: Name

  • Data Dictionary Field: Column name

  • Data Dictionary Field: Unique name

  • Data Dictionary Field: Supports Private

Filters:

  • Data Dictionary Field: Supports Private, Comparison = Is Equal To, Comparison Value = Yes

Did this answer your question?