Set Manager based on Employee Number rather than List ID



We run a workflow to constantly update our SharePoint list to keep it up to date. The Org Chart requires us to set the root ID based on the manager’s list ID, rather than their employee number. Can we use a CAML query to grab the employee number from the same list and set the root ID to the returned manager?

Thank you for taking the time to read this!