Albert Affirmative Action Plans

Your partner for Affirmative Action Plans, Government Audits & Compliance Reviews, US Census,
AAP Training, EEO-1 & VETS-4212 Reports, Disabilities & Veterans regulations.

AAP Census Data

Current Affirmative Action Plan Census Data
Background to the Availability Analysis
Census Codes
Census Reports
Census Territories
Census Data
Additional Resources

Current Affirmative Action Plan Census Data

Current Minority and Female census data from the US Census Bureau’s American Community Survey EEO Tabulation 2014-2018 for Affirmative Action Plans was released in the spring of 2021.

Background to the Availability Analysis

In the AAP, job titles are assigned to Job Groups. For each Job Group, the percentage of Minorities and Females is calculated on the first day of the Affirmative Action plan year. These percentages are compared to the "Availability" of Minorities and Females in the area in which you recruit to determine if you need to set goals.

The Availability Analysis is an estimate of the percentage of Minorities and Females that you would expect to find through good faith efforts to fill openings. Most employers use Census Reports from the US Census Bureau to begin the Availability Analysis.

Census Codes

The Census Bureau has assigned all jobs in the United States to one of 235 census titles for data collected from 2014-2018. Employers match their jobs to these census titles, and analyze the percentage of Minorities and Females for each census title. The Census Bureau assigns a unique code to each census title. The Census Bureau includes two additional titles: All 235 Occupations (totaled up) and the Long-term Unemployed.

Census Reports

Table Set 1 and Table Set 2 report by the 235 census titles, plus the total workforce and the long-term unemployed. If you can’t find the area you’re looking for in Table Set 1, look at Table Set 2, and vice versa. Some smaller counties and some metropolitan areas that include a small county may not be available. Reports that end in R are Residence reports (where people live). Reports that end in W are Worksite reports (where people work).

Use Table Set 3 if you want the 14 Occupational Group roll-ups created by the Census and not individual job titles. Use Table Set 4 if you want 9 EEO-1 category roll-ups and not individual job titles. Using Table Set 3 or 4 doesn't give you the opportunity to choose the jobs that pertain to you.

Census Territories

The Census Bureau publishes separate reports for territories such as large cities/towns (called “places”), counties, metropolitan areas, states, and the entire United States. Depending on how recruiting is done, for each Job Group in the Affirmative Action Plan, an employer may use one or more census titles and more than one territory to estimate the Availability of Minorities and Females.

Census Data

Here's an example of actual current census data for the job title "Human Resources Managers" for several census territories:

Census Data is available on-line directly from the US Census Bureau and from private vendors. You will have to do some analysis on your own if you access the data yourself. You would have to find the Minority and Female percentages for the titles that you want for each census territory used, like a county, metropolitan area, or state. Once you find the title, you have to locate the race/ethnicity data in a different row and column than the female data. You have to use some math to figure out the minority percentage, which must be inferred from the table.

If more than one census title is used in a job group, you must assign weights to each job title and multiply those weights times the census data, add them up, and divide by the total number of weights before using it. Albert Affirmative Action Plans automatically finds the correct Minority and Female percentages for each job title, anywhere in the United States, and, using your HR data on your own employees to assign weights, does all the number crunching.

Additional Resources

Please contact Mike Albert for pricing details or for help selecting census job titles and appropriate territories from the US Census for locations in Massachusetts, New Hampshire, Rhode Island, or anywhere in the United States. If you want to find the data yourself, you still might consider obtaining a more user-friendly version from Mike rather than using the free online version. Mike has downloaded the published census territories and has converted the data into 235 rows, one for each census title, with the minority and female percent on each row, so it’s easy to find on a basic spreadsheet.

You can find the data yourself by leaving this site. Go to: https://www.census.gov/acs/www/data/eeo-data/eeo-tables-2018/index.php