Skip to Content

Student Infraction Template

Student Infraction Template 2019-08-07T11:46:49-06:00

Target Table: STUD_INFRACTION

Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY)

Grain: One record per district / student / infraction date / infraction code / event identifier

Load Sequence/Dependencies:

  1. Student Required

Template Description – This template is used to track student disciplinary infractions.  It is also used to collect data for the “Safe Schools Report” incidents across a school year. The response to each discipline or incident is tracked in the Student Infraction Response template. PED uses both templates to track the information related to student discipline and Safe Schools.  Each specific discipline infraction should be reported only once per student in this template. If a discipline infraction could potentially be categorized into multiple Infraction Codes, include only the most serious of the potential Infraction Codes.  For example, one incident could involve alcohol and assault/battery with a knife. This incident should be reported only as Infraction Code 2 (Assault/battery with knife or cutting object).  See

The Student Infraction and Student Infraction Response templates must be submitted in a point in time fashion.  Please submit in the first reporting period following the incident.  Must be submitted at these reporting periods: 40D, 80D, 120D, EOY.  SUMMER is conditionally required, if new reportable infractions have occurred since EOY.

If multiple students are involved in a single disciplinary infraction, include one record per student in this template. The exception to this is any incident that involves FIREARMS.  Each student in possession of a firearm is to be reported as a separate incident. All fields should be identical for these multiple records with the exception of Student ID and the location code (e.g. one incident could include students from different schools). The Event Identifier field is generated by the district / charter school and is used to “link” the multiple student records to one incident. This field is also used in the Student Infraction Response template to link the response(s) to the incident.

At EOY, if district has no reportable infractions, submit certification via email to PED-STARSadmin@state.nm.us

School Year 2019-2020 Changes:

    • Field 7 – Infraction Code – Severity Ranking for multiple infractions for one student within one incident
      • No longer ranked by the PED. Please use your local policy regarding the severity of infractions and report accordingly. Please refer to the FAQ at the end of this document.

File Name Format:  DDD_STUD_INFRACTION_YYYYMMDDHHMM.fff
File Name Format Example:  001_STUD_INFRACTION_201807071201.csv

Field Number Field Name Data Type, Required, Code Valid Values
1 District Code Character, Required, Key
2 Location Code Character, Required, Updateable
3 School Year Date Date, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
4 Student ID Character, Required, Key 9 digit student ID
or
825881329 – unknown perpetrator(s) or victim
5 Infraction Date Date, Required, Key  YYYY-MM-DD
7 Infraction Code Character, Required, Key  
1 – Assault/battery with firearm

1 – Assault/battery with firearm
2 – Assault/battery with knife or cutting object
3 – Assault/battery with other dangerous weapon
4 – Assault/battery aggravated with hands, feet, fist
5 – Assault/battery simple
6 – Other Violence -Sexual battery
7 – Other Violence – Homicide
8 – Other Violence – Kidnapping
9 – Other Violence – Robbery using force
11 – Other Violence – General (includes Threat or Intimidation)
12 – Sexual Harassment (includes bullying on the basis of sex)
13 – Disorderly Conduct
14 – Bullying and or Harassment not based on sex, race, color, national origin or disability.
15 – Bullying or Harassment on the basis of race, color, or national origin
16 – Bullying or Harassment on the basis of disability
40 – Graffiti
41 – Criminal Damage
42 – Breaking/Entering/Larceny
43 – Missing Property/Theft
44 – Arson
45 – Vandalism
46 – Other Vandalism, Describe in Comment Field (Field #15)
51 – Weapons Possession – Knife/Cutting
52 –  Weapons Possession – Other
53 – Gang-Related Activity
54 – Drug Violation
55P – Alcohol Violation – Possession
55U – Alcohol Violation – Use
55D – Alcohol Violation – Dealing
56 – Tobacco Use
57 – Other Weapons, Substance Abuse, Gang Activity – Describe in Comment Field (Field #15)
61 – Handgun Possession
62 – Rifle/Shotgun Possession
63 – Other Firearms Possession – Describe in Comment Field
64 – Multiple Firearms

14 Event Identifier Character, Required, Key
15 Infraction Comment Character, Optional, Updateable
19 Weapon Type Character, Required, Updateable
  • Y – Yes
  • N – No
20 Victim1 Type Number, Conditionally Required, Updateable 10 = Student
26 Criminal Charge Code Character, Required, Updateable
  • Y = Yes
  • N = No
28 Infraction Cost Character, Required, Updateable
29 Drug Related Indicator Character, Required, Updateable
  • Y = Yes
  • N = No
30 Alcohol Related Indicator Character, Required, Updateable
  • Y = Yes
  • N = No
31 Gang Related Indicator Character, Required, Updateable
  • Y = Yes
  • N = No
32 Hate Crime Indicator Character, Required, Updateable
  • Y = Yes
  • N = No
33 Serious Bodily Injury Indicator Character, Required, Updateable
  • Y = Yes
  • N = No

FAQs

  1. How do I determine which infraction to report in the event of multiple infractions by a single student within one incident?

The following table lists the current infractions along with the severity ranking. Use the column entitled “Ranking” to determine which infraction to report.

CODE INFRACTION SEVERITY RANKING
7 Other-Homicide 1 1.1
6 Other-Sexual battery 1 1.2
8 Other-Kidnapping (non-parental) 1 1.3
1 Assault/battery with firearm 2 2.1
2 Assault/battery knife/cutting object 2 2.2
3 Assault/battery other dangerous weapon 2 2.3
61 Handgun possession 2 2.4
62 Rifle, shotgun possession 2 2.5
64 Multiple Firearms 2 2.6
63 Other Firearms Possession 2 2.7
54 Drug violation-cocaine, heroin, meth 2 2.8
53 Gang related activity 2 2.9
9 Other-Robbery using force 3 3.1
44 Arson 3 3.2
51 Weapons Possession, Blade 3 3.3.1
52 Weapons Possession, Other 3 3.3.2
15 Bullying and or Harassment based on race, color, or national origin. 3 3.4.1
12 Sexual Harassment (includes bullying on the basis of sex) 3 3.4.2
16 Bullying and or Harassment based on disability. 3 3.4.3
14 Bullying and or Harassment (not based on sex, race, color, national origin or disability.) 3 3.4.4
57 Other-Weapons, Substance, Gang 3 3.5
42 Breaking/Entering/Larceny 3 3.6
55D Alcohol Violation-Dealing 3 3.7
4 Assault/battery, hands, feet, fist/fighting 4 4.1
5 Assault/battery, simple 4 4.2
54 Drug violation-Marijuana 4 4.3
55U Alcohol Violation-Use 4 4.4
40 Graffiti 4 4.5
41 Criminal Damage 4 4.6
45 Vandalism 4 4.7
46 Other vandalism 4 4.8
55P Alcohol Violation-Possession 4 4.9
43 Missing Property / Theft 5 5.1
13 Disorderly Conduct 5 5.2
11 Other-General/Threat or Intimidation 5 5.3
56 Tobacco Use 5 5.4

 

Page last updated August 7, 2019