Workforce Data Requirements

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.

2) Click View Template under Employment Information.

3) The following Excel worksheet will open.

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.