Classic View: OH State Reporting > Pre-ID Extract (Current)
Search Terms: 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. | Census > People > Demographics > Student State ID |
Local District Student ID | Report Local Student Number. | Census > People > Demographics > Local Student Number |
Student Last Name |
| Census > People > Demographics > Last Name |
Student First Name |
| Census > People > Demographics > First Name |
Student Middle Name |
| Census > People > Demographics > Middle Name |
Date of Birth | Report Birth Date. Format: YYYY-MM-DD | Census > People > Demographics > Birth Date |
Gender | If Include Protected Identity Info = selected, report Legal Gender. If NULL, report Gender. F = female, M = male | Census > People > Demographics > Gender |
Enrolled Grade | Report Grade. If Grade = KG, report 22. (State Grade Level Code) | Student Information > General > 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 | Census > People > 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. | Student Information > Program Participation > LEP > Program Status, Identified Date, Program Exit Date |
Student's Migrant Status | If Migrant = selected, reports Y.
| Student Information > General > Enrollments > State Reporting > Migrant |
Gifted and Talented | Report blank. | |
504 | If Served by a 504 Plan = selected, reports Y.
| Student Information > General > Enrollments > State Reporting > Served by a 504 Plan |
IEP | If pulling from third party SPED integration
If pulling from campus
| Student Information > sped > docs > IEP |
Primary Disability Category | If pulling from third party SPED integration
If pulling from campus
| Student Information > sped > docs > IEP > Enrollment Status |
Accommodations - ELA | If pulling from third party SPED Integration:
If pulling from Campus:
| Student Information > SPED > Docs > IEP> Statewide and District-wide Testing > Area: Reading, Area: Writing
Student Information > Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Student Information > General > Test Accommodations > ELA |
Accommodations - Mathematics | If pulling from third party SPED Integration:
If pulling from Campus:
| Student Information > SPED > Docs > IEP > Statewide and District-wide testing > Area: Math
Student Information > Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Student Information > General > Test Accommodations > Mathematics |
Accommodations - Science | If pulling from third party SPED Integration:
If pulling from Campus:
|
Student Information > SPED > Docs > IEP > Statewide and District-wide testing > Area: Science
Student Information > Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Student Information > General > Test Accommodations > Science |
Accommodations - Social Studies | If pulling from third party SPED Integration:
If pulling from Campus:
| Student Information > SPED > Docs > IEP > Statewide and District-wide testing > Area: Social Studies
Student Information > Program Participation > LEP > LEP Accommodations Programs > LEP > LEP Setup > LEP Accommodations > Code, Type
Student Information > General > Test Accommodations > Social Studies |
Attending District IRN |
Pad with left leading zero(s) if necessary. | System Admin > Resources > School > School Detail > District IRN Override System Admin > Resources > District Information > District Info > State District Number |
Attending District Name | Report Name. Pad with left leading blank space if necessary. | System Admin > Resources > District Info > Name |
Attending School IRN |
| System Admin > Resources > School > School Detail > School IRN Override System Admin > Resources > School > State School Number |
Attending School Name | Report school Name. | System Admin > Resources > School > Name |
Home District IRN | Report Legal District of Residence code. | Student Information > General > Enrollments > State Reporting > Legal District of Residence |
Home District Name | Report Legal District of Residence name. | Student Information > General > Enrollments > State Reporting > Legal District of Residence |
Home School IRN | Report Home School IRN. | Student Information > General > Enrollments > State Reporting > Home School IRN |
Home School Name | Report Home School Name. If NULL, report blank space. | Student Information > General > Enrollments > State Reporting > Home School Name |
Test eligibility: AASCD | If pulling from third party SPED Integration:
If pulling from Campus:
| Student Information > Special Education > Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Student Information > Special Education > 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:
| Student Information > Special Education > Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Student Information > Special Education > 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:
| Student Information > Special Education > Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Student Information > Special Education > 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:
| Student Information > Special Education > Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Student Information > Special Education > 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:
| Student Information > Special Education > Documents > IEP > Statewide and Districtwide Testing > State Tests > Student has met AASCD Testing Participation Requirements Student Information > Special Education > 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. | Student Information > General > Enrollments > State Reporting |
Accelerated Mathematics Grade | If Test eligibility: AASCD = Y, report blank. Report Mathematics Grade 3-8. If NULL, report blank. | Student Information > General > Enrollments > State Reporting |
Accelerated Science Grade | If Test eligibility: AASCD = Y, report blank. Report Science Grade 5 or 8. If NULL, report blank. | Student Information > General > 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 |
| Student Information > Program Participation > LEP > Program Status, Identified Date, Program Exit Date Student Information > Program Participation > LEP > LEP Accommodations > Test Format, Alternate OELPS |
Test Eligibility: Alternate OELPA | Reports "Y" When:
Otherwise, reports "N" | Student Information > Program Participation > English Learners (EL) > EL Accommodations System Admin > Program Admin > English Learners (EL) > EL Setup > Code |