Should we mask the EMPLID field across all PeopleSoft tables? What are the possible impacts?
Hello everyone,
Our team is considering masking the EMPLID field across all tables in our PeopleSoft environments (mainly for UAT / DEV data privacy compliance).
Before proceeding, I would like to understand:
- Is it recommended or supported by Oracle to mask EMPLID globally?
- What would be the system impacts if we replace or transform EMPLID in all tables (e.g., workflow, effective-dated records, RLS, Integration Broker messages, joins, etc.)?
- Are there any safer or recommended approaches from Oracle for masking sensitive data in non-production environments?
If anyone has experience performing EMPLID masking or anonymization across PeopleSoft environments, please share your insights or best practices.