Process Audits
The report provides a summary of data points that qualify under a variety of system audits.
Report Columns
| Name | Location |
|---|---|
| Req. Identifier | Returns the requisition id, as displayed in the recruiting application. |
| Title | Returns the requisition title, in its base language. |
| Exception | |
| Detail | |
| Candidate Identifier | Returns Candidate ID. |
| Name | Returns the candidate name. |
| Returns the candidate email. | |
| Recruiter Name | Returns the recruiter name. |
| Recruiter Email | Returns the recruiter email. |
| 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. |
| Location Level1 Name | Returns the name of the requisition primary location. |
| Job Field Level1 Name | Returns the name of the requisition job field. |
| Current Status | Returns the current status of the requisition. Note that the values "Approved" and "Sourcing" roll up to the "Open" status. |
| Req. Audit | '@{ReqAudit}{*ALL*}' |
Original Columns/Filters
| Exception | Detail | Filters |
|---|---|---|
| 'Hire with Suspect Time to Hire' | 'Time to Hire: ' || CAST("Candidate Cycle Time"."Time to Hire" AS CHAR) || ' days.' | Content Reference Status Name is equal to / is in Hired AND (Time to Hire is less than or equal to 1 OR Time to Hire is greater than or equal to 365) AND @{ReqAudit}{*ALL*} is LIKE (pattern match) %Hires with Suspect Time to Hire% |
| 'Ace Candidate New 5+ Days' | 'New for ' || cast(round("Submission Aging"."Time Since Last CSW Status Change",2) as CHAR) || ' days.' | Time Since Last CSW Status Change is greater than or equal to 5 AND Is Ace is equal to / is in Yes AND Current Reference Status Name is equal to / is in New AND @{ReqAudit}{*ALL*} is LIKE (pattern match) %Ace Candidates New 5+ Days% |
| 'Hire Missing Source' | '' | Current Reference Status Name is equal to / is in Hired AND Submission Source (BL) is null AND @{ReqAudit}{*ALL*} is LIKE (pattern match) %Hires Missing Source% |
| 'Hire Start Date < Submission Date' | 'Start Date: ' || EVALUATE('to_char(%1,%2)' AS CHAR, ifnull("Submission Dates"."Hire Start Date","Submission Dates"."Offer Target Start Date"),'mm/dd/yyyy') || ' ; Submission Complete Date: ' || EVALUATE('to_char(%1,%2)' as CHAR,"Submission Dates"."Submission Completed Date",'mm/dd/yyyy') | IFNULL("Submission Dates"."Hire Start Date","Submission Dates"."Offer Actual Start Date") < "Submission Dates"."Submission Completed Date" AND IFNULL("Submission Dates"."Hire Start Date","Submission Dates"."Offer Actual Start Date") is not null AND Current Reference Status Name is equal to / is in Hired AND @{ReqAudit}{*ALL*} is LIKE (pattern match) %Hires Start Date < Submission Date% |
| 'Hire Missing Race or Gender (U.S)' | case when "Candidate Regulations"."Gender" is null and "Candidate Regulations"."Race" is null then 'Missing Race & Gender' when "Candidate Regulations"."Gender" is not null and "Candidate Regulations"."Race" is null then 'Missing Race' else 'Missing Gender' end | @{ReqAudit}{*ALL*} is LIKE (pattern match) %Hires Missing Race or Gender (U.S)% AND ((Is Max Standard USA EEO Form With Answer is equal to / is in Yes OR Regulation Form Code is null) AND (Gender is null OR Race is null) AND Location Level1 Name is equal to / is in United States) |
| 'Hire Offer Accepted Date < Submission Date' | 'Offer Accepted Date: ' || EVALUATE('to_char(%1,%2)' AS CHAR, "Submission Dates"."Offer Accepted Date",'mm/dd/yyyy') || ' ; Submission Complete Date: ' || EVALUATE('to_char(%1,%2)' as CHAR,"Submission Dates"."Submission Completed Date",'mm/dd/yyyy') | Current Reference Status Name is equal to / is in Hired AND Status is equal to / is in Accepted AND evaluate('case when %1 < %2 then %3 end' as CHAR, "Submission Dates"."Offer Accepted Date","Submission Dates"."Submission Completed Date",'X') is equal to / is in X @{ReqAudit}{*ALL*} is LIKE (pattern match) %Hires Offer Accepted Date < Submission Date% |
Report Filters
| Filter | Explanation |
|---|---|
| Current Status is prompted | This is a listener for a prompt. |
| 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. |
| Hired 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") is prompted | 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. |
| First Sourced After Latest Approval Date is prompted | This is a listener for a prompt. |
| Last Modified Date is prompted | This is a listener for a prompt. |
| Last Position Accepted Date is prompted | This is a listener for a prompt. |
Report Prompts
All report prompts are optional.
| Name | Description |
|---|---|
| Audits | This is a presentation variable for ReqAudit. It filters the report based on the selected audit criteria. |
| Current Status Start Date | Filters the report based on whether the submission current status start date is between two selected dates. |
| Submission Completed Date | Filters the report based on whether the submission completed 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 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. |
| Latest Filled Date | Filters the report based on whether the latest filled 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. |
| Last Position Accepted Date | Filters the report based on whether the last position 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. |
| Minimum Requirements Met | Filters the report based on whether the minimum requirements met indicator is in the list of values selected. |
| Is Ace | Filters the report based on whether the is ace indicator 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. |
| Submission Is Completed | Filters the report based on whether the submission is completed indicator is in the list of values selected. |