Candidate Offers Pending Approval
The report provides a listing of job offers that are currently in the pending approval status by aging.
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. |
| Candidate Email | Returns the candidate email. |
| Candidate Primary Phone Designation | Returns the candidate primary phone designation. |
| Candidate Mobile Phone | Returns the candidate mobile phone number. |
| Candidate Home Phone | Returns the candidate home phone number. |
| Candidate Work Phone | Returns the candidate work phone number. |
| Is Ace | Returns yes or no value based on whether the submission was Ace. |
| Minimum Requirements Met | Returns yes or no value based on whether the submission met minimum requirements. |
| Current Workflow Name | Returns the name of the candidate selection workflow used for this job submission. |
| Current Status Start Date | Returns the date when the candidate was moved to the current status. |
| Recruiter Name | Returns the recruiter name. |
| Recruiter Email | Returns the recruiter email. |
| # 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. |
| Hiring Manager Email | Returns the hiring manager email. |
| Organization Level1 Name | Returns the name of the organization. |
| Organization Level 2 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 Medium | Returns the submission medium. |
| Submission Is Internal | Returns whether or not the candidate was internal as of when he/she created the submission. |
| Motives | Returns the candidate rejection/declination motives when they are automatically generated by the system. If an auto generated motive is not available, the system returns the candidate rejection/declination motives. |
| Submission Created Date | Returns the date/time when the submission was created. |
| Submission Completed Date | Returns the date/time when the submission was completed. |
| 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. |
| Current Status | Returns the current status of the requisition. Note that the values "Approved" and "Sourcing" roll up to the "Open" status. |
| Offer Target Start Date | Returns the target start date as entered in the candidate job offer section. |
| Target Start Date | Returns the requisition's target start date. |
| Time Since Last CSW Status Change | Returns the time (in days) spent on hold between now and the most recent candidate selection workflow status change. |
| Time Since Submission Completion | Returns the time (in days) the requisition spent on hold between now and the candidate submission completion date. |
| Time on Hold Since Latest CSW Status Change | Returns the average time (in days) between now and the most recent candidate selection workflow status change. |
| Time on Hold Since Submission Completion | Returns average the time (in days) between now and the candidate submission completion date. |
Report Prompts
All report prompts are optional.
| Name | Description |
|---|---|
| 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. |
| Submission Completed Date | Filters the report based on whether the submission completed date is between two selected dates. |
| Req. Target Start Date | Filters the report based on whether the req. target start date is between two selected dates. |
| Offer Target Start Date | Filters the report based on whether the offer target start 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. |
| 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 |
|---|---|
| Submission Job Offer Status is equal to/is in Approval in Progress | Filters the report based one whether the submission job offer status is currently Approval in Progress. |
| 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. |
| 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. |
| 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. |
| First Sourced After Latest Approval Date is prompted | This is a listener for a prompt. |
| Target Start Date is prompted | This is a listener for a prompt. |
| Offer Target Start Date is prompted | This is a listener for a prompt. |