< back

Tools for Multiple VETS-4212 Reports

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

KEY TOPICS:

  • (If necessary) Create Master Plan and Import Data for VETS
  • Link Plan Location and VETS Establishment Information
  • Add Establishment Information
  • Import Establishment Information
  • Delete an Establishment
  • Finalize and Export Multiple VETS-100A Reports

Use Master Plan VETS-100A Settings

(If necessary) Create Master Plan and Import Data

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.