Onboarding Process Summary

This report provides a summary of all onboarding processes.

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 number 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 statu 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.

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.
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.
Process Owner Full Name	Filters the report based on whether the process owner full name is in the list of values selected.
Process Progression Health Is Red	Filters the report based on whether process progression health is red 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 Code is not null	Filter to ensure only records with onboarding processes are returned.