Difference between revisions of "Workforce Data Requirements"

From YMwiki
Jump to navigationJump to search
Line 1: Line 1:
 
In order to run compliant reports for your Affirmative Action Plan you will need to gather as much as you can of the following workforce information for each employee who was in your workforce on the beginning date of your plan. The fields shown below are importable fields grouped by priority to meet OFCCP requirements. To view the Import Template which shows the order required by the software:
 
In order to run compliant reports for your Affirmative Action Plan you will need to gather as much as you can of the following workforce information for each employee who was in your workforce on the beginning date of your plan. The fields shown below are importable fields grouped by priority to meet OFCCP requirements. To view the Import Template which shows the order required by the software:
  
1) Click the Import icon.<br>
+
1) Click the '''Import''' icon.<br>
 
[[File:Import.jpg]]<br>
 
[[File:Import.jpg]]<br>
  
  
2) Click View Template under Employment Information.<br>
+
2) Click ''View Template'' under Employment Information.<br>
 
[[file:Import_Wizard_WF.png‎]]<br>
 
[[file:Import_Wizard_WF.png‎]]<br>
  
Line 56: Line 56:
 
Continue to: [[Adverse Impact Data Requirements]]
 
Continue to: [[Adverse Impact Data Requirements]]
  
==See Also==<br>
+
==See Also==
 
[[Required Fields]]<br>
 
[[Required Fields]]<br>
 
[[Glossary]]<br>
 
[[Glossary]]<br>
  
 
© Copyright Yocom & McKee, Inc.
 
© Copyright Yocom & McKee, Inc.

Revision as of 21:56, 28 October 2011

In order to run compliant reports for your Affirmative Action Plan you will need to gather as much as you can of the following workforce information for each employee who was in your workforce on the beginning date of your plan. The fields shown below are importable fields grouped by priority to meet OFCCP requirements. To view the Import Template which shows the order required by the software:

1) Click the Import icon.
Import.jpg


2) Click View Template under Employment Information.
Import Wizard WF.png


3) The following Excel worksheet will open.
WF Import Template - Blank.png


A) Minimum data required to run compliant, error-free reports.

a. Employee ID
b. Employee Name
c. Race
d. Gender
e. Dept. Name
f. Job Name
g. EEO Code
h. Job Group Name
i. Salary Basis
j. Base Salary
k. Part-Time Status
l. Supervisor’s ID
m. Plan Code
n. Plan Name
o. Location Name

B) The Complete AAP will create these for you if you don’t already have them.

a. Location Code
b. Dept. Code
c. Job Code
d. Job Group Code
e. Annotation

C) In addition to Base Salary and Salary Basis, these fields are helpful in analyzing compensation data.

a. Hire Date
b. Salary Code
c. Total Salary
d. Hours Worked per Week
e. SSEG Code
f. Date 1
g. Date 2
h. Number 1
i. Number 2
j. Number 3

D) These fields can be easily populated after import with the help of the Complete AAP’s Census Wizard.

a. Census Code 1
b. Census Code 2
c. Census Code 3

Continue to: Adverse Impact Data Requirements

See Also

Required Fields
Glossary

© Copyright Yocom & McKee, Inc.