Decrypting PII Data Fields with a Report

Overview

When creating a Data Structure, Designers may encrypt their data fields to hide PII (Personal Identifiable Information) such as an SSN from accidental viewing to avoid security risks,
To allow the display of information within PII fields, data may be decrypted on a trusted Report through the use of a Calculated Column.

Example

1. From a Designer Project, select CREATE DATATYPES/INTEGRATION, and CREATE a new Entity. 
2. Next, name the Entity ("EmployeeInformation") and provide the following Name and Type configurations:"FirstName" String, "SSN" Int32, "Age" Int32.
3. Select the row for "SSN." Then, under ADVANCED, enable Contains Personally Identifying Information (PII).
4. With the Age [Int32] data member selected, enable Encrypt Data under the ADVANCED category. Then, click SAVE. 
5. Via Entity CRUD Actions, generate several pieces of data for the created Entity. 
6. CREATE a new Report using the Employee Information Data Source under User Defined Types > Entities. Then, Add the First Name Data Field. 
7. Under Data Fields, click Add. Then, navigate to Calculated Columns and select EncryptedOrPIIDataField.
   
   From the resulting Add Calculated Column window, select the desired Field from the dropdown (Age), provide a new name for the field under Title, then click OK. 
8. Verify that the Age data now appears in the Report. 
   EncryptedOrPIIDataField Functionality

   The EncryptedOrPIIDataField will decode and display any encrypted data for the select Field on the Report.
   
   If the Report utilizes the previous Encrypted Data Field instead, delete this field and provide a new EncryptedOrPIIDataField to display the desired encrypted data and avoid potential errors.