Employees are typically assigned an employee number, but the system currently generates a GUID instead.

Since employees are unaware of their GUID, the only way to retrieve a specific record is by fetching all employees and filtering manually, which significantly impacts performance—especially for companies with a large workforce.

Our goal is to allow employees to enter their employee number via our mobile app to verify their employment. This number is familiar to them, unlike the system-generated GUID