Recent Arriver (Oregon)

The Recent Arriver Report provides a list of students identified as English Learner (EL) and students identified as SIFE (Student with Interrupted Formal Education). 

Recent Arriver Report

Report Logic

One record per student who qualifies as either a Recent Arriver or SIFE reports. 

  • Students ages 3-21 (determined by the student's birth date and the date of the report generation) who are not born in the US or a US Territory (Birth Country is set to an option that is NOT USA, UMI or BIR; AND
  • Have attended school less than or equal to 540 days (Date Entered US Schools is less than or the same as 540 days from the date of report generation).
  • SLIFE checkbox is marked on the student's active EL record.

Definitions

The United States Department of Education, Title III and the State of Oregon defines Recent Arrivers as students who meet all of the following requirements:

  • aged 3-21 who were not born in the United States or United States Territories;
  • Have NOT been attending one or more schools in any one or more states for more than three full (cumulative) academic years;
  • Have been educated in the US for less than three (3) cumulative years (or 540 days).
    • A student attending school in the United States for more than 540 cumulative days no longer qualifies as a recent arriver despite when in the calendar or school year the days are accumulated.
    • Pre-K does NOT count towards the 540 days (only K-12)

Students are considered SIFE when they meet the following criteria:

  • From a home where a language other than English is spoken and entered a school in the US after second grade;
  • Immigrant students who enter a school in the United States after second grade; 
  • Have had at least two years less schooling than their peers;
  • Functions at least two years below expected grade level in reading and in mathematics and MAY be pre-literate in their native language.

A SIFE student is similar to a Recent Arriver student; however, the SIFE student has previous schooling and enters US schools AFTER the second grade. 

A student ceases to be considered SIFE once the student is scoring proficient, is exiting an EL program and is no longer functioning at least two years below their expected grade level in reading and mathematics.

Report Editor

Data ElementDescription
FormatDetermines in which format the report generates - CSV, XML or HTML.
Apply All ExcludesWhen marked, students who are marked as one of the following are included in the report: 
  • No Show or State Exclude on the Enrollment record
  • Grade Level of enrollment is marked as State Exclude
  • Calendar of enrollment is marked as State Exclude

When Exclude from State Reporting is marked on Course Information or Course Master Information, section of that course are included in the report. 


When NOT marked, any student or course marked as Exclude or No Show are NOT included in the report. 

Report GenerationTo generate the report immediately, use the Generate Extract 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.

Generate the Report

  1. Select the desired Format.
  2. Mark the Apply All Excludes checkbox to include enrollments, grade levels, courses and calendars that are marked as State Exclude in the report.
  3. Click the Generate Extract button to display the results of the report immediately, or click the Submit to Batch button to choose when the report generates.

Recent Arriver Report - HTML Format

Recent Arriver Report - 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 ElementDescriptionLocation
Students with Interrupted Formal Education
Indicates the student has had interrupted education experiences.

Reports a value of Y when the SLIFE checkbox is marked on the student's active EL record. Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
English Learners (EL) > SLIFE

Lep.slife
Foreign Exchange Student
Indicates the student is a Foreign Exchange Student.

Reports a value of Y when the Foreign Exchange Student checkbox is marked on the student's active enrollment record. Otherwise, reports a value of N.

Alphanumeric, 1 character (Y or N)
Enrollments > State Reporting Fields > Foreign Exchange Student

Enrollment.foreignStudent