Physical Restraint and Seclusion 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:

• The selected [number] number of students only – Run the report for students in the current selection.

• All Students (Default) – 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

Enter the start to restrict students for the report.

Report End Date

Enter the end date to restrict students for the report.

Scheduling

Choose a time to run the report from following options:

• Run Now (default)

• Schedule

1

A 

ChkDigitStdntID

Secure Student Identifier (SSID)

ODE assigned Secure Student Identifier (SSID) with a trailing check digit.

Students[SSID]

10

int

Y

2

B 

DistStdntID

District/Local Student Identifier

Identifier, assigned by the district, used to uniquely identify the student.

[Prefs]value

[Prefs]Name=’districtnumber’

10

varchar

N

3

C 

ResdDistInstID

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.

[S_OR_STU_X]ResdDistInstID

[S_OR_REN_X]ResdDistInstID

10

int

Y

4

D 

ResdSchlInstID

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.

[S_OR_STU_X]ResdSchlInstID

[S_OR_REN_X]ResdSchlInstID

10

int

Y

5

E 

AttndDistInstID

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.

[S_OR_STU_X]AttndDistInstID

[S_OR_REN_X]AttndDistInstID

10

int

Y

6

F 

AttndSchlInstID

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.

[S_OR_STU_X]AttndSchlInstID

[S_OR_REN_X]AttndSchlInstID

10

int

Y

7

G 

InstFill

Institution Filler

Reserved for future use.

N/A

20

varchar

N

8

H 

LglLNm

Legal Last Name

Legal last name of the student.

[Students]LegalLastName

50

varchar

Y

9

I 

LglFNm

Legal First Name

Legal first name of the student.

[Students]LegalFirstName

40

varchar

Y

10

J 

LglMNm

Legal Middle Name

Legal middle name of the student.

[Students]LegalMiddleName

40

varchar

N

11

K 

GnrtnCd

Generation Code

Name suffix of the student (i.e. Jr., II, III).

[S_OR_STU_X]GenerationCd

4

varchar

N

12

L 

PrfrdLNm

Preferred Last Name

Preferred last name of the student.

[Student]LastName

50

varchar

N

13

M 

PrfrdFNm

Preferred First Name

Preferred first name of the student.

[Student]FirstName

40

varchar

N

14

N 

PrfrdMNm

Preferred Middle Name

Preferred middle name of the student.

[Student]MiddleName

40

varchar

N

15

O 

BirthDtTxt

Date of Birth

Date the student was born.

[Student]DOB

8

datetime

Y

16

P 

GndrCd

Gender Code

Code indicating the gender of the student.

Calculated based on action codes.

[Students]Gender=M

1

char

Y

17

Q 

HispEthnicFg

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.”

Calculated based on action codes.

[Student]FedEthnicity=1

1

char

Y

18

R 

AmerIndianAlsknNtvRaceFg

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.

Calculated based on action codes.

[StudentRace]racecd=I

1

char

Y

19

S 

AsianRaceFg

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.

Calculated based on action codes.

[StudentRace]racecd=A

1

char

Y

20

T 

BlackRaceFg

African American Race Flag

Indicates a student having origins in any of the black racial groups of Africa.

Calculated based on action codes.

[StudentRace]racecd=B

1

char

Y

21

U 

WhiteRaceFg

White Race Flag

Indicates a student having origins in any of the original peoples of Europe, the Middle East, or North Africa.

Calculated based on action codes.

[StudentRace]racecd=W

1

char

Y

22

V 

PacIslndrRaceFg

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.

Calculated based on action codes.

[StudentRace]racecd=P

1

char

Y

23

W 

RaceFill

Race Filler

Reserved for future use.

N/A

1

char

N

24

X 

LangOrgnCd

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.

[Student]LangOrgnCd

4

varchar

Y

25

Y 

SSN

Partial Social Security Number

Last four (4) digits of the Social Security Number of the student.

[Students]State_StudentNumber

4

varchar

N

26

Z 

EnrlGrdCd

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.

[S_OR_STU_X]EnrlGrdCd

[S_OR_REN_X]EnrlGrdCd

[Students]Grade_Level

[ReEnrollments]Grade_Level

2

char

Y

27

AA

Addr

Street Address

Street Address of the student's primary residence.

[Students]Address

45

varchar

Y

28

AB

City

City

City where the student's primary residence is located.

[Students]City

20

varchar

Y

29

AC

ZipCd

Zip Code

First five digits of the postal Zip Code of the student's primary residence.

[Students]ZipCd

5

varchar

Y

30

AD

Zip4Cd

Zip Plus Four Code

Plus four portion of the postal zip code of the student's primary residence.

[Students]Zip4Cd

4

varchar

N

31

AE

ResdCntyCd

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.

[Students]ResdCntyCd

2

varchar

Y

32

AF

Phn

Phone Number

Phone Number (Area Code, Prefix, and Exchange) of the student.

[Students]Phone

10

varchar

N

33

AG

TchrFill

Teacher Filler

Reserved for future use.

N/A

50

varchar

N

34

AH

HSEntrySchlYr

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

Fill

Student Filler

Reserved for future use.

N/A

16

varchar

N

36

AJ

EconDsvntgFg

Economically Disadvantaged Flag

Indicates student eligibility for a Free or Reduced Lunch program.

[S_OR_STU_X]EconDsvntg

[S_OR_REN_X]EconDsvntg

1

char

Y

37

AK

Ttl1Fg

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]Title1Fg

[S_OR_REN_X]Title1Fg

[SpEnrollments]ProgramID

[SpEnrollments]Enter_Date

[SpEnrollments]Exit_Date

1

char

N

38

AL

SpEdFg

Special Education Flag

Indicates student participation in an Individualized Education Plan (IEP/IFSP).   

Calculated based on action codes.

[S_OR_STU_X]SpEdFg =1

1

char

Y

39

AM

Sect504Fg

Section 504 Flag

Indicates student eligibility for Section 504 services

Calculated based on action codes.

[S_OR_STU_X]Sect504Fg =1

1

char

N

40

AN

MigrntEdFg

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.

Calculated based on action codes.

[S_OR_STU_X]MigrntEdFg=1

1

char

Y

41

AO

IndianEdFg

Indian Education Flag

Indicates student participation in a program designed to meet the unique educational and culturally related academic needs of American Indians.

Calculated based on action codes.

[S_OR_STU_X]IndianEdFg=1

1

char

N

42

AP

ELFg

English Learner Flag

Indicates a student who is an English Learner.

Calculated based on action codes.

[S_OR_STU_X]ELFg=1

1

char

N

43

AQ

DstncLrnFg

Distance Learning Flag

Indicates student participation in a distance learning program or a program that includes online coursework.

Calculated based on action codes.

[S_OR_STU_X]DstncLrnFg=1

1

char

N

44

AR

HomeSchlFg

Homeschooling Flag

Indicates that the student is registered to receive homeschool instruction.

Calculated based on action codes.

[S_OR_STU_X]HomeSchlFg=1

1

char

N

45

AS

TrnstnProgFg

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.

Calculated based on action codes.

[S_OR_STU_X]TrnstnProgFg=1

1

char

N

46

AT

AltEdProgFg

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).

Calculated based on action codes.

[S_OR_STU_X]AltEdProgFg=1

1

char

N

47

AU

AmerIndianTrbMbrshpCd

American Indian Tribal Membership Code

Indicates a student having membership in any Federally recognized tribe.

3

char

N

48

AV

TAGFg

Talented and Gifted Flag

Indicates that the student is identified as Academically Talented or Intellectually Gifted as determined by school district policy.

Calculated based on action codes.

[S_OR_STU_X]TAGFg=1

1

char

N

49

AW

AddnLangCd

Additional Language Code

Code indicating any additional language a student uses to communicate that is not the language of origin.

[Student]AddnLangCd

4

varchar

N

50

AX

DemogFill

Demographic Filler

Reserved for future use.

N/A

11

varchar

N

51

AY

IncdntID

Incident Identifier

A unique identifier for each incident of restraint and/or seclusion.

[Incident]IncdntID

10

varchar

Y

52

AZ

IncdntDt

Incident Date

The date the restraint and/or seclusion occurred.  

[Incident]IncdntDt

8

datetime

Y

53

BA

RstrntFg

Restraint Flag

Flag indicating that the incident involved restraint.

Calculated based on action codes.

[S_OR_STU_X]RstrntFg=1

1

char

Y

54

BB

SclsnFg

Seclusion Flag

Flag indicating that the incident involved seclusion.  

Calculated based on action codes.

[S_OR_STU_X]SclsnFg=1

1

char

Y

55

BC

RmLockFg

Room Locked Flag

Flag indicating that seclusion occurred in a locked room.  

Calculated based on action codes.

[S_OR_STU_X]RmLockFg=1

1

char

N

56

BD

UntrndStfFg

Untrained Staff Flag

Flag indicating that at least one staff member administering restraint or seclusion during this incident was not trained.  

Calculated based on action codes.

[S_OR_STU_X]UntrndStfFg=1

1

char

Y

57

BE

StepTkn1Cd

Steps Taken Code 1

Code indicating the steps taken to decrease the use of restraint and seclusion for students restrained or secluded more than 10 times during the school year.

Calculated based on action codes.

3

varchar

N

58

BF

StepTkn2Cd

Steps Taken Code 2

Code indicating the steps taken to decrease the use of restraint and seclusion for students restrained or secluded more than 10 times during the school year.

Calculated based on action codes.

3

varchar

N

59

BG

StepTkn3Cd

Steps Taken Code 3

Code indicating the steps taken to decrease the use of restraint and seclusion for students restrained or secluded more than 10 times during the school year.

Calculated based on action codes.

3

varchar

N

60

BH

StepsTknCmnt

Steps Taken Comment

Comment for additional or "other" steps taken.

Calculated based on action codes.

5000

varchar

N

61

BI

SclsnRmStndrdMetfg

Seclusion Room Standards Flag

Flag indicating the seclusion room meets all standards for seclusion rooms as per OAR 581-021-0568

Calculated based on action codes.

[S_OR_STU_X]SclsnRmStndrdMetfg =1

1

Char

N

62

BJ

InjuryToStdntFg

Injury to Student Flag

Flag indicating that the use of restraint or seclusion resulted in injury of a student.  

Calculated based on action codes.

[S_OR_STU_X]InjuryToStdntFg=1

1

char

Y

63

BK

InjuryToPrsnnlFg

Injury to Personnel Flag

Flag indicating that the use of restraint or seclusion resulted in injury of a staff member.  

Calculated based on action codes.

[S_OR_STU_X]InjuryToPrsnnlFg=1

1

char

Y

64

BL

DthOfStdntFg

Death of Student Flag

Flag indicating that the use of restraint or seclusion resulted in the death of a student.  

Calculated based on action codes.

[S_OR_STU_X]DthOfStdntFg=1

1

char

Y

65

BM

DthOfPrsnnlFg

Death of Personnel Flag

Flag indicating that the use of restraint or seclusion resulted in the death of a staff member.  

Calculated based on action codes.

[S_OR_STU_X]DthOfPrsnnlFg=1

1

char

Y

66

BN

SrsBdlyInjuryStdntFg

Serious Bodily Injury to Student Flag

Flag indicating that the use of restraint or seclusion resulted in the reported serious bodily injury of a student. (Required if Incident Date >= 1/1/2024)

Calculated based on action codes.

[S_OR_STU_X]SrsBdlyInjuryStdntFg=1

1

char

Y

67

BO

SrsBdlyInjuryPrsnnlFg

Serious Bodily Injury to Personnel Flag

Flag indicating that the use of restraint or seclusion resulted in the reported serious bodily injury of a staff member. (Required if Incident Date >= 1/1/2024)

Calculated based on action codes.

[S_OR_STU_X]SrsBdlyInjuryPrsnnlFg=1

1

char

Y