Tool Search: OH State Reporting
The Pre-ID Extract is used to identify students for testing purposes. This extract is populated with student demographic information that is sent to a testing company for the purpose of distributing tests amongst students. Any student with an enrollment record within the date range entered on the extract editor will report.

Report Logic
If the student has an active enrollment between the start and end date on the extract editor, a record reports.
Generating the Extract
- Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date.
- Select which calendar(s) to include within the extract.
- Select which Grades to include in the extract from the calendar(s) selected.
- Select the Format. For submission to the State, select the State Format (Fixed width). To reviewdata prior to submission, select any of the other available formats.
- Select an Ad hoc Filter, if applicable.
- Indicate if the extract should Include Protected Identity Info.
- Mark the Exclude Dropped Students checkbox if dropped students should not be included in the extract.
- Use the Generate Prior PreID Extract checkbox to create the prior PreID extract (PreID 2014 version).
- Marking Include All Enrolled Students ensures that a record for each student with an enrollment in the selected calendar(s) are included in the extract.
- Click the Generate Extract button. The extract will appear in a separate window in the designatedformat.
Extract Layout
If the Include Protected Identity Info checkbox is marked in the extract editor, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information.
Element Name | Business Rules | Data Source GUI Path |
---|---|---|
Statewide Student Identifier (SSID) | Report Student State ID. | Demographics > Student State ID |
Local District Student ID | Report Local Student Number. | Demographics > Local Student Number |
Student Last Name |
| Demographics > Last Name |
Student First Name |
| Demographics > First Name |
Student Middle Name |
| Demographics > Middle Name |
Date of Birth | Report Birth Date. Format: YYYY-MM-DD | Demographics > Birth Date |
Gender | If Include Protected Identity Info = selected, report Legal Gender. If NULL, report Gender. F = female, M = male | Demographics > Gender |
Enrolled Grade | Report Grade. If Grade = KG, report 22. (State Grade Level Code) | Enrollments > Grade |
Ethnicity | Reports the code below based on the student's Race/Ethnicity code indicated in (Census > People > Demographics > Race/Ethnicity > *Race Ethnicity). 0 = Multiracial | Demographics > Race/Ethnicity > *Race Ethnicity |
English Learner (EL) | If student has a Program Status = EL and Identified Date prior to the End Date of the extract editor, reports Y. If student has a Program Status = Exited EL with a Program Exit Date within the Date Range of the extract editor, reports Y. Else, reports N. | Program Participation > LEP > Program Status, Identified Date, Program Exit Date |
Student's Migrant Status | If Migrant = selected, reports Y.
| Enrollments > State Reporting > Migrant |
Gifted and Talented | Report blank. | |
504 | If Served by a 504 Plan = selected, reports Y.
| Enrollments > State Reporting > Served by a 504 Plan |
IEP | If pulling from third party SPED integration
If pulling from campus
| Special Ed Documents > IEP |
Primary Disability Category | If pulling from third party SPED integration
If pulling from campus
| Special Ed Documents > IEP > Enrollment Status |
Accommodations - ELA | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP> Statewide and District-wide Testing > Area: Reading, Area: Writing
Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Test Accommodations > ELA |
Accommodations - Mathematics | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and District-wide testing > Area: Math
Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Test Accommodations > Mathematics |
Accommodations - Science | If pulling from third party SPED Integration:
If pulling from Campus:
|
Special Ed Documents > IEP > Statewide and District-wide testing > Area: Science
Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Test Accommodations > Science |
Accommodations - Social Studies | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and District-wide testing > Area: Social Studies
Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Test Accommodations > Social Studies |
Attending District IRN |
Pad with left leading zero(s) if necessary. | School Information > School Detail > District IRN Override District Information > District Info > State District Number |
Attending District Name | Report Name. Pad with left leading blank space if necessary. | District Information > Name |
Attending School IRN |
| School Information > School Detail > School IRN Override School Information > State School Number |
Attending School Name | Report school Name. | School Information > Name |
Home District IRN | Report Legal District of Residence code. | Enrollments > State Reporting > Legal District of Residence |
Home District Name | Report Legal District of Residence name. | Enrollments > State Reporting > Legal District of Residence |
Home School IRN | Report Home School IRN. | Enrollments > State Reporting > Home School IRN |
Home School Name | Report Home School Name. If NULL, report blank space. | Enrollments > State Reporting > Home School Name |
Test eligibility: AASCD | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Special Ed Documents > IEP > Statewide and Districtwide > Is the child participating in alternate assessment? |
OST and AASCD Test Mode: ELA | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Special Ed Documents > IEP > Statewide and Districtwide > Is the child participating in alternate assessment? Assessment > Test Setup > State Code, Subject Course > Test Mode |
OST and AASCD Test Mode: Mathematics | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Special Ed Documents > IEP > Statewide and Districtwide > Is the child participating in alternate assessment? Assessment > Test Setup > State Code, Subject Course > Test Mode |
OST and AASCD Test Mode: Science | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Special Ed Documents > IEP > Statewide and Districtwide > Is the child participating in alternate assessment? Assessment > Test Setup > State Code, Subject Course > Test Mode |
AASCD Test Mode: Social Studies | If pulling from third party SPED Integration:
If pulling from Campus:
| Special Ed Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Special Ed Documents > IEP > Statewide and Districtwide > Is the child participating in alternate assessment? Assessment > Test Setup > State Code, Subject Course > Test Mode |
Accelerated ELA Grade | If Test eligibility: AASCD = Y, report blank. Report ELA Grade 3-8. If NULL, report blank. | Enrollments > State Reporting |
Accelerated Mathematics Grade | If Test eligibility: AASCD = Y, report blank. Report Mathematics Grade 3-8. If NULL, report blank. | Enrollments > State Reporting |
Accelerated Science Grade | If Test eligibility: AASCD = Y, report blank. Report Science Grade 5 or 8. If NULL, report blank. | Enrollments > State Reporting |
Test eligibility and mode: HS ELA 2 | 1. If Test eligibility: AASCD = Y, report N. 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = ELA2, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: Algebra 1 | 1. If Test eligibility: AASCD = Y, report N. 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = ALG1, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: Geometry | 1. If Test eligibility: AASCD = Y, report N. 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = GEOM, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: Integrated Mathematics 1 | 1. If Test eligibility: AASCD = Y, report N. 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = MTH1, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: Integrated Mathematics 2 | 1. If Test eligibility: AASCD = Y, report N. 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = MTH2, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: Biology | 1. If Test eligibility: AASCD = Y, report N 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = BIOL, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: American Government | 1. If Test eligibility: AASCD = Y, report N. 2. If student scheduled in a course with an attached assessment with State Code = GE and Subject = GOVM, report course Test Mode. If course Test Mode = NULL, report O. 3. Else report N | Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: American History |
| Assessment > Test Setup > State Code, Subject Course > Test Mode |
Test eligibility & mode: OELPA/OELPS |
| Program Participation > LEP > Program Status, Identified Date, Program Exit Date Program Participation > LEP > LEP Accommodations > Test Format, Alternate OELPS |
Test Eligibility: Alternate OELPA | Reports "Y" When:
Otherwise, reports "N" | Program Participation > English Learners (EL) > EL Accommodations System Admin > Program Admin > English Learners (EL) > EL Setup > Code |