| ID | Data Element Name | Description | Required | Input Format | Field Size | Column | Business Rules |
|---|---|---|---|---|---|---|---|
| DE-C4212-1 | Company Number | Allows the user to indicate their company’s number | N | Text | 7 | Column number 1 | First digit is allowed to be a letter or number Remaining six digits must be a number |
| DE-C4212-2 | Type of Reporting Organization | Allows the user to identify the type of reporting organization | Y | Text | 1 | Column number 2 | · P (for Prime Contractor) · S (for Subcontractor) · B (for Both) |
| DE-C4212-3 | Type of Form | Allows the user to identify the type of form being submitted | Y | Text | 3 | Column number 3 | · S (for Single Establishment) · MHQ (for Multiple Establishment-Headquarters) · MHL (for Multiple Establishment-Hiring Location) · MSC (for Multiple Establishment – State Consolidated) |
| DE-C4212-4 | Number of MSC Locations | Allows the user to indicate the number of Multiple Establishment-State Consolidated locations being reported by this form | N* | Number | 8 | Column number 4 | · Must be a whole, positive number · Must be greater than 0 *Required if the “Multiple Establishment – State Consolidated” Type of Form is selected |
| DE-C4212-5 | Twelve Month Period Ending Date | Allows the user to indicate the day which the data they are submitting was last collected | Y | Date | 8 | Column number 5 | Must be a valid date in mm/dd/yyyy format Date must occur between 7/1 and 8/31 or on 12/31 When submitting new reports, the year must be for the current filing cycle (e.g., for the 2012 filing cycle, the only selectable year will be 2012) |
| DE-C4212-6 | Name of Parent Company | Allows the user to indicate the name of their parent company | Y | Text | 100 | Column number 6 | · The system shall verify that the entered Company Name and Company Number match the previously saved Company Name and Company Number combination · Can contain letters, numbers, dash(-), period (.), ampersand (&), apostrophe (‘) · Cannot contain ~!@#$%^&*_=+[]{}\|;”<>/?: |
| DE-C4212-7 | Company Address (Number and Street) | Allows the user to indicate the building number and street for their company | Y | Text | 100 | Column number 7 | · Can contain letters, numbers, apostrophe (‘),dash(-), period (.) · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-8 | Company Second Address | Allows the user to indicate a second line’s worth of address information for their company | N | Text | 100 | Column number 8 | · Can contain letters, numbers, apostrophe (‘),dash(-), period (.) · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-9 | Company City | Allows the user to indicate the city for their company | Y | Text | 50 | Column number 9 | · Can contain letters, apostrophe (‘),dash(-), period (.) · Cannot contain numbers · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-10 | Company County | Allows the user to indicate the county for their company | Y | Text | 50 | Column number 10 | · Can contain letters, apostrophe (‘),dash(-), period (.) · Cannot contain numbers · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-11 | Company State | Allows the user to indicate the state for their company | Y | Text | 2 | Column number 11 | All 50 US States · DC · AS · GU · MP · PR · VI · FM · MH · PW · AA · AE · AP |
| DE-C4212-12 | Company Zip Code | Allows the user to indicate the zip code for their company | Y | Number | 10 | Column number 12 | · Must be in XXXXX OR XXXXXXXXX format |
| DE-C4212-13 | Name of Company Contact | Allows the user to indicate the name of a contact for their company | Y | Text | 100 | Column number 13 | · Can contain letters, apostrophe (‘),dash(-), period (.) · Cannot contain numbers · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-14 | Telephone for Contact | Allows the user to enter a telephone number for the company contact | Y | Number | 20 | Column number 14 | · The system shall provide an example of the format to enter the phone number in · The system shall removing any special characters entered by the user prior to saving the value to the database · Must be a whole positive number in xxxxxxxxxx format |
| DE-C4212-15 | Email address | Allows the user to enter an email address for the company contact | Y | Text | 100 | Column number 15 | · Must be a valid email address (contain all the correct components, e.g., local-part@domain |
| DE-C4212-16 | Name of Hiring Location | Allows the user to enter the Hiring Location’s Name | N* | Text | 100 | Column number 16 | * Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · Can contain letters, numbers, dash(-), period (.), ampersand (&), apostrophe (‘) · Cannot contain ~!@#$%^&*_=+[]{}\|;”<>/?: |
| DE-C4212-17 | Hiring Location Address (Number and Street) | Allows the user to enter the Hiring Location’s building number and street address | N* | Text | 100 | Column number 17 | * Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · Can contain letters, numbers, apostrophe (‘),dash(-), period (.) · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-18 | Hiring Location Second Address | Allows the user to enter an additional “line’s” worth of address information | N* | Text | 100 | Column number 18 | * Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · Can contain letters, numbers, apostrophe (‘),dash(-), period (.) · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-19 | Hiring Location City | Allows the user to enter the Hiring Location’s City | N* | Text | 50 | Column number 19 | * Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · Can contain letters, apostrophe (‘),dash(-), period (.) · Cannot contain numbers · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-20 | Hiring Location County | Allows the user to enter the Hiring Location’s County | N* | Text | 50 | Column number 20 | * Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · Can contain letters, apostrophe (‘),dash(-), period (.) · Cannot contain numbers · Cannot contain ~!@#$%^&*()_=+[]{}\|;”<>/?:,()& |
| DE-C4212-21 | Hiring Location State | Allows the user to enter the Hiring Location’s State | N* | Text | 2 | Column number 21 |
* Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · All 50 US States · DC · AS · GU · MP · PR · VI · FM · MH · PW · AA · AE · AP |
| DE-C4212-22 | Hiring Location Zip Code | Allows the user to enter the Hiring Location’s zip code | N* | Number | 10 | Column number 22 | * Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated · Must be in either in XXXXX or XXXXXXXXX format · Data element is required if the form type is set to Multiple Establishment-Hiring Location or Multiple Establishment-State-Consolidated |
| DE-C4212-23 | NAICS | Allows the user to enter in the NAICS code | Y | Number | 6 | Column number 23 | · Can only contain numbers · Minimum of two digits in length, max of six |
| DE-C4212-24 | DUNS | Allows the user to enter in the DUNS code | Y | Number | 9 | Column number 24 | · Can only contain numbers · Must be nine digits long · Location DUNS value must match the Company DUNS value for Single Establishment (S) and Multiple Establishment - Headquarters (MHQ) reports. |
| DE-C4212-25 | Employee ID (IRS Tax No) | Allows the user to enter in their Employee ID | Y | Number | 9 | Column number 25 | · Can only contain numbers · Must be nine digits long · Location EIN value must match the Company EIN value for Single Establishment (S) and Multiple Establishment - Headquarters (MHQ) reports. |
| DE-C4212-26 | Number of protected veterans who are Executive/Senior Officials and Managers | Allows the user to enter in the number of protected Veterans employees who are in the Executive/Senior Officials and Managers job category | Y | Number | 8 | Column number 26 | · Must be a whole positive number |
| DE-C4212-27 | Number of Protected Veterans employees who are First/Mid Level Officials and Managers | Allows the user to enter in the number of Protected Veterans employees who are in the First/Mid Level Officials and Managers job category | Y | Number | 8 | Column number 27 | · Must be a whole positive number |
| DE-C4212-28 | Number of protected Veterans employees who are Professionals | Allows the user to enter in the number of protected Veterans employees who are in the Professionals job category | Y | Number | 8 | Column number 28 | · Must be a whole positive number |
| DE-C4212-29 | Number of protected Veterans employees who are Technicians | Allows the user to enter in the number of protected Veterans employees who are in the Technicians job category | Y | Number | 8 | Column number 29 | · Must be a whole positive number |
| DE-C4212-30 | Number of protected Veterans employees who are Sales Workers | Allows the user to enter in the number of protected Veterans employees who are in the Sales Workers job category | Y | Number | 8 | Column number 30 | · Must be a whole positive number |
| DE-C4212-31 | Number of protected Veterans employees who are Administrative Support Workers | Allows the user to enter in the number of protected Veterans employees who are in the Administrative Support Workers job category | Y | Number | 8 | Column number 31 | · Must be a whole positive number |
| DE-C4212-32 | Number of protected Veterans employees who are Craft Workers | Allows the user to enter in the number of protected Veterans employees who are in the Craft Workers job category | Y | Number | 8 | Column number 32 | · Must be a whole positive number |
| DE-C4212-33 | Number of protected Veterans employees who are Operatives | Allows the user to enter in the number of protected Veterans employees who are in the Operatives job category | Y | Number | 8 | Column number 33 | · Must be a whole positive number |
| DE-C4212-34 |
Number of protected Veterans employees who are Laborers / Helpers | Allows the user to enter in the number of protected Veterans employees who are in the Laborers / Helpers job category | Y | Number | 8 | Column number 34 | · Must be a whole positive number |
| DE-C4212-35 | Number of protected Veterans employees who are Service Workers | Allows the user to enter in the number of protected Veterans employees who are in the Service Workers job category | Y | Number | 8 | Column number 35 | · Must be a whole positive number |
| DE-C4212-36 | Total Number of protected Veterans employees | Allows the user to enter in the total number of protected Veterans employees across all job categories | Y | Number | 8 | Column number 36 | · Must be a whole positive number · The system shall confirm that the entered value is equal to the sum of all protected Veteran Employees entered into the following job categories: . Executive/ Senior Level Officials and Managers . First/Mid Level Officials and Managers . Professionals . Technicians . Sales Workers . Administrative Support Workers . Craft Workers . Operatives . Laborers/ Helpers . Service Workers |
| DE-C4212-37 | Total Number of Veterans and Non-Veterans employees who are Executive/Senior Level Officials and Managers | Allows the user to enter in the number Veterans and Non-Veterans employees who are in the Executive/Senior Level Officials and Managers job category | Y | Number | 8 | Column number 37 | · Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Executive/Senior Level Officials and Managers employees |
| DE-C4212-38 | Total Number of Veterans and Non-Veterans employees who are First/Mid Level Officials and Managers | Allows the user to enter in the number of Veterans and Non-Veterans employees who are in the First/Mid Level Officials and Managers job category< | Y | Number | 8 | Column number 38 | · Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans First/Mid Level Officials and Managers employees |
| DE-C4212-39 | Total Number of Veterans and Non-Veterans employees who are Professionals | Allows the user to enter in the number of Veterans and Non-Veterans employees who are in the Professionals job category | Y | Number | 8 | Column number 39 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Professionals employees |
| DE-C4212-40 | Total Number of Veterans and Non-Veterans employees who are Technicians | Allows the user to enter in the number of Veterans and Non-Veterans employees who are in the Technicians job category | Y | Number | 8 | Column number 40 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Technicians employees |
| DE-C4212-41 | Total Number of Veterans and Non-Veterans employees who are Sales Workers | Allows the user to enter in the number Veterans and Non-Veterans employees who are in the Sales Workers job category | Y | Number | 8 | Column number 41 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Sales Workers employees |
| DE-C4212-42 | Total Number of Veterans and Non-Veterans employees who are Administrative Support Workers | Allows the user to enter in the number Veterans and Non-Veterans employees who are in the Administrative Support Workers job category | Y | Number | 8 | Column number 42 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Administrative Support Workers employees |
| DE-C4212-43 | Total Number of Veterans and Non-Veterans employees who are Craft Workers | Allows the user to enter in the number Veterans and Non-Veterans employees who are in the Craft Workers job category | Y | Number | 8 | Column number 43 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Craft Workers employee |
| DE-C4212-44 | Total Number of Veterans and Non-Veterans employees who are Operatives | Allows the user to enter in the number of Veterans and Non-Veterans employees who are in the Operatives job category | Y | Number | 8 | Column number 44 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Operatives employees |
| DE-C4212-45 | Total Number of Veterans and Non-Veterans employees who are Laborers/ Helpers | Allows the user to enter in the number of Veterans and Non-Veterans employees who are in the Laborers / Helpers job category | Y | Number | 8 | Column number 45 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Laborers / Helpers employees |
| DE-C4212-46 | Total Number of Veterans and Non-Veterans employees who are Service Workers | Allows the user to enter in the total number of Veterans and Non-Veterans employees who are in the Service Workers job category | Y | Number | 8 | Column number 46 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Service Workers employees |
| DE-C4212-47 | Total Number of Veterans and Non-Veterans employees | Allows the user to enter in the total number of Veterans and Non-Veterans employees across all job categories | Y | Number | 8 | Column number 47 |
· Must be a whole positive number · The system shall confirm that the entered value is equal to the sum of all Total Veteran and Non-Veteran Employees entered into the following job categories: . Executive/ Senior Level Officials and Managers . First/Mid Level Officials and Managers . Professionals . Technicians . Sales Workers . Administrative Support Workers . Craft Workers . Operatives . Laborers/ Helpers . Service Workers |
| DE-C4212-48 | Number of protected Veterans new hires who are Executive/Senior Level Officials and Managers | Allows the user to enter in the number of protected Veterans new hires who are in the Executive/Senior Level Officials and Managers job category | Y | Number | 8 | Column number 48 | · Must be a whole positive number |
| DE-C4212-49 | Number of protected Veterans new hires who are First/Mid Level Officials and Managers | Allows the user to enter in the number of protected Veterans new hires who are in the First/Mid Level Officials and Managers job category | Y | Number | 8 | Column number 49 | · Must be a whole positive number |
| DE-C4212-50 | Number of protected Veterans new hires who are Professionals | Allows the user to enter in the number of protected Veterans new hires who are in the Professionals job category | Y | Number | 8 | Column number 50 | · Must be a whole positive number |
| DE-C4212-51 | Number of protected Veterans new hires who are Technicians | Allows the user to enter in the number of protected Veterans new hires who are in the Technicians job category | Y | Number | 8 | Column number 51 | · Must be a whole positive number |
| DE-C4212-52 | Number of protected Veterans new hires who are Sales Workers | Allows the user to enter in the number of protected Veterans new hires who are in the Sales Workers job category | Y | Number | 8 | Column number 52 | · Must be a whole positive number |
| DE-C4212-53 | Number of protected Veterans new hires who are Administrative Support Workers | Allows the user to enter in the number of protected Veterans new hires who are in the Administrative Support Workers job category | Y | Number | 8 | Column number 53 | · Must be a whole positive number |
| DE-C4212-54 | Number of protected Veterans new hires who are Craft Workers | Allows the user to enter in the number of protected Veterans new hires who are in the Craft Workers job category | Y | Number | 8 | Column number 54 | · Must be a whole positive number |
| DE-C4212-55 | Number of protected Veterans new hires who are Operatives | Allows the user to enter in the number of protected Veterans new hires who are in the Operatives job category | Y | Number | 8 | Column number 55 | · Must be a whole positive number |
| DE-C4212-56 | Number of protected Veterans new hires who are Laborers / Helpers | Allows the user to enter in the number of protected Veterans new hires who are in the Laborers / Helpers job category | Y | Number | 8 | Column number 56 | · Must be a whole positive number |
| DE-C4212-57 | Number of protected Veterans new hires who are Service Workers | Allows the user to enter in the number of protected Veterans new hires who are in the Service Workers job category | Y | Number | 8 | Column number 57 | · Must be a whole positive number |
| DE-C4212-58 | Total Number of protected Veterans new hires | Allows the user to indicate the total number of protected Veterans new hires across all job categories | Y | Number | 8 | · Column number 58 | · The system shall confirm that the entered value is equal to the sum of all Disabled Veteran New Hires entered into the following job categories: . Executive/Senior Level Officials and Managers . First/Mid Level Officials and Managers . Professionals . Technicians . Sales Workers . Administrative Support Workers . Craft Workers . Operatives . Laborers/ Helpers . Service Workers · Must be a whole positive number |
| DE-C4212-59 | Total Number of Veteran and Non-Veteran new hires who are Executive/Senior Level Officials and Managers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Executive/Senior Level Officials and Managers job category | Y | Number | 8 | Column number 59 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Executive/Senior Level Officials and Managers new hires |
| DE-C4212-60 | Total Number of Veteran and Non-Veteran new hires who are First/Mid Level Officials and Managers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the First/Mid Level Officials and Managers job category | Y | Number | 8 | Column number 60 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans First/Mid Level Officials and Managers new hires |
| DE-C4212-61 | Total Number of Veteran and Non-Veteran new hires who are Professionals | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Professionals job category | Y | Number | 8 | Column number 61 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Professionals new hires |
| DE-C4212-62 | Total Number of Veteran and Non-Veteran new hires who are Technicians | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Technicians job category | Y | Number | 8 | Column number 62 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Technicians new hires |
| DE-C4212-63 | Total Number of Veteran and Non-Veteran new hires who are Sales Workers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Sales Workers job category | Y | Number | 8 | Column number 63 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Sales Workers new hires |
| DE-C4212-64 | Total Number of Veteran and Non-Veteran new hires who are Administrative Support Workers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Administrative Support Workers job category | Y | Number | 8 | Column number 64 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Administrative Support Workers new hires |
| DE-C4212-65 | Total Number of Veteran and Non-Veteran new hires who are Craft Workers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Craft Workers job category | Y | Number | 8 | Column number 65 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Craft Workers new hires |
| DE-C4212-66 | Total Number of Veteran and Non-Veteran new hires who are Operatives | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Operatives job category | Y | Number | 8 | Column number 66 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Operatives new hires |
| DE-C4212-67 | Total Number of Veteran and Non-Veteran new hires who are Laborers / Helpers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Laborers / Helpers job category | Y | Number | 8 | Column number 67 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Laborers / Helpers new hires |
| DE-C4212-68 | Total Number of Veteran and Non-Veteran new hires who are Service Workers | Allows the user to enter in the total number of veteran and non-veteran new hires who are in the Service Workers job category | Y | Number | 8 | Column number 68 |
· Must be a whole positive number · Entered total value must be greater than or equal to the largest individual value entered for the following data element: . Protected Veterans Service Workers new hires |
| DE-C4212-69 | Total Number of Veterans and Non-Veteran new hires | Allows the user to enter in the total number of veteran and non-veteran new hires who across all job categories | Y | Number | 8 | Column number 69 |
· The system shall confirm that the entered value is equal to the sum of all Veteran and Non-Veteran New Hires entered into the following job categories: . Executive/Senior Level Officials and Managers . First/Mid Level Officials and Managers . Professionals . Technicians . Sales Workers . Administrative Support Workers . Craft Workers . Operatives . Laborers/ Helpers . Service Workers · Must be a whole positive number |
| DE-C4212-70 | Maximum Number | Allows the user to enter the maximum number of permanent employees who worked for the company during the period covered by this report | Y | Number | 8 | Column number 70 | · Must be a whole positive number . Must be equal to or greater than minimum number |
| DE-C4212-71 | Minimum Number | Allows the user to enter the minimum number of permanent employees who worked for the company during the period covered by this report | Y | Number | 8 | Column number 71 |
· Must be a whole positive number . Must be equal to or less than maximum number |