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:
- 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.
- Field 7 – Infraction Code – Severity Ranking for multiple infractions for one student within one incident
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 |
|
| 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 |
| 14 | Event Identifier | Character, Required, Key | |
| 15 | Infraction Comment | Character, Optional, Updateable | |
| 19 | Weapon Type | Character, Required, Updateable |
|
| 20 | Victim1 Type | Number, Conditionally Required, Updateable | 10 = Student |
| 26 | Criminal Charge Code | Character, Required, Updateable |
|
| 28 | Infraction Cost | Character, Required, Updateable | |
| 29 | Drug Related Indicator | Character, Required, Updateable |
|
| 30 | Alcohol Related Indicator | Character, Required, Updateable |
|
| 31 | Gang Related Indicator | Character, Required, Updateable |
|
| 32 | Hate Crime Indicator | Character, Required, Updateable |
|
| 33 | Serious Bodily Injury Indicator | Character, Required, Updateable |
|
FAQs
- 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 |