Student Infraction Extract

Introduction

This extract generates a comma-delimited file containing one record per student discipline log entry. If a discipline infraction could be categorized into multiple infraction codes, include only the most serious of the potential infraction codes.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects student records from the [Students] or [ReEnrollments] table based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Exit Date must occur on or after the report start date.
The student’s school enrollment Entry Date must occur on or before the report end date.
The student is HSDA-flagged.

Log Entry Selection

The report selects log entry records from the [Log] table with an incident date that occurs on or after the report start date and on or before the report end date.

Incident Management Entry Selection

The report selects Incidents that were entered via Incident management that have an incident date that’s after the report start date and before the report end date. The incident type must also be “NM State Reporting^”.

Back to Top

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 the 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 (default) – Includes all student records on the PowerSchool server that meet the selection criteria.
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.
Method of discipline incident tracking	Choose one of the following: Log Entries (your state reportable discipline data has been entered in traditional Log entries) Incident Management (your state reportable discipline data has been entered in Incident management)
Log Type to be extracted	If state reportable discipline data is being tracked using Log Entries, select the Log Type that is to be exported.
Extract Description	Choose one of the following to extract the Infraction Comment (field 15): Yes – Extract the description on the report. No – Default option to bypass the description.

Back to Top

Report Output (Log Entries)

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

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The alternate school number is extracted, if populated. Use the following Location Codes for special education students not enrolled at an actual district location: 993 – Students who are hospitalized 997 – Students who are enrolled in a private school 998 – Students who are homebound 999 – Students who are home schooled (does not apply to Special Ed students)	[Schools]Alternate_School_Number [Schools]School_Number = [Log]SchoolID The Location Code logic for summer schools is as follows: For PowerSchool 10.1.4 and higher, if [S_NM_STU_X]LocationCode is blank, it will look at the latest current enrollment location code for the student. [S_NM_STU_X]LocationCode [ReEnrollments]SchoolID [Schools]Alternate_School_Number	9/14
3	School Year Date	This value is automatically extracted as June 30^th. The report determines the year by referencing the school year associated with the term selected when the report is run. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	15/24
4	Student ID	The state issued student identification number.	[Students]State_StudentNumber	25/36
5	Infraction Date	The date that the infraction occurred. The value is extracted in the format YYYY-MM-DD.	[Log]Discipline_IncidentDate	37/46
6	Infraction Number	Not collected.	N/A	47/49
7	Infraction Code	Indicates the type of discipline violation.	[Log]Discipline_IncidentType	50/53
8	Staff ID	Not collected.	N/A	54/65
9	Short Course Code	Not collected.	N/A	66/73
10	Section Code	Not collected.	N/A	74/77
11	Short Class Period Code	Not collected.	N/A	78/79
12	Zone	Not collected.	N/A	80/99
13	Administrator ID	Not collected.	N/A	100/111
14	Event Identifier	An identifying code for the discipline event. The code enables a district to associate an incident with multiple students and possibly varying infractions.	[Log]NM_EventID	112/121
15	Infraction Comment	The infraction comment. Note: This field is surrounded by quotes.	[Log]Entry	122/376
16	Semester	Not collected.	N/A	377/378
17	Primary Infraction	Not collected.	N/A	379/381
18	Case Number	Not collected.	N/A	382/393
19	Weapon Related Flag	Indicates whether a weapon was used in the incident. Valid values: 0 – N 1 – Y	[Log]Discipline_WeaponRelated	394/399
20	First Victim Type	Indicates the type of victim associated with the discipline event. Valid values: 10 – Student 11 – Teacher 12 – Administrator 13 – Other School Employee 14 – Other – Unknown 15 – Other – Non-school personnel	[Log]Discipline_VictimType	400/405
21	Second Victim Type	Not collected.	N/A	406/411
22	Third Victim Type	Not collected.	N/A	412/417
23	Security Transaction Type	Not collected.	N/A	418/429
24	Long Course Code	Not collected.	N/A	430/441
25	Incident Type Frame	Not collected.	N/A	442/446
26	Criminal Charges Flag	Indicates whether a police report was filed. Valid values: 0 – N 1 – Y	[Log]Discipline_PoliceInvolvedFlag	447/466
27	Not Collected	Not collected.	N/A	467/491
28	Infraction Cost	The cost of the damages incurred by the incident.	[Log]Discipline_MoneyLossValue	492/502
29	Drug Related Indicator	Indicates whether the incident was drug related. Valid values: 0 – N 1 – Y	[Log]Discipline_DrugRelatedFlag	503/503
30	Alcohol Related Indicator	Indicates whether the incident was alcohol related. Valid values: 0 – N 1 – Y	[Log]Discipline_AlcoholRelatedFlag	504/504
31	Gang Related Flag	Indicates whether the incident was gang related. Valid values: 0 – N 1 – Y	[Log]Discipline_GangRelatedFlag	505/505
32	Hate Crime Indicator	Indicates whether the incident was a hate crime. Valid values: 0 – N 1 – Y	[Log]Discipline_HateCrimeRelatedFlag	506/506
33	Serious Bodily Injury Indicator	Indicates whether there were injuries related to the incident. Valid values: 0 – N 1 – Y	[Log]Discipline_LikelyInjuryFlag	507/507

Back to Top

Report Output (Incident Management)

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

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The alternate school number is extracted, if populated. Use the following Location Codes for special education students not enrolled at an actual district location: 993 – Students who are hospitalized 997 – Students who are enrolled in a private school 998 – Students who are homebound 999 – Students who are home schooled (does not apply to Special Ed students)	[Schools]Alternate_School_Number [Schools]School_Number = [Log]SchoolID The Location Code logic for summer schools is as follows: [S_NM_STU_X]LocationCode [ReEnrollments]SchoolID [Schools]Alternate_School_Number	9/14
3	School Year Date	This value is automatically extracted as June 30^th. The report determines the year by referencing the school year associated with the term selected when the report is run. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	15/24
4	Student ID	The state issued student identification number. If an unknown participant has been defined, 825881329 will be reported.	[Students]State_StudentNumber	25/36
5	Infraction Date	The date that the infraction occurred. The value is extracted in the format YYYY-MM-DD.	[PSRW_Incident]Incident_TS	37/46
6	Infraction Number	Not collected.	N/A	47/49
7	Infraction Code	Indicates the type of discipline violation. Note: If multiple behaviors have been entered, the behavior with the lowest severity number will be reported	[PSRW_IncidentBehavior]State_Detail_Report_Code	50/53
8	Staff ID	Not collected.	N/A	54/65
9	Short Course Code	Not collected.	N/A	66/73
10	Section Code	Not collected.	N/A	74/77
11	Short Class Period Code	Not collected.	N/A	78/79
12	Zone	Not collected.	N/A	80/99
13	Administrator ID	Not collected.	N/A	100/111
14	Event Identifier	An identifying code for the discipline event. The code enables a district to associate an incident with multiple students and possibly varying infractions.	[PSRW_Incident]Incident_ID	112/121
15	Infraction Comment	The infraction comment. Note: This field is surrounded by quotes. Only the first 255 characters will be reported. Special characters will be stripped from the output.	[PSRW_Incident]Incident_Detail_Desc	122/376
16	Semester	Not collected.	N/A	377/378
17	Primary Infraction	Not collected.	N/A	379/381
18	Case Number	Not collected.	N/A	382/393
19	Weapon Related Flag	Indicates whether a weapon was used in the incident. Valid values: 0 – N 1 – Y	[PSRW_IncidentAttribute]State_Aggregate_RPT_Code	394/399
20	First Victim Type	Indicates the type of victim associated with the discipline event. Valid values: 10 – Student 11 – Teacher 12 – Administrator 13 – Other School Employee 14 – Other – Unknown 15 – Other – Non-school personnel	[Incident_LU_Sub_Code]State_Detail_Report_Code	400/405
21	Second Victim Type	Not collected.	N/A	406/411
22	Third Victim Type	Not collected.	N/A	412/417
23	Security Transaction Type	Not collected.	N/A	418/429
24	Long Course Code	Not collected.	N/A	430/441
25	Incident Type Frame	Not collected.	N/A	442/446
26	Criminal Charges Flag	Indicates whether a police report was filed. Valid values: 0 – N 1 – Y	[PSRW_Incident_Attribute]State_Detail_Report_Code	447/466
27	Not Collected	Not collected.	N/A	467/491
28	Infraction Cost	The cost of the damages incurred by the incident.	[PSRW_Incident]Financial_Impact	492/502
29	Drug Related Indicator	Indicates whether the incident was drug related. Valid values: 0 – N 1 – Y	[PSRW_Incident_Attribute]State_Detail_Report_Code	503/503
30	Alcohol Related Indicator	Indicates whether the incident was alcohol related. Valid values: 0 – N 1 – Y	[PSRW_Incident_Attribute]State_Detail_Report_Code	504/504
31	Gang Related Flag	Indicates whether the incident was gang related. Valid values: 0 – N 1 – Y	[PSRW_Incident_Attribute]State_Detail_Report_Code	505/505
32	Hate Crime Indicator	Indicates whether the incident was a hate crime. Valid values: 0 – N 1 – Y	[PSRW_Incident_Attribute]State_Detail_Report_Code	506/506
33	Serious Bodily Injury Indicator	Indicates whether there were injuries related to the incident. Valid values: 0 – N 1 – Y	[PSRW_Incident_Attribute]State_Detail_Report_Code	507/507

Back to Top