Onboarding - Tasks In Progress Summary

Displays the number of submission transition process tasks that are in progress, by a variety of dimensions.

Onboarding Tasks In Progress

Report Columns

Name	Syntax
Dimensions	See View By: Dimension
Avg Days In Progress	`AVG(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date" , CURRENT_TIMESTAMP))`
# Tasks	"Submission Transitions Process Counts"."# Submission Transitions Tasks"

View By: Dimensions

Name	Syntax
Organization	"Requisition Organization"."Organization Level1 Name"
Country	"Requisition Primary Location"."Location Level1 Name"
Category	"Requisition Job Field"."Job Field Level1 Name"
Department	"Requisition Department"."Department Name"
Hiring Manager	"Requisition Hiring Manager"."Hiring Manager Name"
Process Name	`"Submission Transitions Process"."Submission Transitions Process Name (BL)" \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Process Owner	`"Submission Transitions Process"."Submission Transitions Process Owner Full Name" \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Process Health Is Red	`"Submission Transitions Process"."Submission Transitions Process Progression Health Is Red" \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Process Completion	CASE WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 25 Then '0-25%' WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 50 THEN '25-50%' WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 75 Then '50-75%' WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 100 Then '75-100%' END \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Process Days In Progress	`"Submission Transitions Process"."Submission Transitions Process Days In Progress" + "Requisition Identification"."# Openings" - "Requisition Identification"."# Openings"`
Task Name	`"Submission Transitions Process"."Submission Transitions Task Name (BL)" \|\| REPLACE("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Task Assignee	`"Submission Transitions Process"."Submission Transitions Task Assignee Name" \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Task Type	`"Submission Transitions Process"."Submission Transitions Task Type" \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Task Is Overdue	`"Submission Transitions Process"."Submission Transitions Task Is Overdue" \|\| Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')`
Task Days In Progress	`TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date", CURRENT_TIMESTAMP) + "Requisition Identification"."# Openings" - "Requisition Identification"."# Openings"`

View Configurations

Name	Additional Information
Pie	Slice Size: # Tasks Pies: Dimension
Column-Line	Bars: # Tasks Lines: Avg Days In Progress Group By: Dimension

Name

Additional Information

Pie

Slice Size: # Tasks

Pies: Dimension

Column-Line

Bars: # Tasks

Lines: Avg Days In Progress

Group By: Dimension

Report Filters

Name
Submission Transitions Task Current Status is equal to / is in In progress
Submission Transitions Process Type is equal to / is in New Hire
Onboarding - Dashboard Prompt Listener