Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Difficulty accurately identifying internal versus external hires and counts — Cloud Customer Connect
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

Difficulty accurately identifying internal versus external hires and counts

Received Response
42
Views
6
Comments
edited Apr 2, 2018 1:25PM in Reporting and Analytics Taleo Enterprise 6 comments

Summary

Several data elements are combined to indicate if a hire is internal versus external to ensure accuracy in the data. Our formula works but doesn't seem efficient and we can't easily get to a count.

Content

I'd appreciate any help from the community.  This is my first post and this one is kindof a doozy.

My end goal: Present a chart that mirrors the Recruiting - External Position Trends chart in the Sample Recruiting Dashboard.  Where we've gotten stuck is creating counts. The issue seems to be the complexity of how we identify an internal candidates. 

Context:  We are a large retailer and it is extremely difficult with turnover to ensure that all candidates are coming through our internal portal to apply to new roles. Therefore, a candidate is considered internal as follows: if candidate type for UDF is internal (selected by recruiters on the offer grid), if the submissions is internal, or if the most recent employer reflects one of the many variations of our brands (LBrands, L brands, Victoria's Secret, Lbrands/Victorias's secret, etc.).  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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