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
| 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 |