SQL for propsed worker type error
Ever since moving to Redwood, we have been getting The below error for multiple employees each day.
We use a SQL to gather the information and process a load to fix the error, but with getting the error multiple times a day, this is very time consuming to do this process for each single employee.
Wondering if there is a SQL we can use to run for all employees so we can do one mass load to fix everyone in system so we no longer receive this error. The current SQL we are using is:
select * from fusion.per_all_assignments_m where person_id in (select person_id from fusion.per_all_people_f where person_number='enter person ID here') and assignment_type in ('E', 'ET')