Skip to main content
Skip table of contents

Student Discipline

This category carries information about student discipline incidents and disciplinary actions as published within the Student Discipline category. 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, Incident Date, Last Publish Date, and Publishing ID.

disciplineIncidents

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 a disciplinary action.

Primary PowerSchool Source Data

  • [INCIDENT]
  • [INCIDENT_DETAIL]
  • [INCIDENT_LU_CODE]
  • [INCIDENT_LU_SUB_CODE]

Selection Criteria

Records are published if the following criteria are met:

  • The school where the incident occurred must not be excluded from state reporting.
  • The incident date falls within the year for the Term selected in the PowerSchool UI.
  • The incident includes at least one state-reportable Behavior based on the district's BehaviorDescriptor Ed-Fi mapping.

Resource Output

  • A separate DisciplineIncident record is published for each unique incident based on IncidentIdentifier that contains at least one reportable Behavior code.
  • The DisciplineIncident resource is dependent on the prior publishing of the following entities: Student
  • LEAs and Schools may upload (publish) data to the Ed-Fi 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.

String

[INCIDENT]incident_id

R

schoolReference

      /schoolID

Relates the incident to the school where the incident occurred.

Integer

[INCIDENT]School_Number

Where [INCIDENT_LU_CODE]code_type = locationcode

R

incidentDate

The month, day, and year on which the incident occurred. Format - YYYY-MM-DD.

Date

[INCIDENT]incident_ts

R

behaviors
       /behaviorDescriptorThe category of behavioral incident being recorded.

[INCIDENT_LU_CODE]code_type = behaviorcode

[INCIDENT_LU_CODE]state_aggregate_rpt_code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '001' then use [INCIDENT_LU_CODE]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '012' then use [INCIDENT_LU_CODE]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '027' then use [INCIDENT_LU_CODE]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '230' then use [INCIDENT_LU_CODE]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '271' then use [INCIDENT_LU_CODE]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '650' then use [INCIDENT_LU_CODE]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = '651' then use [INCIDENT_LU_CODE]State_Detail_Report_Code

R
      /behaviorDetailedDescriptionDetails related to the behavioral incident being recorded, such as the time and place of the incident.
[INCIDENT_LU_CODE]incident_category
weapons
    /weaponDescriptorThe type of weapon or object involved in the incident.

[INCIDENT_LU_CODE]code_type = objectcode

[INCIDENT_LU_CODE]state_aggregate_rpt_code = 'OBJ'
[INCIDENT_LU_CODE]state_aggregate_rpt_code = 'WEA' then use [INCIDENT_LU_SUB_Code]State_Detail_Report_Code
[INCIDENT_LU_CODE]state_aggregate_rpt_code = 'DSF' then use [INCIDENT_LU_SUB_Code]State_Detail_Report_Code

R
incidentCostThe overall financial impact.
[INCIDENT]FINANCIAL_IMPACT
incidentTimeThe time of the incident.
[INCIDENT_LU_CODES]LU_Code_ID= 101260 or 101261 then [INCIDENT_LU_SUB_CODE]SUB_CATEGORY

studentDisciplineIncidentBehaviorAssociation

This association indicates the student's behavior related to the discipline incident.

Primary PowerSchool Source Data

  • [INCIDENT]
  • [INCIDENT_LU_CODE]
  • [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 school where the incident occurred must not be excluded from state reporting.
  • The incident includes at least one state-reportable Behavior based on the district's BehaviorDescriptor Ed-Fi mapping.
  • 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, Witness, or Reporter.
  • The StudentDisciplineIncidentAssociation resource is dependent on the prior publishing of the following entities: Student and DisciplineIncident.
  • LEAs and Schools may upload (publish) data to the Ed-Fi 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

behaviorDescriptorThe category of behavioral incident being recorded.

where [INCIDENT_LU_CODE]code_type is behaviorcode
 match using [INCIDENT_LU_CODE]LU_CODE_ID on [INCIDENT_LU_SUB_Code]LU_CODE_ID

INCIDENT_LU_CODE.state_aggregate_rpt_code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '001' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '012' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '027' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '230' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '271' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '650' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code
 INCIDENT_LU_CODE.state_aggregate_rpt_code = '651' then use INCIDENT_LU_SUB_Code.State_Detail_Report_Code


disciplineIncidentReference
  /incidentIdentifierA 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.
[INCIDENT]incident_id
  /schoolID

Relates the incident to the school where the incident occurred.




studentReference
   /studentUniqueIdState-assigned unique identifier to the student associated with the discipline incident.
[STUDENTS]state_studentnumber based on [INCIDENT_PERSON_ROLE]studentid
behaviorDetailedDescriptionSpecifies a more granular level of detail of the behavior involved in the incident.
[INCIDENT_LU_CODE]incident_category
disciplineIncidentParticipationCodes

Indicates the type of student's participation in a discipline incident.

Valid values:

  • Perpetrator
  • Victim
  • Reporter
  • Witness
  • blank

Case INCIDENT_LU_CODE.incident_category
  when 'Offender' then 'Perpetrator'
  when 'Victim' then 'Victim'
  when 'Reporter' then 'Reporter'
  when 'Witness' then 'Witness'
  else null

Students Discipline 

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, Incident Type, State Student Number, Last Publish Date, and Publishing ID.

studentDisciplineIncidentAssociations

This association indicates those students who were victims, perpetrators, witnesses, and/or reporters for a discipline incident.

Primary PowerSchool Source Data

  • [INCIDENT]
  • [INCIDENT_DETAIL]
  • [INCIDENT_LU_CODE]
  • [INCIDENT_LU_SUB_CODE]
  • [INCIDENT_PERSON_ROLE]
  • [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 school where the incident occurred must not be excluded from state reporting.
  • The incident includes at least one state-reportable Behavior based on the district's BehaviorDescriptor Ed-Fi mapping.
  • 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 the role of Perpetrator, Victim, Witness, or Reporter.
  • The StudentDisciplineIncidentAssociation resource is dependent on the prior publishing of the following entities: Student and DisciplineIncident.
  • LEAs and Schools may upload (publish) data to the Ed-Fi 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

   /studentUniqueIdState-assigned unique identifier to the student associated with the discipline incident.
[STUDENTS]state_studentnumber based on [INCIDENT_PERSON_ROLE]studentidR

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

/schoolID

Relates the incident to the school where the incident occurred.

Integer


R

studentParticipationCodeType

The role or type of participation of a student in a discipline incident, for example, Victim, Perpetrator, Witness, Reporter.

Valid values:

  • Offender (Perpetrator)
  • Victim
  • Reporter
  • Witness

Type

[INCIDENT_LU_CODE]incident_category

R

behaviors
Describes behavior by category and provides a detailed description.

O

/behaviorDescriptor

This descriptor holds the categories of behavior describing a discipline incident.

Descriptor

[INCIDENT_LU_CODE]state_aggregate_rpt_code


/behaviorDetailedDescription

Specifies a more granular level of detail of the behavior involved in the incident.

String

[INCIDENT_LU_CODE]incident_category


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, State Student Number, Last Publish Date, and 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]
  • [INCIDENT_ACTION]
  • [INCIDENT_PERSON_ACTION]
  • [INCIDENT_PERSON_ROLE]
  • [INCIDENT_PERSON_DETAIL]
  • [INCIDENT_DETAIL]
  • [INCIDENT_LU_CODE]
  • [STUDENTS]

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 entities.
  • StudentUniqueId is populated in PowerSchool.
  • The student must not be excluded from state reporting.
  • The school where the incident occurred 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 based on the district's DisciplineDescriptor Ed-Fi mapping.

Resource Output

  • A separate DisciplineAction record is published for each reportable action associated with at least one student for the incident for up to three actions per student, per incident.
  • The DisciplineAction resource is dependent on the prior publishing of the following entities: Student, DisciplineIncident, and StudentDisciplineIncidentAssociation.
  • LEAs and Schools may upload (publish) data to the Ed-Fi 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

studentUniqueId

The students disciplined by the discipline action.

String

[Students]State_StudentNumber based on [INCIDENT_PERSON_ROLE]studentid

R

disciplineDate

Month, day, and year of the discipline action.

Date

[INCIDENT_ACTION]action_plan_begin_dt

R

disciplineActionIdentifier 

Identifier assigned by the education organization to the discipline action.

String

[INCIDENT_ACTION]incident_action_id

R

responsibilitySchoolReference

    /schoolID

State-assigned number for school where student was enrolled.

Integer


R

disciplines

  /disciplineDescriptors

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_CODE]state_aggregate_rpt_code

O

studentDisciplineIncidentAssociationReference

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

[INCIDENT_ACTION]incident_id


/schoolID

Relates the incident to the school where the incident occurred.

Integer

[STUDENTS]state_studentnumber based on [INCIDENT_PERSON_ROLE]studentid


       /studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.


[STUDENTS]state_studentnumber based on [INCIDENT_PERSON_ROLE]studentid
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.