VETS-4212 Report
Important Notes: While the EEO-1 and VETS-100A components of balanceAAP share similar functions, each is tailored to some specific requirements for the type of reporting.
KEY TOPICS:
- Prepare the Roster, New Hires, and Termination Data Tables
- Perform Verification (Recommended)
- View Summary Report
- Finalize and Export Report
- Preview Report
- Calculate Minimum/Maximum Number of Employees
- Master Plan VETS-100A Considerations
Create the VETS-100A Report for your Organization
Organizations with Federal contracts meeting a certain value must complete the VETS-100A form to the Veterans' Employment and Training Service. Contractors with multiple establishments will also fall under particular requirements for the number and type of forms to be submitted; BALANCEaap's Master Plan format can support these requirements (as linked above).
Consult the regulations and published instructions for more information on VETS-100A reporting requirements, at: www.dol.gov/vets/vets-100.
Prepare the Roster, New Hire, and Termination Data Tables
The VETS-100A report(s) should be created using an employee Roster effective between August 1 and September 30 of the current survey year. The report should cover new hire records from the 12 months preceding the Roster’s effective date. If your organization's AAP's Plan Date does not fall within this period, create a separate plan for the VETS reporting.
Quick Tip: Prepare EEO-1 and VETS reporting, using the same Plan Date and data set.
If date information is available on the New Hires and Termination tables, the minimum or maximum number of employees staffed during the analysis year can be calculated by the system. (This setting, described below, available on the VETS-100A > Report / Report Settings menu.)
Develop Report Information
The Report Information tab contains 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 required fields. To view hidden fields for a record, click the [Plus sign] on the right.
Enter Analyses Information
The Analysis Information menu displays fields common to all establishments covered in the VETS-100A report(s). Analyses Information is the boilerplate information that will be placed in the report’s header and footer.
Enter the necessary information, then click [Save].
Enter Establishment Information
Note: Changing the selection to or from None will cause current Establishment Information record(s) to be deleted.
Finalize and Export Report
Navigate to the VETS-100A > Reports tab.
Preview Report
To export your report, first select the Report Export option. If applicable, chose to export your report as a single file or separate files. Next, select the file type – PDF, Word, Excel, or Rich Text. Select the Establishment Codes (if applicable) you wish to include in the report, check off whether you want the Min/Max values calculated. Select the appropriate settings and click [Run Report].
The Min/Max values represent the highest and lowest number of employees staffed in the previous 12 months. balanceAAP calculates this number by looking at the new hires and terminations imported with your Roster.
When you are ready to run your final report for electronic submission you can export the file. To export the file, select File Export, select your options under Report Settings, and then click [Run Report]. The exported file will be formatted according to the 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.
Calculate Minimum/Maximum Number of Employees
Perform Verification (Recommended)
This tab allows you to examine your data to identify any inconsistencies that may negatively impact the submission and acceptance of your VETS-100 report.
To scan your report, click Verify. In the information section, identified by the info icon, the date of the most recent verification will be listed.
If your VETS-100 report has errors, 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.
Finalize and Export Report
Navigate to the VETS-100A > Reports tab.
Preview Report
Under Report Viewing Options, select HTML or PDF . If applicable select the Establishment Code you would like to preview. Only one Establishment Code can be chosen at a time.Calculate Minimum/Maximum Number of Employees
Under the Report Settings section, check off whether you want the Min/Max values calculated. The Min/Max values represent the highest and lowest number of employees staffed in the previous 12 months. balanceAAP calculates this number by looking at the new hires and terminations imported with your Roster.Select the appropriate settings, and click [Run Report].
To export your report, first select the Report Export option. If applicable, chose to export your report as a single file or separate files. Next, select the file type – PDF, Word, Excel, or Rich Text. Select the Establishment Codes (if applicable) you wish to include in the report, check off whether you want the Min/Max values calculated. Select the appropriate settings 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, select your options under Report Settings, and then click [Run Report]. The exported file will be formatted according to the 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.