PII Removal
PII Removal
This section has information about a feature that enables retailers to comply with customer requests to remove personal data from the system. This feature helps retailers comply with General Data Protection Regulation (GDPR) requirements. GDPR is a European Union regulation on information privacy in the European Union (EU) and the European Economic Area (EEA).
The feature removes certain personally identifiable information (PII) and replaces it with generic data.
Requirements/Limitations
- Only meant to be used for one customer at a time. A customer comes in and requests their data be removed. This tool enables the retailer to comply with the request. Not meant for clearing data from all customers at a single time.
- Doesn't remove modified_by, created_by entries.
- The Customer SID is not touched.
To Remove PII:
Navigate to Tech Toolkit and log in.
Select Data Utilities > PII Removal Tool.
Select the field by which you want to search for the person and enter search criteria.
Click the Search icon (magnifying glass).
Select the desired customer in the list of results.
Click Purge Personal and Identifying Information.
A message indicates the customer's information is scheduled for removal.
The following tables list the affected fields when the feature is used:
Customer Record
| Customer Record field | Entry after running PII Removal |
|---|---|
| Accounting_System_SID | cleared |
| Alternate_ID1 | cleared |
| Alternate_ID2 | cleared |
| Birth_Day | cleared |
| Birth_Month | cleared |
| Birth_Year | cleared |
| Company_SID | cleared |
| CustImage | cleared |
| Country_SID | cleared |
| cleared | |
| Gender | cleared |
| Image | cleared |
| ImagePath (value) | cleared |
| ImagePath (file) | cleared |
| Info1 | cleared |
| Info2 | cleared |
| Notes | cleared |
| Region_SID | cleared |
| Suffix_SID | cleared |
| Title_SID | cleared |
| WSC_Password | cleared |
| WSC_Username | cleared |
| UDFs | cleared |
Referenced Customer Information on POS Transactions
| POS Transaction field | Entry after running PII |
|---|---|
| bt_address_line1 | cleared |
| bt_address_line2 | cleared |
| bt_address_line3 | cleared |
| bt_address_line4 | cleared |
| bt_address_line5 | cleared |
| bt_address_line6 | cleared |
| bt_company_name | cleared |
| bt_country | cleared |
| bt_email | cleared |
| bt_first_name | changed to PIICLEAR |
| bt_info1 | cleared |
| bt_info2 | cleared |
| bt_last_name | changed to PIICLEAR |
| bt_postal_code | cleared |
| bt_postal_code_extension | cleared |
| bt_primary_phone_no | cleared |
| bt_title | cleared |
| st_address_line1 | cleared |
| st_address_line2 | cleared |
| st_address_line3 | cleared |
| st_address_line4 | cleared |
| st_address_line5 | cleared |
| st_address_line6 | cleared |
| st_company_name | cleared |
| st_country | cleared |
| st_email | cleared |
| st_first_name | cleared |
| st_info1 | cleared |
| st_info2 | cleared |
| st_last_name | changed to PIICLEAR |
| st_postal_code | cleared |
| st_postal_code_extension | cleared |
| st_primary_phone_no | cleared |
| st_title | cleared |
Employee
Employee records are included because under-the-hood of Prism, employees are their own type of record but are also a subset of customer records. That is, employees are a special type of customer.
| Employee field | Entry after running PII Removal |
|---|---|
| empl_no1 | cleared |
| empl_no2 | cleared |
| full_name | cleared |
| hire_date | cleared |
| empl_id | cleared |
| password | cleared |
| empl_name | changed to pseudo-random hash of DateTime |
| user_name | changed to pseudo-random hash of DateTime |
| active | False |
Referenced POS Transactions
| POS Transaction field | Entry after running PII Removal |
|---|---|
| Employee1_Full_Name | PIICLEAR |
| Employee1_Name | PIICLEAR |
| Employee1_Login_Name | PIICLEAR |
| Employee2_Full_Name | PIICLEAR |
| Employee2_Login_Name | PIICLEAR |
| Employee2_Login_Name | PIICLEAR |
| Employee3_Full_Name | PIICLEAR |
| Employee3_Name | PIICLEAR |
| Employee3_Login_Name | PIICLEAR |
| Employee4_Full_Name | PIICLEAR |
| Employee4_Name | PIICLEAR |
| Employee4_Login_Name | PIICLEAR |
| Employee5_Full_Name | PIICLEAR |
| Employee5_Name | PIICLEAR |
| Employee5_Login_Name | PIICLEAR |
Referenced POS Transaction Items
| POS Transaction Item field | Entry after running PII Removal |
|---|---|
| Employee1_Full_Name | PIICLEAR |
| Employee1_Name | PIICLEAR |
| Employee1_Login_Name | PIICLEAR |
| Employee2_Full_Name | PIICLEAR |
| Employee2_Name | PIICLEAR |
| Employee2_Login_Name | PIICLEAR |
| Employee3_Full_Name | PIICLEAR |
| Employee3_Name | PIICLEAR |
| Employee3_Login_Name | PIICLEAR |
| Employee4_Full_Name | PIICLEAR |
| Employee4_Name | PIICLEAR |
| Employee4_Login_Name | PIICLEAR |
| Employee5_Full_Name | PIICLEAR |
| Employee5_Name | PIICLEAR |
| Employee5_Login_Name | PIICLEAR |