Adverse Impact Data Requirements

The Adverse Impact data that you gather should include activities from the year prior to your current plan year. You should gather the following information for the Adverse Impact portion of your Affirmative Action Plan.

1) Applicants, hires, promotions and terminations must be identified by:

• Plan Code
• Activity Code
• Job Group Code
• Job Group Name
• Gender
• Race

2) Activities required to prepare compliant reports include:

• Applicants
• Hires
• Promotions From (and Within)
• Promotions To
• Terminations

Transfers, Layoffs and Training are other activities for which you can run Adverse Impact Reports, but OFCCP auditors rarely request them. If you wish to analyze other activities use the user-defined Activity Fields in the software’s Adverse Impact import or editing window.

To view the Import Template which shows the order mandated by the software:
1) Click the Import icon.

2) Click View Template under Adverse Impact Detail File or Adverse Impact Summary File.

3) The following Excel worksheet will open.

Adverse Impact Detail File Template

Adverse Impact Summary File Template

See Also

Adverse Impact
Adverse Impact Tests
Import Wizard