Harris School Solutions iPass Resource Center
Search:     Advanced search

EEO Survey No Sort Count Query (2 of 2)

Article ID: 1130
Last updated: 28 Nov, 2018
Views: 0

This is one of two queries that iPass Support has created to help extract data from iPass for reporting staff data in the EEO-5 Survey.

This query is designed to help users filter an Excel format report to find the staff count for the EEO-5 Survey categories.

When Executing the query the user should leave all default selections and simply click Submit to run it.

The resulting report will indicate Start Date (New?), Full Time Yes/No (based on check box selection on the iStaff Profile screen, not FTE total), Gender, Race/Ethnicity, and Job Type. 

This particular query lists staff members multiple times if they are identified as Hisplanic, have two or more Races selected, and/or have mutliple Active Careers. 

NOTE: We recommend you first run the EEO Survey Query to identify staff with multiple records to determine how they should be reported. Users can then modify the EEO Survey No Sort Count Excel report to flag New staff, Hispanic staff, and Non-Hispanic staff with Two or More Races. Then users can use the Excel Filter feature to find the staff count in each of the report categories.

Example report (Excel format):

School!Code EMP ID State ID Start Date End Date Full!Time FTE Is main Job Gender Race Code Race State Code Race Description School Name Job Type Description Job Type StateCode
0310 50112 (MEPID 1) 08/29/16 ? yes 1 yes F 01 01 White iPass Middle School Paraprofessional Educators 4100
0310 70573 (MEPID 2) 08/28/17 ? no .5 yes F 01 01 White iPass Middle School Paraprofessional 4100
0310 50034 (MEPID 3) 03/20/18 ? yes 1 yes F 99 99 Hispanic or Latino iPass Middle School Teacher-support instruction 2310
0310 50034 (MEPID 3) 03/20/18 ? yes 1 yes F 01 01 White iPass Middle School Teacher-support instruction 2310
0010 70689 (MEPID 4) 08/27/18 ? yes .1 yes M 01 01 White iPass RED Elementary School Teacher - Elem. 2305
0005 70689 (MEPID 4) 08/27/18 ? yes .5 yes M 01 01 White iPass BLUE Elementary School Teacher - Elem. 2305
0505 42770 (MEPID 5) 08/28/17 ? yes 1 yes M 03 03 Asian iPass High School Teacher - HS 2305
0505 42770 (MEPID 5) 08/28/17 ? yes 1 yes M 03 02 Black iPass High School Teacher - HS 2305


EEO-5 Survey (Elementary-Secondary Staff Information Report)


As part of its mandate under Title VII of the Civil Rights Act of 1964, the Equal Employment Opportunity Commission requires periodic reports from all public elementary and secondary school districts which indicate the composition for their work forces by sex and by race/ethnic category.

EEOC collects labor force data from public elementary and secondary school districts with 100 or more employees within 50 U.S. states and District of Columbia. The reporting  provide information on their employment totals, employees' job category and sex and race/ethnic groups as of October 1 of the survey year. The EEO5 survey is conducted biennially in every even-numbered year.

Link: https://www.eeoc.gov/employers/eeo5survey/index.cfm

Attached files
file EEO_Survey_No_Sort_Count.d (3 kb)

Prev   Next
Earned Credits Query     EEO Survey Query (1 of 2)