Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
The following concepts enable you to accurately interpret the results of the Recruiting and Hiring reports.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
The predefined recruiting and hiring workbooks, in addition to displaying information set up within Oracle HRMS, calculate the following:
New Applicants
The number of applicants for the vacancy who have the status of active application.
Terminations
The number of applicants whose applicant assignment has ended, and for whom an employee assignment has not been created.
Offers
The number of applicants that have the status of Offer.
Note: Applicants can have only one status at any time, therefore the number of offers represents offers which have been made and not yet accepted; it does not include offers which have subsequently been accepted.
Accepts
The number of applicants that have the status of Accept.
Hired
The number of applicant assignments that have been converted to employee assignments, regardless of whether the applicant already works for your enterprise.
Still Employed
The number of applicant assignments that have been converted to employee assignments that are currently active.
Applicant Age
The current age of the applicant, not their age when they applied for the vacancy.
Note: Applicants must have a birth date set up to be included in the worksheet. You cannot enter a date of birth on the Applicant Quick Entry window, so you must use the People window to set this up.
This workbook analyses the days required to fill vacancies within a recruitment activity. It only reports on job applicants that have been hired.
How efficient is my recruitment process?
The workbook contains the following worksheets:
By Ethnic Group (United States specific)
By Ethnic Origin (United Kingdom specific)
By Gender
By Job
By Grade
By Organization
By Location
By Vacancy
This workbook does not use parameters.
The workbook uses the following calculation:
Average Days to Fill Vacancy
This calculation provides the Average Days from Vacancy Start to Hire; it is based on the average interval in days between the date that the vacancy started and the date the employee was hired (excluding the vacancy start date and the employee hire date).
Related Topics
Recruiting and Hiring Discoverer Workbook calculations
This workbook investigates the reasons your enterprise has terminated applications for different vacancies and individual applicants. The workbook only includes terminated applications.
Why are applicants dropping out of the recruitment process?
This workbook contains the following worksheets:
Termination Details
Termination Reasons by Vacancy
This workbook does not use parameters.
The workbook does not use any calculations.
Related Topics
Recruiting and Hiring Discoverer Workbook calculations
This workbook investigates the applications for vacancies within your enterprise.
You can investigate the following by vacancy, recruitment, and applicant status:
Number of openings for a vacancy
New applicants
Applications which have been terminated
Offers to applicants
Accepted offers
Number of applicants hired
The workbook does not use parameters.
This workbook has the following worksheets:
This worksheet enables you to investigate the current age of applicants for a particular vacancy.
What is the age spread of my applicants?
This worksheet does not use calculations.
This worksheet enables you to investigate the applications that exist for a Business Group, requisition, and recruiter.
What is the status of my applicants?
This worksheet does not use calculations.
This worksheet enables you to investigate recruitment activities within your Business Group. You can analyze the current status of recruitment activities, for example, the number of new applicants, the number of offers made, and the number of terminated applicants. You can view recruitment activity information for a Business Group, requisition, vacancy, and recruitment type.
How many applicants are there at each recruitment stage?
This worksheet uses the following calculations:
Recruitment Activity Vacancy Hires
Populates the Hires column in the worksheet with the number of applicants that have been hired into the vacancy from the recruitment activity.
This worksheet enables you to investigate vacancies within your Business Group. You can analyze the current status of vacancies, for example, the number of remaining applicants, the number of new applicants, and the number of terminated applicants. You can view vacancy information for a Business Group, recruitment type, and recruitment activity.
How many applicants are there at each recruitment stage?
This worksheet uses the following calculations:
Recruitment Activity Vacancy Hires
Populates the Hires column in the worksheet with the number of applicants that have been hired into the vacancy from the recruitment activity.
Planned Cost with Currency
Populates the Planned Cost with Currency page item in the worksheet. It is a concatenation of planned cost and currency code.
Actual Cost with Currency
Populates the Actual Cost with Currency page item in the worksheet. It is a concatenation of actual cost and currency code.
Related Topics
Recruiting and Hiring Discoverer Workbook calculations
This workbook analyses vacancy ratios, vacancy ratios by recruitment activity, recruitment activity ratios, and hires versus openings summary for recruitment within your enterprise.
The workbook does not use parameters.
This workbook has the following worksheets:
How successful is my recruitment?
This worksheet uses the following calculations:
Hires/Offers
Populates the Hires / Offers column with the percentage of hires who are employed as of the system date, against the number of open offers as of the system date.
Vacancy/Offers
Populates the Hires / Openings column with the percentage of vacancy hires, against the number of openings.
Hires/Openings
Populates the Hires / Openings column with the percentage of hires who are employed as of the system date, against the number of initial openings.
Vacancy Hires
Populates the Hires column with the number of applicants who have been made an offer for a vacancy.
How many applicants are there at each recruitment stage?
This worksheet uses the following calculations:
Recruitment Activity Vacancy Hires/Openings
Populates the Hires / Openings column with the percentage of recruitment activity hires, against the number of openings.
Recruitment Activity Vacancy Offers/Recruitment Activity Vacancy Hires
Populates the Hires / Opening column with the percentage of hires, against the number of offers made.
Recruitment Activity Vacancy HiresPopulates the Hires column with the number of applicants that have been hired into the vacancy from the recruitment activity.
Recruitment Activity Vacancy OffersPopulates the Offers column with the number of applicants that have been made offers via the recruitment activity.
Cost per Hire
Populates the Cost per Hire column with the actual cost of recruitment activity divided by the number of successful recruitments using that activity.
How successful is my recruitment?
How much does my recruitment cost?
This worksheet uses the following calculations:
Recruitment Activity Hires/Recruitment Activity Offers
Populates the Hires / Opening column with the percentage of hires, against the number of offers made.
Recruitment Activity OffersPopulates the Offers column with the number of offers made from a recruitment activity.
Cost per Hire
Populates the Cost per Hire column with the actual cost of recruitment activity divided by the number of successful recruitments using that activity.
Recruitment Activity HiresPopulates the Recruitment Activity Hires column with the number of hires a recruitment activity has achieved.
How successful is my recruitment?
This worksheet uses the following calculations:
Recruitment Activity Vacancy Hires/Openings
Populates the Hires / Offers column with the percentage of recruitment activity hires, against the number of openings.
Related Topics
Recruiting and Hiring Discoverer Workbook calculations
The Vacancy Hire Success (Organization Hierarchy) Status Analytics workbook provides a status analysis comparing the changes in vacancy success across organizations in your enterprise, or across geographical areas. You can analyze the:
Total number of openings recorded for vacancies.
Total number of openings that have been filled.
This workbook also enables you to view the success of your recruitment activities.
The workbook calculates the total number of vacancy openings and the number of filled vacancies in a particular time period, to produce a vacancy success rate. Vacancy success is defined as the percentage of vacancy openings that are filled.
The workbook only includes vacancies that have a status of Closed and have an End Date within the selected time period.
The workbook only includes assignments that match the criteria selected in the workbook parameters. For example, an assignment must have the same budget measurement value as the worksheet parameter.
How many vacancies have there been in my enterprise within a specific geographical area?
How many of these vacancies have been filled? How does this compare with other geographical areas?
Before running the worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Workforce Measurement Type
Use the following parameters to further restrict the values in the workbook:
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook has the following worksheets:
By Organization
By Geography Area
The worksheets display one row for each grouping. For example, the by Organization worksheet displays one row per organization.
All worksheets contain the following columns:
A grouping column
The heading depends on the selected worksheet, for example, in the by Organization worksheet, this column is named “Organization”.
Openings
The number of openings for each group.
Employee Starts
The number of employee starts for each group. The worksheets calculate the Employee Starts total by totaling the employee assignments created to fill the vacancies.
Success Rate Percent
Displays the total workforce starts as a percentage of total workforce openings.
The worksheets count employee assignments using Workforce, enabling you to define the employee value of each assignment. See: Workforce Calculation, Oracle HRMS Configuring, Reporting, and System Administration Guide
Related Topics
Recruiting and Hiring Discoverer Workbook calculations
The Vacancy Hire Success (Organization Hierarchy) Trend Analytics workbook provides a trend analysis showing the changes in vacancy success over a selected period of time. You can analyze the:
Total number of openings recorded for vacancies.
Total number of openings that have been filled.
This workbook also enables you to view the success of your recruitment activities.
The workbook calculates the total number of vacancy openings and the number of filled vacancies in a particular time period, to produce a vacancy success rate. Vacancy success is defined as the percentage of vacancy openings that are filled.
The workbook only includes vacancies that have a status of Closed and have an End Date within the selected time period.
The workbook only includes assignment that match the criteria selected in the workbook parameters. For example, an assignment must have the same budget measurement value as the worksheet parameter.
How many vacancies have there been in my enterprise over, for example, the last quarter?
How many of these vacancies have been filled? How does this compare with the previous quarter?
Before running the worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Workforce Measurement Type
Use the following parameters to further restrict the values in the workbook:
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook has the following worksheets:
By Year
By Semi Year
By Quarter
By Bi Month
By Month
The worksheets display one row for each time period. For example, the by Month worksheet displays one row per month.
All worksheets contain the following columns:
Start Date
The start date of the time period.
End Date
The end date of the time period.
A time period column
The heading depends on the selected worksheet, for example, in the by Year worksheet, this column is named “Year”.
Openings
The number of openings within the time period.
Employee Starts
The number of employee starts within the time period. The worksheets calculate the Employee Starts total by totaling the employee assignments created to fill the vacancies
Success Rate Percent
Displays the total workforce starts as a percentage of total workforce openings.
The worksheets count employee assignments using Workforce, enabling you to define the employee value of each assignment. See: Workforce Calculation, Oracle HRMS Configuring, Reporting, and System Administration Guide
Related Topics
Recruiting and Hiring Discoverer Workbook calculations
The Vacancy Hire Success (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating vacancy success over yearly periods, the other providing a detailed analysis of vacancy success in the workforce.
These worksheets help you to create reports to analyze the success of your recruitment activities. Recruitment success is defined as the percentage of vacancy openings that are filled.
The workbook calculates the total number of vacancy openings for each year, and how many of these have been filled.
The workbook uses the Budget Measurement Value to calculate the number of openings. The worksheet Openings column displays the number of Headcounts or Full Time Equivalents (depending on your Budget Measurement Value) represented by your vacancies.
The workbook only includes vacancies that have been closed within the selected time period.
The vacancy must also match all the selection criteria. For example, if you select an organization and a job, you must have entered an organization and job for the vacancy on the HRMS Requisition and Vacancy window.
The workbook calculates the Employee Starts total by totaling the employee assignments created to fill the vacancies. HRMS Intelligence counts employee assignments using Workforce, enabling you to define the employee value of each assignment.
See: Workforce Calculation, Oracle HRMS Configuring, Reporting, and System Administration Guide
The assignments created to fill the vacancy must match the criteria selected in the report, to appear in the Openings Filled total. For example, an assignment must have the same budget measurement value as the report parameters.
The success rate calculation is:
Total Workforce Measurement Value for all Employee Starts*100/Total Workforce Measurement Value for Openings
Before running the template worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Workforce Measurement Type
The template includes the following optional parameters:
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook has the following worksheets:
By Year
By Detail
The by Year worksheet enables you to see vacancy success for each year.
This worksheet contains the following columns:
Start Date
The start date of the time period.
End Date
The end date of the time period.
Year
The time period for which this worksheet is run.
Openings
The number of openings within the time period.
Employee Starts
The number of employee starts within the time period.
Success Rate Percent
Displays the vacancy success rate.
The Detail worksheet calculates the vacancy success rates for vacancies with the same opening and closing dates, for each organization, location, job, grade, and position.
This worksheet contains the following columns:
Vacancy Open Date
The date the vacancy opened.
Vacancy Close Date
The date the vacancy closed.
Openings
The number of openings within the vacancy open and close date, for each organization, location, job, grade, and position, calculated using the selected workforce measurement value.
Employee Starts
The number of employee starts for openings within the vacancy open and close date, for each organization, location, job, grade, and position, calculated using the selected workforce measurement value. The worksheets calculate the Employee Starts total by totaling the employee assignments created to fill the vacancies.
Success Rate Percent
Displays the vacancy success rate. Recruitment success is a calculation of the total workforce starts as a percentage of total workforce openings.
Organization
The organization that had the vacancy.
Location
The location where the vacancy occurred.
Job
The job for which the vacancy occurred.
Grade
The grade for which the vacancy occurred.
Position
The position for which the vacancy occurred.
Related Topics