Student Discipline Data
This category carries information about student discipline incidents. the Student Discipline category includes the following data views and resources:
Discipline Incident
This view captures information about discipline incidents occurring at each school as published in the disciplineIncident resource within the Student Discipline category. The layout includes the School Name, Incident Identifier, Participant Type, Incident Date, Last Publish Date, and the Publishing ID.
disciplineIncident
This event resource represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (for example, a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.
Primary PowerSchool Source Data
[Incident]
Selection Criteria
Records are published if the following criteria are met:
The incident date falls within the year for the Term selected in the PowerSchool UI.
The student must not be excluded from state reporting.
The student must have an active school enrollment.
Resource Output
A separate disciplineIncident record is published for each unique incident that meets the selection criteria.
The disciplineIncident resource is dependent on the prior publishing of the following resource: student
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Required |
|---|---|---|---|---|
schoolReference A reference to the related school resource. | R | |||
/schoolID | The school that is associated with the incident. | Integer | [Incident]School_Number | R |
incidentIdentifier | A locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders. | String | [Incident]Incident_ID | R |
ParticipantType | The Participant type. | [Incident]Paricipant_Type | ||
incidentDate | The month, day, and year on which the incident occurred. | Date/Time | [Incident]Incident_TS | R |
incidentDescription | The description for an incident. | String | [Incident]Title [Incident]Incident_Detail_Desc | O |
homicideIndicator | Indicates if this discipline incident involved a homicide. | Boolean | When [Incident_LU_Code]Code_Type = attributecode and [Incident_LU_Code]State_Aggregate_Rpt_Code = HOM Then published value = 'True' | O |
shootingIndicator | Indicates if the discipline incident involved a shooting. | Boolean | If [Incident_LU_Code]Code_Type = attributecode and [Incident_LU_Code]State_Aggregate_Rpt_Code = FAU Then published value = 'True' | O |
Student Discipline Incidents
This view captures details about student involvement in discipline incidents as published in the studentDisciplineAssociation resource within the Student Discipline category. The layout includes the School Name, Incident Identifier, Participant Type, Incident Date, Last Publish Date, and the Publishing ID.
studentDisciplineIncidentBehaviorAssociation
This association indicates those students who were victims, perpetrators, witnesses, and/or reporters for a discipline incident.
Primary PowerSchool Source Data
[Incident]
[Incident_LU_Code]
Selection Criteria
Records are published if the following criteria are met:
The incident must refer to an incident published in a preceding disciplineIncident resource.
The student must not be excluded from state reporting.
The student must have an active school enrollment.
The incident date falls within the year for the Term selected in the PowerSchool UI.
Resource Output
A separate studentDisciplineIncidentAssociation record is published for each student associated with a reportable incident.
The studentDisciplineIncidentAssociation resource is dependent on the prior publishing of the following resources: student and disciplineIncident.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Required |
/behaviorDescriptor | This descriptor holds the categories of behavior describing a discipline incident. Publishes sate-reportable behaviors associated with the student. | Descriptor | 'select ils1.state_detail_report_code from incident_detail ind1 join incident_lu_code ilc1 on ilc1.lu_code_id = ind1.lu_code_id and ilc1.code_type = 'behaviorcode' and ilc1.state_aggregate_rpt_code is not null join incident_lu_sub_code ils1 on ils1.lu_sub_code_id = ind1.lu_sub_code_id join incident_person_detail ipd1 on ipd1.incident_detail_id = ind1.incident_detail_id join incident_person_role ipr1 on ipr1.incident_person_role_id = ipd1.incident_person_role_id -- studentid/staffid for code_type = behaviorcode and ipr1.studentid = ipr.studentid where ind1.incident_id = inc.incident_id and ils1.is_state_reportable_flg = 1 Note that a default '113' behavior is published where a student does not have a state-reportable behavior but does have a state-reportable action for the incident. | R |
disciplineIncidentReference | ||||
incidentIdentifier | Incident Identifier | String | inc.incident_id | R |
schoolId | State-assigned school id | String | inc.school_number | R |
studentReference | ||||
studentUniqueId | State-assigned number for student (s.state_studentnumber) | String | Derived from ipr.studentid | R |
behaviorDetailedDescription | Behavior description | String | N/A | |
disciplineIncidentParticipationCodes | As per Discipline Incident Participant code descriptor | O | ||
disciplineIncidentParticipationCodeDescriptor | Descriptor | Derived from Ilc.incident_category When ilc.incident_category = 'Victim' then publish 'Victim', when 'Offender' then publish 'Perpetrator' | R | |
NE extensions | ||||
gunFreeSchoolViolation | Indicate | String | Publishes if the incident has 'GFV' attribute code (Gun-Free School Violation) and student is offender and has a gun weapon code: state_aggregate_rpt_code in ('HGN', 'OFA', 'RSG'), published as weapon code '02', '05', '08' when exists (select 'y' from incident_detail ind1 join incident_lu_code ilc1 on ilc1.lu_code_id = ind1.lu_code_id | R |
referralToLawEnforcement | NE | Publishes if student has action code in ('SRA', 'LER') when exists (select 'y' from incident_action iac incident_person_action ipa on ipa.incident_action_id = iac.incident_action_id join incident_detail ind2 on ind2.incident_detail_id = iaa.incident_detail_id |
| |
schoolRelatedArrestIndicator | NE | Publishes if student has action code = 'SRA' (school-related arrest) when exists (select 'y' from incident_action iac and iac.incident_id = inc.incident_id | R | |
seriousBodilyInjury | NE | Publishes if student has Code: SBD & subcode: SBD_Y behavior detail code when exists (select 1 from incident_detail ind1 | ||
weapons | ||||
weaponDescriptor | Publishes all weapons associated with student for incident. | NE | select ils1.state_detail_report_code from incident_object iob | R |
Additional fields | ||||
sch.school_name | view only | |||
s.student_number | view only | |||
s.lastfirst | view only | |||
inc.incident_ts | trunc(inc.incident_ts,'DD' |
Student Discipline Action
This view captures information about the disciplinary actions associated with incidents and students as published in the disciplineAction resource within the Student Discipline category. The layout includes the School Name, Incident Identifier, Participant Type, Incident Date, Last Publish Date, and the Publishing ID.
disciplineAction
This event resource represents actions taken by an education organization after a disruptive event that is recorded as a discipline incident.
Primary PowerSchool Source Data
[Incident_Action]
Selection Criteria
Records are published if the following criteria are met:
The discipline action record must refer to an incident published in a preceding disciplineIncident and studentDisciplineIncidentAssociation resources.
The studentUniqueId is populated in PowerSchool.
The student must not be excluded from state reporting.
The student must have an active school enrollment.
The incident and discipline action dates fall within the year for the Term selected in the PowerSchool UI.
Resource Output
A separate disciplineAction record is published for each reportable disciplinary action associated with a published student and incident.
The disciplineAction resource is dependent on the prior publishing of the following resources: student, disciplineIncident, and studentDisciplineIncidentAssociation.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Required |
|---|---|---|---|---|
schoolReference Reference to the school associated with the discipline incident. | R | |||
/responsibilitySchoolID | The school responsible for student's discipline. | Integer | SchoolID downloaded from State Derived from: [Schools]SchoolID | R |
studentReference Reference to the student associated with the discipline incident. | R | |||
/studentUniqueID | A unique alphanumeric code assigned to a student. | String | Derived from: [Students]State_StudentNumber | R |
identifier | Identifier assigned by the education organization to the discipline action. | String | [Incident_Action]Incident_Action_ID | R |
disciplineDate | Month, day, and year of the discipline action. | Date/Time | [Incident_Action]Action_Plan_Begin_DT | R |
length | The length of time in school days for the Discipline Action, for example, removal or detention, if applicable. | Integer | [Incident_Action]Duration_Assigned Rounded to whole number | O |
actualDisciplineActionLength | Indicates the actual length in school days of a student's disciplinary assignment. | Integer | [Incident_Action]Duration_Actual Rounded to whole number | O |
lengthDecimal | The length of time in partial school days for the discipline action. | Number | Calculated from: [Incident_Action]Duration_Actual and [Incident_Action]Duration_Assigned Where [Calendar_Day]InSession = 1 and [Calendar_Day]Date_Value is between [Incident_Action]Action_Plan_Begin_DT and [Incident_Action]Action_Plan_End_DT | O |
unilateralRemovalDescriptor | For SPED students only who were were subject to Unilateral Removal. Refer to Incident Management: Action Subcodes for more information. | String | [Incident_LU_Sub_Code]State_Detail_Report_Code
| O |
gfsaExpModToLessThanOneYear | Indicates if a student who was expelled under GFSA had the expulsion modified to less than one year. | Boolean | If [Incident_LU_Code]Code_Type = objectcode and [Incident_LU_Code]State_Aggregate_Rpt_Code is not blank Then derived from: [Incident_LU_Sub_Code]State_Detail_Report_Code If the Object code equals HGN (Handgun), OFA (Other Firearm), or RSG (Rifle/Shotgun) AND the Action Change code equals EMY (Expulsion Modified to < One Year (GFSA)) Then published value = 'True' Otherwise, published value = 'False' | O |
gfsaAlternativePlacement | Indicates of a student who was expelled under GFSA received Alternative Placement. | Boolean | If [Incident_LU_Code]Code_Type = objectcode Then derived from: [Incident_LU_Sub_Code]State_Detail_Report_Code If the Object code equals HGN (Handgun), OFA (Other Firearm), or RSG (Rifle/Shotgun) AND The Action code equals either EWS (Expulsion with Services) or ULR (Unilateral Removal) OR the Action Attribute code equals ALP (Alternative Placement) Then published value = 'True' Otherwise, published value = 'False' | O |
disciplineDescriptor | The type of action, such as removal from the classroom, used to discipline the student involved as a perpetrator in a discipline incident. | Descriptor | [Incident_LU_Sub_Code]State_Detail_Report_Code
| O |
disciplineIncidentReference Reference to the disciplineIncident associated with the disciplineAction. | ||||
/incidentIdentifier | A locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders. | String | [Incident]Incident_ID | R |
/participanttype | The Participant type. | [Incident]Paricipant_Type | ||
/schoolID | The school that is associated with the incident. | Integer | [Incident]School_Number | R |
studentDisciplineIncidentNonOffenderAssociation
This association indicates those students who were Non-offenders.
Primary PowerSchool Source Data
[Incident]
[Incident_LU_Code]
Selection Criteria
Publishes one record for each incident/student combination where:
The incident is published if
Incident has at least one offender
Only Non-offenders information to be published
Enrolled student is a victim where the incident has a state-reportable behavior.
The student must not be excluded from state reporting.
The student must have an active school enrollment.
The incident date falls within the year for the Term selected in the PowerSchool UI.
Resource Output
Publishes one record for each incident where:
The incident occurred during the selected school year
There was an associated offender who was enrolled in the district during the year
There was either a state-reported behavior or a state-reported action
Incident category (ilc.incident_category) = 'Nebraska State Reporting^'
The Discipline Incident Non Offender resource is dependent on the prior publishing of the following resources: student and disciplineIncident.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Required |
disciplineIncidentReference | ||||
Reference to the disciplineIncident associated with the disciplineAction. | ||||
/incidentIdentifier | A locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders. | String | [Incident]Incident_ID | R |
/participanttype | The Participant type. | [Incident]Paricipant_Type | ||
/schoolID | The school that is associated with the incident. | Integer | [Incident]School_Number | R |
studentReference | ||||
Reference to the student associated with the discipline incident. | ||||
disciplineIncidentParticipationCodes | ||||
String | [Incident]Incident_ID | Y | ||
State-assigned school id | Integer | [Schools]SchoolID | Y | |
Y | ||||
State-assigned number for student (s.state_studentnumber) | Integer | [Student]UniqueId | Y | |
restraintEvents
This event entity represents the instances where a student was physically or mechanically restrained due to imminent serious physical harm to themselves or others, imminent serious property destruction, or a combination of both imminent serious physical harm to themselves or others and imminent serious property destruction.
Primary PowerSchool Source Data
[Incident]
[Incident_LU_Code]
Selection Criteria
Records are published if the following criteria are met:
Publishes all restraint/seclusion events for enrolled students during school year:
ilc.incidenttypecode = 'Nebraska State Reporting^' (same as discipline)
State aggregate code = 'SEC' or 'RES'
Resource Output
A separate restraintevent record is published for each student associated with a reportable incident.
The restraintevent resource is dependent on the prior publishing of the following resources: student and disciplineIncident.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Tables: INCIDENT (inc), INCIDENT_DETAIL (ind), INCIDENT_LU_CODE (ilc), INCIDENT_PERSON_ROLE (ipr), INCIDENT_PERSON_DETAIL (ipd), INCIDENT_ACTION (iac), INCIDENT_PERSON_ACTION (ipa), INCIDENT_OBJECT (iob), STUDENTS (s)
Data Element | Description | Data Type | Stored in [Table]Field | Required |
restraintEventIdentifier | A unique number or alphanumeric code assigned to a restraint event by a school, school system, a state, or other agency or entity. | String | [Incident]Incident_ID | R |
/schoolID | The school that is associated with the incident. | Integer | [Incident]School_Number | R |
studentUniqueId | State-assigned number for student | Integer | [s.state]studentnumber) | R |
eventDate | Incident action start date. | [Incident]iac.action_plan_begin_dt | R | |
NE extensions | ||||
restraintCategories | [Array] | |||
restraintCategoryDescriptor | Event Type | Descriptor | derived from state aggregate and detail report codes: | |
Additional fields (Read only | ||||
School Name | String | [School]School_Name | ||
Student Number | Integer | [Student]student_number | ||
Student Name(Last name first name) | String | [Student]lastfirst |
studentDisciplineIncidentAssociation (Deprecated)
This resource is deprecated as of PS State Reporting Version 24.3.1.0.
This association indicates those students who were victims, perpetrators, witnesses, and/or reporters for a discipline incident.
Primary PowerSchool Source Data
[Incident]
[Incident_LU_Code]
Selection Criteria
Records are published if the following criteria are met:
The incident must refer to an incident published in a preceding disciplineIncident resource.
The student must not be excluded from state reporting.
The student must have an active school enrollment.
The incident date falls within the year for the Term selected in the PowerSchool UI.
Resource Output
A separate studentDisciplineIncidentAssociation record is published for each student associated with a reportable incident.
The studentDisciplineIncidentAssociation resource is dependent on the prior publishing of the following resources: student and disciplineIncident.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Required |
|---|---|---|---|---|
disciplineIncidentReference Reference to the discipline incident associated with the student. | R | |||
/incidentIdentifier | A locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders. | String | [Incident]Incident_ID | R |
studentReference Reference to the student associated with the discipline incident. | R | |||
/studentIdentity | Relates the student associated with the discipline incident. | Integer | Derived from: [Students]State_StudentNumber | R |
studentParticipationCode | The role or type of participation of a student in a discipline incident, for example, Victim, Perpetrator, Witness, Reporter. Defaults to Perpetrator. | String | Published value = 'Perpetrator' | R |
gunFreeSchoolViolation | Identifies if a gun was used during the incident. | Boolean | When [Incident_LU_Code]Code_Type = attributecode and [Incident_LU_Code]State_Aggregate_Rpt_Code = GFV and When [Incident_LU_Code]Code_Type = objectcode and [Incident_LU_Code]State_Aggregate_Rpt_Code = HGN, OFA, or RSG Then published value = 'True' | O |
schoolRelatedArrestIndicator | Indicates if student was involved in a disciplinary incident that resulted in an arrest. | Boolean | When [Incident_LU_Code]Code_Type = actioncode and [Incident_LU_Code]State_Aggregate_Rpt_Code = SRA or When [Incident_LU_Code]Code_Type = actionattribute and [Incident_LU_Code]State_Aggregate_Rpt_Code = AAR Then published value = 'True' | O |
referralToLawEnforcement | Indicates if a student was referred to law enforcement. | Boolean | When [Incident_LU_Code]Code_Type = actioncode and [Incident_LU_Code]State_Aggregate_Rpt_Code = SRA or LER or When [Incident_LU_Code]Code_Type = actionattribute and [Incident_LU_Code]State_Aggregate_Rpt_Code = AAR or PNO Then published value = 'True' | O |
seriousBodilyInjury | Indicates if student was involved in a serious bodily injury incident that resulted in an arrest. | Boolean | When [Incident_LU_Code]Code_Type = actioncode and [Incident_LU_Code]State_Aggregate_Rpt_Code = SRA or LER or When [Incident_LU_Code]Code_Type = actionattribute and [Incident_LU_Code]State_Aggregate_Rpt_Code = AAR or PNO Then published value = 'True' | |
behavior (1-many) Describes behavior by category and provides a detailed description. | R | |||
/behaviorDescriptor | This descriptor holds the categories of behavior describing a discipline incident. | Descriptor | When [Incident_LU_Code]Code_Type = behaviorcode and [Incident_LU_Code]State_Aggregate_Rpt_Code is not blank then derived from: [IncidentDetail]LU_Sub_Code_ID and
| R |
weaponDescriptor | Identifies the type of weapon used during an incident. The Federal Gun-Free Schools Act requires states to report the number of students expelled for bringing firearms to school by type of firearm. Note: Only published if the value is not blank. | Descriptor | When [Incident_LU_Code]Code_Type = objectcode and [Incident_LU_Code]State_Aggregate_Rpt_Code is not blank then derived from: [IncidentObject]Incident_Object_ID and
| O |