Recruiting - Open Reqs Tiles

The summary is comprised of tiles outlining key measures pertaining to open requisitions.

Report Columns

Name	Syntax
Organization Level1 Name	"Requisition Organization"."Organization Level1 Name"
# Requisitions	"Requisition Counts"."# Requisitions"
# Requisitions by Recruiter	"Requisition Counts"."# Requisitions By Recruiter" *Requisitions by Recruiter gives both the information about # of requisitions by recruiter and has conditional formatting to help identify when a recruiter may be over or under worked. If # Requisitions by Recruiter is between 0 and 5 then Yellow background If # Requisitions by Recruiter is between 12 and 20 then Yellow background If # Requisitions by Recruiter is between 5 and 12 then Green background If # Requisitions by Recruiter is greater than or equal to 20 then Red background
# Submissions Currently New	"Candidate Counts"."# Submissions Currently New"
# Submissions Currently Active	"Candidate Counts"."# Submissions Currently In 1st Intv." + "Candidate Counts"."# Submissions Currently In 2nd Intv." + "Candidate Counts"."# Submissions Currently In 3rd Intv." + "Candidate Counts"."# Submissions Currently In Offer" + "Candidate Counts"."# Submissions Currently in Review" + "Candidate Counts"."# Submissions Currently In Testing"
Req. Aging	Avg(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", CURRENT_TIMESTAMP)) *Req. Aging gives both the information about requisition aging and has conditional formatting to help identify when a requisition might be getting stale. If Req. Aging is greater than or equal to 70 then Red background If Req. Aging is between 0 and 45 then Green background If Req. Aging is between 45 and 70 then Yellow background
# Offers Extended	COUNT(CASE WHEN "Submission Job Offer"."Status"='Extended' THEN "Submission General Info"."Submission Identifier" END)

Report Filters

Name
Current Status is equal to / is in Sourcing
Has Unlimited Openings is equal to / is in No
Recruiting - Open Req. Dashboard Prompt Listener

Report Tile Views

Measure	Name	Description
# Requisitions	# Open Reqs.	Currently open requisitions
# Requisitions by Recruiter	Reqs / Recruiter	# Open requisitions by recruiter.
Req. Aging	Avg Days Open	Avg. Aging of requisitions (from sourcing date till now.)
# Submissions Currently Active	# Active Apps	Returns the number of distinct submissions currently active in the hiring process.
# Submissions Currently New	# New Apps	Returns the number of submissions currently in the "New" status