Standard AQ - Vets 4212 Reporting

Required Setup

Mapping should be setup in Admin Tools > Import Export Mapping or an error message “Missing Mapping in Admin Tools >> Import Export Mapping Setion” will appear. Mapping Type with group description EEO Report Mapping should be setup.

Report Description

Contractors and subcontractors who enter into, or modify a contract or subcontract with the federal government, and whose contract meets the criteria set forth under the 38 U.S. Code, Section 4212, codified at 41 CFR Section 31-300, must report the data that this report populates. This report makes it easy to report the VETS 4212 data.

Based on this spec: Format/Spec

Parameters

Parameter Name	Options	Description
Supplier	All available suppliers
Branch (Employee)	All available branches
Date Type	Week Worked, Accounting Period Date	Transaction’s week worked or accounting period
Start Date
End Date
Show Employee Info	Yes / No	Shows different columns based on Yes or No selected

Report Fields

Field Name	Description
Employee ID	Employee ID (Visible when “Yes” is selected for Show Employee Info)
BoldTalentID	The identifier for the employee in AviontéBOLD (Front OFfice)
Employee Name	Employee name (Visible when “Yes” is selected for Show Employee Info)
Veteran Status	Veteran status from employee EEO (Visible when “Yes” is selected for Show Employee Info)
Job Position	Job position from transaction (Visible when “Yes” is selected for Show Employee Info)
Mapping Job Category	Shows the category from the table AQ_Tbl_FederalEEOReporting_JobCategoryList according to the MapToID (Admin>Import Export Mapping Type) of the job position (Visible when “Yes” is selected for Show Employee Info)
Is New Hire	Shows checked if employee has received his/her first paycheck in date range between the end date and one year prior to end date (Visible when “Yes” is selected for Show Employee Info)
Job Category	Shows the category from the table AQ_Tbl_FederalEEOReporting_JobCategoryList according to the MapToID (Admin>Import Export Mapping Type) of the job position (Visible when “No” is selected for Show Employee Info)
Disabled Veterans (L)	Shows the count of employees with veteran status “Disabled” and ”Disabled Veterans” but does not include new hire employees (Visible when “No” is selected for Show Employee Info)
Other Protected Veterans (M)	Shows the count of employees with veteran status “Other Protected Veterans” but does not include new hire employees (Visible when “No” is selected for Show Employee Info)
Armed Forces Service Medal Veterans (N)	Shows the count of employees with veteran status “Armed Forces Service Medal Veterans” but does not include new hire employees (Visible when “No” is selected for Show Employee Info)
Recently Separated Veterans (O)	Shows the count of employees with veteran status “Recently Separated Veterans” but does not include new hire employees (Visible when “No” is selected for Show Employee Info)
Total Employees (P)	Shows the total number of employees but does not includes new hire employees (Visible when “No” is selected for Show Employee Info)
Disabled Veterans NewHire Previous12Months (Q)	Shows the count of new hire employees with veteran status “Disabled Veterans” (Visible when “No” is selected for Show Employee Info)
Other Protected Veterans NewHire Previous12Months (R)	Shows the count of new hire employees with veteran status “Other Protected Veterans” (Visible when “No” is selected for Show Employee Info)
Armed Forces Service Medal Veterans NewHire Previous12Months (S)	Shows the count of new hire employees with veteran status “Armed Forces Service Medal Veterans” (Visible when “No” is selected for Show Employee Info)
Recently Separated Veterans NewHire Previous12Months (T)	Shows the count of new hire employees with veteran status “Recently Separated Veterans” (Visible when “No” is selected for Show Employee Info)
Total Employees NewHire Previous12Months (U)	Shows the total number of new hire employees (Visible when “No” is selected for Show Employee Info)