Data Masking in a Peoplesoft

I am trying to do a data masking project. My requirement is to create master lookup table to mask the the data consistently across the solution through an app engine.
I want to populate NID for each employee by shuffling the NID from PERS_NID of the employee with the another NID having same country and the NID_TYPE.
Can any one suggest the peoplecode to achieve this?

Popular White Paper On This Topic

What Expenses does is to have a mask table of the credit card (two fields, the encrypted value and the mask to be displayed) and then the system uses application package peoplecode to encrypt and decrypt the information as needed.

Advantage is that all the necessary code is in one object and just the necessary methods are exposed and can be used anywhere that peoplecode can be used.

The specific application package in Financials 9.1 is EX.Common.CreditCard

when you said Data masking , I assume you want to re arrange NID so that it does not match original one but remain consistence among all tables . There are many publicly available tools for that doing that . If you want to do something similar in Peoplesoft :

2. Through psrecdefn table , make a list of all tables having NID field

3. Update Old Value with new value ..

I hope you are creating solution for data masking in non production environment and donot want to retrieve original Data ..

If you want to have data masking in production then you are actually looking for data encryption + data masking and Richard soultion will work just fine for you . You might need to tweek some field to use that .

If you are masking, take care of fields that have a check-sum type valildation.
For example, if you are applying a random number to NID, and you are in Canada, and you make a change on the page, and the NID is invalid due to the random number, you will be prevented from saving the page until you "guess" the correct MOD10 number.

Did you try using the data masking at database level. Oracle has some nice tools for enabling datamasking without application level changes. I have not tried it myself aganist PeopleSoft but it must be worth looking at.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.