19_CIRS_Victims | PowerSchool SIS Compliance

Report Description

This report produces the student ADM extract for all currently enrolled students in a comma-delimited format. Student ADM is submitted.

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	Victim_IDNUM	Victim ID. Note: If the victim is the same person in different incidents, they will have a different number for each incident extracted.	[PSRW_IncidentParticipant]Participant_Number	Number	10
3	Incident_Num	The incident ID.	[PSRW_IncidentParticipant]Incident_ID	Number	15
4	ENRORGID	The org ID of the school where the incident was create.	[S_VT_Schools_X]ENRORGID	String	6
5	Victim_LastName	victim's last name	[PSRW_IncidentParticipant]Last_Name	String	36
6	Victim_FirstName	victim's first name	[PSRW_IncidentParticipant]First_Name	String	20
7	Victim_MName	victim's middle name	[PSRW_IncidentParticipant] Middle_Name	String	20
8	Victim_DOB	victim's date of birth Note: MM/DD/YYYY format.	[PSRW_IncidentParticipant]DOB	Date	N/A
9	Victim_Grade	victim's grade	[PSRW_IncidentParticipant]grade_level	String	2
10	Victim_Gender	victim's gender	[PSRW_IncidentParticipant]gender	String	1
11	Victim_AmIndAKNat	Native American victim indicator.	[StudentRace] [TeacherRace]	String	1
12	Victim_Asian	Asian victim indicator.	[StudentRace] [TeacherRace]	String	1
13	Victim_Black	Black victim indicator.	[StudentRace] [TeacherRace]	String	1
14	Victim_White	White victim indicator.	[StudentRace] [TeacherRace]	String	1
15	Victim_Hispanic	Hispanic victim indicator.	[StudentRace] [TeacherRace]	String	1
16	Victim_Hawaiian	Hawaiian / Islander victim indicator.	[StudentRace] [TeacherRace]	String	1
17	Victim_Type	The victim type.	[ParticipantAttributeCode]state_detail_report_code Category = "Victim_Type"	Number	1
18	Victim_Injury	Victim injury occurring during incident indicator.	[ParticipantAttributeCode]state_detail_report_code Category = "Victim_Injury"	String	1
19	Victim_ID	The victim's state assigned student ID.	[STUDENTS]State_StudentNumber	Number	10
20	Victim_Choice	School Choice for Victim.	[ParticipantAttributeCode]state_detail_report_code Category = "Victim_Choice"	String	1
21	SY	The school year.	[S_VT_District_S]SY	Number	4