Recent Arrivers File

Field

Description

Select Schools*

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

• All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

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:

• Use Current Selection – Run the report for students in the current selection.

• Don’t Use Current Selection – Run the report for all students in the current school or district that meet the selection criteria.

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.

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