Difference between revisions of "Workforce Data Requirements"

From YMwiki
Jump to navigationJump to search
Line 6: Line 6:
  
 
2) Click ''View Template'' under Employment Information.<br>
 
2) Click ''View Template'' under Employment Information.<br>
[[file:Import_Wizard_WF.png‎]]<br>
+
[[File:New Imprt Wizard -Workforce Template.png‎]]<br>
  
  

Revision as of 17:36, 12 December 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.
New Imprt Wizard -Workforce Template.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.