Restraint and Seclusion Incidents File Layout
Following is the file layout and database mapping for the student discipline-level Restraint and Seclusion Incidents submission file created through the OR Student Download and OR Student Submission Files options.
Data Element Name | Field Length | Required | Zero Padded | Download Table.Column | Download Table.Column | Where in eSchoolPlus? |
|---|---|---|---|---|---|---|
Incident Identifier | 10 | Y | N | disc_incident.incident_id | or_rest_sec_inc_down.incident_id | Incident Detail > Incident panel: Incident ID |
Incident Date | 8 | Y | Y | disc_incident.incident_date | or_rest_sec_inc_down.incident_date | Incident Detail > Incident panel: Date |
Restraint Flag | 1 | Y | N | Report as Y if disc_off_action.action_code is the same as any value in state_ocr_dist_disc.disc_code where disc_code_id = PRSNT and code_or_subcode = C. or Report as Y if disc_off_subcode.offense_subcode is the same as any value in state_ocr_dist_disc.disc_code where disc_code_id = PRSNT and code_or_subcode = S. Otherwise, report N. | or_rest_sec_inc_down.restraint_flag | For the Action Code, incident Detail > Offenders panel > click appropriate offender name > Offense Actions section: Action Code For the offender's Category code, Incident Detail > Offenders panel > click View Detail for the appropriate offender > General panel: Categories For the OCR District Setup, Regulatory > Civil Rights Data Collection > Setup > OCR District Setup > Discipline panel: Physical Restraint Action Codes and Categories |
| Seclusion Flag | 1 | Y | N | Report as Y if disc_off_action.action_code is the same as any value in state_ocr_dist_disc.disc_code where disc_code_id = SECLN and code_or_subcode = C. or Report as Y if disc_off_subcode.offense_subcode is the same as any value in state_ocr_dist_disc.disc_code where disc_code_id = SECLN and code_or_subcode = S. Otherwise, report N. | or_rest_sec_inc_down.seclusion_flag | For the Action Code, incident Detail > Offenders panel > click appropriate offender name > Offense Actions section: Action Code For the offender's Category code, Incident Detail > Offenders panel > click View Detail for the appropriate offender > General panel: Categories For the OCR District Setup, Regulatory > Civil Rights Data Collection > Setup > OCR District Setup > Discipline panel: Seclusion Action Codes and Categories |
| Room Locked Flag | 1 | N | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 3 | or_rest_sec_inc_down.room_lock_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Seclusion in a Locked Room |
| Untrained Staff Flag | 1 | Y | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 1 | or_rest_sec_inc_down.untrained_staff_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Involving Untrained Staff |
| Steps Taken Code 1 | 3 | N | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 4 | or_rest_sec_inc_down.steps_taken_code_1 | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Steps Taken Code 1 |
| Steps Taken Code 2 | 3 | N | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 5 | or_rest_sec_inc_down.steps_taken_code_2 | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Steps Taken Code 2 |
| Steps Taken Code 3 | 3 | N | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 6 | or_rest_sec_inc_down.steps_taken_code_3 | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Steps Taken Code 3 |
| Steps Taken Comment | 5000 | N | N | Concatenation of disc_user.field_value where screen_type = O, screen_number = 222, and field_number is in 27 through 46 | or_rest_sec_inc_down.steps_taken_comment | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Steps Taken Comment 1 through 20 |
| Seclusion Room Standards Flag | 1 | N | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 47 This flag cannot be blank when Seclusion Flag = Y | or_rest_sec_inc_down.seclusion_room_standards_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Seclusion in a Locked Room and meets all standards as per OAR 581-021-0568 |
| Injury to Student Flag | 1 | Y | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 48 | or_rest_sec_inc_down.injury_to_student_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Resulting in Injury to Student |
| Injury to Personnel Flag | 1 | Y | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 49 | or_rest_sec_inc_down.injury_to_personnel_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Resulting in Injury to Personnel or staff member |
| Death of Student Flag | 1 | Y | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 50 | or_rest_sec_inc_down.death_of_student_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Resulting in Death of Student |
| Death of Personnel Flag | 1 | Y | N | disc_user.field value where screen type = 'O' and screen_number = 222 and field_number = 51 | or_rest_sec_inc_down.death_of_personnel_flag | Incident Detail > Offenders panel > click View Detail for the appropriate offender > Other Offender Information panel > OR Physical Restraint and Seclusion: Resulting in Death of Personnel or staff member |