Recruiting - Open Reqs Tiles

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

Report Columns

The table shows report columns and syntax if any

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

The table shows 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

The table shows report tile descriptions

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