VETS preparation report (HcmVETSPrepReport) [AX 2012]

Updated: November 27, 2013

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

This report provides data that you can use if you are required to prepare the VETS 100 or VETS100A report regarding your organization’s affirmative action efforts in employing veterans. Federal contractors and subcontractors who meet specific requirements must submit the VETS reports annually to the Office of Federal Contractor Compliance Programs (OFCCP).


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

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.



End date

The last day of the 12-month reporting period that is covered by the report that you are completing. The system calculates the first day of the reporting period based on the date that you enter here.

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\HcmVETSPrepReport

Menu item of the report


Navigation to the report

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

The data on this report comes from the following sources:

  • HcmVETSPrepReport query

  • HcmWorker table

  • HcmEmployemnt table

  • HcmEEOEstablishment table

  • HcmPositionWorkerAssignment table

  • HcmPositionDetail table

  • HcmJob table

  • HcmJobDetail table

  • HcmJobFunction table

  • Dirperson table

  • HcmPersonDetails table

  • HcmVeteranStatus table

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).