Requisitions Active Historical Snapshot
The report displays how many requisitions were in the sourcing status as of a user defined point in time.
Report Columns
| Name | Description |
|---|---|
| Requisition Organization Name | A hierarchical column based on requisition organization names. |
| Requisition Primary Location Name | A heirarchical column based on requisition primary job location names. |
| Requisition Job Field Name | A heirarchical column based onrequisition job field names. |
| # Requisitions | Returns the number of requisitions. |
| Avg Age | Returns the average time in days between the req. historical status start date and the point in time specified in the analysis prompt (ReqSnapDate). |
| # Submissions Complete | Returns the number of distinct job submissions that are completed. |
| # Submissions in Process | # Submissionsfiltered by: historical reference status name in 1st interview, 2nd interview, 3rd interview, offer, reviewed, and testing; and submission historical status start date less than the point in time specified in the analysis prompt (ReqSnapDate), and the historical status end date greater than the point in time specified in the analysis prompt (ReqSnapDate) or null. |
Report Prompts
All report prompts are optional except enter date point in time.
| Name | Description |
|---|---|
| Enter Date Point in Time | This is a variable prompt (ReqSnapDate) that is used by other filters to limit data based on the specified date, which is the snapshot date. |
| 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. |
Report Filters
| Filter | Description |
|---|---|
| Historical Status is equal to/ is in Sourcing | Filters the report to requisitions historically in the sourcing status. |
| Req. Historical Status Start Date is less than or equal to ReqSnapDate | Filters the report to requisitions whose historical status start date is less than or equal to the point in time specified in the analysis prompt (ReqSnapDate). |
| Req. Historical Status End Date is greater than or equal to ReqSnapDate OR Req. Historical Status End Date is null |
Filters the report to requisitions whose historical status end date is greater than or equal to the point in time specified in the analysis prompt (ReqSnapDate), or null. |
| 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. |
| Req. Creation 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. |
| Latest Fully Approved Date is prompted | This is a listener for a prompt. |