Difference between revisions of "Format Your Workforce Data for Import"

From YMwiki
Jump to navigationJump to search
Line 1: Line 1:
−
==Detailed Formatting Steps & Workforce Requirements==
 
−
 
−
The following are the types of files that the Complete AAP recognizes:
 
−
* Microsoft Excel 2007
 
−
 
 
==Detailed Formatting Steps:==
 
==Detailed Formatting Steps:==
  
Line 10: Line 5:
 
2) Launch the Complete AAP.
 
2) Launch the Complete AAP.
  
−
3) Click on the Import icon.
+
3) Pro users must then open an AAP.
 +
 
 +
40 Click on the '''Import''' icon.
  
 
[[File:Import.jpg]]
 
[[File:Import.jpg]]
  
−
4) Click View Template under Workforce File.
+
5) Click '''View Template''' under '''Workforce File'''.
  
 
[[file:Import_Wizard_WF.png‎]]
 
[[file:Import_Wizard_WF.png‎]]
  
  
−
5) A new Excel worksheet will open.
+
6) A new Excel worksheet will open.
  
 
[[File:WF_Import_Template_-_Blank.png]]
 
[[File:WF_Import_Template_-_Blank.png]]
Line 25: Line 22:
 
''Example of Workforce Template.''
 
''Example of Workforce Template.''
  
−
6) The file is automatically saved in a folder within the open company as “company_import.xlsx” in Excel Workbook format (Excel 2007).  Though not recommended, you may relocate the file.We recommend that you retain the Excel Workbook format (Excel 2007).
+
7) The file is automatically saved in a folder within the open company as “company_import.xlsx” in Excel Workbook format (Excel 2007).  Though not recommended, you may relocate the file. We recommend that you retain the Excel Workbook format (Excel 2007).
  
−
7) Copy and paste data values from your workforce file into the appropriate columns in the import file.  The software requires the data to be imported in the order shown in the template. You may retain row one (1) as the header row.
+
8) Copy and paste data values from your workforce file into the appropriate columns in the company_import.xlsx file.  The software requires the data to be imported in the order shown in the template. You may retain row one (1) as the header row. Formulas are not allowed.
  
−
8) Add Annotation information.
+
9) Review your import file to ensure that all data that you wish to import is present and that there are no blank rows between data.
  
−
:a) There are three methods you can use to add annotations for employees who report to supervisors at a different location.
+
10) If you are not using the Pro version, separate data for multiple AAPs into individual files. Pro version users may import workforce data for multiple AAPs at one time if the plan codes and names are identified in the workforce file. The import will not work properly if there is data on multiple tabs with on file.
  
−
::i. You may allow the software to create the annotation for you. Identify the work location in the Location column and the correct Supervisor ID for each employee in your import file. The software will create the annotations.
+
11) Save your changes.  
  
−
::ii. You can create annotations in your import file. Use a formula, or do a visual comparison of each employee’s work location against his or her manager’s work location to create an annotation that you can import. If you import supervisor IDs and locations, the software will create its own annotations for any left blank, but will not overwrite those you import.
+
==See Also==
−
 
+
[[Required Fields]]<br>
−
::iii. You may type annotations in after you import the workforce data by clicking on the icon on the right of the annotation box in the Employees screen and then typing in your information.
+
[[Format Your Adverse Impact Data for Import]]<br>
−
 
+
[[Annotations]]<br>
−
9) Check your import file to be sure:
 
−
 
 
−
:a) You have included all required data.
 
−
:b) There are no blank rows.
 
−
:c) Assign only one plan code for all data if you are using The Complete AAP Regular software. If you have multiple plans to prepare and you are not using the Pro version you will need to create an import file for each plan.
 
−
 
 
−
[[File:ProTag.jpg]] Pro version users may import workforce data for multiple plans at one time if the plan codes and names are identified in the workforce file.
 
−
 
 
−
==Workforce 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.
 
  
−
1) 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
 
−
 
−
2) 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
 
−
 
−
3) 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
 
−
 
−
4) These fields can be easily populated after importwith the help of the Complete AAP’s Census Wizard.
 
−
:a. Census Code 1
 
−
:b. Census Code 2
 
−
:c. Census Code 3
 
−
 
−
5) Save your changes and close the file.
 
−
 
−
If you have applicant, hire, promotion or termination data to report in your Affirmative Action Plan, please see [[Format Your Adverse Impact Data for Import]] instructions.
 
−
 
−
If you have no applicants, hires, promotions or termination data to report in your Affirmative Action Plan, proceed to [[Import Workforce]].
 
−
 
−
==See Also==
 
−
[[Required Fields]]
 
  
 
© Copyright Yocom & McKee, Inc.
 
© Copyright Yocom & McKee, Inc.

Revision as of 19:51, 1 September 2011

Detailed Formatting Steps:

1) Open your workforce file in Excel.

2) Launch the Complete AAP.

3) Pro users must then open an AAP.

40 Click on the Import icon.

Import.jpg

5) Click View Template under Workforce File.

Import Wizard WF.png


6) A new Excel worksheet will open.

WF Import Template - Blank.png

Example of Workforce Template.

7) The file is automatically saved in a folder within the open company as “company_import.xlsx” in Excel Workbook format (Excel 2007). Though not recommended, you may relocate the file. We recommend that you retain the Excel Workbook format (Excel 2007).

8) Copy and paste data values from your workforce file into the appropriate columns in the company_import.xlsx file. The software requires the data to be imported in the order shown in the template. You may retain row one (1) as the header row. Formulas are not allowed.

9) Review your import file to ensure that all data that you wish to import is present and that there are no blank rows between data.

10) If you are not using the Pro version, separate data for multiple AAPs into individual files. Pro version users may import workforce data for multiple AAPs at one time if the plan codes and names are identified in the workforce file. The import will not work properly if there is data on multiple tabs with on file.

11) Save your changes.

See Also

Required Fields
Format Your Adverse Impact Data for Import
Annotations


© Copyright Yocom & McKee, Inc.

Retrieved from "https://yocom-mckee.com/wiki2/index.php?title=Format_Your_Workforce_Data_for_Import&oldid=931"