17_CIRS_Offenders

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.

Field	Description
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 Connections	Choose 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	Description	[Table]FieldName	Field Type	Field Length
1	ADMINID	The district's SU/SD ID.	[S_VT_District_S]AdminID	String	6
2	OFF_IDNUM	Offender ID number by school	[PSRW_IncidentParticipant]ID	Number	10
3	INCIDENT_NUM	The incident ID.	[PSRW_IncidentParticipant]Incident_ID	Number	15
4	ENRORGID	The enrolling org ID.	[S_VT_Schools_X]EnrOrgID	String	6
5	OFF_LASTNAME	The offender's last name.	[PSRW_IncidentParticipant]Last_Name	String	36
6	OFF_FIRSTNAME	The offender's first name.	[PSRW_IncidentParticipant]First_Name	String	20
7	OFF_MNAME	The offender's middle name.	[PSRW_IncidentParticipant]Middle_Name	String	20
8	OFF_DOB	The offender's date of birth. Note: MM/DD/YYYY format.	[PSRW_IncidentParticipant]DOB	Date	N/A
9	OFF_GRADE	The offender's grade level.	[PSRW_IncidentParticipant]Grade_Level	String	2
10	OFF_GENDER	The offender's gender.	[PSRW_IncidentParticipant]Gender	String	1
11	OFF_TYPE	Code set for type of offender.	[PSRW_IncidentAttribute]State_Detail_Report_Code	Number	1
12	OFF_INJURY	Offender injury during incident.	[PSRW_IncidentAttribute]State_Detail_Report_Code	Number	1
13	OFF_IEP	The offender's IEP at the time of the incident. DECIDED offender on IEP at time of incident	[S_VT_STU_X]IEP	String	1
14	OFF_ID	The offender's state assigned student ID, if known.	[Students]State_StudentNumber	Number	10
15	OFF_AMINDAKNAT	Native American offender indicator.	[StudentRace] [TeacherRace]	String	1
16	OFF_ASIAN	Asian offender indicator.	[StudentRace] [TeacherRace]	String	1
17	OFF_BLACK	Black offender indicator.	[StudentRace] [TeacherRace]	String	1
18	OFF_WHITE	White offender indicator.	[StudentRace] [TeacherRace]	String	1
19	OFF_HISPANIC	Hispanic offender indicator.	[StudentRace] [TeacherRace]	String	1
20	OFF_HAWAIIAN	Hawaiian offender indicator.	[StudentRace] [TeacherRace]	String	1
21	OFF_DISABILITY	Code set for offender disability.	[ParticipantAttributeCode]State_Detail_Report_Code	Number	2
22	OFF_ELL	The offender's ELL status.	[StudentCoreFields]LEP_Status	String	1
23	SY	The school year.	[S_VT_District_S]SY	Number	4

Back to top