How to report on direct reports excluding contingent workers in story reporting?

[carlyhilder71]

I am able to report on the total number of direct reports an employee has including contingent workers using the direct reports field on the user entity (accessed off Job Information). Is there a way to exclude contingent workers from this field, or otherwise accomplish this?

[nicholasaglass · Accepted solution]

Hello - This is possible.  Depending on your current data source/query design, and your EC configuration, you should be able to set a simple filter on the Direct Reports table where the field Is Contingent Worker = 0.

The design above will result in a list of all employees in the Job Information table - and where applicable, identify the direct reports who are not contingent workers.  You could further limit your query to only report people who have direct reports (aka managers) who are not contingent workers by applying a query-level filter for Direct Report User ID is not null.

Without any filters you might have data like this:

By adding both filters described above, only Alice would be reported, showing Bob and Charlie as her direct reports. This is because only Alice is a people manager of (2) non-contingent workers.

Does this achieve your objective?

Thanks,

Nick

[carlyhilder71 · Accepted solution]

Hi Nick, thank you! Yes, the solution I ended up implementing is very similar to this but with a filter on employee class rather than 'Is Contingent Worker'.