Ninth Grade On-Track (Oregon)

Tool Search: OR Student Programs

The Ninth Grade On-Track Report returns enrolled students who have entered high school for the first time during the reporting year AND are considered on-track to graduate. Students are considered to be on track when they have earned 25% of their required credits for graduation in their first year of high school. Data reports from the student's On Track record. 

Screenshot of the Ninth Grade On-Track Report, located at Reporting, OR State Reporting, OR Student ProgramsNinth Grade On-Track Report Editor 

Read - View, select options, and generate the Ninth Grade On-Track Report.
Write - N/A
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

To report, a student's most recent On-track record that is active during the reporting range must contain a value in the First School Year Entered HS that is equal to the reporting school year AND the Program Status field is set to 1: On-Track to Graduate. 

A student must have a Student State ID and be enrolled in at least one reportable calendar on at least one date during the reporting school year to be included in the report.

A student does NOT report when:

  • The Calendar of Enrollment is marked as State Exclude. 
  • The Enrollment record is marked as State Exclude or No Show. 
  • The Grade Level of Enrollment is marked as State Exclude. 

Report Editor

Data Element Description
Report Type Determines which report generates. For this instance, select Ninth Grade On-Track.
Ad hoc Filter Select which students to include in the extract by choosing a filter created in the Filter Designer. Only those students included in the filter are included in the report.
Output Options
Report Processing To generate the report immediately, select Generate Now option. To choose when the report generates, use the Submit to Batch option. Submit to Batch is useful when generating the report for several calendars or for larger amounts of data being reported. See the Batch Queue article for more information.
Format Determines in which format the report generates - CSV, XML or HTML.

Generate the Report

  1. Select Ninth Grade On-Track from the Report Type field. 
  2. Choose an Ad hoc Filter to return just the course and staff information included in the selected filter. 
  3. Select the desired Report Processing option of Generate Now or Submit to Batch Queue
  4. Select the desired Format Type
  5. Click Generate. The report displays in the selected format.


Screenshot of the Ninth Grade On-Track Report in HTML format. Ninth Grade On-Track - HTML Format



Screenshot of the Ninth-Grade On-Track Report in CSV FormatNinth Grade On-Track - CSV Format


Report Layout

The following fields are the same on many Oregon state reports. Click the Click to expand link to view these fields.

Click here to expand...

Data Element Description Location
Check Digit Student Identifier Lists the student's state-issued identification number.

Numeric, 10 digits
Demographics > Person Identifiers > Student State ID

Person.stateID
District Student Identifier Lists the student's district-issued identification number.

Numeric, 10 digits
Demographics > Person Identifiers > Local Student Number

Person.studentNumber
Resident District Institution Identifier Reports the district number in which the student resides.

Numeric, 10 digits

Enrollments > State Reporting Fields > Resident District

Enrollment.residentDistrict
District Information > State District Number

District.number
Resident School Institution Identifier Reports the school number in which the student resides.

Numeric, 10 digits
Enrollments > State Reporting Fields > Resident School

Enrollment.residentSchool
District Information > State School Number

School.number
Attending District Institution Identifier Reports the district number in which the student is enrolled.

Numeric, 10 digits
Enrollments > State Reporting Fields > Serving District

Enrollment.servingDistrict
District Information > State District Number

District.number
Attending School Institution Identifier Reports the school number in which the student is enrolled.

Numeric, 10 digits
Enrollments > State Reporting Fields > Serving School

Enrollment.servingSchool
District Information > State School Number

School.number
Institution Filler N/A N/A
Legal Last Name

Reports the student’s legal last name.


When the Legal Last Name field is not populated, information reports from the Last Name field.


Alphanumeric, 50 characters

Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName


Demographics > Person Information > Last Name


Identity.lastName

Legal First Name

Reports the student’s legal first name.


When the Legal First Name field is not populated, information reports from First Name field.


Alphanumeric, 30 characters

Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName


Demographics > Person Information > First Name


Identity.firstName

Legal Middle Name

Reports the student’s legal middle name.


When the Legal Middle Name field is not populated, information reports from the Middle Name field. 


Alphanumeric, 30 characters

Identities > Identity Information > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName


Demographics > Person Information > Middle Name


Identity.middleName

 Suffix (Generational Code)

Indication student is considered a Junior, III, etc. 


Alphanumeric, 3 characters

Demographics > Person Information


Identity.suffix

Preferred Last Name Reports the student's last name.

Alphanumeric, 50 characters

Demographics > Person Information > Last Name


Identity.lastName

Preferred First Name Reports the student's first name.


Alphanumeric, 30 characters

Demographics > Person Information > First Name


Identity.firstName

Preferred Middle Name

Reports the student’s legal middle name.


Alphanumeric, 30 characters

Demographics > Person Information > Middle Name


Identity.middleName

Birth Date Reports the student's date of birth.

Date field, 8 digits (MMDDYYYY)

Demographics > Person Information > Birth Date


Identity.birthDate

Gender Code Reports the student's Legal Gender as either Male (M), Female (F) or Non-Binary (X).

When the Legal Gender field is not populated, information reports from the Gender field.

When the Legal Gender or Gender fields are not populated, reports a value of X.

Alphanumeric, 1 character (M, F, X)
Identities > Identity Information > Protected Identity Information > Legal Gender


Identity.legalGender


Demographics > Person Information > Gender


Identity.Gender

Hispanic/Latino Ethnicity Flag

An indication of whether a student identifies as having a Hispanic ethnicity.

  • Reports a value of Y when Is the individual Hispanic/Latino? is set to Yes. 
  • Reports a value of N when Is the individual Hispanic/Latino? is set to No or is not populated.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Is the individual Hispanic/Latino?


Identity.hispanicEthnicity

American Indian/Alaskan Native Flag  Reports a value of Y when the American Indian or Alaskan Native checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > American Indian or Alaska Native


Identity.raceEthnicity

Asian Race Flag Reports a value of Y when the Asian checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > Asian


Identity.raceEthnicity

BlackRace Flag Reports a value of Y when the Black/African American checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > Black or African American


Identity.raceEthnicity

White Race Flag Reports a value of Y when the White checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > White


Identity.raceEthnicity

Native Hawaiian/Other Pacific Islander Race Flag Reports a value of Y when the Native Hawaiian or Other Pacific Islander checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander


Identity.raceEthnicity

Race Filler N/A N/A
Language of Origin Code Reports the language that is most often spoken in the student's home.

Numeric, 4 digits

Demographics > Person Information > Home Primary Language


Identity.homePrimaryLanguage

Partial Social Security Number Reports the last four digits of the student's Social Security number.

Numeric, 4 digits

Demographics > Person Information > Soc Sec Num


Identity.SSN

Enrolled Grade Code Reports the state grade level that is mapped to the student's grade level of enrollment.

Numeric, 2 digits
Enrollments > General Enrollment Information > State Grade Level

Enrollment.stateGradeLevel
Street Address Reports the student's Primary Household address.

The following logic is used when reporting addresses when a student is associated with multiple addresses:
  • A Street Address is selected over a P.O Box.
  • A Primary household membership is selected over a secondary household membership.
  • A Primary location is selected over a secondary location.
  • The household ID is used as a tiebreaker when multiple addresses have the same/earliest start date.
  • The location ID is used as a tiebreaker when the start date on multiple household locations is the same. 
  • When a P.O. Box is the only address available for the student, that address reports. 
Alphanumeric, 45 characters
Household > Address > Number, Prefix, Street, Tag

Address.number
Address.prefix
Address.street
Address.tag
City Reports the city in which the student resides.

Alphanumeric, 20 characters
Household > Address > City

Address.city
Zip Code Reports the five digit zip code of the student's address.

Numeric, 5 digits
Household > Address > Zip

Address.zip
Zip Plus Four Code Reports the additional four digits of the zip code associated with the student's address.

Numeric, 4 digits
Household > Address > Zip

Address.zip
Resident County Code Reports the county of residence code from the student's primary enrollment record as of the date of generation.

When there is no primary enrollment, reports from the partial enrollment, then from the Special Education enrollment.

When there are multiple primary enrollments, reports from the most recent entered enrollment.

Numeric, 2 digits
Enrollment > State Reporting Fields > Resident County

Enrollment.residentCounty
Phone Number Reports the student's 10-digit phone number as entered in the Cell Phone field in the Personal Contact Information.

When the Cell Phone field is not populated, reports from the Other Phone field.

Numeric, 10 digits (XXXXXXXXXX)
Demographics > Personal Contact Information > Cell Phone

Contact.cellPhone
Teacher Filler N/A N/A
High School Entry Cohort School Year Reports the concatenated school year value based on the student's date of first entry into 9th grade.

When the student enters 9th grade in the 22-23 school year, a value of 2223 reports.

Numeric, 4 digits
Graduation > Date First Entered Grade 9

Graduation.grade9Date
Student Filler N/A N/A
Economically Disadvantaged Flag Reports a value of Y when:
  • The active school history at the time of report generation identifies the school as Provision 2.
  • The student has an active FRAM record at the time of report generation where the Eligibility is Free or Reduced.

Reports a value of N when there is no active FRAM record or when the Eligibility is NOT Free or Reduced. 


Alphanumeric, 1 character (Y or N)

Eligibility > Eligibility Detail > Eligibility

POSEligibility.eligibility
School > School History > Provision Status

SchoolAttribute.provision
Title 1 Flag Reports a value of Y when the student has an active Title 1 record on the date of report generation.

When there is no active Title 1 record on the date of report generation, a value of N reports.

Alphanumeric, 1 character (Y or N)
Title 1 > Start Date, End Date

Title1.startDate
Title1.endDate
Special Education Flag Reports a value of Y when the student has a locked IEP OR has a data plan that is active on the day of report generation AND has a Special Ed Eligibility entry of Yes.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Enrollments > Special Ed Fields > Status

Enrollment.specialEdStatus


Section 504 Flag Reports a value of Y when the student has an active Section 504 record on the date of report generation.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Section 504 > Start Date, End Date

Section504.startDate
Section504.endDate
Migrant Education Flag Reports a value of Y when the student has an active Migrant record on the date of report generation.

Active is defined as the report generation date being on or after the Services Start Date and on or before the Services End Date.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Migrant > Services Start Date, Services End Date

Migrant.servicesStartDate
Migrant.servicesEndDate
Indian Education Flag Reports as N for all records. N/A
English Learner Flag Reports a value of Y ONLY when the student has an active EL record at the time of generation where the EL Program Status is EL.

Active is defined as the report generation date being on or after the Identified Date and on or before the Program Exit Date.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
English Learner > Program Status, Identified Date, Program Exit Date

lep.programStatus
lep.identifiedDate
lep.exitDate
Distance Learning Flag Reports a value of Y when the Distance Learning checkbox is marked on the student's enrollment record.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Enrollments > State Reporting Fields > Distance Learning

Enrollment.distanceLearning

Homeschooling Flag Reports a value of Y when the Home School checkbox is marked on the student's enrollment record.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Enrollments > State Reporting Fields > Home School

Enrollment.homeSchooled
Transition Program Flag When the Special Education Flag (field 38) reports a value of Y, logic checks the student's State Reporting Plan to see if it is active during the reporting range. When yes, this field reports as Y.

Otherwise, a value of N reports.

Alphanumeric, 1 character (Y or N)
Enrollments > Special Ed Fields > Status

Enrollment.specialEdStatus

Special Ed Documents > Data Plan


Alternative Education Program Flag Reports a value of Y when the student's calendar of enrollment as of the report generation date contains a Calendar Type of Alternative.

Otherwise, reports a blank value.

Alphanumeric, 1 character (Y)
Calendar Information  > Calendar Info > Type

Calendar.type
Tribal Affiliation Code
Indicates Tribal affiliation with a federally recognized, state-acknowledged, or terminated Tribe for the student, their parent, or their grandparent.
  • When the student's Race/Ethnicity is marked as American Indian or Alaska Native, reports a value of Y. 
  • When the Detail Ancestry/Tribal Code field contains a value, reports a value of Y. 
Otherwise, reports a blank value.

Alphanumeric, 1 character (Y)
Identities > Race/Ethnicity > American Indian or Alaska Native, Detailed Ancestry/Tribal Codes

Identity.raceEthnicity
Identity.raceSubcategory
Talented and Gifted Flag Reports a value of Y when the student has an active Gifted record as of the date of report generation.

Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Gifted > Start Date, End Date

gifted.startDate
gifted.endDate
Additional Language Code Reports any additional language codes assigned on the student's Identities record.

Alphanumeric, 4 characters
Identities > Secondary Language

Identity.altLanguage
Demographic Filler N/A N/A


The following fields are unique to the Recent Arriver Report.

Data Element Description Location
On Track Flag
Reports a value of Y for all records.

Students who are not on-track to graduation do not report a record.
N/A