Creating a BI report to extract Candidate PII to then use for HDL load after anonymising the data
Summary:
Trying to extract Candidate PII data to then anonymise and HDL load back in to satisfy RTBF requests.
Content (required):
We have a few RTBF requests from Candidates. After researching and reading comments posted, it does not look like there is an Oracle process that covers this for candidates what do not have a work relationship.
Therefore, I need to establish all the 'tables' that the candidates PII information would reside on, then put together a BI report which can be used to do a HDL load after the extract data has been anonymised.
Has anyone else done this?