Difference between revisions of "Workforce Data Requirements"

From YMwiki
Jump to navigationJump to search
 
(8 intermediate revisions by the same user not shown)
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:
+
Most of the statistical reports in your AAP are based on a one-moment snapshot of your workforce as of the beginning date of your AAP year.  The snapshot should include all employees covered by affirmative action regulations. The workforce snapshot should be in the form of a spreadsheet file pulled from your payroll or Human Resources Information System (HRIS) or other database.  In addition to employee names, your file must contain information associated with each employee.  In order to run compliant reports for your AAP gather as many of the importable fields as you can for each employee who was in your workforce on the beginning date of your AAP.
  
1) Click the Import icon.<br>
+
To view the '''Workforce Import''' template which shows the order required by the software:
 +
 
 +
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 '''Workforce File'''.<br>
[[file:Import_Wizard_WF.png‎]]<br>
+
[[File:New Imprt Wizard -Workforce Template.png‎]]<br>
  
  
3) The following Excel worksheet will open.<br>
+
3) The template opens in a spreadsheet program. Your fields must be ordered in the order shown in the template.<br>
[[file:WF_Import_Template_-_Blank.png]]<br>
+
[[file:Company Import file - Blank 3-10-14.png]]<br>
  
  
Line 29: Line 31:
 
:n. Plan Name<br>
 
:n. Plan Name<br>
 
:o. Location Name<br>
 
:o. Location Name<br>
 +
:p. Veteran<br>
 +
:q. Disabled<br>
  
 
B) The Complete AAP will create these for you if you don’t already have them.<br>
 
B) The Complete AAP will create these for you if you don’t already have them.<br>
Line 50: Line 54:
  
 
D) These fields can be easily populated after import with the help of the Complete AAP’s Census Wizard.<br>
 
D) These fields can be easily populated after import with the help of the Complete AAP’s Census Wizard.<br>
:a. Census Code 1<br>
+
:a. 2010 Census Code 1<br>
:b. Census Code 2<br>
+
:b. 2010 Census Code 2<br>
:c. Census Code 3<br>
+
:c. 2010 Census Code 3<br>
  
Continue to: [[Adverse Impact Data Requirements]]
+
==See Also==
 +
[[Adverse Impact Data Requirements]]<br>
 +
[[Import Wizard]]<br>
 +
[[Glossary]]<br>
 +
[[Required Fields - Workforce Import]]<br>
  
==See Also==<br>
 
[[Required Fields]]<br>
 
[[Glossary]]<br>
 
  
 
© Copyright Yocom & McKee, Inc.
 
© Copyright Yocom & McKee, Inc.

Latest revision as of 21:26, 10 March 2014

Most of the statistical reports in your AAP are based on a one-moment snapshot of your workforce as of the beginning date of your AAP year. The snapshot should include all employees covered by affirmative action regulations. The workforce snapshot should be in the form of a spreadsheet file pulled from your payroll or Human Resources Information System (HRIS) or other database. In addition to employee names, your file must contain information associated with each employee. In order to run compliant reports for your AAP gather as many of the importable fields as you can for each employee who was in your workforce on the beginning date of your AAP.

To view the Workforce Import template which shows the order required by the software:

1) Click the Import icon.
Import.jpg


2) Click View Template under Workforce File.
New Imprt Wizard -Workforce Template.png


3) The template opens in a spreadsheet program. Your fields must be ordered in the order shown in the template.
Company Import file - Blank 3-10-14.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
p. Veteran
q. Disabled

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. 2010 Census Code 1
b. 2010 Census Code 2
c. 2010 Census Code 3

See Also

Adverse Impact Data Requirements
Import Wizard
Glossary
Required Fields - Workforce Import


© Copyright Yocom & McKee, Inc.