Protecting Personal Identifiable Information
What is PII?
Personally Identifiable Information (PII), is any data that can be used used to identify an individual such as names, Birthdate, driver’s license number, SSNs, bank account numbers, passport numbers, email addresses, and more
"Encryption is the process of converting data to an unrecognizable or "encrypted" form. It is commonly used to protect sensitive information
I would guess there are multiple definitions and not the one and only! I would not say that encryption is wrong in this context, but "data anonymization" would be the better wording here.
PII Example :
Let's start data anonymization for PII fields
TAXID & SALARY fields are PII. Customer can mask their field value through UPDATE SQL Statement as shown below ENCRYPTED_TAXID
Note:
- Must have Database privileges for UPDATE Statements or
- Share your tested SQL script to Contact Technical Service Team for masking the field.
Additional references :