ACS and EEO Employment Tables

I have been asked to help update our city's EEO report.  EEO requirements require that we report out data using the EEO-4 job categories found in section 3 of this web page. This job classification system does not match the one that is used in the current ACS, a more detailed version of which can be found in table S2401.  There is also a simplified 6 category system used in many other occupation related ACS tables.  I also looked into the 2010 EEO ACS file, which has not been updated as far as I can tell.  The EEO file includes tables using a job category classification that is similar to the EEO-4 system, but does not one-to-one.

Has anyone come across a similar data challenge? Were you able to find data that can be compared to EEO-4 or did you not do so?  It is unclear to me if that step is a necessary one, since I am unfamiliar with the overall EEO process.

Parents
  • I'm passing along a message from Ana Montalvo, Census Bureau's Industry and Occupation Statistics Branch

    We are aware that the 5th category does not match. The respective federal agency who requested the table is aware of this issue, and hopefully plans to update it for the next Tab which is planned to be released 2021.

     

    The topic page for the EEO Tab-

    https://www.census.gov/topics/employment/equal-employment-opportunity-tabulation.html

     

    FAQ's-

    https://www.census.gov/topics/employment/equal-employment-opportunity-tabulation/about/faq.html

     

    FAQ's specific to EEO-4-

     

    43. Who should I contact regarding questions from employers required to complete an EEO-1, EEO-3, EEO-4 and EEO-5 form?

    EOC has a FAQ on completing the EEO-1 Form.

    Employer surveys:
    EEO-1, EEO-3, EEO-4 and EEO-5 1-866-286-6440
    202-663-7185 (FAX)
    e1.techassistance@eeoc.gov

    EEO process for Federal employees and agencies: 202-663-4599
    ofo.eeoc@eeoc.gov

    State and Local Government Tables, as defined by the respective agency that requires these data-

    https://factfinder.census.gov/bkmk/table/1.0/en/EEO/10_5YR/EEOALL6W

     

    FAQ 52 has the response to this specific question-

     

    52. In preparing a workforce chart for the EEOP Utilization Report, how does a recipient that is a state or local government agency decide which of the eight major job categories used in the EEO Tabulation 2006-2010 (5-year ACS data) is the appropriate classification for a particular job title?

    In preparing a workforce chart for an EEOP Utilization Report, a recipient may need to reclassify some jobs in its workforce to correspond with the revised job categories used in the EEO Tabulation 2006-2010 (5-year ACS data). For example, to reclassify jobs that were previously classified as Para-Professional, a category that no longer exists, or to reclassify jobs previously designated as simply Protective Services (instead of the new categories of Protective Services Sworn and Protective Services Non-Sworn), one should use the job classifications listed on the U.S. Census Bureau's web site. To access the information from the website, locate the third line from the top of the page, click on the underlined words "State and Local Occupation Groups." The link will lead to the file Occupational Crosswalk to State and Local Government Job Categories. Scrolling downward, find particular job titles listed in the Category Title column, and on the same line for each job title, in the far right column, there is a number that corresponds to one of the eight job categories in the EEO Tabulation 2006-2010 (5-year ACS data) (i.e., one (1) for Officials and Managers, two (2) for Professionals, three (3) for Technicians, four (4) for Protective Services: Sworn, five (5) for Protective Services: Non-sworn, six (6) for Administrative Support, seven (7) for Skilled Craft, and eight (8) for Service Maintenance).

    The crosswalk of occupations and its definitions are located below.

    Learn about subjects covered by the data and which data tool to use. Find out about handbooks, data users groups, and related topics.

    For more questions, contact the Office of Justice Programs at the Department of Justice-

    Office of Justice Programs
    Department of Justice
    810 Seventh Street NW
    Washington, DC 20531
    Phone: 202-514-2000

    This is the crosswalk between Census occupations-SOC codes-State and Local Job Categories-

    https://www.census.gov/topics/employment/equal-employment-opportunity-tabulation/guidance.html

    Tab- OccReCodesAggregatedOccs

    The DU can contact this person (not sure the person is still there, but that is the office to contact)-

    42. Who should I contact regarding questions from state and local governments or organizations required to complete an EEOP?

    Joseph Swiderski
    US Department of Justice
    Office of Justice Programs
    Office of Civil Rights
    202-514-8615

Reply
  • I'm passing along a message from Ana Montalvo, Census Bureau's Industry and Occupation Statistics Branch

    We are aware that the 5th category does not match. The respective federal agency who requested the table is aware of this issue, and hopefully plans to update it for the next Tab which is planned to be released 2021.

     

    The topic page for the EEO Tab-

    https://www.census.gov/topics/employment/equal-employment-opportunity-tabulation.html

     

    FAQ's-

    https://www.census.gov/topics/employment/equal-employment-opportunity-tabulation/about/faq.html

     

    FAQ's specific to EEO-4-

     

    43. Who should I contact regarding questions from employers required to complete an EEO-1, EEO-3, EEO-4 and EEO-5 form?

    EOC has a FAQ on completing the EEO-1 Form.

    Employer surveys:
    EEO-1, EEO-3, EEO-4 and EEO-5 1-866-286-6440
    202-663-7185 (FAX)
    e1.techassistance@eeoc.gov

    EEO process for Federal employees and agencies: 202-663-4599
    ofo.eeoc@eeoc.gov

    State and Local Government Tables, as defined by the respective agency that requires these data-

    https://factfinder.census.gov/bkmk/table/1.0/en/EEO/10_5YR/EEOALL6W

     

    FAQ 52 has the response to this specific question-

     

    52. In preparing a workforce chart for the EEOP Utilization Report, how does a recipient that is a state or local government agency decide which of the eight major job categories used in the EEO Tabulation 2006-2010 (5-year ACS data) is the appropriate classification for a particular job title?

    In preparing a workforce chart for an EEOP Utilization Report, a recipient may need to reclassify some jobs in its workforce to correspond with the revised job categories used in the EEO Tabulation 2006-2010 (5-year ACS data). For example, to reclassify jobs that were previously classified as Para-Professional, a category that no longer exists, or to reclassify jobs previously designated as simply Protective Services (instead of the new categories of Protective Services Sworn and Protective Services Non-Sworn), one should use the job classifications listed on the U.S. Census Bureau's web site. To access the information from the website, locate the third line from the top of the page, click on the underlined words "State and Local Occupation Groups." The link will lead to the file Occupational Crosswalk to State and Local Government Job Categories. Scrolling downward, find particular job titles listed in the Category Title column, and on the same line for each job title, in the far right column, there is a number that corresponds to one of the eight job categories in the EEO Tabulation 2006-2010 (5-year ACS data) (i.e., one (1) for Officials and Managers, two (2) for Professionals, three (3) for Technicians, four (4) for Protective Services: Sworn, five (5) for Protective Services: Non-sworn, six (6) for Administrative Support, seven (7) for Skilled Craft, and eight (8) for Service Maintenance).

    The crosswalk of occupations and its definitions are located below.

    Learn about subjects covered by the data and which data tool to use. Find out about handbooks, data users groups, and related topics.

    For more questions, contact the Office of Justice Programs at the Department of Justice-

    Office of Justice Programs
    Department of Justice
    810 Seventh Street NW
    Washington, DC 20531
    Phone: 202-514-2000

    This is the crosswalk between Census occupations-SOC codes-State and Local Job Categories-

    https://www.census.gov/topics/employment/equal-employment-opportunity-tabulation/guidance.html

    Tab- OccReCodesAggregatedOccs

    The DU can contact this person (not sure the person is still there, but that is the office to contact)-

    42. Who should I contact regarding questions from state and local governments or organizations required to complete an EEOP?

    Joseph Swiderski
    US Department of Justice
    Office of Justice Programs
    Office of Civil Rights
    202-514-8615

Children
  • Thanks for adding information to the thread. It looks like a fundamental question here is which version of the EEO-4 classification state and local governments need to use for current reporting.
  • Cliff--
    For a municipal government, what federal agency asks for your EEO report? Is it EEOC itself? Or another agency?

    The agency where I work reports as a federally-supported transit agency. In the instructions we have from US DOT/FTA the 5th category is "paraprofessionals."

    --Todd Graham
  • Todd

    The person who can answer that question is out of town until late next week, so I will have to wait until then to find out. We have been using a EEO-4 classification with the paraprofessional category, so there could be a federal requirement or it could be the state mirroring the federal requirement.

    Were you able to determine which OCCSOC classification you used when creating the crosswalk between occupation codes and the SOC classification? I this may relate to what version of the ACS you used for your source data.

    Cliff