1. Using Oracle Business Intelligence for Oracle Taleo Enterprise Edition
  2. Recruiting - Requisition Activity History

Recruiting - Requisition Activity History

The chart displays a 3 month rolling plus current’s month’s trend of key requisition activity measures, including filled requisitions, opened requisitions and time to fill.

Requisition Activity

Image showing a mixed column/line chart

Result Columns

In the following table the value i is replaced in the criteria with 0, -1, -2, -3, in the combined results criteria to get the metrics for the last 4 months rolling.

The table shows the report columns and syntax if any
Name Syntax
Period 
EVALUATE('TO_CHAR(%1,%2)' as char, 
TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || 
replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Open (1st) 
FILTER("Requisition Counts"."# Requisitions" 
	USING ("Requisition Status - Historical"."Req. Historical Status Start Date" <= CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char,
		TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') 
		AS DATE)) 
	AND   (("Requisition Status - Historical"."Req. Historical Status End Date" >= CAST(EVALUATE('TO_DATE(%1,%2)' as date,
		EVALUATE('TO_CHAR(%1,%2)' as char, 
		TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE)) OR "Requisition Status - Historical"."Req. Historical Status End Date" IS NULL)
	AND ("Requisition Identification"."Has Unlimited Openings"='No') 
	AND ("Requisition Status - Historical"."Historical Status"='Sourcing'))
Opened 
FILTER("Requisition Counts"."# Requisitions" 
	USING ("Requisition Status - Historical"."Req. Historical Status Start Date" 
		BETWEEN CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
				TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
		AND 
			CAST(EVALUATE('TO_DATE(%1,%2)' as date, EVALUATE('TO_CHAR(%1,%2)' as char, 
                TIMESTAMPADD(SQL_TSI_MONTH, i+1, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
		AND ("Requisition Identification"."Has Unlimited Openings"='No') 
		AND ("Requisition Status - Historical"."Historical Status"='Sourcing')))
Filled 
FILTER("Requisition Counts"."# Requisitions" 
	USING ("Requisition Status - Historical"."Req. Historical Status Start Date" 
	BETWEEN CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
			TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
	AND CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
		TIMESTAMPADD(SQL_TSI_MONTH, i+1, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
	AND ("Requisition Identification"."Has Unlimited Openings"='No') 
	AND ("Requisition Status - Historical"."Historical Status"='Filled')))
Can/Hold 
FILTER("Requisition Counts"."# Requisitions" 
	USING ("Requisition Status - Historical"."Req. Historical Status Start Date" 
	BETWEEN CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
		TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
	AND CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
		TIMESTAMPADD(SQL_TSI_MONTH, i+1, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
	AND ("Requisition Identification"."Has Unlimited Openings"='No') 
	AND ("Requisition Status - Historical"."Historical Status" IN ('Canceled','On Hold'))))
TTF 
FILTER("Requisition Cycle Time"."Average Time To Fill" 
	USING ("Requisition Status - Historical"."Req. Historical Status Start Date" 
	BETWEEN CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
		TIMESTAMPADD(SQL_TSI_MONTH, i, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
	AND CAST(EVALUATE('TO_DATE(%1,%2)' as date,EVALUATE('TO_CHAR(%1,%2)' as char, 
		TIMESTAMPADD(SQL_TSI_MONTH, i+1, CURRENT_TIMESTAMP),'yyyy-mm') || '01','yyyy-mm-dd') AS DATE) 
	AND ("Requisition Identification"."Has Unlimited Openings"='No') AND ("Requisition Status - Historical"."Historical Status"='Filled')))

Filters

The table shows a filter
Name
Recruiting - Summary Dashboard Prompt Listener - No Filled Date

View Configurations

The table shows the report settings and configurations
Name Additional Information
Column

Bars: Open (1st), Opened, Filled, Can/Hold

Lines: TTF

Group By: Period
Table

Columns and Measures: Period, Open (1st), Opened, Filled, Can/Hold, TTF