Tool Search: Discipline Interchange Action File
The Discipline Interchange Action File captures students who have a Behavior incident in the selected calendar and includes information on the behavior event and the resulting disciplinary action (behavior resolution) for each incident.
Discipline Interchange Action FileRead - Access and generate the Discipline Interchange Action File.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
Report Logic
Information reports from the student's primary enrollment record as of the entered Effective Date.
- When the student does not have an active enrollment in the selected calendar, the most recent primary enrollment record is used.
- When there is more than one primary enrollment in the selected calendar, the latest Enrollment Start Date determines which enrollment reports.
- When the start dates are all the same, the enrollment with the highest enrollmentID reports.
- All Enrollment Service Types (Primary, Partial, Special Ed) report.
One record per student per resolution ID reports.
State Exclude logic is enforced. Students are not reported, even when they meet the above requirements when:
- The Enrollment is marked as State Exclude or No Show.
- The Grade level of enrollment is marked as State Exclude.
- The selected Calendar is marked as State Exclude.
Only state-mapped resolutions are reported for the student listed as the Offender in the Behavior Event Participant editor.
Only Behavior Responses with a value of M: Mechanical Restraint, P: Physical Restraint and S: Seclusion report.
Non-Binary Reporting
Schools can assign students a gender of M: Male, F: Female or N: Non-binary. This is done on the Identities tool and/or the Demographics tool.
Data Pipeline Extracts and other required extracts use the Legal Gender field included in the Protected Identity Information to report student identity information.
To properly record a gender of N: Non-Binary, on the Identities tool:
- Assign the Gender of N: Non-Binary in the standard identify fields.
- Assign the Protected Identity Information Legal Gender field to M: Male, F: Female or N: Non-Binary.
- Save the record when finished.
Gender and Legal Gender Assignment
Report Editor
| Data Element | Description |
|---|---|
| Start Date | Indicates the start date by which to report behavior events. At least one day of the Behavior Incident must fall within or on the start and end date.
Dates are entered in mmddyy format or use the calendar icon to select a date. |
| End Date | Indicates the end date by which to report behavior events. At least one day of the Behavior Incident must fall within or on the start and end date.
Dates are entered in mmddyy format or use the calendar icon to select a date. |
| Report Legal Name | When marked, reports the student names from the Protected Identity Information entered on the student's Identity record. |
| Ad hoc Filter | When chosen, only those students included in the selected ad hoc filter are reported in the extract, if they meet the requirements of the extract. |
| Format | Determines the layout of the report. Choose either CSV or HTML. |
| Calendar Selection | Select at least one calendar from which to report student discipline information. |
| Report Generation | Use the Generate Extract button to display the results of the extract immediately. When there is a larger data set being reported, use the Submit to Batch option to choose when the extract generates (after or before school hours, etc.). See the Batch Queue article for more information. |
Generate the Report
- Enter a Start Date and End Date.
- Mark the Report Legal Name checkbox, if desired, to return the student's Legal Name.
- If desired, select an Ad hoc Filter to report only those students included in that filter.
- Select the desired Format, either CSV or HTML, from the dropdown list.
- Select at least one Calendar from which to report discipline records. Calendars can be chosen by active year, by school name or by year.
- Click the Generate Extract button or the Submit to Batch button. The report displays in the selected format.
Discipline Interchange Action File - HTML Format
Discipline Interchange Action File - CSV FormatReport Layout
| Data Element | Description | Location |
|---|---|---|
| Admin Unit/BOCES Code | The Administrative Unit Code assigned to the school by the Colorado Department of Education. This must be a valid Administrative Unit/State Operated Program Code and be the 5-digit code representing the AU/SOP submitting the data. This code must match the Administrative Unit/State Operated Code referred to in the file name. When this field is not populated, 00000 reports.
Numeric, 5 digits |
School Information > School Detail > Admin Unit Code
School.adminUnitCode |
| District Code | Reports the district number assigned to the school district by the Colorado Department of Education.
Numeric, 4 digits |
District Information > District Information > State District Number
District.number |
| School Code | Reports the number assigned to the school building by the Colorado Department of Education.
This value reports from the student's active enrollment on the date of the incident. When the student has more than one active enrollment, the value reports from the Primary enrollment. When a student has a Special Education Attendance Code of 31: Administrative Unit OR 32: State-Operated Program, the four-digit code reports from the Serving District field.
For all other students:
|
Enrollments > State Reporting Fields > Serving District
Enrollment.serviceDistrict Enrollments > Special Education Fields > Service Agency/Facility Code
Enrollment.serviceFacility Student Information > General > Enrollments > State Reporting Fields > School of Accountability
Enrollment.residentSchool School Information > School Editor > State School Number
School.number |
| Special Education Program Code | Reports the code assigned to the special education program, as noted on the student's most recent IEP or from the Special Ed Program Code on the student's Enrollment record.
A student must have an IEP with a date that continues in the date range chosen in the extract editor. The IEP start date can be before July 1 of the reporting year.
When there is no assigned program code, this field reports 0000.
Numeric, 4 digits (padded on the left) |
Special Education Documents > Plan > IEP > State Special Ed Program Code
SEPlan.programCode Enrollments > Special Ed Fields > State Special Ed Program Code Enrollment.spedProgramCode |
| Incident Identifier | A unique number assigned to each behavior incident by each reporting entity (either administrative unit or school district).
Numeric, 10 digits (padded on the left) |
Behavior Management > Incident Detail Information > Incident ID
BehaviorIncident.incidentID |
| Date of Incident | Reports the date the behavior incident occurred.
Date field, 8 characters (MMDDYYYY) |
Behavior Management > Incident Detail > Date of Incident
BehaviorIncident.timestamp |
| Behavior Type | Reports the State Event Code assigned to the Behavior Incident.
When there is no state code assigned to the behavior event, a value of 00 reports. When the Special Education Action Flag reports 00 AND the Behavior Type is 17-22, 31-33, the Discipline Action Type field reports 00. When the Special Education Action Flag reports 00 and the Behavior Type is 41-43, a second record for the same incident reports with a Behavior Type of 11. Two records for one incident report. When the Special Education Action Flag is 01 AND the Behavior Type is 17-43 AND the Resolution Type is State Code 01, the Discipline Action Type reports 00. AND a second record reports for the same incident with a Behavior Type of 11 and a Discipline Action Type of 00. Numeric, 2 digits |
Event Type Setup > Behavior Event Type Detail > State Event Code (Mapping)
|
| Weapon Type | Reports the weapon code associated with the event.
Numeric, 2 digits |
Behavior Management > Events and Participant Details > Participant Details > GFSA Weapon
BehaviorWeapon.weaponType |
| Student State ID | The unique 10-digit number assigned to each student by the Colorado Department of Education.
Numeric, 10 digits |
Demographics > Person Identifiers > Student State ID
Person.stateID |
| Student First Name | Reports the student's first name.
When the Report Legal Name checkbox is marked on the report editor, the student's First Name reports from the Legal First Name field.
Alphanumeric, 30 characters |
Demographics > Person Information > First Name
Identity.first Name Identities > Protected Identity Information > Legal First Name
Identity.legalFirstName |
| Student Last Name | Reports the student's last name.
When the Report Legal Name checkbox is marked on the report editor, the student's Last Name reports from the Legal Last Name field.
Alphanumeric, 30 characters |
Demographics > Person Information > Last Name
Identity.last Name Identities > Protected Identity Information > Legal Last Name
Identity.legalLastName |
| Student Gender | Reports the student's gender.
When the Report Legal Name checkbox is marked on the report editor, the student's Gender reports from the Legal Gender field. Numeric, 1 digit |
Demographics > Person Information > Gender
Identity.gender Identities > Protected Identity Information > Legal Gender
Identity.legalGender |
| Student Date of Birth | The student's date of birth.
Date field, 8 characters (MMDDYYYY) |
Identities > Birth Date
Identity.birthDate |
| Special Education Action Flag | When the incident date falls within the Special Ed Start Date and Special Ed End Date, a value of 1 reports.
When the student has an active and locked IEP at the time of the incident/resolution, a value of 1 reports. All other instances report a value of zero (0). When the Special Education Action Flag reports 00 AND the Behavior Type is 17-22, 31-33, the Discipline Action Type field reports 00. When the Special Education Action Flag reports 00 and the Behavior Type is 41-43, a second record for the same incident reports with a Behavior Type of 11. Two records for one incident report. When the Special Education Action Flag is 01 AND the Behavior Type is 17-43 AND the Resolution Type is State Code 01, the Discipline Action Type reports 00. AND a second record reports for the same incident with a Behavior Type of 11 and a Discipline Action Type of 00. Numeric, 1 character (1 or 0) |
Behavior Management > Incident Detail > Date of Incident
BehaviorIncident.timestamp Behavior Management > Events and Participants > Resolution > Resolution Start Date, Resolution End Date BehaviorResolution.startDate BehaviorResolution.endDate |
| Discipline Action Identifier | Reports the Resolution ID.
This number must be unique and unduplicated, unless the student had a unilateral removal for two removal reasons. For Behavior Responses, the Response ID reports left-zero padded to 9 digits, with an 8 added to the front of the number (e.g., 8000001234). For Behavior Resolutions, the Response ID reports left-zero padded to 9 digits, with a 9 added to the front (e.g., 9000001234). Numeric, 10 digits |
Behavior Management > Events and Participants > Resolution Detail, Resolution ID
BehaviorResolution.resolutionID Behavior Management > Events and Participants > Response Detail > Response ID BehaviorResponse.responseID |
| Discipline Action Type | Indicates whether the student was suspended, expelled, etc..Reports the Resolution Type assigned to the student.
|
Behavior Management > Incident Detail Information > Events and Participants > Resolution Details > Resolution Type
BehaviorResolution.type |
| Referral to Law Enforcement | Reports a value of 1 when the Referral to Law Enforcement is marked on the Resolution Detail editor.
For Behavior Responses, a value of zero (0) reports. According to Department of Education guidance, Referral to Law Enforcement means a communication between a school administrator, teacher, or other school employee and law enforcement that: Is initiated by the school administrator, teacher, or other school employee; and concerns behavior by a student that the school administrator, teacher, or other school employee believes may constitute a violation of the school conduct and discipline code or a criminal or delinquent offense, and for which the school administrator, teacher, or other school employee requests an investigation or other involvement by law enforcement. Numeric, 1 digit |
Behavior Management > Incident Detail Information > Events and Participants > Resolution Details > Referral to Law Enforcement BehaviorResolution.arrest |
| Handcuffed Status | Indicates the student was handcuffed as a result of the behavior event. This only reports for Behavior Responses. When the Behavior Response Type Code is HC (capital letter) AND the Response Type is M: Mechanical Restraint, reports a value of 1 for this field and for Mechanically Restrained. Otherwise, a value of 0 reports. When the Behavior Response Type Code is H (capital letter) AND the Response Type is M: Mechanical Restraint, reports a value of 1 for this field only. Numeric, 1 digit |
Incident Detail Information > Events and Participants > Response Details > Response Type
BehaviorResponse.responseType |
| School-Related Arrest Status | Indicates the offender was arrested for any activity conducted on school grounds, during off-campus school activities, or due to a referall by any school official. Reports a value of 1 when marked for Behavior Resolutions. Reports a value of 0 for Behavior Responses. Numeric, 1 character |
Behavior Management > Incident Detail Information > Events and Participants > Resolution Details > School-Related Arrest
BehaviorResolution.arrest |
| Physically Restrained | Indicates the student was physically restrained as a response to the behavior incident.
Reports a value of 1 when P: Physical Restraint is assigned as the Behavior Response. This only reports for a Behavior Response. Numeric, 1 digit |
Behavior Management > Incident Detail Information > Events and Participants > Response Details > Response Type
BehaviorResponse.responseType |
| Mechanically Restrained | Indicates the student was mechanically restrained as a response to the behavior incident. This only reports for a Behavior Response. When the Behavior Response Type Code is HC (capital letter) AND the Response Type is M: Mechanical Restraint, reports a value of 1 for this field and for Handcuffed Status. Otherwise, a value of 0 reports. When the Response Type is M: Mechanical Restraint, reports a value of 1 for this field only. Numeric, 1 digit |
Behavior Management > Incident Detail Information > Events and Participants > Response Details > Response Type
BehaviorResponse.responseType |
| Placed in Seclusion | Indicates the student was placed in seclusion as part of the response to this incident. This only reports for a Behavior Response. Reports a value of 1 when S: Seclusion is assigned as the Behavior Response. Numeric, 1 digit |
Behavior Management > Incident Detail Information > Events and Participants > Response Details > Response Type
BehaviorResponse.responseType |
| Received Education Services During Expulsion | Indicates the student received services during their expulsion.
Reports a value of 1 when Services During Expulsion is marked for Behavior Resolutions. Reports a value of 0 for Behavior Responses. Numeric, 1 character |
Behavior Management > Incident Detail Information > Events and Participants > Resolution Details > Services During Expulsion
BehaviorResolution.serviceProvided |
| Transferred to Alternative School (for Disciplinary Actions) | Indicates the student was transferred to another school as a result of their behavior.
Reports a value of 1 when Transferred to Alternative School (for Disciplinary Reasons) is marked for Behavior Resolutions. Reports a value of 0 for Behavior Responses. Numeric, 1 character |
Behavior Management > Incident Detail Information > Events and Participants > Resolution Details > Transferred to Alternative School
BehaviorResolution.transferOption |
| Discipline Action Length | Reports the length in school days of the assigned resolution, as noted in the Duration in School Days field.
When Duration in School Days field is NULL, calculates the number of instructional days between the behavior start date and behavior end date.
Numeric, 4 digits (XXXX) |
Behavior Management > Incident Management Editor > Events and Participants > Resolution Details > Duration in School Days, Resolution Start Date, Resolution End Date
Behavior.schoolDaysDuration BehaviorResolution.startDate BehaviorResolution.endDate |
| Discipline Start Date | Reports the Start Date of the Behavior Resolution.
This field is required for Special Education records. Date field, 8 characters (MMDDYYYY) |
Behavior Management > Incident Management Editor > Events and Participants > Resolution Details > Resolution Start Date, Resolution End Date
BehaviorResolution.startDate BehaviorResolution.endDate |
| Special Education Removal Type | Indicates the reason the Special Education student was removed from the school as a result of the behavior incident. This reports for Special Education students only. Reports a value of 01 when the Behavior Resolution assigned to the event is 01: Unilateral Removal by School Personnel. Reports a value of 02 when the Behavior Resolution assigned to the event is 02: Removal Based on a Hearing Officer's Determination. Otherwise, a value of 00 reports. Behavior Response always report a value of 0. Numeric, 2 digits |
Behavior Management > Incident Management Editor > Events and Participants > Resolution Details > Resolution Type: 01, 02
BehaviorResolution.type |
| Special Education Removal Reason | Indicates the reason the Special Education student was removed from the school. This is required for Special Education students ONLY when the student was unilaterally removed by school personnel. Report the following codes based on the State Event Code and State Resolution codes selected:
Behavior Responses always report a value of 0. Numeric, 2 digits |
Behavior Management > Incident Management Editor > Events and Participants > Resolution Details > Resolution Type
BehaviorResolution.resolutionType Behavior Management > Incident Management Editor > Events and Participants > Event Details > Event Type BehaviorEvent.eventType |
