Recruiting - Open Req Aging

The chart outlines aging of open requisitions across various dimensions.

Aging

Report Columns

Short sentence or paragraph to describe the configuration table.

Type Permission
Name	Location
Dimensions
Avg Aging	Avg(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", CURRENT_TIMESTAMP))
# Open 0-45 Days	count(distinct case when TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date" , CURRENT_TIMESTAMP) between 0 and 45 then "Requisition Identification"."Req. Identifier" end)
# Open 45-100 Days	count(distinct case when TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", CURRENT_TIMESTAMP) between 45 and 100 then "Requisition Identification"."Req. Identifier" end)
# Open 100-150 Days	count(distinct case when TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", CURRENT_TIMESTAMP) between 100 and 150 then "Requisition Identification"."Req. Identifier" end)
# Open 150+ Days	count(distinct case when TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", CURRENT_TIMESTAMP) >= 150 then "Requisition Identification"."Req. Identifier" end)

View By: Dimensions

Short sentence or paragraph to describe the configuration table.

Name	Syntax
Organization Level 1 Name	"Requisition Organization"."Organization Level1 Name" *Interaction:Requisition Details, Candidate Details
Organization Level 2 Name	"Requisition Organization"."Organization Level2 Name" *Interaction:Requisition Details, Candidate Details
Location Level 1 Name	"Requisition Primary Location"."Location Level1 Name" *Interaction:Requisition Details, Candidate Details
Location Level 2 Name	"Requisition Primary Location"."Location Level2 Name" *Interaction:Requisition Details, Candidate Details
Job Field Level 1 Name	"Requisition Job Field"."Job Field Level1 Name" *Interaction:Requisition Details, Candidate Details
Job Field Level 2 Name	"Requisition Job Field"."Job Field Level2 Name" *Interaction:Requisition Details, Candidate Details
Hiring Manager	"Requisition Hiring Manager"."Hiring Manager Name" *Interaction:Requisition Details, Candidate Details
Recruiter	"Requisition Recruiter"."Recruiter Name" *Interaction:Requisition Details, Candidate Details
Job Level	"Requisition Profile"."Req. Job Level" *Interaction:Requisition Details, Candidate Details
Job Type	"Requisition Profile"."Req. Job Type" *Interaction:Requisition Details, Candidate Details
Justification	"Requisition Identification"."Justification" *Interaction:Requisition Details, Candidate Details
Organization Level 1 Name (Drill)	"Requisition Organization"."Organization Level1 Name"
Location Level 1 Name (Drill)	"Requisition Primary Location"."Location Level1 Name"
Job Field Level 1 Name (Drill)	"Requisition Job Field"."Job Field Level1 Name"

View Configurations

Context	Additional Information
Avg Aging	Group By: Dimension Bars: Avg Aging This view has conditional formatting based on average aging. When average aging is between 0 and 45 the bars will be green. When average aging is between 45 and 100 the bars will be orange. When average aging is between 100 and 150 the bars will be red. When average aging is greater than or equal to 150 the bars will be red.
# Reqs by Aging Band	Group By: Dimension Areas: #Open 0-45 Days, # Open 45-100 Days, # Open 100-150 Days, # Open 150+ Days
Pareto of Urgent Reqs	Group By: Dimension Measures: # Open 150+ Days

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