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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Cannot find Department field from Offer table within Recruiting RT SA

edited May 1, 2020 6:53PM in Recruiting, Opportunity Marketplace 3 comments

Summary

It does not currently seem possible to report on the Department Name from the Offer section of the Recruiting Real Time SA

Content

I have an analysis built to report on new hires. Occasionally, we will have a req which is opened for one department but for whatever reason (recruiter error, req realignment, etc) the department is switched during the offer creation process.

To account for this, we need to report on the department as listed in the offer section. However, the only department field in that section is Department ID ("Job Offer - Assignment Details"."Department Id"). This is a 15-digit string of numbers that does not provide any value for our needs.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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