KIAS Discipline Data Collection Extract
Introduction
The KIAS extract generates discipline data for the Kansas Integrated Accountability System (KIAS). This data is categorized into the following disciplinary areas:
Demographics
Bullying
Kansas School Safety and Security Act
Students Involved with Firearms
Discipline of Students with Disabilities (IDEA)
For IDEA students, all in-school suspensions, out-of-school suspensions, and expulsions of at least one school day must be reported. For Non-IDEA students, all in-school suspensions, out-of-school suspensions, and expulsions of a least one school day as the result of violence, weapons, alcohol, or substance abuse must be reported. Also for non-IDEA students, all in-school suspensions, out-of-school suspensions, and expulsions where the student is removed from their regular school program for the remainder of the school year for any reason must be reported.
Selection Criteria
The report selects records from the database based on the following criteria:
The incident must be associated with a school that is not excluded from state reporting.
The incident date must occur between the start and end dates of the report.
The incident type must be Kansas State Reporting.
The incident must have an offender and at least one action and one behavior.
Incidents with more than one action and behavior will be reported as separate records.
If the incident involves a primary behavior with a code of 1110, 1120, 1130, or 1140, it will be reported as expected.
For behaviors not listed above, the incident will still be reported if any of the following conditions are met:
The IDEA status is marked as “Yes (21)"
There is an associated object code with the behavior.
The student’s enrollment D35 Primary Disability Indicator is populated as “WD” (in line with the student’s requirements).
There are no additional conditions required for actions if either the specified behavior conditions are met or if any of the action codes 550, 555, 560, or 565 are indicated.
Primary behavior must be present in the report; actions cannot be reported on their own.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Schools to Include | When running from the district office, choose one of the following:
When running from a school, the extract will run for the current school.
|
Start Date | Enter a date (in mm/dd/yyyy format) for the first day of the report date range. |
End Date | Enter a date (in mm/dd/yyyy format) for the last day of the report date range. |
Report Output
Each field in the report output is described below. See Understanding the Report Output Table for a definition of each column in the table.
This report extracts only the primary behavior. If there is more than one action associated with the Primary behavior, then the report merges and extracts all the actions (of only the most recent record identified from Action Begin Date) associated with the primary behavior. If there are two actions with the same recent date, then only those 2 recent records are merged and extracted.
Field Ref | Data Element | Description | Validation | [Table]FieldName |
1 | Building_ID | The school associated with the incident. | Required | [S_KS_STU_X]Accountability_School [S_KS_REN_X]Accountability_School [Students]SchoolID |
2 | KIDS_ID | The student's state identifier. | Required | [Students]State_StudentNumber |
3 | Incident_Date | The date of the reported incident. | Required | [Incident]Incident_Date |
Bullying | ||||
4 | Bullying_Type | Indicates the type of bullying associated with the incident. Valid values:
| Required if one of the following fields is not blank:
| Derived from behavior code.
|
5 | Days of In-School Suspension (ISS) Days_of_ISS | The number of days of in-school suspension (ISS) associated with the incident. Note: Half days are reported as .5. | Derived from action code. If action code = 450 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
6 | Days of Out-of-School Suspension (OSS) Days_of_OSS | The number of days of out of school suspension (OSS) associated with the incident. Note: Half days are reported as .5. | Derived from action code. If action code = 520 or 510 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
7 | Days of Expulsion Days_of_Expulsion | The number of days of expulsion (EXP) associated with the incident. Note: Half days are reported as .5. | Derived from action code. If action code = 550, 555, 560, or 565 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
8 | Educational Services during Expulsion Edu_Srv_Expulsion | Indicates if educational services were rendered during the expulsion associated with the incident. | Required if Days_of_Expulsion is not blank. | Derived from action code. If action code = 550 or 555: ‘Yes’ If action code = 560 or 565: ‘No’ |
9 | Days_of_Other | The number of days of other actions associated with the incident. Note: Half days are reported as .5. | Derived from action code. If action code = 999 (850, 860, 870) AND Actual Duration is available [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
Kansas School Safety and Security Act | ||||
10 | Felony | Indicates whether school staff reported an act to law enforcement that constituted or involved a felony. | Derived from action code. If action code = 750: ‘Yes’ | |
11 | Misdemeanor | Indicates whether school staff reported an act to law enforcement that constituted or involved a misdemeanor. | Derived from action code. If action code = 730: ‘Yes’ | |
12 | Possession | Indicates whether school staff reported an act to law enforcement that constituted or involved the possession, use, or disposal of explosives, firearms, or other weapons. | Must be "Yes" if Weapon_Type is not blank. | Derived from object code. If object code = W2-Weapons: ‘Yes’ |
13 | Location | Indicates whether the act reported to law enforcement occurred at one of the below locations. Valid values:
| Required if one of the following fields is not blank:
| Derived from location code and time code.
|
14 | Arrest /Referral | Indicates whether an arrest and referral to law enforcement, or juvenile intake and assessment services was made in connection to the incident. | Required if one of the following fields is not blank:
| Derived from action code. If action code = 710, 730, 750, or 777: ‘Yes’ |
Students Involved with Firearms | ||||
15 | Weapon_Type/Firearm Type | Indicates the weapon type associated with the incident. Valid values:
| Required if Discipline_Method_IDEA or Discipline_Method _Non_IDEA is not blank. | Derived from object code.
|
16 | Discipline_Method_IDEA | Indicates the discipline method used for an IDEA student. Valid values:
| With discipline incidents that have an Object Type of Weapon the DISCIPLINE_METHOD_IDEA and DISCIPLINE_METHOD_NON_IDEA fields will display in the following manner:
| Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
|
17 | Discipline_Method _ | Indicates the discipline method used for a non-IDEA student. Valid Values:
| With discipline incidents that have an Object Type of Weapon the DISCIPLINE_METHOD_IDEA and DISCIPLINE_METHOD_NON_IDEA fields will display in the following manner:
| Derived from participant attribute code and action code. Where participant attribute code does not = IDEA Disability.
|
Discipline of Students with Disabilities (IDEA) | ||||
18 | IDEA_Days_of_ISS | The number of days of In-School Suspension, for an IDEA student, associated with the incident. Note: Half days are reported as .5. | Required if one of the following fields is "Yes":
| Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes. If action code = 450 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned |
19 | IDEA_ISS_Drugs | Indicates whether an IDEA student received an in-school suspension (ISS) where the reason for removal was drugs. | Derived from participant attribute code, participant attribute subcode, action code, and behavior code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
20 | IDEA_ISS_Weapons | Indicates whether an IDEA student received an in-school suspension (ISS) where the reason for removal was weapons. | Derived from participant attribute code, participant attribute subcode, action code, and object code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
21 | IDEA_ISS_Bodily_Injury | Indicates whether an IDEA student received an in-school suspension (ISS) where the reason for removal was serious bodily injury. | Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability.
| |
22 | IDEA_ISS_Code_of_ | Indicates whether an IDEA student received an in-school suspension (ISS) where the reason for removal was a violation of the school's Code of Conduct. | Derived from participant attribute code, participant attribute subcode, action code, and behavior code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
23 | IDEA_Days_of_OSS | The number of days of out of school suspension (OSS), for an IDEA student, associated with the incident. Note: Half days are reported as .5. | Required if one of the following fields is "Yes":
| Derived from participant attribute code, participant attribute subcode, and action code Where participant attribute code = IDEA Disability and participant attribute subcode = Yes. If action code = 510 or 520 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned |
24 | IDEA_OSS_Drugs | Indicates whether an IDEA student received an out of school suspension (OSS) where the reason for removal was drugs. | Derived from participant attribute code, participant attribute subcode, action code, and behavior code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
25 | IDEA_OSS_Weapons | Indicates whether an IDEA student received an out of school suspension (OSS) and the reason for removal was weapons. | Derived from participant attribute code, participant attribute subcode, action code, and object code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
26 | IDEA_OSS_Bodily_ | Indicates whether an IDEA student received an out of school suspension (OSS) and the reason for removal was serious bodily injury. | Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability.
| |
27 | IDEA_OSS_Code_of_ | Indicates whether an IDEA student received an out of school suspension (OSS) and the reason for removal was a violation of the school's Code of Conduct. | Derived from participant attribute code, participant attribute subcode, action code, and behavior code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
28 | IDEA_Days_of_Expulsion | The number of days of expulsion, for an IDEA student, associated with the incident. Note: Half days are reported as .5. | Required if one of the following fields is "Yes":
| Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes. If action code = 550, 555, 560, or 565 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned |
29 | IDEA_Expulsion_Drugs | Indicates whether an IDEA student was expelled where the reason for removal was drugs. | Derived from participant attribute code, participant attribute subcode, action code, and behavior code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
30 | IDEA_Expulsion_ | Indicates whether an IDEA student was expelled where the reason for removal was weapons. | Derived from participant attribute code, participant attribute subcode, action code, and object code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes.
| |
31 | IDEA_Expulsion_Bodily_ | Indicates whether an IDEA student was expelled where the reason for removal was serious bodily injury. | Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability.
| |
32 | Discipline of Students with Disabilities (IDEA) | Days of Expulsion Reason for Removal - Other violation of school code of conduct (IDEA) Yes/No | ||
33 | Discipline of Students with Disabilities (IDEA) | Indicates if Educational Services during Expulsion. (IDEA) | IDEA AND If Expulsion in (550,555) then yes If Expulsion in (560,565) then no | |
34 | Discipline of Students with Disabilities (IDEA) | Days of Removal by School Personnel (not the IEP team) to another educational setting | Action code in (610,650) If Actual Duration is available extract that, else pull Assigned Duration | |
35 | Discipline of Students with Disabilities (IDEA) | Days of Removal by School Personnel (not the IEP team) to another educational setting; Reason for Removal - Drugs | Action code in 610,650 And Behavior code = 2300 | |
36 | Discipline of Students with Disabilities (IDEA) | Days of Removal by School Personnel (not the IEP team) to another educational setting; Reason for Removal - Weapons | Action code in 610,650 And If Object code = WEAPON | |
37 | Discipline of Students with Disabilities (IDEA) | Days of Removal by School Personnel (not the IEP team) to another educational setting; Reason for Removal - Serious bodily injury | Action code in 610,650 And Participant attribute code = Victim injury And subcode is major injury | |
38 | Students within the foster care system | Days of In School Suspension (ISS) Record days less than one with a 0 to the left of the decimal place, for example "0.25". | The student should be in a foster care system Derived from action code. If action code = 450 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
39 | Students within the foster care system | Days of Out-of-School Suspension (OSS) Record days less than one with a 0 to the left of the decimal place, for example "0.25". | The student should be in a foster care system Derived from action code. If action code = 520 or 510 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
40 | Students within the foster care system | Days of Expulsion Record days less than one with a 0 to the left of the decimal place, for example "0.25". | The student should be in a foster care system Derived from action code. If action code = 550, 555, 560, or 565 AND Actual Duration is available: [Incident_Action]Duration_Actual Otherwise: [Incident_Action]Duration_Assigned | |
41 | Do you have an expulsion to report that involved a violence related offense | Expulsion to report that involved a violence related offense, including crimes against persons which constitute the commission of a felony, including murder, aggravated assault, battery, criminal threat, hazing, kidnapping, robbery, burglary, and stalking; or sex crimes such as rape, aggravated indecent liberties with a child, indecent solicitation of a child, sexual battery, sexual exploitation of a child, and sodomy; or child abuse or terroristic threat. (If the student was not expelled for a violence related offense, please leave blank) | Can be blank. If the student was expelled due to a violence related offense, then this is required. If the student was not expelled due to a violence related offense, then this should be left blank. If this is 'Yes', then column J must be 'Yes'. | Non IDEA student which is identified by Participant Attribute Code = IDEA Disability^ subcode Yes Behavior Category = Assault (1000) or Threat (2000) or Arson (3000) Note: A violence-related offense including crimes against persons which constitute the commission of a felony. This includes murder, aggravated assault, battery, criminal threat, hazing, kidnapping, robbery, burglary, and stalking; or sex crimes such as rape, aggravated indecent liberties with a child, indecent solicitation of a child, sexual battery, sexual exploitation of a child, and sodomy; or child abuse or terroristic threat. |
42 | Expulsions to report (not already reported in any previous section) | Expulsions to report (not already reported in any previous section) - (If the student was involved in a bullying incident, is a student with a disability, or was not expelled, please leave blank) | Can be blank. If the student was expelled, then this is required. If the student was not expelled, then this should be left blank. | Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes. If action code = 550, 555: 'Yes' if action code = 560, 565: 'No' Derived from participant attribute code, participant attribute subcode, and action code. Where participant attribute code = IDEA Disability and participant attribute subcode = Yes. Otherwise: NULL |