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. |
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 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:
|
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 | ||
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 | 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.
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:
Date field, 6 digits, YYYYMM | Student Information > General > Assessments > Date TestScore.date |
| Test Day of the Month | The 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 | 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:
If no Score to report, report ***. 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 |
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 |
