ED166 Disciplinary Offense Record
Contents
Report Description
This report is used to collect disciplinary actions that result in a sanction type of in-school or out-of-school suspension or expulsion. In addition, all serious offenses, weapons, and drug/alcohol/tobacco offenses are reported, regardless of the sanction type.
This report lists specific offenses and disciplinary actions per student. These offenses may include alcohol, drugs, vandalism, violence, weapons, or any other incident required by the state to be included on this report. You can filter the report by type of offense and offenses that resulted in a specific consequence.
The extract must be submitted to the DOE by mid-July. Most of the data entry for this report is completed on the student’s Log Entry page, Start Page > Student > Log Entries.
Selection Criteria
Selection criteria determine which database records are used in the report.
School Selection
The report selects school records from the [Schools] table that are not excluded from state reporting. This is true when generating the extract at both the district and school level.
Discipline Incident Selection
The report selects discipline records from the [Log] table based on the following criteria:
- The ‘Include in State Reporting’ flag on the Log Entry page must be set to Yes.
- The log entry must be recorded at a school included on the report.
- The log entry must have a valid offense date which falls between the reporting period defined by the report start and end dates, inclusive.
- The log type must be Discipline.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Include District-Level Log Entries | Select Yes or No from the drop down to indicate whether or not you want to include log entries entered for the District Office in the output of the report. |
Select Students | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Display Header | Select Yes to display the Header on the report. Important: Choose No if you are planning to import state-assigned incident numbers into PowerSchool when these numbers are received from the state. Refer to the Incident Import File Layout for more information about importing state-assigned discipline incident numbers. |
Report Start Date | Enter the start date for the reporting period. |
Report End Date | Enter the end date for the reporting period. |
Report only incidents involving weapons, alcohol, or drugs (codes 3700 and 3800) | Select Yes to include only discipline incidents that involved weapons, alcohol, or drugs on the report. Select No to include all incidents on the report. |
Report only offenses that result in a bus, in-school, or out-of-school suspension, or expulsion (codes 1030, 1020, 1010, 1000) | Select Yes to include only offenses that resulted in a bus, in-school, or out-of-school suspension, or an expulsion. Select No to include all offenses on the report, regardless of the consequences from the offense. |
Extract Format | Choose whether to extract the records in comma-delimited format for troubleshooting purposes or in fixed length format for submission to the state. If you are sending the file to the state to obtain incident numbers, then choose comma-delimited format. |
Identifying information | When you run the report with this option enabled, the report displays a column with the actual school ID of the student's school enrollment. |
Report Output
Each of the fields displayed in the output of the report are described below. For documentation of XML report output from the state department of education, see http://www.csde.state.ct.us/public/ed166/docs.asp.
See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field | Field Length | Begin / End |
1 | State Assigned Student ID (SASID) | The unique identification number assigned to the student by the state. | [Students]State_StudentNumber | Numeric | 10 | 1–10 |
2 | Date of Birth | The student’s date of birth. | [Students]DOB | Alpha-numeric | 8 | 11–18 |
3 | Reporting District | The three-digit code for the reporting school district. | [Prefs]Value where [Prefs]Name=districtnumber | Alpha-numeric | 3 | 19–21 |
4 | Facility Code | The seven-digit facility code. | [S_CT_LOG_X]FacilityCodeOverride [Schools]Alternate_School_Number where [Schools]School_Number = [Log]CT_FacilityCode [Log]CT_FacilityCode If [S_CT_LOG_X]FacilityCodeOverride = blank/null and [Log]CT_FacilityCode = null/-1 (blank in the UI is stored as -1 in the DB) then: [Schools]Alternate_School_Number where [Schools]School_Number = [S_CT_STU_X]FacilityCode1 or [S_CT_REN_X]FacilityCode1 [S_CT_STU_X]FacilityCode1 or [S_CT_REN_X]FacilityCode1 where [S_CT_LOG_X]IncidentDate is between the enrollment record start and end dates [Schools]Alternate_School_Number where [Schools]School_Number = [Students]SchoolID or [Reenrollments]SchoolID [Students]SchoolID [Reenrollments]SchoolID | Alpha-numeric | 7 | 22–28 |
5 | Local Incident Number | A unique identifier for this discipline incident, which is required by the state. This is a locally assigned identifier, not the state assigned identifier. | [S_CT_LOG_X]LocalIncidentNumber | Alpha-numeric | 6 | 29–34 |
6 | Date of Incident | The date that the disciplinary incident occurred. | [S_CT_LOG_X]IncidentDate | Alpha-numeric | 8 | 35–42 |
7 | Time of Incident | The time that the disciplinary incident occurred. | [S_CT_LOG_X]IncidentTime | Alpha-numeric | 6 | 43–48 |
8 | Bullying | Identify if this incident involves Bullying | [S_CT_LOG_X]BullyingFlag | Alpha-numeric | 4 | 49-50 |
9 | Incident Type – part 1 | The primary disciplinary incident that the student committed. See the Appendix for valid code values. | [S_CT_LOG_X]IncidentType1 | Alpha-numeric | 4 | 51-54 |
10 | Incident Type – part 2 | The secondary disciplinary incident that the student committed. See the Appendix for valid code values. | [S_CT_LOG_X]IncidentType1 | Alpha-numeric | 4 | 55-58 |
11 | Weapon Involvement | The weapon involved in this discipline offense, if applicable. See the Appendix for valid code values. | [S_CT_LOG_X] WeaponInvolvement | Alpha-numeric | 4 | 59-62 |
12 | Substance Involvement | The appropriate code if the discipline offense involved the suspicion, possession, or use of drugs, alcohol, or tobacco. See the Appendix for valid code values. | [S_CT_LOG_X] SubstanceInvolvement | Alpha-numeric | 4 | 63–66 |
13 | Victim – Other Student | A value of “Y” indicates that another student was the victim in this discipline offense. | [S_CT_LOG_X] OtherStudentVictim | Alpha-numeric | 1 | 67 |
14 | Victim – Certified Staff | A value of “Y” indicates that a certified staff member (Teacher, Counselor, Psychologist, Administrator, etc.) was a victim of this offense. | [S_CT_LOG_X] CertifiedStaffVictim | Alpha-numeric | 1 | 68 |
15 | Victim – Substitute Teacher | A value of “Y” indicates that a substitute teacher was a victim of this offense. | [S_CT_LOG_X] SubstitueTeacherVictim | Alpha-numeric | 1 | 69 |
16 | Victim – Other Staff | A value of “Y” indicates that another staff member (Paraprofessional, Support Staff, Cafeteria Worker, Custodial Staff, Bus Driver, etc.) was a victim of this offense. | [S_CT_LOG_X]OtherStaffVictim | Alpha-numeric | 1 | 70 |
17 | Victim – Non-School | A value of “Y” indicates that a non-school person (Parent, Volunteer, Contractor, Non-student Youth, etc.) was a victim of this offense. | [S_CT_LOG_X]NonSchoolVictim | Alpha-numeric | 1 | 71 |
18 | Arrested | A value of “Y” indicates that the student was arrested as a consequence of this discipline offense. | [S_CT_LOG_X]StudentArrested | Alpha-numeric | 1 | 72 |
19 | Location of Incident | A value of “Y” indicates that the discipline offense occurred on school property. | [S_CT_LOG_X]OffenseLocation | Alpha-numeric | 2 | 73-74 |
20 | School Sponsored Activity | A value of “Y” indicates that the discipline offense occurred during a school sponsored activity. | [S_CT_LOG_X] SchoolSponsoredActivity | Alpha-numeric | 1 | 75 |
21 | Sanction Type (part 1) | The most severe type of sanction/discipline the student received for his/her offense. See the Appendix for valid values. | [S_CT_LOG_X] SanctionType1 | Alpha-numeric | 4 | 76-79 |
22 | Education Provided (part 1) | The type of education the student received during their out-of-school suspension or expulsion. See the Appendix for valid values. | [S_CT_LOG_X] EducationProvided1 | Alpha-numeric | 4 | 80-83 |
23 | #of Days Sanctioned (part 1) | The total number of partial/full days sanctioned for their offense. | [S_CT_LOG_X]DaysSanctioned1 | Numeric | 7 | 84-90 |
24 | # of Days Served (part 1) | The total number of partial/full days served for their offense. | [S_CT_LOG_X]DaysServed1 | Numeric | 7 | 91-97 |
25 | # of Days to Carryover (part 1) | The total number of partial/full days the student will serve in the following school year. | [S_CT_LOG_X] DaysServedCarryover1 | Numeric | 7 | 98-104 |
26 | Sanction Type (part 2) | Enter the code for the most severe type of sanction/discipline the student received for their offense. See the Appendix for valid values. | [S_CT_LOG_X]SanctionType2 | Alpha-numeric | 4 | 105-108 |
27 | Education Provided (part 2) | Choose the code for the type of education the student received during their out-of-school suspension or expulsion. See the Appendix for valid values. | [S_CT_LOG_X] EducationProvided2 | Alpha-numeric | 4 | 109-112 |
28 | # of Days Sanctioned (part 2) | Enter the number of partial/full days the student is assigned for their offense. Note: If a student received a suspension followed by an expulsion, report the sanction as an expulsion and report the number of days received as the sum of the days suspended and expelled. Remember to update the sanction type. | [S_CT_LOG_X]DaysSanctioned2 | Numeric | 7 | 113-119 |
29 | # of Days Served (part 2) | Enter the number of partial/full days the student served for this offense. | [S_CT_LOG_X]DaysServed2 | Numeric | 7 | 120-126 |
30 | # of Days Carryover (part 2) | Enter the number of partial/full days the student will serve in the following school year. | [S_CT_LOG_X] DaysServedCarryover2 | Numeric | 7 | 127-133 |
31 | Referring Party | The name of the person who referred the student to the party taking action. See the Appendix for valid values. | [S_CT_LOG_X]ReferringParty | Alpha-numeric | 2 | 134-135 |
32 | Party Taking Action | This party responsible for initiating the sanction. See the Appendix for valid values. | [S_CT_LOG_X]PartyTakingAction | Alpha-numeric | 2 | 136-137 |
33 | Memo field | This field contains details about the discipline offense. | [S_CT_LOG_X]IncidentMemo | Alpha-numeric | 50 | 138-187 |
34 | Incident Tracking Number (ITN) | The unique tracking number assigned to incident by the Connecticut Department of Education. Your district must include this number in order to modify existing incidents through a batch process. This field is blank for new incidents. The state assigns an incident number to each new incident, and returns the file to the district. Import the state-assigned incident number into PowerSchool using the Data Import System on the District Setup page. | [S_CT_LOG_X] StateIncTrackNumber | Numeric | 10 | 188-197 |
35 | District Student ID | The locally assigned student number. The field is used when importing the discipline incident record into PowerSchool. | [Students]Student_Number | Alpha-numeric | 20 | 198-217 |
36 | Reserve | The log ID assigned to the discipline incident. This field is automatically generated by PowerSchool and used when importing the discipline incident record into PowerSchool. | [Log]ID | Alpha-numeric | 50 | 218-267 |
37 | End of Record Marker | The end of record marker. | N/A | Alpha-numeric | 1 | 268 |