What are some algorithms to use to MASK DOLLAR amounts such as salary, expenses, bonus?

  • 0
  • 1
  • Question
  • Updated 2 weeks ago
  • Answered
What are some algorithms to use to MASK $$$ dollar amounts such as salary, expenses, loans, bonus? Are there out-of-the box algorithms? Thanks
Photo of Raymond Siegel

Raymond Siegel

  • 100 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of John Leser

John Leser, Employee

  • 300 Points 250 badge 2x thumb
One option that might meet your needs is to construct a Secure Lookup algorithm with reasonable dollar amount replacement values. I've found that so long as all the lookup values are valid numerical amounts such as "125.50", etc. the SL algorithm will work to mask numerical data.

If you're hoping to preserve more of nature of your data, another option is using min/max algorithm to eliminate outliers that might identify a specific individual.
Photo of Raymond Siegel

Raymond Siegel

  • 100 Points 100 badge 2x thumb
Can Secure Shuffle work to mix up the numbers?  or can SSN / SSN work to mix up numbers?  Thanks

Photo of Raymond Siegel

Raymond Siegel

  • 100 Points 100 badge 2x thumb
For Secure lookup---I think you need to provide a Lookup text file--with value pairs--but the Salary numbers are too random to make a table of possible values.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 5,846 Points 5k badge 2x thumb
Hi ,

The best one for salary, bonus, age ... is the max-min algorithm

Regards,

Mouhssine
Photo of John Leser

John Leser, Employee

  • 300 Points 250 badge 2x thumb
Official Response
For secure lookup, the file you provide is a newline separate list of replacements, like:

100.00
200.00
300.00
400.00


The masking behavior of secure lookup is to cryptographically hash each input value, and replace it with one of the values from the lookup file based on the hash result. So the result with my example input file would be each value replaced with one of those 4 values. There is no need to provide any information about the potential input values.
(Edited)
Photo of Raymond Siegel

Raymond Siegel

  • 100 Points 100 badge 2x thumb
I see--that is quite simple then!!  Sounds good.  So I can make multiple Algorithms for Salary, Bonus, hourly rate, etc with associated Unique lookup tables so the substituted New Values (as masked values) are valid for the ranges and field criteria like 401K =Y/N.  THANKS!
Photo of John Leser

John Leser, Employee

  • 300 Points 250 badge 2x thumb
Correct, you can create as many secure lookups as you need with data that is realistic for your particular use cases.
Photo of John Hanratty

John Hanratty, Employee

  • 620 Points 500 badge 2x thumb
I agree a SL algorithm would work well here. You might include a $ character in your SL file if needed. Even a Segmented Mapping would work. *note: keep in mind if the bonus amount needs to correspond in range of the salary amount.