Pre-ID Ohio State Assessment Extract | PowerSchool SIS Compliance

Introduction

Use this option to generate the Ohio Statewide Assessments student pre-identification file for vendor submission. The extract supports OST, AASCD, OELPA/OELPS, and Alternate OELPA eligibility and test-mode reporting without changing the underlying PowerSchool source information

Selection Criteria

The report generates a comma-separated values (.csv) file for Alternate Assessments, Grades 3–8 assessments, High School End-of-Course assessments, and OELPA/OELPS. Districts may need to run the extract multiple times based on assessment participation. The selected schools and students are first limited by the report inputs, then filtered by the applicable enrollment, course, Pre-ID, Special Programs, assessment, and override rules below.

School Selection

Use the Schools for which to run? parameter to select the requested district or school scope and the student records that meet the extract criteria. Schools and students excluded from state reporting are omitted; district-level runs may use Select Multiple Schools or All Schools.

The school must be associated with a student included in the report.
The school in which the student is enrolled is not excluded from state reporting.

Student Selection

The report selects which student records to use based on the following criteria:

The student is not excluded from state reporting (State/Province - OH > Home Tab > State_ExcludeEnrollment)

Student inclusion depends on the assessment group selected and the report parameters. Students may be included through enrollment in a tested grade or course, an assessment indicator on the Student Pre-ID tab, an IEP Test Type containing ALT, or an applicable override. Students not enrolled in a tested course who elect to take or retake an assessment must have the applicable assessment area checked on the Student Pre-ID tab.

General: LEP, IEP, and 504 accommodation indicators on the Student Pre-ID tab identify subject-level IEP and/or LEP accommodations. Students in block-scheduled courses are included when Block Scheduling Override contains a date within the course start and end dates. If the report is run outside of the school year, enter a date within the school year so eligible block-scheduled students can be identified. When blank, only students in non-block-scheduled courses are included.
OELPA/OELPS: OELPA students identified as LEP (L, S, or Y) on the FD tab are included. Students taking Alternate OELPA must be identified through Test Eligibility: Alternate OELPA = Yes, or through the Student Pre-ID Tab option. ELPA21 Screener students are included when the corresponding ELPA21 Screener box is checked on the State/Province – OH Pre-ID tab.
Alternate Assessment: Students are identified when IEP Test Type on the Special Programs page contains ALT, or when the user hand-selects students and sets IEP Test Type Override to Yes. Alternate Assessment grade-level boxes are required only when students have not been pre-selected; do not select those boxes when using the override.
Grades 3–8: Students are included when enrolled in the selected grade. Accelerated students are included when the applicable ELA, Mathematics, or Science assessment is selected on the Pre-ID tab. Grade 8 Science may include non-accelerated students in grades 6 or 7 when Science Override identifies them as eligible for the Grade 8 Science test.
High School: Students are included when enrolled in an appropriate course with a matching assessment. For HS Science courses, Science Override may identify the required science assessment or identify students who are not required to take an HS science assessment.
Hand-selected and retake groups: For a hand-selected group of non-alternate-assessment students, Test Override must be set to Y and the applicable tests selected; no course or teacher data is included. For retake students not enrolled in a tested course, Re-Take Assessment Override uses only the selected assessment area on the Pre-ID tab.

Assessment Selection and Course Matching

Use the report’s test parameters to select Exclude, Online, or Paper for each applicable assessment. The available assessment groups are:

Grades 3–8: ELA/Literacy and Mathematics for Grades 3–8; Science for Grades 5 and 8, including applicable accelerated students.
High School: HS ELA II (050170); Algebra I (110065, 110301, 110480); Geometry (111200, 110490); Mathematics I (110065, 110480, 110010); Mathematics II (110020, 110490); American Government (150300, 150308, 159950); American History (150810, 152300); Biology (132230, 132330).

Override Options

Block Scheduling Override: Enter a date in MM/DD/YYYY format. If the report is run outside of the school year, the date must be within the school year. Use a date within the applicable block-scheduled course dates to include those students; when blank, only students in non-block-scheduled courses are included.
IEP Test Type Override: Set to Yes for selected Alternate Assessment students; no Alternate Assessment grade-level boxes should be selected.
Re-Take Assessment Override: Includes only the Pre-ID assessment area that matches a selected assessment.
Test Override: Required for hand-selected non-alternate students and selected tests.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

The report input is done in Data and Reporting > Reports > Compliance Reports > Pre-ID Ohio State Assessment Extract.

Report parameter	Exact screen options / values	Purpose and use
Schools for which to run?*	Select Multiple Schools; All Schools	Select the schools included in the run. Select Multiple Schools allows one or more schools; All Schools runs for the district. The selected schools must meet the report's student-selection criteria.
Students*	The Selected Students Only; All Students	Run for the current student selection or for all students in the current school or district who meet the applicable criteria.
Block Scheduling Override	MM/DD/YYYY	Enter a date in MM/DD/YYYY format when needed to evaluate block-scheduled courses. If the report is run during the school year, the date must fall within the applicable block-scheduled course dates. If the report is run outside of the school year, enter a date within the school year so eligible students can be identified. When blank, only students enrolled in non-block-scheduled courses are included.
JVSD*	Yes; No	Select Yes when a JVSD is running the extract. Before running it, complete Home Building HS IRN on the student's State/Provincial – OH page, Pre-ID tab. The IRN is required by the vendor.
Use Legal Names Instead Of Demographics (Ohio reporting does not require legal names, consulting your legal counsel prior to selecting Yes is advised)*	Yes; No	Select whether the extract uses legal names instead of demographic names. Ohio reporting does not require legal names; consult legal counsel before selecting Yes.
IEP Test Type Override*	Yes; No	When students are hand-selected for Alternate Assessment, select Yes to include them. Do not select Alternate Assessment grade-level boxes when using this override.
Alternate Assessment (Grade Level)	3; 4; 5; 6; 7; 8; 9; 10; 11; 12	Select the applicable alternate-assessment grade level when students have not been pre-selected. The screen displays grade-level choices 3–12 and Yes/No options as shown.
Re-Take Assessment Override*	Yes; No	Use for students not enrolled in a tested course who elect to take or retake an assessment. The applicable assessment area must be checked on the Student Pre-ID tab.
Test Override*	Yes; No	For a hand-selected group of non-alternate-assessment students, select the override and the tests they will take.
OELPA Test*	Exclude; Online; Paper	Select the OELPA participation option. OELPA modes are reported as P=Paper, O=Online, or N=Not Eligible.
Test Eligibility: Alternate OELPA*	No; Student Pre-ID Tab; Yes	Select Yes for students eligible for Alternate OELPA, No when applicable, or Student Pre-ID Tab to use the student's indicator. When Yes, IEP must be Y and Primary Disability must be populated.
ELPA21 Screener*	Exclude; Online; Paper	Select the ELPA21 Screener option. Students with the corresponding ELPA21 Screener box checked on the State/Province – OH Pre-ID tab are included. OELPS is reported as P only when the paper accommodation applies.
Grades 3-8 Tests: 0 selected
Grade 3 ELA/Literacy*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 3 Mathematics*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 4 ELA/Literacy*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 4 Mathematics*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 5 ELA/Literacy*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 5 Mathematics*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 5 Science*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 6 ELA/Literacy*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 6 Mathematics*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 7 ELA/Literacy*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 7 Mathematics*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 8 ELA/Literacy*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 8 Mathematics*	Exclude; Online; Paper	Select the test mode or exclude the assessment.
Grade 8 Science*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Grade 8 Science may also include eligible students in grades 6 or 7 identified through Science Override.
High School Tests: 0 selected
HS ELA II*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course code: 050170.
Algebra I*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 110065, 110301, 110480.
Geometry*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 111200, 110490.
Mathematics I*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 110065, 110480, 110010.
Mathematics II*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 110020, 110490.
HS American Government*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 150300, 150308, 159950.
HS American History*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 150810, 152300.
HS Biology*	Exclude; Online; Paper	Select the test mode or exclude the assessment. Matching course codes: 132230, 132330.
Scheduling — Please select when to run
Run Now	Run Now	Run the report immediately.
Schedule	Schedule	Schedule the report for a later run according to the available scheduling options.

Report Output

The vendor-facing output is a comma-separated values (.csv) file containing the report fields in the required order. The PowerSchool source mappings documented in the table below remain unchanged; use the vendor field name, position, length, required/optional status, and accepted values from the current layout when validating the extract. The report output file is named Pre-ID_OSA_[Timestamp].

Before submitting the extract

Confirm that the file is a .csv (UTF-8) in the same format exported from PowerSchool.
Avoid editing, or resaving the file locally, as doing so may change its formatting and cause upload issues.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	SSID	The student ID number assigned by the State of Ohio to this student. This value is extracted from the FS screen, Start Page > Student Selection > State/Province - OH > (FS) Student Standing Record.	[Students]State_StudentNumber	Alpha-numeric	9
2	District Student ID	The student number as assigned by the district.	[Students]Student_Number	Alpha-numeric	9
3	Student Last Name	The student’s last name. When Use Legal Names Instead Of Demographics is set to Yes, this value is pulled from Start Page > Student Selection > State/Province - OH > SSID Screen using the legal last-name field; otherwise, it is pulled from the demographics screen: Start Page > Student Selection > State/Province - OH > (GI) Student Demographic Record.	[Students]Last_Name When legal names are selected: [STUDENTCOREFIELDS]PSCORE_LEGAL_LAST_NAME	Alpha-numeric	35
4	Student First Name	The student’s first name. When Use Legal Names Instead Of Demographics is set to Yes, this value is pulled from Start Page > Student Selection > State/Province - OH > SSID Screen using the legal first-name field; otherwise, it is pulled from the demographics screen: Start Page > Student Selection > State/Province - OH > (GI) Student Demographic Record.	[Students]First_Name When legal names are selected: [STUDENTCOREFIELDS]PSCORE_LEGAL_FIRST_NAME	Alpha-numeric	35
5	Student Middle Name	The student’s middle name. When Use Legal Names Instead Of Demographics is set to Yes, this value is pulled from Start Page > Student Selection > State/Province - OH > SSID Screen using the legal middle-name field; otherwise, it is pulled from the demographics screen: Start Page > Student Selection > State/Province - OH > (GI) Student Demographic Record.	[Students]Middle_Name When legal names are selected: [STUDENTCOREFIELDS]PSCORE_LEGAL_MIDDLE_NAME	Alpha-numeric	35
6	Date of Birth	Student date of birth in YYYY-MM-DD format.	[Students]DOB	Numeric	10
7	Gender	F=Female, M=Male, Blank=Missing/Unknown.	[Students]Gender	Alpha-numeric	1
8	Enrolled Grade	22=Kindergarten; 01–12=grades; 13=Adult High School; 14=Testing Only.	[Students]Grade_Level	Alpha-numeric	2
9	Ethnicity	0=Two or more races; 1=American Indian or Alaska Native; 2=Native Hawaiian or Other Pacific Islander; 3=Asian; 4=Hispanic or Latino; 5=Black or African American; 6=White; 7=Other or Unknown.	[StudentRace]RaceCd [Students]FedEthnicity	Alpha-numeric	1
10	EL	English Learner indicator: Y=Yes, N=No.	[S_OH_STU_FD_X]Limited_English_Proficiency	Alpha-numeric	1
11	Student's Migrant Status	Y=Migrant Student; N=Not Applicable.	[S_OH_STU_FD_X]Migrant_Status	Alpha-numeric	1
12	Gifted/Talented	Indicator that the student is identified as Gifted. If a student is marked as gifted in any area (Start Page > Student Selection > State/Province - OH > (GG) Student Gifted Education Record, the extract will pull a Y.	[S_OH_STU_GIFTED_C]Type [S_OH_STU_GIFTED_C]Identification	Alpha-numeric	1
13	504	504 Plan Indicator: Y=Yes, N=No.	[S_OH_STU_FD_X]Section_504	Alpha-numeric	1
14	IEP	IEP Indicator: Y=Yes, N=No.	[S_OH_STU_FD_X]Disability	Alpha-numeric	1
15	Primary Disability	Primary disability category: AUT, DB, DD, EMN, HI, ID, MD, OI, OHI, SLD, SLI, TBI, VI, or Blank=Retain Existing Value.	[S_OH_STU_FD_X]Disability	Alpha-numeric	3
16	Accommodations: ELA	ELA accommodation eligibility from the Student Pre-ID tab: Y=Yes, N=No. Mark Y when the student is eligible and also mark the applicable IEP, 504, or EL indicator. This field does not set test settings or tools.	N/A	Alpha-numeric	1
17	Accommodations: Mathematics	Mathematics accommodation eligibility: Y=Yes, N=No, Blank=Retain Existing Value. Mark Y when the student is eligible for a Mathematics accommodation and also mark the applicable IEP, 504, or EL indicator. This field does not set test settings or tools.	N/A	Alpha-numeric	1
18	Accommodations: Science	Science accommodation eligibility from the Student Pre-ID tab: Y=Yes, N=No, Blank=Retain Existing Value. Mark Y when the student is eligible and also mark the applicable IEP, 504, or EL indicator. This field does not set test settings or tools.	N/A	Alpha-numeric	1
19	Accommodations: Social Studies	Social Studies accommodation eligibility from the Student Pre-ID tab: Y=Yes, N=No, Blank=Retain Existing Value. Mark Y when the student is eligible and also mark the applicable IEP, 504, or EL indicator. This field does not set test settings or tools.	N/A	Alpha-numeric	1
20	Attending District IRN	Numeric IRN for the district administering tests to the student.	[Prefs]DistrictNumber CST_SUBDISTRICTS.Subdistrict_number	Numeric	6
21	Attending District Name	Name of the district administering tests to the student.	[Prefs]DistrictName	Alpha-numeric	30
22	Attending School IRN	IRN for the school administering tests to the student; must be associated with the district IRN.	[S_OH_STU_FS_X]Attending_Building_IRN or [S_OH_STU_COMMON_X]Building_IRN or District default – School Number or Alt School Number	Numeric	6
23	Attending School Name	Name of the school administering tests to the student.	[Schools]Name	Alpha-numeric	30
24	Home District IRN	District that also receives access to the student's results; must differ from the Attending District IRN.	[S_OH_STU_FS_X]How_Received_IRN or [Students]districtofresidence	Numeric	6
25	Home District Name	Name corresponding to the Home District IRN.	N/A	Alpha-numeric	30
26	Home School IRN	School that also receives access to the student's results; must be associated with the Home District IRN.	[S_OH_STU_PREID_X]Home_Building_IRN	Numeric	6
27	Home School Name	Name corresponding to the Home School IRN.	Code Set Home Building IRN	Alpha-numeric	30
28	AASCD	Test eligibility for AASCD: Y=Eligible, N=Not Eligible, Blank=Retain Existing Value. Students are identified through IEP Test Type containing ALT or through the IEP Test Type Override parameter. When Y, applicable AASCD test modes and Primary Disability must be populated.	[S_OH_SPENROLLMENTS_X]SpecialEd_Date_Type [S_OH_SPENROLLMENTS_X]Test_Type (ALT identifies alternate assessment) IEP Test Type Override parameter may include selected students [S_OH_SPENROLLMENTS_X]Test_Type	Alpha-numeric	1
29	OST and AASCD Test Mode: ELA	OST Grades 3–8 ELA/Literacy or AASCD ELA mode. OST: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. AASCD also permits S=Supplemental. Grade 3–8 students are selected by enrolled or accelerated grade, Pre-ID selection, retake override, or test override.	Grades 3–8 ELA/Literacy test parameter AASCD ELA test parameter Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
30	OST and AASCD Test Mode: Math	OST Grades 3–8 Mathematics or AASCD Mathematics mode. OST: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. AASCD also permits S=Supplemental. Grade 3–8 students are selected by enrolled or accelerated grade, Pre-ID selection, retake override, or test override.	Grades 3–8 Mathematics test parameter AASCD Mathematics test parameter Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
31	OST and AASCD Test Mode: Science	OST Grade 5 or Grade 8 Science, or AASCD Science mode. OST: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. AASCD also permits S=Supplemental. Grade 8 Science eligibility may include the Science Override for students in grades 6 or 7.	Grades 5 or 8 Science test parameter AASCD Science test parameter Science Override, Test Override, or Re-Take Assessment Override when applicable	Alpha-numeric	1
32	AASCD Test Mode: Social Studies	AASCD Social Studies mode: P=Paper, O=Online, S=Supplemental, N=Not Eligible, Blank=Retain Existing Value. The assessment is included through alternate-assessment selection or the IEP Test Type Override.	AASCD Social Studies test parameter IEP Test Type Override when applicable	Alpha-numeric	1
33	Accelerated ELA	Accelerated OST ELA grade: 3, 4, 5, 6, 7, 8, or Blank=N/A. Students accelerated into the tested grade are included when the applicable Pre-ID selection is present.	[S_OH_STU_PREID_X]AT_Reading	Numeric	1
34	Accelerated Math	Accelerated OST Mathematics grade: 3, 4, 5, 6, 7, 8, or Blank=N/A. Students accelerated into the tested grade are included when the applicable Pre-ID selection is present.	[S_OH_STU_PREID_X]AT_Math	Numeric	1
35	Accelerated Sci	Accelerated OST Science grade: 5, 8, or Blank=N/A. Students accelerated into the tested grade are included when the applicable Pre-ID selection is present.	[S_OH_STU_PREID_X]AT_Science	Numeric	1
36	Test Mode: HS ELA II	OST HS ELA II eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Students are selected through matching course code 050170 or applicable Test Override, Pre-ID, or retake settings.	HS ELA II test parameter; course code 050170 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
37	Test Mode: Algebra I	OST Algebra I eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 110065, 110301, and 110480; applicable overrides may also select students.	Algebra I test parameter; course codes 110065, 110301, 110480 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
38	Test Mode: Geometry	OST Geometry eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 111200 and 110490; applicable overrides may also select students.	Geometry test parameter; course codes 111200, 110490 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
39	Test Mode: Integrated Math I	OST Integrated Mathematics I eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 110065, 110480, and 110010; applicable overrides may also select students.	Mathematics I test parameter; course codes 110065, 110480, 110010 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
40	Test Mode: Integrated Math II	OST Integrated Mathematics II eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 110020 and 110490; applicable overrides may also select students.	Mathematics II test parameter; course codes 110020, 110490 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
41	Test Mode: Biology	OST Biology eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 132230 and 132330; applicable overrides may also select students.	Biology test parameter; course codes 132230, 132330 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
42	Test Mode: AmGovt	OST American Government eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 150300, 150308, and 159950; applicable overrides may also select students.	HS American Government test parameter; course codes 150300, 150308, 159950 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
43	Test Mode: AmHist	OST American History eligibility and mode: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. Matching course codes are 150810 and 152300; applicable overrides may also select students.	HS American History test parameter; course codes 150810, 152300 Test Override / Re-Take Assessment Override when applicable	Alpha-numeric	1
44	OELPS/OELPA Mode	OELPA: P=Paper, O=Online, N=Not Eligible, Blank=Retain Existing Value. OELPS: P only when the paper accommodation applies; otherwise Blank=Retain Existing Value.	OELPA Test parameter: Exclude, Online, or Paper ELPA21 Screener selection and paper accommodation logic for OELPS [S_OH_STU_PREID_X]ELPAScreener	Alpha-numeric	1
45	Alternate OELPA	Alternate OELPA eligibility: Y=Eligible, N=Not Eligible, Blank=Retain Existing Value. When Y, IEP must be Y and Primary Disability must be populated.	Test Eligibility: Alternate OELPA parameter Student Pre-ID Tab Alternate OELPA indicator when applicable	Alpha-numeric	1