Difference between revisions of "Workforce Data Requirements"
(Created page with "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 ...") |
|||
| (10 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. |
| − | + | To view the '''Workforce Import''' template which shows the order required by the software: | |
| − | |||
| − | + | 1) Click the '''Import''' icon.<br> | |
| − | + | [[File:Import.jpg]]<br> | |
| − | |||
| − | |||
| − | + | 2) Click '''View Template''' under '''Workforce File'''.<br> | |
| − | + | [[File:New Imprt Wizard -Workforce Template.png]]<br> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | 3) The template opens in a spreadsheet program. Your fields must be ordered in the order shown in the template.<br> | |
| − | a. | + | [[file:Company Import file - Blank 3-10-14.png]]<br> |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | A) Minimum data required to run compliant, error-free reports.<br> | ||
| + | :a. Employee ID<br> | ||
| + | :b. Employee Name<br> | ||
| + | :c. Race<br> | ||
| + | :d. Gender<br> | ||
| + | :e. Dept. Name<br> | ||
| + | :f. Job Name<br> | ||
| + | :g. EEO Code<br> | ||
| + | :h. Job Group Name<br> | ||
| + | :i. Salary Basis<br> | ||
| + | :j. Base Salary<br> | ||
| + | :k. Part-Time Status<br> | ||
| + | :l. Supervisor’s ID<br> | ||
| + | :m. Plan Code<br> | ||
| + | :n. Plan 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> | |
| + | :a. Location Code<br> | ||
| + | :b. Dept. Code<br> | ||
| + | :c. Job Code<br> | ||
| + | :d. Job Group Code<br> | ||
| + | :e. Annotation<br> | ||
| − | + | C) In addition to Base Salary and Salary Basis, these fields are helpful in analyzing compensation data.<br> | |
| + | :a. Hire Date<br> | ||
| + | :b. Salary Code<br> | ||
| + | :c. Total Salary<br> | ||
| + | :d. Hours Worked per Week<br> | ||
| + | :e. SSEG Code<br> | ||
| + | :f. Date 1<br> | ||
| + | :g. Date 2<br> | ||
| + | :h. Number 1<br> | ||
| + | :i. Number 2<br> | ||
| + | :j. Number 3<br> | ||
| + | |||
| + | D) These fields can be easily populated after import with the help of the Complete AAP’s Census Wizard.<br> | ||
| + | :a. 2010 Census Code 1<br> | ||
| + | :b. 2010 Census Code 2<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. | ||
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.
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.
