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


2010 Census Data

Background to the Availability Analysis
Census Codes
Census Reports
Census Territories
Census Data
Additional Resources


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 Data 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 487 census titles. 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.


Census Reports

There are 113 EEO reports to select from.


Table Set 1 and Table Set 2 report by the 487 census titles, including the total workforce. Use Table Set 1 for metropolitan or micropolitan areas as well as places (cities/towns with a population over 50,000). Use Table Set 2 for Counties or large places (cities/towns with a population over 100,000). Use either Table Set for entire states or the entire United States. 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 Occupational Group roll-ups and not individual job titles or Table Set 4 if you want 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.


There are 14 Table Sets in all. Some of the Table Sets allow you to choose everyone in the database or just citizens or non-citizens, federal and state government workers, reports by earnings, education, and industry.


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, an employer may combine job titles and use more than one territory to estimate the Availability of Minorities and Females for each Job Group in the Affirmative Action Plan.


2010 Census Data is available for any county with a population in excess of 50,000, every state, the entire United States, and urban areas. The Census Bureau reports AAP data for two types of urban areas. “Metropolitan Statistical Areas” (MSAs) are urbanized areas containing at least 50,000 people. “Micropolitan Statistical Areas” (µSAs) are urbanized areas of at least 10,000 people.


Most of the metropolitan and micropolitan areas contain only one single county. Since the data for that urban area is identical to the county data, it doesn't matter whether you use the urban area report or the county report.


Some of the metropolitan and micropolitan areas contain more than one county. You may decide that using the urban area saves time, rather than analyzing separate counties. But you lose the ability to set different value weights on each county if you use the urban area report.


Census Data

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


UL
UR

Affirmative Action Plans Census Data



Job Title:  Human Resources Managers


Location
Minorities Females

Boston Metropolitan Area 18.6% 60.1%






Massachusetts 16.4% 61.6%






New Hampshire 4.4% 55.8%






Rhode Island 11.0% 66.0%






United States 27.8% 59.4%


2010 Census data obtained from the EEO-ALL02R (Residence) Reports of the US Census Bureau's American FactFinder EEO Tabulation 2006-2010 (5-year ACS data) found at:
www.census.gov/people/eeotabulation/data/eeotables20062010.html


Census Data is available on-line directly from the US Census Bureau and from private vendors. You will have to do some analysis of 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. 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.


You can find the data yourself by leaving this site. Go to: www.census.gov/people/eeotabulation/data/eeotables20062010.html


You can find a complete list of urban areas by leaving this site. Go to: www.census.gov/population/metro/files/lists/2009/List1.txt