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: Select a single or multiple schools – Includes all data records associated with the selected school(s) that meet the selection criteria. Select a school or, to select multiple schools, press Ctrl+Click. When running from a school, the extract will run for the current school. Current School Only – Includes all data 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.
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: 1 (Physical Bullying) 2 (Cyber Bullying) 3 (Verbal Bullying) 4 (Relational Bullying)	Required if one of the following fields is not blank: Days of In-School Suspension Days of Out of School Suspension Days of Expulsion Days of Other	Derived from behavior code. Physical Bullying (1110)^: extracts as '1' Cyber Bullying (1120)^: extracts as '2' Verbal Bullying (1140)^: extracts as '3' Relational Bullying (1130)^: extracts as '4'
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: 1 (On school property, during the school day) 2 (On school property, outside the school day) 3 (Off school property, at a school-supervised activity)	Required if one of the following fields is not blank: Felony Misdemeanor Possession Arrest/Referral	Derived from location code and time code. If location code = 100 and time code = 100: ‘1’ If location code = 100 and time code = 200: ‘2’ If location code = 200: ‘3’
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: Felony Misdemeanor Possession Location	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: 1 (Handguns) 2 (Rifles/Shotguns) 3 (Other) 4 (Multiple)	Required if Discipline_Method_IDEA or Discipline_Method _Non_IDEA is not blank.	Derived from object code. If object code = 100: ‘1’ If object code = 200: ‘2’ All other objects: ‘3’ If more than one object: ‘4’
16	Discipline_Method_IDEA	Indicates the discipline method used for an IDEA student. Valid values: (1) Expulsion that was modified to less than one year and received educational services under IDEA. (2) One-year expulsion and received educational services under IDEA. (3) No expulsion because the student was removed for other reasons such as death, withdrawal, or incarceration. (4) Another type of disciplinary action. (5) No type of disciplinary action was taken.	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: DISCIPLINE_METHOD_IDEA and DISCIPLINE_METHOD_NON_IDEA will be populated as these values are mutually exclusive, which means that when one field has a value then the other field must be blank and vice versa. If the student is NON-IDEA, then the DISCIPLINE_METHOD_IDEA will be blank and DISCIPLINE_METHOD_NON_IDEA should have a value.	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: ‘1’ If action code = 555: ‘2’ If action code = 850, 860, or 870: ‘3’ If action code = 810: ‘5’ Otherwise: ‘4’
17	Discipline_Method _ Non_IDEA	Indicates the discipline method used for a non-IDEA student. Valid Values: (1) One-year expulsion and no educational services (including alternative placement with educational services). (2) One-year expulsion and educational services (or alternative placement with educational services). (3) Expulsion modified to less than one year and no educational services (including alternative placement with educational services). (4) Expulsion modified to less than one year and educational services (or alternative placement with educational services) (5) No expulsion because the student was removed for other reasons such as death, withdrawal, or incarceration. (6) Another type of disciplinary action. (7) No disciplinary action was taken.	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: DISCIPLINE_METHOD_IDEA and DISCIPLINE_METHOD_NON_IDEA will be populated as these values are mutually exclusive, which means that when one field has a value then the other field must be blank and vice versa. If the student is NON-IDEA, then the DISCIPLINE_METHOD_IDEA will be blank and DISCIPLINE_METHOD_NON_IDEA should have a value.	Derived from participant attribute code and action code. Where participant attribute code does not = IDEA Disability. If action code = 565: ‘1’ If action code = 555: ‘2’ If action code = 560: ‘3’ If action code = 550: ‘4’ If action code = 850, 860, or 870: ‘5’ If action code = 810 : ‘7’ Otherwise: ‘6’
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": IDEA_ISS_Drugs IDEA_ISS_Weapons IDEA_ISS_Bodily_Injury IDEA_ISS_Code_of_Conduct	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. If action code = 450 and behavior code = 2300 : ‘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. If action code = 450 and object code = W2-Weapons: '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. If action code = 450 AND participant attribute code = Victim Injury AND participant attribute subcode = Major Injury: 'Yes'
22	IDEA_ISS_Code_of_ Conduct	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. If action code = 450 and Behavior code = 3300, 4300, 5000, 5100, or 4200 : ‘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": IDEA_OSS_Drugs IDEA_OSS_Weapons IDEA_OSS_Bodily_Injury IDEA_OSS_Code_of_Conduct	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. If action code = 510 or 520 and behavior code = 2300: ‘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. If action code = 510 or 520 and object code = W2-Weapons: 'Yes'
26	IDEA_OSS_Bodily_ Injury	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. If action code = 520 or 510 AND participant attribute code = Victim Injury AND participant attribute subcode = Major Injury: 'Yes'
27	IDEA_OSS_Code_of_ Conduct	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. If action code = 510 or 520 and behavior code = 3300, 4300, 5000, 5100, or 4200: ‘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": IDEA_Expulsion_Drugs IDEA_Expulsion_Weapons IDEA_Expulsion_Bodily_Injury IDEA_Expulsion_Code_of_Conduct	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. If action code = 550, 555, 560, or 565 and behavior code = 2300: ‘Yes’
30	IDEA_Expulsion_ Weapons	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. If action code = 550, 555, 560, or 565 and object code = W2-Weapons: 'Yes'
31	IDEA_Expulsion_Bodily_ Injury	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. If action code = 550, 555, 560, or 565 AND participant attribute code = Victim Injury AND participant attribute subcode = Major Injury: 'Yes'
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