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 NumberField NameData Type, Required, CodeValid Values
1District CodeCharacter, Required, Key
2Location CodeCharacter, Required, Updateable
3School Year DateDate, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
4Student IDCharacter, Required, Key9 digit student ID
or
825881329 – unknown perpetrator(s) or victim
5Infraction DateDate, Required, Key YYYY-MM-DD
7Infraction CodeCharacter, 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

14Event IdentifierCharacter, Required, Key
15Infraction CommentCharacter, Optional, Updateable
19Weapon TypeCharacter, Required, Updateable
  • Y – Yes
  • N – No
20Victim1 TypeNumber, Conditionally Required, Updateable10 = Student
26Criminal Charge CodeCharacter, Required, Updateable
  • Y = Yes
  • N = No
28Infraction CostCharacter, Required, Updateable
29Drug Related IndicatorCharacter, Required, Updateable
  • Y = Yes
  • N = No
30Alcohol Related IndicatorCharacter, Required, Updateable
  • Y = Yes
  • N = No
31Gang Related IndicatorCharacter, Required, Updateable
  • Y = Yes
  • N = No
32Hate Crime IndicatorCharacter, Required, Updateable
  • Y = Yes
  • N = No
33Serious Bodily Injury IndicatorCharacter, 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.

CODEINFRACTIONSEVERITYRANKING
7Other-Homicide11.1
6Other-Sexual battery11.2
8Other-Kidnapping (non-parental)11.3
1Assault/battery with firearm22.1
2Assault/battery knife/cutting object22.2
3Assault/battery other dangerous weapon22.3
61Handgun possession22.4
62Rifle, shotgun possession22.5
64Multiple Firearms22.6
63Other Firearms Possession22.7
54Drug violation-cocaine, heroin, meth22.8
53Gang related activity22.9
9Other-Robbery using force33.1
44Arson33.2
51Weapons Possession, Blade33.3.1
52Weapons Possession, Other33.3.2
15Bullying and or Harassment based on race, color, or national origin.33.4.1
12Sexual Harassment (includes bullying on the basis of sex)33.4.2
16Bullying and or Harassment based on disability.33.4.3
14Bullying and or Harassment (not based on sex, race, color, national origin or disability.)33.4.4
57Other-Weapons, Substance, Gang33.5
42Breaking/Entering/Larceny33.6
55DAlcohol Violation-Dealing33.7
4Assault/battery, hands, feet, fist/fighting44.1
5Assault/battery, simple44.2
54Drug violation-Marijuana44.3
55UAlcohol Violation-Use44.4
40Graffiti44.5
41Criminal Damage44.6
45Vandalism44.7
46Other vandalism44.8
55PAlcohol Violation-Possession44.9
43Missing Property / Theft55.1
13Disorderly Conduct55.2
11Other-General/Threat or Intimidation55.3
56Tobacco Use55.4

 

Page last updated August 7, 2019