Target Table: STUD_INFR_RESP
Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY), and Summer
Grain: One record per district / student / response date / response code / event identifier
Load Sequence/Dependencies:
- Student Template Required
- Student Infraction Template Required
Template Description: – This template is used to track student infraction responses. Infractions and incidents are tracked in the Student Infraction template. PED uses the Student Infraction and Infraction Response templates to track information related to Student Discipline and Violence and Vandalism. One response should be submitted per incident per student in this template. If there are multiple responses to a disciplinary incident, include only the most serious response. For example, a district may initially suspend a student and then later expel him or her. In this scenario, include only one record with the Response Code of 4 (Expulsion (no educational services) – FOR REGULAR ED ONLY).
IN SCHOOL suspensions (response code 2) and OUT OF SCHOOL suspensions (response 3) do not include Lunch, Before/After School Detentions.
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 reporting periods: 40D, 80D, 120D and EOY. SUMMER is conditionally required, if a new reportable infraction has occurred.
The Event Identifier field is used to “link” the Student Infraction Response record to the Student Infraction record. Please use the same district-generated value in this field to link the records in these templates together for the same incident.
Note: A response record is not required when the infraction record utilizes the UNKNOWN perpetrator code.
School Year 2019-2020 Changes:
- Field 7 – Response Code – The following code has been returned:
- 8 – Other/Unknown
File Name Format: DDD_STUD_INFR_RESP_YYYYMMDDHHMM.fff
File Name Format Example: 001_STUD_INFR_RESP_201907071201.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 | Response Date | Date, Required, Key | YYYY-MM-DD |
| 7 | Response Code | Character, Required, Key |
|
| 11 | Event Identifier | Character, Required, Key | |
| 12 | Response Comment | Character, Optional, Updateable | |
| 13 | Response Duration | Character, Required, Updateable | Provide the length, in school days, of the discipline response. If the response is a fraction of the school day, then use a decimal representation of the school day (e.g. 0.25 for removal for 2 periods of an 8 period school day). Required if Response Code, field #7 is 2, 3, 4, 5, 6 or 7; and the duration for these response codes must be greater than zero. |