Skip to main content
Skip table of contents

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

Req'd

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

ParticipantTypeThe 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

homicideIndicatorIndicates 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
shootingIndicatorIndicates 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.

studentDisciplineIncidentAssociation

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

Req'd

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

schoolRelatedArrestIndicatorIndicates 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
referralToLawEnforcementIndicates 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
seriousBodilyInjuryIndicates 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
[Incident_LU_Sub_Code]State_Detail_Report_Code

  • DOF: '51'
  • DGW: '54'
  • SBO: '55'
  • SBI: '59'
  • VHB: '59'
  • VPI: '59'
  • VWP: '59'
  • HBS: 'Harassment - Sex'
  • HBR: 'Harassment - Race, Color, National Origin'
  • HBD: 'Harassment - Disability'
  • BBD: '62'
  • BBR: '62'
  • BBS: '62'
  • OSC: '63'
  • PAW: 'Physical Attack or Fight'
  • PWW: Physical Attack or Fight
  • PFE: 'Physical Attack or Fight'
  • RAP: 'Rape or Attempted Rape'
  • RFE: 'Robbery'
  • RAW: 'Robbery'
  • RWW: 'Robbery'
  • SXO: 'Sexual assault other than rape'
  • TPF: 'Threat of Physical Attack'
  • TAW: 'Threat of Physical Attack'
  • TWW: 'Threat of Physical Attack'
  • Otherwise: a value of '58' (Other) is published

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
[Incident_LU_Sub_Code]State_Detail_Report_Code

  • CLU: '01'

  • HGN: '02'

  • KNF: '03'

  • OUN: '04'

  • OFA: '05'

  • OOT: '06'

  • OSO: '07'

  • RSG: '08'

  • SUW: '09'

  • UNK: '10'

  • PKT: '11'

  • EXP: 'Explosive Device'

O

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

Req'd

schoolReference

Reference to the student 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

  • URS: '01'
  • URL: '02'
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
[Incident_LU_Code]Code_Type = ActionChangedCode
[Incident_LU_Code]State_Aggregate_Rpt_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
and [Incident_LU_Code]State_Aggregate_Rpt_Code is not blank

Then derived from:

[Incident_LU_Sub_Code]State_Detail_Report_Code
[Incident_Action_Attribute]Is_Yes1_No0_Attribute
[Incident_LU_Code]State_Aggregate_Rpt_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

  • RFC: '01'
  • ISS: '02'
  • OSS: '03'
  • ENS: '04'
  • URS: '05'
  • URL: '05'
  • EWS: '05'
  • CSS: '06'
  • NAT: '08'
  • NAD: '09'
  • Otherwise: '07'

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

       /participanttypeThe Participant type.
[Incident]Paricipant_Type

/schoolID

The school that is associated with the incident.Integer

[Incident]School_Number

R
JavaScript errors detected

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

If this problem persists, please contact our support.