ACS and EEO Employment Tables

Hi Cliff--
This past spring, I worked on a similar thing. I summarized Census ACS PUMS data into an updated report of metro area civilian workforce composition, by race, gender, and disability -- each of those variabless crosstabulated with EEO-4 job families.

And then our HRIS colleagues are tabulating comparable stats for our own agency.

I built my own correspondence table of what detailed SOC occupations belong in what EEO-4 job families. I can share that crosswalk if helpful.

A tricky aspect of this, Cliff: I think EEO-4 categories may have changed a few years ago. Not sure when exactly. But, specifically, the 5th category (out of 8) may have changed. So if you're using someone else's inherited crosswalk, verify: what is the 5th category. In the current version of EEO-4, it should be "paraprofessionals."

Todd

It sounds like you ran into the same issue I am having. I would love to get access to a copy of your crosswalk. I do believe that the fifth category we have is Paraprofessionals, though I will confirm that, so it appears that your work would prove very helpful to us.

I'm curious where you were able to find the information that allowed you to construct the crosswalk. I did find a crosswalk here: www.eeoc.gov/.../00-09opmcode.cfm However, this crosswalk does not include paraprofessionals.

Cliff--
This is the issue that I characterized as tricky. EEO has multiple versions of job families. EEO-FedSec9 (which you pointed to) is different from EE0-4. And I have seen multiple versions of EEO-4 over the past decade!

So when our agency receives notice from the feds that new reporting is needed, I always look at the notice to verify the eight categories being asked for.

If anyone has an authoritative source for a SOC to EEO-4 crosswalk, let us know!

In the meantime, I relied on general descriptions of each of the eight categories to come up with a crosswalk. The crosswalk I authored is here: sdcclearinghouse.files.wordpress.com/.../eeojobcategories-sas.docx

cheers,
Todd Graham

Todd

I have done some more investigation and see why you call the question of job classifications tricky. There are a number of systems out there and you have to be careful to find the right one for the right task for the vintage of your data set.

Lacking SAS or a similar tool, I plan to run a query on the IPUMS USA website using the 2012-16 ACS data set to collect data for analysis.

IPUMS USA includes (at least) two relevant variables - OCC2010. and OCC.

- OCC2010 appears to use a hybrid system than offers more long term consistency.

- OCC uses "2013 ACS/PRCS OCCSOC" codes - usa.ipums.org/.../acs_occtooccsoc10.shtml

I plan to use the OCC variable to gather data into a table. IPUMS makes a crosswalk available to convert the data into OCCSOC categories - linked from the top of the page here usa.ipums.org/.../acs_occtooccsoc10.shtml The crosswalk covers several different OCCSOC classification schemes. (For unknown reasons, data in unavailable in OCCSOC form from IPUMS USA despite indications to the contrary in the IPUMS data dictionary.)

My question for you is do you know which OCCSOC classification you used when creating the crosswalk between occupation codes and the SOC classification?

Thanks!

Todd

I have done some more investigation and see why you call the question of job classifications tricky. There are a number of systems out there and you have to be careful to find the right one for the right task for the vintage of your data set.

Lacking SAS or a similar tool, I plan to run a query on the IPUMS USA website using the 2012-16 ACS data set to collect data for analysis.

IPUMS USA includes (at least) two relevant variables - OCC2010. and OCC.

- OCC2010 appears to use a hybrid system than offers more long term consistency.

- OCC uses "2013 ACS/PRCS OCCSOC" codes - usa.ipums.org/.../acs_occtooccsoc10.shtml

I plan to use the OCC variable to gather data into a table. IPUMS makes a crosswalk available to convert the data into OCCSOC categories - linked from the top of the page here usa.ipums.org/.../acs_occtooccsoc10.shtml The crosswalk covers several different OCCSOC classification schemes. (For unknown reasons, data in unavailable in OCCSOC form from IPUMS USA despite indications to the contrary in the IPUMS data dictionary.)

My question for you is do you know which OCCSOC classification you used when creating the crosswalk between occupation codes and the SOC classification?

Thanks!