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
| 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
| Name |
|---|
| Current Status is equal to / is in On Hold; Sourcing |
| Recruiting - Open Req. Dashboard Prompt Listener |
Section
| 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
| 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
| 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
| 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 |