Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

Generate a valid masked US SSN using Delphix algorithm framework

  • 1.  Generate a valid masked US SSN using Delphix algorithm framework

    Posted 01-18-2022 11:05:00 AM

    Q. How to create a valid SSN using Delphix ?

    A. It is very easy to generate a valid SSN using Delphix while de-identifying data. This can be achieved using the "Segmented Mapping" Type of algorithm.
    Read more here - https://maskingdocs.delphix.com/6.0.11/Securing_Sensitive_Data/Algorithms/Algorithm_Frameworks/Segment_Mapping/

    The specification is relevant to the US SSA number format as per the guidance here - https://www.ssa.gov/employer/randomization.html

    Create a Segmented Mapping Algorithm

    • Choose 3 Segments  3,2,4 - Alpha Numeric
    • 1st Segment - set a range of 1,2,3,4,5,6,7,8 for the first digit
    • 1st Segment - set a range of 0,1,2,3,4,5,7,8,9 for second ( or third) digit
    • 2nd segment -  set a range of 1,2,3,4,5,6,7,8,9 for first ( or second) digit
    • Last segment - set a range of 1,2,3,4,5,6,7,8,9 for one of the last 4 digits
    Save and use.

    Please comment on any improvements or enhancements.

    ------------------------------
    Himanshu Pawar
    Principal Solutions Engineer
    Delphix
    ------------------------------


  • 2.  RE: Generate a valid masked US SSN using Delphix algorithm framework

    Posted 01-18-2022 04:59:00 PM
    Thank you for the solution to mask valid SSN using Delphix. 

    Do you have any example where we can look into and set up the SSN configuration in masking algorithm. This would be helpful for us to apply SSN rules.

    ------------------------------
    Wajeed Ahamad
    Delphix Community Members
    ------------------------------

    Original Message


Related Content