Match Applicants and New Hires

RETURN TO: Data Tables (and Tools)

KEY TOPICS

• Export a Workbook to Review Data
• Perform Batch Processing to Reconcile Data
• Import Corrected Apps to Hires Workbook
• Reviewing Master Plan Data / Apps to Hires Batch Processing

---

Reconcile Applicant and New Hire Data

Both the Applicant and New Hire Data tables will contain informationinformation, ondescribing who was hired at your organization and what job openingspositions were filled during the plan's analysis period. Therefore, the two tables should be reviewed for accuracy. Data may be reconciled, ifIf inconsistencies are found, or extraneous Applicant data are found, the data may be removed.reconciled in balanceAAP..

Quick Tip: As an indicator of potential inconsistencies, compare the number of applicants hired to the number of new hires.

NavigateFor access to tools that support reconciliation of the Applicant and New Hire tables, navigate to Data > Data Tables, and select:

1. Select Applicant (table) from the upper drop-down. Then, click
2. Click the [Apps to Hires] button in the Applicant table header.

Read the remainder of the article below to help you decide which methods will work best for the issues that are presented.

Export a Workbook to Review Data

After navigatingScroll to the bottom of the Rules menu, First, selectmenu:

1. Select whether to: Include Excel formatting. (Yes,(A selection of Yes will createdcreat a spreadsheet with shaded data rows.)

Next, click

2. Click the button: [Export Apps to Hires Workbook]. The system will generate an Excel file, showing issues by category for your review (e.g., Partial Matches, Hired Applicants without New Hire).

For information on importing a corrected workbook, jump to Import Corrected Apps to Hires Workbook below.

Perform Batch Processing to Reconcile Data

At the bottom of the page, the Batch Processing toolbar includes the following buttons, which initiate operations to "clean up" data, depending on the issue(s) presented:

Use "SwapSwap Hires"Hires to Automatically Update the Applicant table

1. Carefully review the Applicant table for "Hired" entries in the Applicant Disposition column, as these entries will be replaced with appropriate data from the New Hire table.
2. Click the [Swap Hires] button in the Batch Processing toolbar. (Disability and Veteran status will also be transferred.)

"CleanClean up Requisitions"Requisitions Based on Requisition Number

Select [Clean up Requisitions] from the Batch Processing toolbar, and two options are presented:

1. Delete Applicants, if Requisition lacks an Applicant Disposition Code of Hired.
2. Update Requisition Job Codes to match the Job Code of the New Hire(s), if one Job Code was used in both.

Click the [Clean up Requisitions] button again to startinitiate the process.

• Update Applicant Info —

  Click the third button from the leftleft, [Update Applicant Info], to globally update blank and/or mismatched entries in the Applicant table with corresponding New Hire entries. From the provided menu, select a field (e.g., Job Code, Req[uisition] #); then choose whether to update Blank, Mismatched, or both types of values. Choose [Update] to apply. You can also [Preview] the updates in table format before applying them.

• Import Corrected Apps to Hires — Workbook

  Once a workbook has been exported (as described above) and corrected, it can be re-imported into the system, by clicking thisthe [Import Apps To Hires Workbook] button. First, select a Hired Disposition code from the provided drop-down. Next, [Choose File] from your computer, and click the [Upload] button.