Student Assessment (FA) (Ohio Extracts)

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.

Early Learning Preschool Assessment (GB)

Reports a record if the student has a GB Test date within the Date Range entered with a Subject of AEE, COOP, PLR, COMM, W, CLRF, CSM, SFIP, RWA, VOC, NBSN or PCT. Multiple assessment records can be reported.

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 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 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

  1. Select the Student Assessment (FA) Extract Type.
  2. Select the Assessment Type.
  3. Enter a Date Range in mmddyyyy format or by clicking the calendar icon and selecting a date.
  4. Select the Format in which the report should generate.
  5. Select an Ad hoc Filter to specify student results.
  6. Select the Calendar(s) that should be included in the report.
  7. 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



SortTypeCode

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

Reporting
Period Code

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.


  1. When (System Admin > Resources > School > School Detail > District IRN Override) NOT = null, reports the value entered into the District IRN Override field.
  2. 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

EMIS Student ID Number

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

Assessment Type Code

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

Assessment Area Code

Reports the Code entered into the Code field.


System Admin > Assessments > Tests > Test Detail > Code


TestDate

The date on which the student took the test.

For AP assessments, reports as CCYY05, where CCYY is the End Year of the calendar.


For GU assessments, reports as CCYY01, where CCYY is the End Year of the calendar.


For GY and GW assessments, reports as CCYYMM. 


For AC and SA assessments, reports as CCYYMMDD. 


For GN assessments, reports as follows, with CCYY indicating the year of the original Test Date: 

  • Test Date 09/01 - 12/31: Reports CCYY11
  • Test Date 01/01 - 05/31: Reports CCYY04
  • Test Date 06/01 - 08/31: Reports CCYY07

Date field, 6 digits, YYYYMM

Student Information > General > Assessments > Date


TestScore.date

Test Day of the MonthThe day of the month on which the test was administered.
For GD and GM assessments, reports the Test Day.  

Date field, 2 digits, DD
Student Information > General > Assessments > Test Date

TestScore.date

Required Test Type

Reports Required Test Type. If NULL, report STR.


Student Information > General > Assessments > Required Test Type


TestScore.modification

Grade Level of Student at time of test

The grade level of the student at the time that the test was taken. If the assessment doesn't have a Student Grade Level selected, reports the Student Grade Level of the parent assessment. If both are Null, reports the Student Grade at Time of Test calculated from the most recent enrollment. See the following Grade Level Options table for values.

For GN assessments, report the Test Grade Level if entered (Student Information > General > Assessment). Otherwise reports the Test Grade Level, or as ** if null.


Alphanumeric, 2 characters

Student Information > General > Assessments > Student Grade Level


TestScore.testingGrade

Type of Accommodation

Identifies the accommodations the student received when taking the standard format of the test. If the assessment doesn't have a Type of Accommodation selected, reports the Type of Accommodation of the parent assessment. See the following Type of Accommodation Options table for values.


Alphanumeric, 2 characters

Student Information > General > Assessments > Type of Accommodation


TestScore.accommodation

ScoreNot
Reported

Identifies the reason the student did not take a required test and/or does not have a score to report. If the assessment doesn't have Score Not Reported, reports the Score Not Reported value of the parent assessment. See the following Score Not Reported Options table for values. If null, reports as *.


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:
  1. Scale Score
  2. Raw Score
  3. Percentile
  4. Result (Code)

If no Score to report, report ***.


** Logic for RD and DS Assessments:

  1. When the score reported in the record = 0, "000" must be reported.
  2. "***" 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

GDMeasures of Academic Progress (DPR Growth Assessment by NWEA only)
GEEnd of Course Tests

GF

Ohio English Language Proficiency Assessment

GM

Preschool Childhood Outcome Summary

GNOhio's State Tests

GO

Kindergarten Readiness Assessment

GP

Graduation-Only Test

GS

Student Preschool ASQ/SE Assessment

GU

CTE Industry Assessment

GWIndustry Credential

GX

Ohio Graduation Test

GY

CTE Technical Assessment

IBInternational Baccalaureate Assessment
WKWorkKeys 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

AEEAwareness and Expression of Emotion
CCommunication
CLRFClarification
COMMCommunication
COOPCooperation with Peers
CSMCoordination - Small Motor
EPositive Social-Emotional Skills
ELEnglish/Language Arts
KAcquiring/Using Knowledge and Skills
LListening
LLLanguage and Literacy
MMath
PCTPersonal Care Tasks
PDPhysical Well-Being and Motor Development
PLRPhonics and Letter Recognition
RReading
SScience
SFSocial Foundations
SFIPSafety and Injury Prevention
SPSpeaking
SSSocial Studies
TTaking Appropriate Action to Meet Needs
WWriting

Required Test Type Options

Code

Description

STR

Standard (regular)

ALT

Alternative Assessment

IPDIndustry Credential administered 7/1/19 or later, cost paid by reporting LEA
INPIndustry 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

ST1Standard (regular) Student took the PBA only
ST2Standard (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

QPreviously 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

VCTE student not given tech or industry assessment


 

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save