< back

Tools for Multiple VETS-4212 Reports

Please read the linked EEO-1VETS-100A instructions above to familiarize yourself with VETS-100AVETS tools. Then review the following notes, regarding creating multiple VETS reports from a Master Plan.

Use Master Plan VETS-100A Settings

If the organization is comprised of multiple locations and all VETS-100A reports are to be created from one master data set, first create the Master Plan and import the master data set. Include a Plan Code, Drilldown, or a User Defined Field in the data set to be used as the Establishment Code to parse data for each VETS-100A report.

Add an Establishment

Below the Analysis Information menu, click [Add Establishment] to enter establishments one at a time. The Add Report Information menu opens. Enter the requested information to identify and organize the establishment’s report in accordance with Federal requirements. The requested entries include:

Type of Organization

Choose one of the following:

  • P - Prime Contractor
  • S - Subcontractor
  • B - Both

Type of Form

Choose one of the following as it pertains to the establishment:

  • S – Single Establishment
  • MHQ – Multiple Establishment Headquarters
  • MHL – Multiple Establishment – Hiring Location
  • MSC – Multiple State – Consolidated

Number of Locations

Enter a numerical entry.

Notes: If S - Single Establishment has been selected under Type of Form, the Number of Locations field becomes inactive. When MHQ, MHL, or MSC has been selected for Type of Form, the Number of Locations will be included in the VETS-100A report.

Hiring (HL) Information

Complete address fields for the hiring location.

Minimum (Min Value) and Maximum (Max Value) Number of Employees

Enter the maximum number of regular employees on board during the period covered by this report and the minimum number of regular employees on board during the period covered by this report, respectively. The numbers will be displayed in the footer of the report.

NAICS, DUNS, and EIN numbers

Enter the identifying numbers for the establishment.

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.

The Establishment Information table houses added or imported records by Establishment Code.

Import Establishments

To import Establishment information, 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 establishment click on the plus sign.