Skip to Content
0
Former Member
Jan 05, 2012 at 07:47 PM

How to list those employees who do not have a certain pay rate type set up

37 Views

Hi,

I'm trying to create a report that lists all employees who DO NOT have a certain pay rate role type set up. An employee can have multiple pay rate roles - for example: chargeable miles, non-chargeable miles, subsistence, etc.

I want to identify all those employees who do not have, say, subsistence yet set up.

I joined the employee table to the employee rates table. The employee_role_id=20 is the particular rate role value that I am interested in. I want to only list those employees who do not have rate of role type 20 set up. That way I can go and set one up for these employees. At present, I am using selection criteria where employee_role_id=20. This brings back only those employees that have an employee_role_id of 20 setup. I would like to do the inverse but setting <>20 only screens out those roles with value 20 and displays all of the rest of the pay role values for each employee.

Any help is appreciated.

thx!

Mark