Requisition Pipeline Detail (Active Requisitions)
The report displays a listing of active requisitions along with a summary of candidates by various attributes.
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. |
| Recruiter Name | Returns the recruiter name. |
| # Openings Left to Fill (Hired) | Returns the number of positions left to fill on the requisition, based on the number of openings minus the number of candidates in the hired reference status. |
| Hiring Manager Name | Returns the hiring manager name. |
| 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. |
| 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. |
| # Submissions | Returns the number of distinct job submissions. |
| # Submissions Complete | Returns the number of distinct job submissions that are complete. |
| # Submissions Ace | Returns the number of distinct job submissions where the candidate is considered to be ACE. |
| # Submissions Min. Requirements Met | Returns the number of distinct job submissions where the candidate as met all the requisition minimum requirements. |
| # Submissions Internal | Returns the number of distinct submissions that are internal. |
| # Submissions Currently New | Returns the number of distinct submissions currently in the "New" reference model status. |
| # Submissions Current in Review | Returns the number of distinct submissions currently in the "Review" reference model status. |
| # Submissions Currently in 1st Intv. | Returns the number of distinct submissions currently in the "1st Interview" reference model status. |
| # Submissions Currently in 2nd Intv. | Returns the number of distinct submissions currently in the "2nd Interview" reference model status. |
| # Submissions Currently in 3rd Intv. | Returns the number of distinct submissions currently in the "3rd Interview" reference model status. |
| # Submissions Currently in Offer | Returns the number of distinct submissions currently in the "Offer" reference model status. |
| # Submissions Currently in Testing | Returns the number of distinct submissions currently in the "Testing" reference model status. |
| # Submissions Currently Hired | Returns the number of distinct submissions currently in the "Hired" reference model status. |
| # Submissions Currently Rejected | Returns the number of distinct submissions currently in the "Rejected" reference model status. |
| # Submissions Currently Declined | Returns the number of distinct submissions currently in the "Declined" reference model status. |
| # Submissions Matched | # Submissions filtered using Submission Medium = Matched to Job |
| # Submissions in Process | # Submissions Currently In 1st Intv + # Submissions Currently In 2nd Intv. # Submissions Currently In 2nd Intv. + # Submissions Currently In 3rd Intv. + # Submissions Currently In Offer + # Submissions Currently in Review + # Submissions Currently In Testing |
Report Prompts
All report prompts are optional.
| Name | Description |
|---|---|
| Latest Fully Approved Date | Filters the report based on whether the latest fully approved date is between two selected dates. |
| First Sourced After Latest Approved Date | Filters the report based on whether the first sourced after latest approved date is between two selected dates. |
| Req. Creation Date | Filters the report based on whether the req. creation date is between two selected dates. |
| 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. |
| # Openings Left to Fill (Hired) | Allows you to select the operator for the prompt on # openings left to fill (hired) and the corresponding values, if necessary. |
Report Filters
| Filter | Description |
|---|---|
| Current Status is eqal to/ is in Sourcing | Filters the report to requisitions in the sourcing status. |
| 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. |
| 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. |
| First Sourced After Latest Approval Date is prompted | This is a listener for a prompt. |
| Latest Fully Approved Date is prompted | This is a listener for a prompt. |