VETS4212 V2

https://data.dol.gov/get/vets4212dataset

This dataset contains required veteran employment data by federal contractors/subcontractors. The table VwV4212DataDotGov contain the past two years plus current filing cycle. V4212DataDotGov are reports entered for contracts that were established with the Federal Government and are greater than $150,000.00.

Dataset Tables

V4212DataDotGov

VETS4212 Data Dot Gov
Column Name Data Type Column Description
Column Name ReportID Data Type int Column Description Report ID - Primary Key
Column Name ReportType Data Type nvarchar Column Description Report Type - VETS-4212
Column Name FilingCycle Data Type int Column Description Filing Cycle - Year
Column Name EndingPeriod Data Type date Column Description Ending Period - Date (mm/dd/yyyy)
Column Name FormType Data Type nvarchar Column Description Form Type - Single Establishment (S), Multiple Establishment-Headquarters (MHQ), Multiple Establishment-Hiring Location (MHL), Multiple Establishment - State Consolidated (MSC)
Column Name OrgType Data Type nvarchar Column Description Type of Reporting Organization - Prime Contractor (P), Subcontractor (S), Both (B)
Column Name CoName Data Type nvarchar Column Description Company Name
Column Name CoAddress Data Type nvarchar Column Description Company Address
Column Name CoCity Data Type nvarchar Column Description Company City
Column Name CoCounty Data Type nvarchar Column Description Company County
Column Name CoState Data Type nvarchar Column Description Company State
Column Name CoZip Data Type varchar Column Description Company Zip
Column Name HlName Data Type nvarchar Column Description Hiring Location Name
Column Name HlAddress Data Type nvarchar Column Description Hiring Location Address
Column Name HlCity Data Type nvarchar Column Description Hiring Location City
Column Name HlCounty Data Type nvarchar Column Description Hiring Location County
Column Name HlState Data Type nvarchar Column Description Hiring Location State
Column Name HlZip Data Type varchar Column Description Hiring Location Zip
Column Name NAICS Data Type varchar Column Description NAICS
Column Name MSC Data Type int Column Description Number of MSC Locations
Column Name MaxNumber Data Type int Column Description Maximum Number
Column Name MinNumber Data Type int Column Description Minimum Number
Column Name CreatedOn Data Type datetime Column Description Created On - Date
Column Name JobCategCode1 Data Type nvarchar Column Description Job Category - Executive/Senior Level Officials and Managers
Column Name NumEmps_ProtectedVets1 Data Type int Column Description Number of Employees - Protected Veterans employees in the Executive/Senior Level Officials and Managers
Column Name NewHire_ProtectedVets1 Data Type int Column Description Number of New Hires - Protected Veterans Employees in the Executive/Senior Level Officials and Managers
Column Name NumEmps_TotalAllEmployees1 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees1 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode2 Data Type nvarchar Column Description Job Category - First/Mid Level Officials and Managers
Column Name NumEmps_ProtectedVets2 Data Type int Column Description Number of Employees - Protected Veterans in the First/Mid Level Officials and Managers Job Category
Column Name NewHire_ProtectedVets2 Data Type int Column Description Number of New Hires - Protected Veterans in the First/Mid Level Officials and Managers Job Category
Column Name NumEmps_TotalAllEmployees2 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees2 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode3 Data Type nvarchar Column Description Job Category - Professionals
Column Name NumEmps_ProtectedVets3 Data Type int Column Description Number of Employees - Protected Veterans in the Professionals Job Category
Column Name NewHire_ProtectedVets3 Data Type int Column Description Number of New Hires - Other Protected Veterans in the Professionals Job Category
Column Name NumEmps_TotalAllEmployees3 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees3 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode4 Data Type nvarchar Column Description Job Category - Technicians
Column Name NumEmps_ProtectedVets4 Data Type int Column Description Number of Employees - Other Protected Veterans in the Technicians Job Category
Column Name NewHire_ProtectedVets4 Data Type int Column Description Number of New Hires - Protected Veterans in the Technicians Job Category
Column Name NumEmps_TotalAllEmployees4 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees4 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode5 Data Type nvarchar Column Description Job Category - Sales Workers
Column Name NumEmps_ProtectedVets5 Data Type int Column Description Number of Employees - Protected Veterans in the Sales Workers Job Category
Column Name NewHire_ProtectedVets5 Data Type int Column Description Number of New Hires - Protected Veterans in the Sales Workers Job Category
Column Name NumEmps_TotalAllEmployees5 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees5 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode6 Data Type nvarchar Column Description Job Category - Administrative Support Workers
Column Name NumEmps_ProtectedVets6 Data Type int Column Description Number of Employees - Protected Veterans in the Administrative Support Workers Job Category
Column Name NewHire_ProtectedVets6 Data Type int Column Description Number of New Hires - Protected Veterans in the Administrative Support Workers Job Category
Column Name NumEmps_TotalAllEmployees6 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees6 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode7 Data Type nvarchar Column Description Job Category - Craft Workers
Column Name NumEmps_ProtectedVets7 Data Type int Column Description Number of Employees - Protected Veterans in the Craft Workers Job Category
Column Name NewHire_ProtectedVets7 Data Type int Column Description Number of New Hires - Protected Veterans in the Craft Workers Job Category
Column Name NumEmps_TotalAllEmployees7 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees7 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode8 Data Type nvarchar Column Description Job Category - Operatives
Column Name NumEmps_ProtectedVets8 Data Type int Column Description Number of Employees - Protected Veterans in the Operatives Job Category
Column Name NewHire_ProtectedVets8 Data Type int Column Description Number of New Hires - Protected Veterans in the Operatives Job Category
Column Name NumEmps_TotalAllEmployees8 Data Type init Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees8 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode9 Data Type nvarchar Column Description Job Category - Laborers/Helpers
Column Name NumEmps_ProtectedVets9 Data Type int Column Description Number of Employees - Protected Veterans in the Laborers/Helpers Job Category
Column Name NewHire_ProtectedVets9 Data Type int Column Description Number of New Hires - Protected Veterans in the Laborers/Helpers Job Category
Column Name NumEmps_TotalAllEmployees9 Data Type int Column Description Number of Employees - Total Employees, BothVeterans and Non- Veterans
Column Name NewHire_TotalAllEmployees9 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode10 Data Type nvarchar Column Description Job Category - Service Workers
Column Name NumEmps_ProtectedVets10 Data Type int Column Description Number of Employees - Protected Veterans in the Service Workers Job Category
Column Name NewHire_ProtectedVets10 Data Type int Column Description Number of New Hires - Protected Veterans in the Service Workers Job Category
Column Name NumEmps_TotalAllEmployees10 Data Type int Column Description Number of Employees - Total Employees, Both Veterans and Non- Veterans
Column Name NewHire_TotalAllEmployees10 Data Type int Column Description Number of New Hires - Total Employees, Both Veterans and Non- Veterans
Column Name JobCategCode11 Data Type nvarchar Column Description Job Category - Total
Column Name NumEmps_ProtectedVets11 Data Type int Column Description Total Number of Employees - Protected Veterans
Column Name NewHire_ProtectedVets11 Data Type int Column Description Total Number of New Hires - Protected Veterans
Column Name NumEmps_TotalAllEmployees11 Data Type int Column Description Total Number of Veteran and Non-Veteran employees
Column Name NewHire_TotalAllEmployees11 Data Type int Column Description Total Number of Veteran and Non-Veteran new hires