Recruiting - Open Req. Summary Pivot

This pivot table view provides details on a variety of metrics that can be viewed using different contexts by choosing different sections, rows, and columns.

Selected Columns

This table shows graph data and syntax if any

Name	Syntax
Section
Row
Column
Open	"Requisition Counts"."# Requisitions Currently Sourcing"
On Hold	"Requisition Counts"."# Requisitions Currently On Hold"
# Openings Left To Fill (Hired)	"Requisition Counts"."# Openings Left To Fill (Hired)"
Avg. Days Open	FILTER(Avg(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", CURRENT_TIMESTAMP)) USING ("Requisition Status - Current"."Current Status"='Sourcing'))
New Apps	FILTER("Candidate Counts"."# Submissions Currently New" USING ("Submission General Info"."Submission Is Completed" = 'Yes'))
Active Apps	"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 Review" + "Candidate Counts"."# Submissions Currently In Testing"
Apps In Offer Stage	"Candidate Counts"."# Submissions Currently In Offer"
# Submissions Currently Hired	"Candidate Counts"."# Submissions Currently Hired"

Filters

This table shows report filters

Name
Current Status is equal to / is in On Hold; Sourcing
Recruiting - Open Req. Dashboard Prompt Listener

Section

This table shows report sections and syntax if any

Name	Syntax
Organization Level1 Name	"Requisition Organization"."Organization Level1 Name"
Organization Level2 Name	"Requisition Organization"."Organization Level2 Name"
Location Level1 Name	"Requisition Primary Location"."Location Level1 Name"
Location Level2 Name	"Requisition Primary Location"."Location Level2 Name"
Job Field Level1 Name	"Requisition Job Field"."Job Field Level1 Name"
Job Field Level2 Name	"Requisition Job Field"."Job Field Level2 Name"
Employee Status	"Requisition Profile"."Req. Employee Status"
All	'All'

Row

This table shows report rows and syntax if any

Name	Syntax
Recruiter	"Requisition Recruiter"."Recruiter Name"
Hiring Manager	"Requisition Hiring Manager"."Hiring Manager Name"
Organization Level1 Name	"Requisition Organization"."Organization Level1 Name"
Organization Level2 Name	"Requisition Organization"."Organization Level2 Name"
Location Level1 Name	"Requisition Primary Location"."Location Level1 Name"
Location Level2 Name	"Requisition Primary Location"."Location Level2 Name"
Job Field Level1 Name	"Requisition Job Field"."Job Field Level1 Name"
Job Field Level2 Name	"Requisition Job Field"."Job Field Level2 Name"
Employee Status	"Requisition Profile"."Req. Employee Status"
All	'All'

Column

This table shows report columns and syntax if any

Name	Syntax
Organization Level1 Name	"Requisition Organization"."Organization Level1 Name"
Organization Level2 Name	"Requisition Organization"."Organization Level2 Name"
Location Level1 Name	"Requisition Primary Location"."Location Level1 Name"
Location Level2 Name	"Requisition Primary Location"."Location Level2 Name"
Job Field Level1 Name	"Requisition Job Field"."Job Field Level1 Name"
Job Field Level2 Name	"Requisition Job Field"."Job Field Level2 Name"
Employee Status	"Requisition Profile"."Req. Employee Status"
Job Level	"Requisition Profile"."Req. Job Level"
Job Type	"Requisition Profile"."Req. Job Type"
Job Schedule	"Requisition Profile"."Req. Job Schedule"

Pivot Table Configuration

This table shows table configurations

Name	Location
Sections (Totals Enabled)	Section
Rows (Totals Enabled)	Row
Columns	Column
Measures	Open On Hold # Openings Left to Hire Avg. Days Open New Apps Active Apps Apps In Offer Stage # Hired