Tool Search: OH Extracts

The Student Assessment (FA) Extract combines the previous assessment extracts. It reports general assessment information based on the Test settings and the student's score record.

Ohio Student Assessment (FA) Extract Editor

Report Logic

Extracts report based on the selected Assessment Type. Students must be enrolled in a selected calendar for at least one day during the Date Range entered in the extract editor to report. If more than one enrollment is found, reports based on the most recent enrollment with a Service Type of P or N.

Assessment Type	Logic
Grades 3-8 Alternate Assessment (GA)	Reports a record if the student has a GA Test date within the Date Range entered with a Subject of M, R, W, S or C. All tests records found during the Date Range entered in the extract editor will report.
Ohio Graduation Test (GX)	Reports a record if the student has a GX Test date within the Date Range entered with a Subject of C, M, S, W or R and a Test Grade Level. Reports one record per student, per test, per subject. A student can have more than 5 records reported. Only students with a Diploma Date entered will report for the G reporting period.
Ohio English Language Proficiency Assessment (GF)	Reports a record if the student has a GF Test date within the Date Range entered with a Subject of Reading, Writing, Listening, or Speaking. All tests records found during the Date Range entered in the extract editor will report.
Preschool Childhood Outcome Summary (GM)	Reports two records if the student has a GM Test date within the Date Range entered with a Subject of E, K or T. The first record reports for Subject E, K or T and reports Score. The second record reports for Subject EPRG, KPRG or TPRG and reports Progress. Only students with an enrollment in a State Grade Level of PS will report. For the K reporting period, only assessment records up to December 1st of the current year will report. For the N reporting period, only assessments between December 2nd and May 15th will report.
Kindergarten Readiness Assessment (GO)	Reports a record if the student has a test record within the selected calendar with a State Code of GO and a Subject of OISR, SF, LL, M, S, C, or PD. Subjects S and C report two records based on Scale Score and Error Band. Subjects OISR, LL, M, PD, and SF report only Scale Score.
CTE Technical Assessment (GY)	Reports a record if the student has a test record within the selected calendar with a State Code of GY and a Code that is not null.
CTE Industry Assessment (GU)	Reports a record if the student has a test record within the selected calendar with a State Code of GU and a Code that is not null. All tests records found during the Date Range entered in the extract editor will report.
Industry Credential (GW)	Reports a record if the student has a test record within the selected calendar with a State Code of GW and a Code that is not null.
American College Testing (AC)	Reports a record if the student has a test record within the Date Range with a National Code of ACT and a Subject of M, R, W, S, or EL.
Scholastic Aptitude Test (SA)	Reports a record if the student has a test record within the Date Range with a National Code of SAT and a Subject of M or R.
Advanced Placement (AP)	Reports a record if the student has a test record within the selected calendar with a National Code of AP and a Code that is not null.
International Baccalaureate (IB)	Reports a record if the student has a test record within the selected calendar with a State Code of IB and a Code that is not null.
Reading Diagnostic (RD)	Reports a record if the student has a test record within the selected calendar with a State Code of RD and a Code that is not null.
Ohio's State Tests (GN)	Reports a record if the student has a test record within the selected calendar with a State Code of GN and a Subject of C, ELA, M, R, or S.
End of Course Tests (GE)	Reports a record if the student has a test record within the selected calendar with a State Code of GE and a Subject of BIOL, GOVM, HIST, PHYS, ELA1, ELA2, ALG1, GEOM, MTH1, or MTH2.
WorkKeys Assessment (WK)	Reports a record if the student has a test record within the selected calendar with a State Code of WK and a Subject of M, R, LCIF, AMTH, GLIT, or WDOC.
Measures of Academic Progress (DPR Growth Assessment by NWEA only) (GD)	Reports a record if the student has a test record within the selected calendar with a State Code of GD and a Subject of M or R.
Tier 1 Dyslexia Screener (DS)	Reports a record if the student has a test record within the selected calendar, a State Code of DS1, and a Code that is not null.

Extract Fields

Field	Description
Extract Type
Assessment Type	The assessment for which results are reported. Options are: GA: Grades 3-8 Alternate Assessment GX: Ohio Graduation Test GF: Ohio English Language Proficiency Assessment GM: Preschool Childhood Outcome Summary GS: Preschool ASQ/SE GB: Early Learning Preschool Assessment GO: Kindergarten Readiness Assessment GY: CTE Technical Assessment GU: CTE Industry Assessment GW: Industry Credential AC: American College Testing SA: Scholastic Aptitude Test AP: Advanced Placement IB: International Baccalaureate GN: Ohio's State Tests GE: End of Course Tests WK: WorkKeys Assessment GD: Measures of Academic Progress (DPR Growth Assessment by NWEA only)
Reporting Period	Indicates when the report is being submitted.
Date Range	The dates which determine which student assessment records will appear on the report.
Format	The format in which the report will generate. Options are State Format (Fixed width), HTML, CSV and XML. Use HTML, CSV or XML formats for data review and verification and State Format for submission to the State.
Ad Hoc Filter	Allows a previously created Ad hoc Filter to be selected that will limit what students appear in the report. Filters are created in the Filter Designer.
Calendar(s)	Students enrolled in the selected calendar(s) will appear in the report.

Generating the Extract

Select the Student Assessment (FA) Extract Type.
Select the Assessment Type.
Enter a Date Range in mmddyyyy format or by clicking the calendar icon and selecting a date.
Select the Format in which the report should generate.
Select an Ad hoc Filter to specify student results.
Select the Calendar(s) that should be included in the report.
Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate. If generating multiple extracts at a time (after Campus.1921), requests can only be submitted to the Batch Queue.

Users have the option of submitting a Student Assessment report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Extract Layout

Element Name	Description & Format	Campus Location
Filler1
SortType	Reports as FA for this record.	N/A
Filler2
FiscalYear	The end year of the reporting school year. Alphanumeric, 1 character	System Administration > Calendar > School Year > End Year Calendar.endYear
ReportingPeriod	The Reporting Period selected in the extract editor.	OH State Reporting > OH Extracts > Student Assessment (FA) > Reporting Period Not dynamically stored
DistrictIRN	The state-assigned information retrieval number (IRN) of the district. When (System Admin > Resources > School > School Detail > District IRN Override) NOT = null, reports the value entered into the District IRN Override field. When District IRN Override = null, reports entry in (System Admin > Resources > District Information > District Info > State District Number). Numeric, 6 characters	System Administration > Resources > District Information > State District Number District.number
StudentID	The locally determined EMIS student ID. For GW and GY assessment types (Reporting Period D), this field reports the Student State ID instead of the Local Student Number. Alphanumeric, 9 characters	Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber
AssessmentTypeCode	Reports DS for this record. Alphanumeric, 2 characters	Assessments > Test Setup > Tests > Test Detail > Test Type > State Code Test.stateCode
TestGradeLevel	The Test Grade Level of the assessment. See the following Grade Level Options table for values. For the GN assessments, reports the Test Grade Level. If null, reports as . For the GF and GE assessments, this field reports as . Alphanumeric, 2 characters	Assessments > Test Setup > Test Detail > Test Grade Level; Student Information > General > Assessments > Student Grade Level Test.testGradeLevel
AssessmentAreaCode	A one to four character code that identifies the test or subject area of the assessment administered. AC: Report code based on the Subject of the test administered. If Subject = Reading, report 'R ' If Subject = Writing, report 'W ' If Subject = Math, report 'M ' If Subject = Science, report 'S ' If Subject = English/Language Arts, report 'ENG ' WK, RD, IB, GY, GW, GN, GE, GD, DS, AP: Reports first 4 digits of the value entered in the Code field on (Parent or Child) Assessment Set up GF: When S, SPKG When L, LIST When R, R When W, W When PROD, PROD WHEN RECE, RECE GM: Record 1 Report Subject code. Pad with blank space. Record 2 Report Subject code + PRG. Example: Subject = E would report = EPRG. SA: If Subject = Reading, report 'R ' If Subject = Writing, do not report If Subject = Math, report 'M '.	Student Information > Assessment Administration > Assessment Center > Subject (Drop List) Student Information > Assessment Administration > Assessment Center > Code (Text Field) Student Information > Assessment Administration > Assessment Center > Subject (Drop List) System Administrator > Assessments > Tests > Test Detail > Subject Student Information > General > Assessments > Progress Student Information > Assessment Administration > Assessment Center > Subject (Drop List)
TestDate	Report GD, GN as: Test Date 09/01 - 12/31: Reports CCYY11 Test Date 01/01 - 05/31: Reports CCYY04 Test Date 06/01 - 08/31: Reports CCYY07 ELSE Report as YYYYMM	Student Information > General > Assessments > Date
TestDay	The day of the month on which the test was administered. Report Day of the month the test was taken Date field, 2 digits, DD	Student Information > General > Assessments > Test Date TestScore.date
TestRequiredType	Report Required Test Type If null/blank report STR	Student Information > General > Assessments > Required Test Type TestScore.modification
GradeLevel	Report student's - Student Information > General > Assessment > Test Scores > Student Grade Level If blank AND the student is enrolled on the test date - report Mapped stateGrade based on the student's enrollment Grade Level If blank AND the student is NOT enrolled on the test date - Report Student Information > General > Assessment > Test Scores > Test Grade Level Override If Student Grade Level and Test Grade Level Override are blank, report Student Information > Assessment Administration > Test Setup > Test Detail > Test Grade Level IF all are null report 2 spaces. NOTE: GO & GM report Overrides from data entered on the Child Assessments	Student Information > General > Assessments > Student Grade Level TestScore.testingGrade
TestAccommodation	Report Type of Accommodation from the student's test Else Report Type of Accommodation from the Parent Assessment Else Report as '**' See the following Type of Accommodation Options table for values.	Student Information > General > Assessments > Type of Accommodation TestScore.accommodation
ScoreNotReported	Report Score Not Reported from the student's test Else Report Score Not Reported from the Parent Assessment Else Report as '*' See the following Score Not Reported Options table for values. For GY assessments, if a value other than or X is entered, reports as **. Otherwise, logic looks at the Assessment Code. If it begins with 3 alphabetic characters, the field reports differently based on when the student took the test. If that student's result is A, N, or P and the Test Date is on or after 4/1/2020, the Result reports. If the student's result is not A, N, or P and the Test Date is before 4/1/2020, the Scale Score reports. If the Assessment Code ends with two alphabetic characters, field logic is unchanged. Alphanumeric, 1 character*	Student Information > General > Assessments > Score Not Reported TestScore.nonParticipationReason
Score	Identifies the score the student received. Report in the following hierarchy the first non-null entry: Scale Score Raw Score Percentile Result (Code) If no Score to report, report *. Logic for RD and DS Assessments: When the score reported in the record = 0, "000" must be reported. "***" must only be reported when there is no score to report from the 4 score fields (all are null). Non-numeric scores that do not require all 3 available characters may be reported with either leading or trailing spaces. A score of A, for example, could be reported as either “ A” or “A ”. Numeric scores that do not require all 3 available characters may be reported with either leading zeros or leading spaces, but in both cases, the actual score must be right-justified within the element. A score of 53, for example, can be reported as either “053” or “ 53”.	Student Info > general > Assessments > Scale Score, Raw Score, Percentile, Result (Code) TestScore.scaleScore TestScore.rawScore

State Code Options

Code	Description
GA	Grades 3-8 Alternate Assessment
GB	Early Learning Preschool Assessment
GD	Measures of Academic Progress (DPR Growth Assessment by NWEA only)
GE	End of Course Tests
GF	Ohio English Language Proficiency Assessment
GM	Preschool Childhood Outcome Summary
GN	Ohio's State Tests
GO	Kindergarten Readiness Assessment
GP	Graduation-Only Test
GS	Student Preschool ASQ/SE Assessment
GU	CTE Industry Assessment
GW	Industry Credential
GX	Ohio Graduation Test
GY	CTE Technical Assessment
IB	International Baccalaureate Assessment
WK	WorkKeys Assessment

Grade Level Options

Code	Description
IN	Infant/Toddler
PS	Preschool
KG	Kindergarten
01	Grade 1
02	Grade 2
03	Grade 3
04	Grade 4
05	Grade 5
06	Grade 6
07	Grade 7
08	Grade 8
09	Grade 9
10	Grade 10
11	Grade 11
12	Grade 12
13	Enrolled, completed course requirements
23	Student identified with disability

Subject Options

Code	Description
AEE	Awareness and Expression of Emotion
C	Communication
CLRF	Clarification
COMM	Communication
COOP	Cooperation with Peers
CSM	Coordination - Small Motor
E	Positive Social-Emotional Skills
EL	English/Language Arts
K	Acquiring/Using Knowledge and Skills
L	Listening
LL	Language and Literacy
M	Math
PCT	Personal Care Tasks
PD	Physical Well-Being and Motor Development
PLR	Phonics and Letter Recognition
R	Reading
S	Science
SF	Social Foundations
SFIP	Safety and Injury Prevention
SP	Speaking
SS	Social Studies
T	Taking Appropriate Action to Meet Needs
W	Writing

Required Test Type Options

Code	Description
STR	Standard (regular)
ALT	Alternative Assessment
IPD	Industry Credential administered 7/1/19 or later, cost paid by reporting LEA
INP	Industry Credential administered 7/1/19 or later, cost not paid by reporting LEA
NRP	Not required (part-time or home school)
NRF	Not required (exchange student)
NRL	Not required (exchange student citizenship test)
NBD	Deaf and/or Blind
NSL	LEP Student
MOV	Student Moved
ST1	Standard (regular) Student took the PBA only
ST2	Standard (regular) Student took the EOY only

Type of Accommodation Options

Code	Description
**	Not Applicable
NO	No accommodations
Y1	504 plan accommodations
Y2	IEP accommodations
Y3	LEP accommodations

Score Not Reported Options

Code	Description
*	Not Applicable
A	Medical Reasons
B	Parent Refusal
C	Student Refusal
D	Suspension/Expulsion
E	Truancy
F	Other (e.g. excused absence, incarceration)
J	Student moved in/out of district prior to test
K	Not required in this district
L	Student has disability condition-test not required
M	Medical Emergency
N	Accelerated Stu./No Subject Test at Accl. Grade
O	Student Older than Max Age for ASQ/SE Assessment
P	Due to Timing of Alt Assessment Determination
I	Invalidated by ODE or school district
Q	Previously in KG, KG again this year, not reported as retained
R	Parents request results not be reported to state
S	Non-Scorable Assessment
U	Unable to answer simple terms
V	CTE student not given tech or industry assessment

Save

Student Assessment (FA) (Ohio Extracts)