You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!