Student Discipline Data
This category carries information about student discipline incidents and disciplinary actions as published within the Student Discipline category.
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, 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
[Log]
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 incidentTypeCategory value is between '17' and '38'.
The Discipline_ActionTaken value equals 'I', 'R', 'S', or 'E'.
Resource Output
A separate disciplineIncident record is published for each unique incident that meets the selection criteria.
If applicable, multiple behaviors may be reported in the same record.
The disciplineIncident resource is dependent on the prior publishing of the following resources: student.
If the record contains a staffReference, the resource is also dependent on the prior publishing of the staff member in the Staff resource.
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 | Req'd |
|---|---|---|---|---|
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. | Varchar(20) | [Log]DCID | M |
incidentDate | The month, day, and year on which the incident occurred. | Date | [Log]EntryDate | R |
incidentTime | An indication of the time of day the incident took place. | Time/DateTime (hh;mm) | [Log]Entry_Time | O |
incidentLocation | Identifies where the incident occurred and whether or not it occurred on campus, for example, On campus, Administrative offices area, Cafeteria area, Classroom, Hallway, or stairs. | Enumerated List | [Log]Discipline_IncidentLocation C: 'On campus' O: 'Off campus' OFF: 'Off campus' T: 'Walking to or from school' Else: 'Unknown' | R |
incidentDescription | The description for an incident. | Varchar(1024) | [Log]Entry | O |
reporterName | Identifies the reporter of the incident by name. | Varchar(75) | [Log]Discipline_Reporter | O |
behavior (1-many) Describes behavior by category and provides a detailed description. | R | |||
/behaviorDescriptor | Refer to Behavior Descriptor Codes for information about behavior codes and their descriptions. | String(Descriptor) | Derived from: [Log]DisciplineIncidentTypeCategory | M |
weapon | 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. | Descriptor | Derived from: [Log]DisciplineIncidentTypeCategory 18: 'Handgun' 19: 'Rifle/Shotgun' 21: 'Other Firearm' Else: 'Other' | O |
reportedToLawEnforcement | Indicator of whether the incident was reported to law enforcement. | Boolean | [Log]Discipline_PoliceInvolvedFlag | O |
schoolReference/schoolIdentity | Relates the incident to the school where the incident occurred. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
staffReference/staffUniqueId | Identifies the staff reporter of the incident by use of a pre-existing school or district unique identifier. | Integer | [CST_PubUniqueIdStaff]UniqueId Derived from: [S_TN_LOG_X]StaffAssociateID If blank: [LOG]TeacherId (if non-zero) | O |
Student Discipline Incidents
This view captures details about student involvement in discipline incidents as published in the StudentDiscipline Association resource within the Student Discipline category. The layout includes the School Name, Student Number, Student Name, Incident Identifier, Incident Date, Behavior Type Category, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentDisciplineIncidentAssociation
This association indicates those students who were victims, perpetrators, witnesses, and/or reporters for a discipline incident.
Primary PowerSchool Source Data
[Log]
[Students]
Selection Criteria
Records are published if the following criteria are met:
The incident must refer to an incident published in a preceding DisciplineIncident resource.
StudentUniqueId is populated in PowerSchool.
The student must not be excluded from state reporting.
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.
Based on studentParticipationCode, included students may have a role of Perpetrator, Victim, or Witness.
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 | Req'd |
|---|---|---|---|---|
studentReference/studentUniqueId | Relates the student associated with the discipline incident. | Integer | StudentUniqueId downloaded from State Derived from: [Log]StudentID linked to [Students]DCID | M |
disciplineIncidentReference/disciplineIncidentIdentity Reference to the discipline incident associated with the student. | M | |||
/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. | Varchar(20) | [Log]DCID | M |
/schoolReference/ | Relates the incident to the school where the incident occurred. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
studentParticipationCodeDescriptor | The role or type of participation of a student in a discipline incident, for example, Victim, Perpetrator, Witness, Reporter. | Enumerated List | Derived from: [S_TN_LOG_CRDC_X]DiscHarassOffender_YN If value is not blank: 'Perpetrator' [S_TN_LOG_CRDC_X]DiscHarassVictim_YN If value is not blank: 'Victim' Else: 'Witness' | R |
behavior (1-many) Describes behavior by category and provides a detailed description. | R | |||
/behavior | This descriptor holds the categories of behavior describing a discipline incident. | Descriptor | Derived from: [Log]DisciplineIncidentTypeCategory 17, 18, 19, 20, 21, 22, 27, 37, or 38: 'State Offense' 23, 25, 26, 30, 31, 32, 33, 34, 35, or 36: 'School Violation' 24 or 29: 'School Code of Conduct' Else: 'Other' | M |
studentDisciplineIncidentBehaviorAssociation
This association describes the behavior of students involved in a discipline incident.
Primary PowerSchool Source Data
[Log]
[Students]
Selection Criteria
Records are published if the following criteria are met:
The incident must refer to an incident published in a preceding DisciplineIncident resource.
StudentUniqueId is populated in PowerSchool.
The student must not be excluded from state reporting.
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.
Based on studentParticipationCode, included students may have a role of Perpetrator, Victim, or Witness.
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 | Req'd |
|---|---|---|---|---|
studentReference/studentUniqueId | Relates the student associated with the discipline incident. | Integer | StudentUniqueId downloaded from State Derived from: [Log]StudentID linked to [Students]DCID | M |
/behaviorDescriptor | Refer to Behavior Descriptor Codes for information about behavior codes and their descriptions. | String(Descriptor) | Derived from: [Log]DisciplineIncidentTypeCategory | M |
disciplineIncidentReference/disciplineIncidentIdentity Reference to the discipline incident associated with the student. | M | |||
/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. | Varchar(20) | [Log]DCID | M |
/schoolYear | The identifier for the school year, for example, 2010-2011. | Integer | [Terms]YearID | M |
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, Student Number, Student Name, Incident Identifier, Incident Date, Action Taken, Ed-Fi Unique ID, 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
[Log]
[S_TN_LOG_X]
[Students]
Selection Criteria
Records are published if the following criteria are met:
The discipline action record must refer to an incident published in the disciplineIncident and studentDisciplineIncidentAssociation resources.
StudentUniqueId is populated in PowerSchool.
The student must not be excluded from state reporting.
The incident and discipline action dates fall within the year for the Term selected in the PowerSchool UI.
The incident includes at least one state-reportable discipline type.
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 | Req’d |
disciplineActionIdentifier | Identifier assigned by the education organization to the discipline action. | Varchar(20) | [Log]DCID | M |
disciplineDescriptor | Type of action, such as removal from the classroom, used to discipline the student involved as a perpetrator in a discipline incident. Refer to Disciplinary Action Type Codes for information about behavior codes and their descriptions. | Descriptor | [Log]Discipline_ActionTaken | M |
disciplineDate | Month, day, and year of the discipline action. | Date | [Log]Discipline_ActionDate | M |
disciplineActionLength | The length of time in school days for the Discipline Action, for example, removal or detention, if applicable. | Integer | [Log]Discipline_DurationAssigned Rounded to whole number | O |
actualDisciplineActionLength | Indicates the actual length in school days of a student’s disciplinary assignment. | Integer | [Log]Discipline_DurationActual Rounded to whole number | O |
disciplineActionLengthDifferenceReason | Indicates the reason for the difference, if any, between the official and actual lengths of a student's disciplinary assignment. | Integer | Derived from: [Log]DurationChangeSource If contains ‘district’ or = ‘d’: ‘Term Modified By District’ If contains ‘court’ or = ‘c’: ‘Term Modified By Court Order’ If contains ‘agreement’ or = ‘a’: ‘Term Modified By Mutual Agreement’ If contains ‘complet’ or = ‘e’: ‘Student Completed Term Requirements Sooner Than Expected’ If contains ‘incarcerated’: ‘Student Incarcerated’ If contains ‘health’: ‘Term Decreased Due To Extenuating Health-Related Circumstances’ If contains ‘withdr’: ‘Student Withdrew From School’ If contains 'year end’: ‘School Year Ended’ If contains ‘continu’: ‘Continuation Of Previous Year’s Disciplinary Action Assignment’ If contains ‘behavior’: ‘Term Modified By Placement Program Due To Student Behavior While In The Placement’ If contains ‘no diff’: ‘No Difference’ Else: ‘Other’ | O |
relatedToZeroTolerancePolicy | An indication of whether or not this disciplinary action taken against a student was imposed as a consequence of state or local zero tolerance policies. | Boolean | Derived from: [S_TN_LOG_X]ZeroTolerance_YN 1: ‘True’; else ‘False’ | O |
specialEdModifiedIndicator | An indication of whether or not the action was modified based on special education status of the student. | Varchar(1) | [S_TN_LOG_X]ModifiedAction_YN This element is published only when the value = ‘Y’. | |
specialEdAuthority | Indicates authority for removal of a special education student. | Descriptor | [S_TN_LOG_X]DisciplinaryActAuthority 1: ‘Removal by hearing officer’ 3: ‘IEP Team Decision’ | |
assignment/schoolReference/SchoolId | Optional school where student is transferred for discipline. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | O |
studentReference/studentIdentity | The student(s) disciplined by the discipline action. | Integer | StudentUniqueId downloaded from State Derived from: [Log]StudentID linked to [Students]DCID | M |
disciplineIncidentReference/disciplineIncidentIdentity Reference to the DisciplineIncident associated with the DisciplineAction. | M | |||
/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. | Varchar(20) | [Log]DCID | M |
/schoolReference/ | Relates the incident to the school where the incident occurred. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
responsibilitySchoolReference/ | School responsible for student’s discipline. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | R |