Difference between revisions of "Workforce Data Requirements"
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | In order to run compliant reports for your | + | 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 | + | 2) Click '''View Template''' under '''Workforce File'''.<br> |
− | [[ | + | [[File:New Imprt Wizard -Workforce Template.png]]<br> |
− | 3) The | + | 3) The template opens in a spreadsheet program. Your fields must be ordered in the order shown in the template.<br> |
− | [[file: | + | [[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> |
− | + | ==See Also== | |
+ | [[Adverse Impact Data Requirements]]<br> | ||
+ | [[Import Wizard]]<br> | ||
+ | [[Glossary]]<br> | ||
+ | [[Required Fields - Workforce Import]]<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:
2) Click View Template under Workforce File.
3) The template opens in a spreadsheet program. Your fields must be ordered in the order shown in the template.
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.