[IPAC-List] MSA labor force percentages by race and gender and EEO-4 job categories

[Aamodt, Michael G]

Hi Kurt,

The attached might help (courtesy of our Census expert - Fred Satterwhite).  The crosswalk goes from occupational category to the 8 groups reported in the EEO Tabulation, but there is no explanation of how/why the EEO-4 categories transform into the EEO Tabulation categories.

Take care,

Mike

_________________________________________

Michael G. Aamodt, Ph.D. (Mike)
Professor Emeritus
Department of Psychology
Radford University
Radford, VA  24142-6946
(202) 280-2172
maamodt at radford.edu<mailto:maamodt at radford.edu>


________________________________
From: IPAC-List [ipac-list-bounces at ipacweb.org] on behalf of Wilkening, Kurt [WilkeningK at HillsboroughCounty.ORG]
Sent: Thursday, July 10, 2014 12:54 PM
To: IPAC-List at ipacweb.org
Subject: [IPAC-List] MSA labor force percentages by race and gender and EEO-4 job categories

If you’ve been involved in EEO-4 reporting and affirmative action planning in your organization, perhaps you can help me locate data I’ve been hunting for. If not, then you may not want to read any further.
Each of the 500+ job classifications we utilize in our county is associated with one of eight EEO-4 job categories. I’m in the process of putting together a snapshot that shows the makeup of the current county (as an organization) workforce by gender, race and EEO-4 category. Simple enough.
However, for comparison purposes, I also want to show the makeup of my metropolitan statistical area workforce by gender, race and EEO-4 category. Turns out . . . not so simple.   I’m looking on the US Census Bureau website for subject data set for my MSA, but the data set I end up with has two categories for Protective Service Worker (sworn and non-sworn) and no category at all for Para-Professional. There seems to be a gap between Census occupational groups and EEO-4 job categories.
So my question is, where do I find the latest workforce percentages by race, gender and actual EEO-4 job categories?  Or is there an elusive crosswalk file that I just haven’t discovered?
In any event, if you’ve cracked the code and want to share how you compiled this information ~ it would be appreciated.
Sincerely,

Kurt Wilkening
Talent Acquisition Division Chief
Hillsborough County Civil Service
p: 813-274-6764
e: wilkeningk at hillsboroughcounty.org
w: www.hccsb.org
=============================
Where People & Jobs Come Together!

Kurt Wilkening


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nine.pairlist.net/pipermail/ipac-list/attachments/20140710/0f6222f7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: AggregatedOccupationGroupDefinitions-02.05.13.pdf
Type: application/pdf
Size: 36730 bytes
Desc: AggregatedOccupationGroupDefinitions-02.05.13.pdf
URL: <http://nine.pairlist.net/pipermail/ipac-list/attachments/20140710/0f6222f7/attachment-0002.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: EEOTabulation-OccupationCodeCrosswalktoAggregatedOccupations-04.26.13.pdf
Type: application/pdf
Size: 273626 bytes
Desc: EEOTabulation-OccupationCodeCrosswalktoAggregatedOccupations-04.26.13.pdf
URL: <http://nine.pairlist.net/pipermail/ipac-list/attachments/20140710/0f6222f7/attachment-0003.pdf>