[HR] How to create a lookup that shows last 4 digits of the Social Security Number

Created by Crystal Ann Harvey, Modified on Tue, 26 Aug at 9:14 AM by Crystal Ann Harvey

To create a user-defined lookup restricting the social security field to only the last 4 digits, it will be necessary to create the user-defined lookup in UD User Defined Lookups.

In User Database>Programs folder, open the UD User Defined Lookups form
Click File>Copy Lookup.
Then use HRRM as the Source Lookup, create a ud name and description. Click Copy button to create new lookup.
On the Details tab, create a column name with the SQL statement "RIGHT (SSN, 4)" and then give it a Column Heading.
The Input Type will be a 0-String with only an Input Length of 4.
Next go to Human Resources>Programs>HR Resources. In the Resource # field, press F3 (Field Properties) on the keyboard to bring up the Field Properties screen.
Select the Lookups tab and add the new UD Lookup.
Now the option will be available to choose the new UD lookup when F4 (Lookup) is used in the Resource # field.