Difference between revisions of "Import Adverse Impact"

From YMwiki
Jump to navigationJump to search
Line 1: Line 1:
If you have not already formatted your “Activity” or “Summary” file, please refer to [[Format Your Adverse Impact Data for Import]] for information on formatting your adverse impact data. You must format your file before importing.
+
If you have not already formatted your '''Activity''' or '''Summary''' file, please refer to [[Format Your Adverse Impact Data for Import]]. . You must format your file before importing.  Have the appropriate AAP open before performing the following steps.  Pro users may import using the '''Work with All Plans''' option, or may import into one AAP at a time.  To import, have no windows open in the The Complete AAP, and follow the steps below.
  
 
Follow these steps to import:
 
Follow these steps to import:
  
1) Click the Import icon.
+
1) Click the '''Import''' icon.
  
 
[[file:Import_Icon.png‎]]
 
[[file:Import_Icon.png‎]]
  
2) Select the type of file you want to import: Detail or Summary.
+
2) Select the type of file you want to import: '''Adverse Impact Detail File''' or '''Adverse Impact Summary File'''.
  
 
[[file:Import_Wizard_-_AI_Summary.png]]
 
[[file:Import_Wizard_-_AI_Summary.png]]
  
3) Click the [[File:Browse.jpg]] button to find your file if you renamed it or saved it in a different location.
+
3) The Import File box displays the location of your '''ai_detail__import.xlsx''' or '''ai_summary_import.xlsx''' file.  If your import file is not mapped correctly, click the [[File:Browse.jpg]] button to locate it.
  
4) Use pull-down menu to indicate the drive where your file is stored.
+
:a. Use '''Look in''' pull-down menu to indicate the drive where your file is stored.
  
 
[[file:Open - Select an Import file.png]]
 
[[file:Open - Select an Import file.png]]
  
5) Select your ''Detail'' or ''Summary'' File.
+
:b. Select your '''Adverse Impact Detail File''' or '''Adverse Impact Summary File''' and then click '''OK'''.
  
 
[[file:Import Wizard - AI Detail.png]]
 
[[file:Import Wizard - AI Detail.png]]
  
6) You’ll see your path appear in the Import File box.
+
:c. You’ll see your path appear in the '''Import File''' box.
  
7) Click Import.
+
4) Click '''Import'''.
  
8) If it applies, click Yes when you see the following message.   
+
5) If it applies, click '''Yes''' when you see the following message.   
  
 
[[file:HeaderRowMessage.png‎]]
 
[[file:HeaderRowMessage.png‎]]
  
[[File:ProTag.jpg]]  Pro users will see the following message. Click Yes if you are importing data for only the plan you are in. Click No if you are importing data for all plans.
+
[[File:ProTag.jpg]]  Pro users will see the following message.  
 +
* Click '''Yes''' if you are importing data for only the plan you are in.  
 +
* Click '''No''' if you are importing data for all plans.
  
 
[[file:SinglePlanImportMessage.png‎]] 
 
[[file:SinglePlanImportMessage.png‎]] 
  
9) The Complete AAP might ask you to clarify information that it does not recognize. This is NOT an error. Do not cancel the import.
+
6) The Complete AAP might ask you to clarify information that it does not recognize. These are not errors. Do not cancel the import.
  
:a) Note the identifier that is in question.
+
:a) Identify the item that is in question.
 
:b) Select the correct corresponding selection from the provided list.
 
:b) Select the correct corresponding selection from the provided list.
:c) Click OK.
+
:c) Click '''OK'''.
:d) If the software asks you to clarify “Other”, “Unknown” or blank race or sex, select the “Unknown” option. Do not select a specific race. If importing transfers, layoffs or any other user-defined activity, select one User-Defined for each activity.
+
:* If the software asks you to clarify '''Unknow'''n or blank race or sex, select the '''Unknown''' option.
 +
:* If importing user-defined activity, select one user-defined button for each activity.
  
 
[[file:Import_Mapping_AI_Activities.png‎]]
 
[[file:Import_Mapping_AI_Activities.png‎]]
  
10) When import is complete click the Adv. Impact icon.
+
7) When import is complete click the '''Adv. Impact''' icon.
  
11) If dates are not populated, type dates in the date boxes or use the calendar to select them.
+
8) If dates are not populated, type dates in the date boxes or use the calendar to select them.
  
12) If Beginning fields are not populated, type totals for males, female, White, Black, Hispanic, Asian, American Indian, Pacific Islander~/Hawaiian and Two or More.
+
9) If Base Group fields are not populated, type totals for males, females, Whites, Blacks, Hispanics, Asians, American Indians, Pacific Islanders/Hawaiians and Two or More.
  
13) Check the Applicant, Hires, Promotions (From), Promotions (To) and Terminations tabs to verify that the data was imported correctly.
+
10) Check the '''Applicant''', '''Hires''', '''Promotions (From)''', '''Promotions (To)''' and '''Terminations''' tabs to verify that the data was imported correctly.
  
14) If you wish to change some of the data we suggest making the changes manually or removing all the data and reimporting. The Complete AAP does not overwrite data already input when additional data is imported, it adds to existing totals.
+
11) If you wish to change some of the data we suggest making the changes manually or removing all the data and re-import the corrected data. The Complete AAP adds to existing totals.
  
 
Continue to: [[Determine Goals Progress]]
 
Continue to: [[Determine Goals Progress]]

Revision as of 21:41, 1 September 2011

If you have not already formatted your Activity or Summary file, please refer to Format Your Adverse Impact Data for Import. . You must format your file before importing. Have the appropriate AAP open before performing the following steps. Pro users may import using the Work with All Plans option, or may import into one AAP at a time. To import, have no windows open in the The Complete AAP, and follow the steps below.

Follow these steps to import:

1) Click the Import icon.

Import Icon.png

2) Select the type of file you want to import: Adverse Impact Detail File or Adverse Impact Summary File.

Import Wizard - AI Summary.png

3) The Import File box displays the location of your ai_detail__import.xlsx or ai_summary_import.xlsx file. If your import file is not mapped correctly, click the Browse.jpg button to locate it.

a. Use Look in pull-down menu to indicate the drive where your file is stored.

Open - Select an Import file.png

b. Select your Adverse Impact Detail File or Adverse Impact Summary File and then click OK.

Import Wizard - AI Detail.png

c. You’ll see your path appear in the Import File box.

4) Click Import.

5) If it applies, click Yes when you see the following message.

HeaderRowMessage.png

ProTag.jpg Pro users will see the following message.

  • Click Yes if you are importing data for only the plan you are in.
  • Click No if you are importing data for all plans.

SinglePlanImportMessage.png

6) The Complete AAP might ask you to clarify information that it does not recognize. These are not errors. Do not cancel the import.

a) Identify the item that is in question.
b) Select the correct corresponding selection from the provided list.
c) Click OK.
  • If the software asks you to clarify Unknown or blank race or sex, select the Unknown option.
  • If importing user-defined activity, select one user-defined button for each activity.

Import Mapping AI Activities.png

7) When import is complete click the Adv. Impact icon.

8) If dates are not populated, type dates in the date boxes or use the calendar to select them.

9) If Base Group fields are not populated, type totals for males, females, Whites, Blacks, Hispanics, Asians, American Indians, Pacific Islanders/Hawaiians and Two or More.

10) Check the Applicant, Hires, Promotions (From), Promotions (To) and Terminations tabs to verify that the data was imported correctly.

11) If you wish to change some of the data we suggest making the changes manually or removing all the data and re-import the corrected data. The Complete AAP adds to existing totals.

Continue to: Determine Goals Progress

See Also

Import Current Midyear Adverse Impact Data


© Copyright Yocom & McKee, Inc.