Difference between revisions of "Adverse Impact Data Requirements"
(Created page with "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 Impac...") |
|||
| Line 21: | Line 21: | ||
window. | window. | ||
| − | To view the Import Template which shows the order mandated by the software: | + | To view the Import Template which shows the order mandated by the software:<br> |
1) Click the Import icon. | 1) Click the Import icon. | ||
| − | + | [[File:Import.jpg]] | |
2) Click View Template under Adverse Impact Detail File or Adverse Impact Summary File. | 2) Click View Template under Adverse Impact Detail File or Adverse Impact Summary File. | ||
| − | + | [[File:Importwizardaidetail.png]] | |
3) The following Excel worksheet will open. | 3) The following Excel worksheet will open. | ||
| − | + | [[File:Aidetailspreadsheet.jpg]]<br> | |
''Adverse Impact Detail File Template'' | ''Adverse Impact Detail File Template'' | ||
| − | + | ||
| + | [[File:Aiasummaryimporttemplate.png]]<br> | ||
''Adverse Impact Summary File Template'' | ''Adverse Impact Summary File Template'' | ||
| − | + | ==See Also== | |
| + | [[Adverse Impact]] | ||
| + | [[Adverse Impact Tests]] | ||
| + | [[Import Wizard]] | ||
Revision as of 13:25, 18 March 2011
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
