masking a ss# on a smart note - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

SueS

Basic Member

Posts: 20

New Poster

5/7/2012 12:02 PM

I have a smart note that HR wants to see the "before" and "after" of various fields that may get changed on a dependent's record. One of thee fields is the ss#. Is there a way to mask the ss# so it shows as ***-**-6789?

Any advice would be greatly appreciated.

Matthew Nye

Veteran Member

Posts: 514

5/7/2012 12:15 PM

Easiest place to do this is in the InfoSet. What is your data source type, DME, RDBMS, etc?

SueS

Basic Member

Posts: 20

New Poster

5/7/2012 12:34 PM

It is a jdbc connection to a relational db.

Matthew Nye

Veteran Member

Posts: 514

5/7/2012 12:53 PM

So the easiest method would be to mask the SS# field in your SQL statement. Not sure what your database platform is but for SQL Server it would be something like"

SELECT '****-**-'+RIGHT(SSN_FIELD,4)
FROM Table

SueS

Basic Member

Posts: 20

New Poster

5/7/2012 4:20 PM

We use Oracle SQL so it is the same general type of syntax but by doing it like that if one of the first 5 numbers of the ss# were changed, it would not recognize the change. It only recognizes the change if it is to the last four digits.

Matthew Nye

Veteran Member

Posts: 514

5/7/2012 4:43 PM

You could create a display column using the above syntax and then include the actual ssn field but hide the latter on step 4 of the notification.

SueS

Basic Member

Posts: 20

New Poster

5/7/2012 6:56 PM

Thank you so much that did it.

I did not realize that you could hide a column.