EEO-1 Report

KEY TOPICS:

• Prepare the Roster
• View Report Information
• Import Establishments
• Perform Verification (Recommended)
• Export Report
• Master Plan Considerations and Settings

Important Note: While the EEO-1 and VETS-100 components of balanceAAP share similar functions, each is tailored to the specific requirements for the type of reporting.

Please consult the regulations for more information on EEO reporting requirements.

Prepare the Roster

EEO-1 report(s) should be created using an employee roster effective between July 1 and August 31 of the current survey year. If the source AAP plan date does not fall within this period, create a separate plan, and use the employment data from the appropriate period to create the EEO-1 report(s).

If the organization is comprised of multiple locations and all EEO-1 reports can be created from a master data set, first create the Master Plan and Import a master data set. Include a Plan Code, a Drilldown, or a User Defined Field in the data set to be used as the Establishment Code, which will parse data for each EEO-1 report.

View Report Information

On the Report Information tab are the Analysis Information menu and the Establishment Information table. Also available from the tab header are tabs for Verification and Report.

The Establishment Information table is organized by Establishment Code and describes each establishment, using EEO-1 required fields. To view hidden fields for a record, click the expand [Plus sign] on the right.

Enter Analyses Information

TheEnter Analysis InformationInformation, menu displays fields common to all establishments covered in the EEO-1 report(s). Analyses Information is the boilerplate information thatwhich will be placed in the report’s headerreport and footer.used by the Agency to identify the reporting organization and its contacts.

Enter the necessary information, then clickClick [Save].

Note: Analyses Information can be edited and re-saved.

Enter Establishment Information

If multiple establishments are to be represented in the EEO-1 report, use the provided drop-down to select the field from the AAP data tables that contains this information.

The drop-down options include Plan Code and any Drilldowns or User Defined Fields that were created. Choose None if the report is for one location.

Note: A Master Plan or Regular Plan must be open to have fields available in the drop-down menu. Changing the selection to or from None will cause current Establishment Information record(s) to be deleted.

Add Establishment Information

To manually add information, select [Add Establishment]. A window will display, allowing data to be entered. Click [Save] to store the information.

Import Establishments

Click [Import Establishments]. Choose the appropriate file type (Excel, Access or a text) from the list. Click [Browse] to choose the file you would like to import and click [Next]. Select the file and sheet name information from the drop-down menu. In the Match Fields section, select the field names from the drop-down menus that best match the field names listed. Some fields may be automatically matched. Fields marked with an * are required. You can view a Preview of the data in the file you are importing from in the Preview of Data section. Click [Next] once you have completed matching your fields. Then choose whether to Overwrite or Append the data. Click [Import Data] to complete the import process. The import results will be displayed when the import process is complete.

The Establishment Code and three additional fields will display in the table. To view additional information fields for the establishments, click on the plus sign icon on the right.

Export Report

If applicable, from the Report Export option located on the Reports tab, choose to export your report as a single file or separate files.

Next, select the file type PDF, Word, Excel, or Rich Text. Finally, select the Establishment Codes (if applicable) you wish to include in the report, select the report settings if necessary, and click [Run Report].

When you are ready to run your final report for electronic submission you can export the file. To export the file, select File Export and then click Run Report. The exported file will be formatted according to the EEOC requirements for electronic submission. You will be prompted to download the file. If your pop-up blocker prevents the file from automatically being downloaded, you can also click the link at the top of the screen to download the file.

Perform Verification (Recommended)

The Verification tab allows you to examineinitiate youra system scan on the report's data prior to identifysubmission: anyClick inconsistencies that may negatively impact the submission and acceptance of your EEO-1 report.

To scan your report, click *[*Verify]Verify. In the information section, identified by the info icon, the date of the most recent verification will be listed.

If yourthe system detects errors in the EEO-1 report has errors,report, they will be displayed in the Errors Section. If your report has multiple error types, you can select to view a particular error from the Error Type drop-down menu. Any errors that should be addressed will be listed in table form, displaying the description of the error, the Establishment the error is located in, the field that contains the incorrect data, and the actual incorrect value.

Some error types have an available acceptable solution. These errors will have the Fix These Records link next to the Error Type drop-down menu. Click this option to be assisted in fixing the error(s).

If the error type does not have an acceptable solution, you will need to manually correct the data. You can do this by returning to the Report Information tab and making any necessary changes.

You can also produce a summary report of all the errors by clicking View Summary. A new tab will open with an error summary report displaying all error types and corresponding information.

Master Plan Considerations Settings

If multiple establishments are to be represented in the EEO-1 report, use the provided drop-down to select the field from the AAP data tables that contains this information.

The drop-down options include Plan Code and any Drilldowns or User Defined Fields that were created.