1. Using Oracle Business Intelligence for Oracle Taleo Enterprise Edition
  2. Recruiting - Filled Positions Trends

Recruiting - Filled Positions Trends

The chart displays a trend of hired candidates with corresponding time metrics such as average time to hire.

Hires

Image showing a mixed column/line chart

Report Columns

The table shows the report columns and syntax is any
Name Syntax
Filled Period EVALUATE('to_char(%1,%2)' as char,"Requisition Dates"."Latest Filled Date",'YYYY-MM')
Dimension 1
Dimension 2
Fact

Filters

The table shows report filters
Name
Current Reference Status Name is equal to / is in Hired
Hired Date is not null
Recruiting - Summary Dashboard Prompt Listener

Dimension 1

Short sentence or paragraph to describe the configuration table.

The table shows report columns and syntax if any
Name Syntax
# Submissions Internal "Candidate Counts"."# Submissions Internal"
# Submissions Ace "Candidate Counts"."# Submissions Ace"
# Submissions Min. Requirements Met "Candidate Counts"."# Submissions Min. Requirements Met"
# Male 
FILTER("Candidate Counts"."# Submissions" 
USING ("Candidate Regulations"."Gender"='Gender - Male'))
# White 
FILTER("Candidate Counts"."# Submissions" 
USING (("Candidate Regulations"."Race"='Race - White') 
AND (("Candidate Regulations"."Ethnicity" <> 'Ethnicity - Hispanic Latino') 
    OR ("Candidate Regulations"."Ethnicity" IS NULL))))

Dimension 2

Short sentence or paragraph to describe the configuration table.

The table shows report columns and syntax if any
Name Syntax
# Submissions External "Candidate Counts"."# Submissions External"
# Submissions Non-Ace "Candidate Counts"."# Submissions Non-Ace"
# Submissions Min. Requirements Unmet "Candidate Counts"."# Submissions Min. Requirements Unmet"
# Female 
FILTER("Candidate Counts"."# Submissions" 
USING ("Candidate Regulations"."Gender"='Gender - Female'))
# Non-White 
FILTER("Candidate Counts"."# Submissions" 
USING (("Candidate Regulations"."Race" NOT IN ('Race - White', 'Not Specified', 'Undisclosed')) 
OR ("Candidate Regulations"."Ethnicity"='Ethnicity - Hispanic Latino')))

Facts

Short sentence or paragraph to describe the configuration table.

The table shows report columns and syntax if any
Name Syntax
Average Time to Hire "Candidate Cycle Time"."Average Time to Hire"
Median Time to Hire 
MEDIAN("Candidate Cycle Time"."Time to Hire")
Average Submission Cycle Time "Candidate Cycle Time"."Average Submission Cycle Time"
Median Submission Cycle Time 
MEDIAN("Candidate Cycle Time"."Submission Cycle Time")
Average Time to Start "Candidate Cycle Time"."Average Time to Start"
Median Time to Start 
MEDIAN("Candidate Cycle Time"."Time to Start")
Avg Time To Intv. 
AVG(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Completed Date", "Submission Dates"."1st Interviewed Date"))
Median Time to Intv. 
MEDIAN(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Completed Date", "Submission Dates"."1st Interviewed Date"))

Bar Graph View

The table shows the bar graph settings
Element Details
Bars Dimension 1, Dimension 2
Lines Fact
Group By Filled Period