Recent Arrivers File
Contents
Introduction
The Recent Arrivers File generates a list of students enrolled during the selected date range who are recent arrivers to the US school system.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:
- Students active, in-full or in-part, between the Report Start Date and Report End Date.
- The student's school must not be excluded from state reporting.
- The student must not be excluded from state reporting.
- The following values are both checked on the enrollment record:
- Student born outside the US or Puerto Rico
- Less than 3 years US schools’ education
Report Input
To generate the Recent Arrivers File, do the following:
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools* | Choose one of the following:
Note: The All Schools option is only available when running the report from the District Office. |
Students to Include* | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Report Start Date | The start of the date range to select students and assessments. |
Report End Date | The end of the date range to select students and assessments. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
This report is a student-level Consolidated Collections report using the “core fields query” to gather student details and assure consistent data submissions to ODE.
SEE THE SSID REPORT OUTPUT FOR A LISTING OF THE CORE ELEMENTS OF THIS STUDENT-LEVEL CONSOLIDATED COLLECTION REPORT.
| Row | Column | Data Element Name | Data Element Description | [Table]Field Name | Width | Data Type | Required |
|---|---|---|---|---|---|---|---|
| 1 | A | Secure Student Identifier (SSID) | ODE assigned Secure Student Identifier (SSID) with a trailing check digit. | ChkDigitStdntID | 10 | int | Y |
| 2 | B | District/Local Student Identifier | Identifier, assigned by the district, used to uniquely identify the student. | DistStdntID | 10 | varchar | N |
| 3 | C | Resident District Institution Identifier | ODE assigned Institution Identifier for the Resident District. The District responsible for the education of the student and also is the basis on which the State School Fund, the Common School Fund, and the County School Fund are distributed to local districts. Special provisions apply as defined in ORS 339.133, 338.155(1), and 338.165. | ResdDistInstID | 10 | int | Y |
| 4 | D | Resident School Institution Identifier | ODE assigned Institution Identifier for the Resident School. The School responsible for the education of the student and also is the basis on which the State School Fund, the Common School Fund, and the County School Fund are distributed to local districts. Special provisions apply as defined in ORS 339.133, 338.155(1), and 338.165. | ResdSchlInstID | 10 | int | Y |
| 5 | E | Attending District Institution Identifier | ODE assigned Institution Identifier for the Attending District. The District where the student is receiving instruction and where state assessments are administered. | AttndDistInstID | 10 | int | Y |
| 6 | F | Attending School Institution Identifier | ODE assigned Institution Identifier for the Attending School. The School where the student is receiving instruction and where state assessments are administered. | AttndSchlInstID | 10 | int | Y |
| 7 | G | Institution Filler | Reserved for future use. | InstFill | 20 | varchar | N |
| 8 | H | Legal Last Name | Legal last name of the student. | LglLNm | 50 | varchar | Y |
| 9 | I | Legal First Name | Legal first name of the student. | LglFNm | 40 | varchar | Y |
| 10 | J | Legal Middle Name | Legal middle name of the student. | LglMNm | 40 | varchar | N |
| 11 | K | Generation Code | Name suffix of the student (i.e. Jr., II, III). | GnrtnCd | 4 | varchar | N |
| 12 | L | Preferred Last Name | Preferred last name of the student. | PrfrdLNm | 50 | varchar | N |
| 13 | M | Preferred First Name | Preferred first name of the student. | PrfrdFNm | 40 | varchar | N |
| 14 | N | Preferred Middle Name | Preferred middle name of the student. | PrfrdMNm | 40 | varchar | N |
| 15 | O | Date of Birth | Date the student was born. | BirthDtTxt | 8 | datetime | Y |
| 16 | P | Gender Code | Code indicating the gender of the student. | GndrCd | 1 | char | Y |
| 17 | Q | Hispanic/Latino Ethnic Flag | Indicates a student of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. The term, “Spanish origin,” can be used in addition to “Hispanic or Latino.” | HispEthnicFg | 1 | char | Y |
| 18 | R | American Indian/Alaskan Native Race Flag | Indicates a student having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment. | AmerIndianAlsknNtvRaceFg | 1 | char | Y |
| 19 | S | Asian Race Flag | Indicates a student having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. | AsianRaceFg | 1 | char | Y |
| 20 | T | African American Race Flag | Indicates a student having origins in any of the black racial groups of Africa. | BlackRaceFg | 1 | char | Y |
| 21 | U | White Race Flag | Indicates a student having origins in any of the original peoples of Europe, the Middle East, or North Africa. | WhiteRaceFg | 1 | char | Y |
| 22 | V | Native Hawaiian/Other Pacific Islander Race Flag | Indicates a student having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. | PacIslndrRaceFg | 1 | char | Y |
| 23 | W | Race Filler | Reserved for future use. | RaceFill | 1 | char | N |
| 24 | X | Language of Origin Code | Code indicating the first language spoken in an individual's home in their early or earliest childhood. One's first language or native language. | LangOrgnCd | 4 | varchar | Y |
| 25 | Y | Partial Social Security Number | Last four (4) digits of the Social Security Number of the student. | SSN | 4 | varchar | N |
| 26 | Z | Enrolled Grade Code | Code indicating the enrolled grade level of the student; or a grade level assigned to an ungraded student based on student age. | EnrlGrdCd | 2 | char | Y |
| 27 | AA | Street Address | Street Address of the student's primary residence. | Addr | 45 | varchar | Y |
| 28 | AB | City | City where the student's primary residence is located. | City | 20 | varchar | Y |
| 29 | AC | Zip Code | First five digits of the postal Zip Code of the student's primary residence. | ZipCd | 5 | varchar | Y |
| 30 | AD | Zip Plus Four Code | Plus four portion of the postal zip code of the student's primary residence. | Zip4Cd | 4 | varchar | N |
| 31 | AE | Resident County Code | Code indicating the county of legal residence of the student's parent or legal guardian or the county of residence of an emancipated minor student. | [S_OR_STU_X]ResdCntyCd | 2 | varchar | Y |
| 32 | AF | Phone Number | Phone Number (Area Code, Prefix, and Exchange) of the student. | [S_OR_STU_X]Phn | 10 | varchar | N |
| 33 | AG | Teacher Filler | Reserved for future use. | TchrFill | 50 | varchar | N |
| 34 | AH | High School Entry Cohort School Year | School year the student entered high school in the format XXYY. (i.e. 0809 for the 2008-2009 school year). Indicates the ninth grade cohort group associated with the student. | [S_OR_STU_X]HSEntrySchlYr | 4 | varchar | N |
| 35 | AI | Student Filler | Reserved for future use. | Fill | 16 | varchar | N |
| 36 | AJ | Economically Disadvantaged Flag | Indicates student eligibility for a Free or Reduced Lunch program. | [S_OR_STU_X]EconDsvntgFg | 1 | char | N |
| 37 | AK | Title I Flag | Indicates the student is being served in a Title I Targeted Assisted School (TAS). Does NOT include students served in a Title I School Wide Program (SWP). | [S_OR_STU_X]Ttl1Fg | 1 | char | N |
| 38 | AL | Special Education Flag | Indicates student participation in an Individualized Education Plan (IEP/IFSP). | [S_OR_STU_X]SpEdFg | 1 | char | N |
| 39 | AM | Section 504 Flag | Indicates student eligibility for Section 504 services | Sect504Fg | 1 | char | N |
| 40 | AN | Migrant Education Flag | Indicates student participation in a program designed to assure that migratory children receive full and appropriate opportunity to meet the state academic content and student academic achievement standards. | [S_OR_STU_X]MigrntEdFg | 1 | char | N |
| 41 | AO | Indian Education Flag | Indicates student participation in a program designed to meet the unique educational and culturally related academic needs of American Indians. | [S_OR_STU_X]IndianEdFg | 1 | char | N |
| 42 | AP | English Learner Flag | Indicates a student who is an English Learner. | [S_OR_STU_X]ELFg | 1 | char | Y |
| 43 | AQ | Distance Learning Flag | Indicates student participation in a distance learning program or a program that includes online coursework. | [S_OR_STU_X]DstncLrnFg | 1 | char | N |
| 44 | AR | Homeschooling Flag | Indicates that the student is registered to receive homeschool instruction. | [S_OR_STU_X]HomeSchlFg | 1 | char | N |
| 45 | AS | Transition Program Flag | Indicates a Special Education student of high school or post high school age (up through the age of 21) who has not graduated with a regular diploma and are not working towards a regular or modified diploma. | [S_OR_STU_X]TrnstnProgFg | 1 | char | N |
| 46 | AT | Alternative Education Program Flag | Indicates that the student has been placed by the district in an Alternative Education Program(s) based on criteria described in OAR 581-022-1350 (5). | [S_OR_STU_X]AltEdProgFg | 1 | char | N |
| 47 | AU | American Indian Tribal Membership Code | Indicates a student having membership in any Federally recognized tribe. | [S_OR_STU_X]AmerIndianTrbMbrshpCd | 3 | char | N |
| 48 | AV | Talented and Gifted Flag | Indicates that the student is identified as Academically Talented or Intellectually Gifted as determined by school district policy. | [S_OR_STU_X]TAGFg | 1 | char | N |
| 49 | AW | Additional Language Code | Code indicating any additional language a student uses to communicate that is not the language of origin. | [S_OR_STU_X]AddnLangCd | 4 | varchar | N |
| 50 | AX | Demographic Filler | Reserved for future use. | DemogFill | 11 | varchar | N |
| 51 | AY | Students with Interrupted Formal Education | Flag indicating that this student has had interrupted formal education. | [S_OR_STU_LEP_X]SIFEFg [S_OR_REN_LEP_X]SIFEFg | 1 | char | Y |
| 52 | AZ | Foreign Exchange Student | Flag indicating that this student is a foreign exchange student | [S_OR_STU_LEP_X]FrgnExchStdntFg [S_OR_REN_LEP_X]FrgnExchStdntFg | 1 | char | Y |