Difference between revisions of "Adverse Impact Data Requirements"
| Line 9: | Line 9: | ||
* Race | * Race | ||
| − | 2) Activities required to prepare compliant reports include: | + | 2) The following additional information may be imported and utilized in your adverse impact analyses: |
| + | * Job Code | ||
| + | * Job Title | ||
| + | * Requisition Code | ||
| + | * Requisition Name | ||
| + | |||
| + | 3) Activities required to prepare compliant reports include: | ||
* Applicants | * Applicants | ||
* Hires | * Hires | ||
| Line 28: | Line 34: | ||
[[File:Import.jpg]] | [[File:Import.jpg]] | ||
| − | 2) Click '''View Template''' under '''Adverse Impact Detail | + | 2) Click '''View Template''' under '''Adverse Impact Detail File'''. |
| − | [[File: | + | [[File:New Imprt Wizard -AI Template.png]] |
3) The following Excel worksheet will open. | 3) The following Excel worksheet will open. | ||
| − | [[File: | + | [[File:New AI Detail Import - 10 Columns.png]]<br> |
''Adverse Impact Detail File Template'' | ''Adverse Impact Detail File Template'' | ||
| − | |||
| − | |||
| − | |||
| − | |||
==See Also== | ==See Also== | ||
Revision as of 21:51, 9 December 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) The following additional information may be imported and utilized in your adverse impact analyses:
- Job Code
- Job Title
- Requisition Code
- Requisition Name
3) Activities required to prepare compliant reports include:
- Applicants
- Hires
- Promotions From (and Within)
- Promotions To
- Terminations
- Base Group (The employees who were in your workforce on the first day of the previous AAP year.)
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 required by the software:
1) Click the Import icon.
2) Click View Template under Adverse Impact Detail File.
3) The following Excel worksheet will open.
Adverse Impact Detail File Template
See Also
Adverse Impact
Adverse Impact Tests
Import Wizard
Required Fields - Adverse Impact
© Copyright Yocom & McKee, Inc.
