EEO preparation report (HcmEEOPrepReport) [AX 2012]

Updated: November 27, 2013

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

There are several versions of the EEO preparation report that you can use when you prepare the reports required by the U.S. Equal Employment Opportunity Commission. The EEOC enforces the federal laws that prohibit discrimination against a job applicant or an employee because of the person's race, color, religion, sex (including pregnancy), national origin, age (40 or older), disability, or genetic information.


This topic does not apply to versions of Microsoft Dynamics AX 2012 prior to cumulative update 6 for AX 2012.

The following list includes all of the available versions of the EEO preparation report:

  • Incomplete EEO-related values: Used to identify any missing information that would prevent you from completing an EEO report accurately.

  • EEO-1: Used by private-sector entities.

  • EEO-4: Used by state and local governments.

  • EEO-5: Used by public elementary or secondary schools and school districts.

You should always run the Incomplete EEO-related values report and enter missing information before you run any of the other EEO preparation reports. The first time that you run this report, it is possible that every worker will be missing the Classification of the position type. This field, which is set up in the Position types form, indicates whether the position is full-time or part-time.

When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.



As of

Each EEO report includes the workers who have an active employment on this date.

Regulatory establishment

The work location that you are completing the report for.

The following topics explain how to print a report and how to filter and sort the data on a report.

The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.



Name of report in the AOT


Location of report in the AOT

SSRS Reports\Reports\HcmEEOPrepReport

Menu item of the report


Navigation to the report

Click Human resources > Reports > Workers > Regulatory > EEO preparation.

The data on this report comes from the following sources:

  • HcmWorker

  • HcmEmployment

  • HcmPositionWorkerAssignment

  • HcmPersonPrivateDetails

  • HcmPositionDetail

  • HcmJob

  • HcmJobDetail

  • HcmJobFunction

  • HcmEthnicOrigin

  • HcmPositionType

  • DirPerson

  • HrmCompFixedEmpl

These tables are all included in the query HcmEEOPrepReport.

If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.

  1. Open the AOT.

  2. Locate the report in the SSRS Reports\Reports node.

  3. Right-click the report and click Add-Ins > Cross-reference > Using (instant view).

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).