Skip to main content
Skip table of contents



Report Description

This file is used to submit data describing offenders involved in disciplinary incidents.

Report Input 

For help with navigation and running the report, see How to Find and Generate a Report.  



Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Select Students

Choose one of the following:

  • The Selected [x] Students Only – Run the report for students in the current selection.
  • All Students – Run the report for all students in the current school or district.

Start Date

Enter the start date for the report date range.

End Date

Enter the end date for the report date range.

File Path

Enter the file path. If applicable, select the associated checkbox to save as the default value.
Data Collection Name

Choose the applicable Data Collection from the pop-up menu.

  • 03_NightlyCollection_Unofficial
  • 04_YearEndCollection_Official
SFTP ConnectionsChoose a selection from the pop-up menu. The default value is Disable.

Report Output 

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table. 

Item #

Data Element



Field Type

Field Length

 1ADMINIDThe district's SU/SD ID.


 2OFF_IDNUMOffender ID number by school[PSRW_IncidentParticipant]IDNumber10
 3INCIDENT_NUMThe incident ID.[PSRW_IncidentParticipant]Incident_IDNumber15
 4ENRORGIDThe enrolling org ID.[S_VT_Schools_X]EnrOrgIDString6
 5OFF_LASTNAMEThe offender's last name.[PSRW_IncidentParticipant]Last_NameString36
 6OFF_FIRSTNAMEThe offender's first name.


 7OFF_MNAMEThe offender's middle name.



The offender's date of birth.

Note: MM/DD/YYYY format.


 9OFF_GRADEThe offender's grade level.


 10OFF_GENDERThe offender's gender.


 11 OFF_TYPECode set for type of offender.[PSRW_IncidentAttribute]State_Detail_Report_CodeNumber
 12OFF_INJURYOffender injury during incident.[PSRW_IncidentAttribute]State_Detail_Report_CodeNumber
 13OFF_IEPThe offender's IEP at the time of the incident. DECIDED offender on IEP at time of incident[S_VT_STU_X]IEPString 
 14OFF_IDThe offender's state assigned student ID, if known.[Students]State_StudentNumberNumber10
 15OFF_AMINDAKNATNative American offender indicator.



 16OFF_ASIANAsian offender indicator.



 17OFF_BLACK Black offender indicator.



 18OFF_WHITE White offender indicator.



 19OFF_HISPANIC Hispanic offender indicator.



String 1
 20OFF_HAWAIIAN Hawaiian offender indicator.



String 1
 21OFF_DISABILITY Code set for offender disability.[ParticipantAttributeCode]State_Detail_Report_Code Number2
 22OFF_ELL The offender's ELL status.[StudentCoreFields]LEP_StatusString1
 23SYThe school year.[S_VT_District_S]SYNumber

Back to top

JavaScript errors detected

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

If this problem persists, please contact our support.