< 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 report footer.

Quick Tip: To have the system perform this calculation, see: Report Settings.

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.