Report Logic | Report Editor | Generate the Report | Report Layout

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 Element	Description
Format	Determines in which format the report generates - CSV, XML or HTML.
Apply All Excludes	When 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 Generation	To 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.

Data Element

Description

Format

Determines in which format the report generates - CSV, XML or HTML.

Apply All Excludes

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

To 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

Select the desired Format.
Mark the Apply All Excludes checkbox to include enrollments, grade levels, courses and calendars that are marked as State Exclude in the report.
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 Element	Description	Location
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

Recent Arriver (Oregon)

Report Logic

Definitions

Report Editor

Generate the Report

Report Layout

Related Articles