Onboarding Process Details
This report provides a summary of all onboarding processes and their associated steps.
Report Columns
| Name | Description |
|---|---|
| Req. Identifier | Returns the requisition id, as displayed in the recruiting application. |
| Req. Title | Returns the requisition title, in its base language. |
| Candidate Identifier | Returns Candidate ID. |
| Candidate Name | Returns the candidate name. |
| Correspondence Email | Returns the subject correspondence email or, if that is null, Returns the candidate email. |
| Corporate Email | Returns the subject corporate email. |
| Primary Phone Designation | Returns the candidate primary phone designation. |
| Mobile Phone | Returns the subject mobile phone number or, if that is null, Returns the candidate mobile phone number. |
| Home Phone | Returns the subject home phone number or, if that is null, Returns the candidate home phone number. |
| Work Phone | Returns the subject work phone numbe with the extension, if available, or, if the subject home phone number is null, Returns the candidate work phone number. |
| Fax Number | Returns the subject fax number. |
| Department Name | Returns the subject department name. |
| Current Reference Status Name | Returns the current reference status name. |
| Current Workflow Name | Returns the name of the candidate selection workflow used for this job submission. |
| Current Step Name | Returns the current CSW step name. |
| Current Status Name | Returns the current CSW status name. |
| Current Status Start Date | Returns the date when the candidate was moved to the current status. |
| Hiring Manager Name | Returns the hiring manager name. |
| Hiring Manager Email | Returns the hiring manager email. |
| Organization Level1 Name | Returns the name of the organization. |
| Job Field Level1 Name | Returns the name of the requisition job field. |
| Location Level1 Name | Returns the name of the requisition primary location. |
| Submission Is Completed | Returns whether or not the submission is complete. |
| Submission Is Internal | Returns whether or not the candidate was internal as of when he/she created the submission. |
| Submission Created Date | Returns the date/time when the submission was created. |
| Submission Completed Date | Returns the date/time when the submission was completed. |
| Hired Candidate Start Date | Returns the hire start date/time as entered when the candidate is moved to the Hired reference status If the hire start date is not available the system returns the hire start date as entered in the candidate job offer section. |
| Hired Date | Returns the most recent date/time when the candidate was moved to the Hired reference status. |
| Offer Accepted Date | Returns the date/time when the candidate accepted the job offer. |
| Latest Filled Date | Returns the date/time when the requisition was most recently filled. |
| Latest Position Accepted Date | Returns the date/time when the last position was accepted on the requisition. |
| First Sourced After Latest Approval Date | Returns the first time the requisition was put into the sourcing status after the most recent time the requisition the requisition was put into the approved status. |
| Req. Status | Returns the current status of the requisition. Note that the values "Approved" and "Sourcing" roll up to the "Open" status. |
| Time to Hire | Returns the average number of days between the first fully approved date and the hired date. |
| Submission Cycle Time | Returns the average number of days between the submission completed date and hired date. |
| Time to Start | Returns the average number of days between the the first fully approved date and the hire start date (offer actual start date, if hire start date is null). |
| Onboarding Process Name (BL) | Returns the process name in its base locale. |
| Onboarding Process Code | Returns the submission transitions process code. |
| Onboarding Process Current Status | Returns the submission transitions process current status. |
| Onboarding Process Start Date | Returns the submission transitions process start date. |
| Onboarding Process End Date | Returns the submission transitions process end date. |
| Onboarding Process Percent Complete | Returns the submission transitions process percent complete. |
| Onboarding Process Progression Health Is Red | Returns yes if a step or task in the submission transitions process is overdue. |
| Onboarding Process Owner Full Name | Returns the submission transitions process owner full name. |
| Onboarding Process Days In Progress | If the submission transitions process is in progress, the time in days between the submission transitions process start date and the current date is returned. |
| Onboarding Process Days To Complete | If the submission transitions process is complete, the time in days between the profile transitions process start date and the profile transitions latest status change date. |
| Onboarding Step Name (BL) | Returns the submission transitions step name in its base locale. |
| Onboarding Step Start Date | Returns the submission transitions step start date. |
| Onboarding Step Due Date | Returns the submission transitions step due date. |
| Onboarding Step End Date | Returns the submission transitions step end date. |
| Onboarding Step Days In Progress | If the submission transitions step is complete, the time in days between the submission transitions step start date and the submission transitions step latest status change date is returned. |
| Onboarding Step Days To Complete | If the submission transitions step is complete, the time in days between the submission transitions step start date and the submission transitions step latest status change date is returned. |
| Onboarding Step Overdue Days | If the submission transitions step is in progress, the time in days between the submission transitions step due date and the current date is returned. |
| Onboarding Task Name | Returns the name of task in its base locale. |
| Onboarding Task Owner Name | Returns the submission transitions task owner name. |
| Onboarding Task Owner Email | Returns the submission transitions task owner email. |
| Onboarding Task Type | Returns the submission transitions task type. |
| Onboarding Task Current Status | Returns the submission transitions task current status. |
| Onboarding Task Creation Date | Returns the submission transitions task creation date. |
| Onboarding Task Due Date | Returns the submission transitions task due date. |
| Onboarding Task Assignee Name | Returns the submission transitions task assignee name. |
| Onboarding Task Assignee Email | Returns the submission transitions task assignee email. |
| Onboarding Task Assignee Department | Returns the submission transitions task assignee department. |
| Onboarding Step Is Overdue | Returns the submission transitions step is overdue. |
| Onboarding Task Is Overdue | Returns whether or not the submission transitions task is overdue. |
Report Prompts
All report prompts are optional.
| Name | Description |
|---|---|
| Transitions Prompts | |
| Process Start Date | Filters the report based on whether the process start date is between two selected dates. |
| Process End Date | Filters the report based on whether the process end date is between two selected dates. |
| Task Due Date | Filters the report based on whether the task due date is between two selected dates. |
| Step Start Date | Filters the report based on whether the step start date is between two selected dates. |
| Step Due Date | Filters the report based on whether the step due date is between two selected dates. |
| Step End Date | Filters the report based on whether the step end date is between two selected dates. |
| Process Name (BL) | Filters the report based on whether the process name is in the list of values selected. |
| Process Current Status | Filters the report based on whether the process current status is in the list of values selected. |
| Step Name (BL) | Filters the report based on whether the step name is in the list of values selected. |
| Task Name (BL) | Filters the report based on whether the task name is in the list of values selected. |
| Task Current Status | Filters the report based on whether the task current status is in the list of values selected. |
| Task Owner Name | Filters the report based on whether the task owner name is in the list of values selected. |
| Process Health Is Red | Filters the report based on whether process progression health is red indicator is in the list of values selected. |
| Step Is Overdue | Filters the report based on whether step is overdue indicator is in the list of values selected. |
| Report Prompts | |
| Submission Current Status Start Date | Filters the report based on whether the submission current status start date is between two selected dates. |
| Submission Created Date | Filters the report based on whether the submission created date is between two selected dates. |
| Hired Candidate Start Date | Filters the report based on whether the hired start date is between two selected dates. If the hire start date is null the offer actual start date is used. |
| Hired Date | Filters the report based on whether the hired date is between two selected dates. |
| Offer Accepted Date | Filters the report based on whether the offer accepted date is between two selected dates. |
| Ref. Status Name | Filters the report based on whether the current status reference name is in the list of values selected. |
| Workflow Name | Filters the report based on whether the current workflow name is in the list of values selected. |
| Step Name | Filters the report based on whether the current step name is in the list of values selected. If the workflow name filter is being used, only the steps in the selected workflow will be available. |
| Status Name | Filters the report based on whether the current status name is in the list of values selected. If the step name filter is being used, only the statuses in the filtered steps will be available. |
| Organization (Level 1) | Filters the report based on whether the organization level1 name is in the list of values selected. |
| Organization (Level 2) | Filters the report based on whether the organization level2 name is in the list of values selected. If the Organization (Level 1) filter is being used, only the child organizations in organization level2 will be available. |
| Organization (Level 3) | Filters the report based on whether the organization level3 name is in the list of values selected. If the Organization (Level 2) filter is being used, only the child organizations in organization level3 will be available. |
| Organization (Level 4) | Filters the report based on whether the organization level4 name is in the list of values selected. If the Organization (Level 3) filter is being used, only the child organizations in organization level4 will be available. |
| Location (Level 1) | Filters the report based on whether the location level1 name is in the list of values selected. |
| Location (Level 2) | Filters the report based on whether the location level2 name is in the list of values selected. If the Location (Level 1) filter is being used, only the child locations in location level2 will be available. |
| Location (Level 3) | Filters the report based on whether the location level3 name is in the list of values selected. If the Location (Level 2) filter is being used, only the child locations in location level3 will be available. |
| Location (Level 4) | Filters the report based on whether the location level4 name is in the list of values selected. If the Location (Level 3) filter is being used, only the child locations in location level4 will be available. |
| Job Field (Level 1) | Filters the report based on whether the job field level1 name is in the list of values selected. |
| Job Field (Level 2) | Filters the report based on whether the job field level2 name is in the list of values selected. If the Job Field (Level 1) filter is being used, only the child job fields in job field level2 will be available. |
| Job Field (Level 3) | Filters the report based on whether the job field level3 name is in the list of values selected. If the Job Field (Level 2) filter is being used, only the child job fields in job field level3 will be available. |
| Job Field (Level 4) | Filters the report based on whether the job field level4 name is in the list of values selected. If the Job Field (Level 3) filter is being used, only the child job fields in job field level4 will be available. |
| Recruiter Name | Filters the report based on whether the recruiter name is in the list of values selected. |
| Hiring Manager Name | Filters the report based on whether the hiring manager name is in the list of values selected. |
| Req. Identifier | Filters the report based on whether the req. identifier is in the list of values selected. |
| Req. Title | Filters the report based on whether the req. title is in the list of values selected. |
| Requisition Status | Filters the report based on whether the current status is in the list of values selected |
| Submission Is Internal | Filters the report based on whether the submission is internal indicator is in the list of values selected. |
Report Filters
| Filter | Description |
|---|---|
| Current Status Start Date is prompted | This is a listener for a prompt. |
| Submission Created Date is prompted | This is a listener for a prompt. |
| Submission Completed Date is prompted | This is a listener for a prompt. |
| Latest Filled Date is prompted | This is a listener for a prompt. |
| Current Reference Status Name is prompted | This is a listener for a prompt. |
| Current Workflow Name is prompmted | This is a listener for a prompt. |
| Current Step Name is prompted | This is a listener for a prompt. |
| Current Status Name is prompted | This is a listener for a prompt. |
| Organization Level1 Name is prompted | This is a listener for a prompt. |
| Organization Level2 Name is prompted | This is a listener for a prompt. |
| Organization Level3 Name is prompted | This is a listener for a prompt. |
| Organization Level4 Name is prompted | This is a listener for a prompt. |
| IFNULL("Submission Dates"."Hire Start Date","Submission Dates"."Offer Actual Start Date") | This is a listener for a prompt. When the prompt is set this value filters on the Hire Start Date. If hire start date is null it filters on the Offer Actual Start Date. |
| Location Level1 Name is prompted | This is a listener for a prompt. |
| Location Level2 Name is prompted | This is a listener for a prompt. |
| Location Level31 Name is prompted | This is a listener for a prompt. |
| Location Level4 Name is prompted | This is a listener for a prompt. |
| Job Field1 Name is prompted | This is a listener for a prompt. |
| Job Field2 Name is prompted | This is a listener for a prompt. |
| Job Field3 Name is prompted | This is a listener for a prompt. |
| Job Field4 Name is prompted | This is a listener for a prompt. |
| Recruiter Name is prompted | This is a listener for a prompt. |
| Hiring Manager Name is prompted | This is a listener for a prompt. |
| Req. Identifier is prompted | This is a listener for a prompt. |
| Title (BL) is prompted | This is a listener for a prompt. |
| Is Ace is prompted | This is a listener for a prompt. |
| Minimum Requirements Met is prompted | This is a listener for a prompt. |
| Submission Is Internal is prompted | This is a listener for a prompt. |
| Submission Is Completed is prompted | This is a listener for a prompt. |
| Current Status is prompted | This is a listener for a prompt. |
| Last Position Accepted Date is prompted | This is a listener for a prompt. |
| Hired Date is prompted | This is a listener for a prompt. |
| Offer Accepted Date is prompted | This is a listener for a prompt. |
| First Sourced After Latest Approval Date is prompted | This is a listener for a prompt. |
| Submission Transition Process Name (BL) is not null | Filter to ensure only records with onboarding processes are returned. |
| Submission Transition Process Name (BL) is prompted | This is a listener for a prompt. |
| Submission Transition Process Current Status is prompted | This is a listener for a prompt. |
| Submission Transition Process Start Date is prompted | This is a listener for a prompt. |
| Submission Transition Process End Date is prompted | This is a listener for a prompt. |
| Submission Transition Process Progression Health Is Red is prompted | This is a listener for a prompt. |
| Submission Transition Step Start Date is prompted | This is a listener for a prompt. |
| Submission Transition Step End Date is prompted | This is a listener for a prompt. |
| Submission Transition Step Due Date is prompted | This is a listener for a prompt. |
| Submission Transition Task Name (BL) is prompted | This is a listener for a prompt. |
| Submission Transition Task Owner Name is prompted | This is a listener for a prompt. |
| Submission Transition Task Current Status is prompted | This is a listener for a prompt. |
| Submission Transition Task Due Date is prompted | This is a listener for a prompt. |
| Submission Transition Process Code is not null | Filter to ensure only records with onboarding processes are returned. |