For documentary proof items to appear in the lookup list, a locale number must be assigned to the employee to whom the documentary proof is being assigned. If a locale number is not assigned, the lookup list will remain blank.
Confirming if the Locale Number is the Issue
Follow these steps to confirm whether the missing locale number is causing the issue.
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Use the database drop-down to change the database to SelectHR.
Log in with your SQL credentials.
Paste the following SQL into the SQL Tab:
SELECT Person.Snapshot.[Person Number], Person.Snapshot.[First Name], Person.Snapshot.Surname, Person.Snapshot.[Effective Status], Person.Details.[Locale Number], Person.Address.[Address Line 1], Person.Address.[Address Line 2], Person.Address.[Address Line 3], Person.Address.[Address Line 4], Person.Address.[Address Line 5], Person.Address.[Post Code], Person.Address.[Locale Number] FROM Person.Snapshot INNER JOIN Person.Details ON Person.Snapshot.[Person Number] = Person.Details.[Person Number] INNER JOIN Person.Address ON Person.Details.[Person Number] = Person.Address.[Person Number] WHERE Person.Snapshot.[Effective Status] = 'current'
Click Data.
Search for the employee experiencing the issue and check if they have a Locale Number.
Adding the Locale Number
You can add a Locale Number in one of two ways.
Perform a data import to update the employee's Locale Number to the relevant Locale. Typically, this would be Locale Number 1.
Use the Global Module (a separate licensed module) to add the Locale Number to the employee.