CRDC - DISC - Student Discipline Ad Hoc Filters

Last Modified on 10/22/2022 10:01 am CDT

Classic View: Federal Reporting > Civil Rights Data Collection (CRDC) > Maintain Survey Results

Search Terms: Maintain CRDC Survey Results

This article covers basic ways to use the Campus Ad hoc Reporting tools to design Ad hoc filters that can produce the school mappings needed to identify data sets for the Civil Rights Data Collection (CRDC). If the required information is not entered into Campus, a filter will not be able to produce the data. The filters used within this document utilize the Filter Designer's Query Wizard. Ad hoc fields vary by state; therefore, examples within this article may need to use different data elements from what appears in the examples. 

Also note, the Query Wizard returns data based on AND. For most of the examples, logical expressions should be entered to indicate an AND or OR is required. This is not represented in all of the captured images, but should be incorporated into your queries.

Ad Hoc filters will not report any student or course that is not enrolled or assigned to the school the filter is being run.  Any students or courses that need to be added to a school's mapping will need to be manually added using the Quick Search feature in the school's mapping tool.

The CRDC is run for previous years' data, not current years' data.

Images may display reference to a particular year. Users should update the year as appropriate for reporting. Information noted in each of the queries is current with CRDC requirements, regardless of the year displayed.

DISC-1a: Preschool Suspensions and Expulsions - One or More Out-of-School Suspension - For 2020-21 Version Only

Preschool Suspensions and Expulsions - One or More Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.


Filter Identifying Preschool Students with One or More Out of School Suspension


Preschool Suspensions and Expulsions - One or More Out-of-School Suspension - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying EL Preschool Students with One or More Out of School Suspension


Preschool Suspensions and Expulsions - One or More Out-of-School Suspension - with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying IDEA Preschool Students with One or More Out of School Suspension


DISC-1a: Preschool Suspensions and Expulsions - Only One Out-of-School Suspension - For 2017-18 Version Only

Preschool Suspensions and Expulsions - Only One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Preschool Students with Only One Out of School Suspension


Preschool Suspensions and Expulsions - Only One Out-of-School Suspension - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.


Filter Identifying EL Preschool Students with Only 1 Out of School Suspension


Preschool Suspensions and Expulsions - Only One Out-of-School Suspension - with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.


Filter Identifying IDEA Preschool Students with Only 1 Out of School Suspension


 

DISC-1b: Preschool Suspensions and Expulsions - Expulsions - For 2020-21 Version Only

Preschool Suspensions and Expulsions - Expulsions

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Preschool Students with Expulsions


Preschool Suspensions and Expulsions - Expulsions - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.


Filter Identifying EL Preschool Students with Expulsions


Preschool Suspensions and Expulsions - Expulsions - with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying IDEA Preschool Students with Expulsions


DISC-1b: Preschool Suspensions and Expulsions - More than One Out-of-School Suspension - For 2017-18 Version Only

Preschool Suspensions and Expulsions - More than One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Preschool Students with More than 1 Out of School Suspension


Preschool Suspensions and Expulsions - More than One Out-of-School Suspension - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying EL Preschool Students with More than 1 Out of School Suspension


Preschool Suspensions and Expulsions - More than One Out-of-School Suspension - with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying IDEA Preschool Students with More than 1 Out of School Suspension



 

DISC-1c: Preschool Suspensions and Expulsions - Expulsions - For 2017-18 Version Only

Preschool Suspensions and Expulsions - Expulsions

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Preschool Students with Expulsions


Preschool Suspensions and Expulsions - Expulsions - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying EL Preschool Students with Expulsions


Preschool Suspensions and Expulsions - Expulsions - with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.


Filter Identifying IDEA Preschool Students with Expulsions


 

DISC-2: Preschool Instances of Suspension

Preschool Instances of Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number Instances of Suspension for Preschool Students


Preschool Instances of Suspension with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number Instances of Suspension for IDEA Preschool Students



 

DISC-3: Corporal Punishment Indicator

Corporal Punishment Indicator

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Students with a Corporal Punishment Indicator


Corporal Punishment Indicator with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying IDEA Students with a Corporal Punishment Indicator



 

DISC-4: Preschool Corporal Punishment

Preschool Corporal Punishment

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of Preschool Students who Received Corporal Punishment


Preschool Corporal Punishment - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of EL Preschool Students who Received Corporal Punishment


Preschool Corporal Punishment - with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of IDEA Preschool Students who Received Corporal Punishment



 

DISC-5: Preschool Instances of Corporal Punishment

Preschool Instances of Corporal Punishment

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of Instances of Corporal Punishment for Preschool Children


Preschool Instances of Corporal Punishment with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of Instances of Corporal Punishment for IDEA Preschool Children


 

DISC-6: Instances of Corporal Punishment

Instances of Corporal Punishment

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of Instances of Corporal Punishment for Students in Grades K-12


 Instances of Corporal Punishment with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying the Number of Instances of Corporal Punishment for IDEA Students in Grades K-12



 

DISC-7a: Students who Received Corporal Punishment by Gender & Race

Non-IDEA Students who Received Corporal Punishment by Gender & Race

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA Students who Received Corporal Punishment by Gender & Race

Non-IDEA Students with EL who Received Corporal Punishment by Gender & Race

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA Students with EL who Received Corporal Punishment by Gender & Race



 

 DISC-7b: Non-IDEA Students who Received In-School Suspension by Gender & Race

Non-IDEA Students who Received In-School Suspension by Gender & Race

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA Students who Received In-School Suspension by Gender & Race

Non-IDEA Students with EL who Received In-School Suspension by Gender & Race

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA Students with EL who Received In-School Suspension by Gender & Race

 

DISC-7c: Discipline of Students without Disabilities - Only One Out-of-School Suspension

Discipline of Students without Disabilities - Only One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA Students who Received One Out of School Suspension


Discipline of EL Students without Disabilities - Only One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.



Filter Identifying Non-IDEA EL Students who Received One Out of School Suspension


 

DISC-7d: Discipline of Students without Disabilities - More than One Out-of-School Suspension

Discipline of Students without Disabilities - More than One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA Students who Received More than One Out of School Suspension


Discipline of Students without Disabilities - More than One Out-of-School Suspension - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Non-IDEA EL Students who Received More than One Out of School Suspension


 

DISC-7e: Discipline of Students without Disabilities - Expulsions with Educational Services

Discipline of Students without Disabilities - Expulsions with Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students without Disabilities - Expulsions with Educational Services


Discipline of Students without Disabilities - Expulsions with Educational Services - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students without Disabilities - Expulsions with Educational Services


 

DISC-7f: Discipline of Students without Disabilities - Expulsions without Educational Services

Discipline of Students without Disabilities - Expulsions without Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students without Disabilities - Expulsions without Educational Services


Discipline of Students without Disabilities - Expulsions without Educational Services - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students without Disabilities - Expulsions without Educational Services


 

DISC-7g: Discipline of Students without Disabilities - Expulsions Under Zero-Tolerance

Discipline of Students without Disabilities - Expulsions Under Zero-Tolerance

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students without Disabilities - Expulsions Under Zero-Tolerance


Discipline of Students without Disabilities - Expulsions Under Zero-Tolerance - with EL

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students without Disabilities - Expulsions Under Zero-Tolerance


 

DISC-8a: Transfer to Alternative School for Students without Disabilities

Transfer to Alternative School for Students without Disabilities

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Transfer to Alternative School for Students without Disabilities


 

DISC-9a: Discipline of Students with Disabilities - Corporal Punishment

Discipline of Students with Disabilities - Corporal Punishment

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

   

Filter Identifying Discipline of Students with Disabilities - Corporal Punishment


Discipline of Section 504 Students with Disabilities - Corporal Punishment

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - Corporal Punishment



Discipline of EL Students with Disabilities - Corporal Punishment

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - Corporal Punishment


 

DISC-9b: Discipline of Students with Disabilities - One or More In-School Suspensions

Discipline of Students with Disabilities - One or More In-School Suspensions by Gender and Race

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students with Disabilities - One or More In-School Suspensions


Discipline of Section 504 Students with Disabilities - One or More In-School Suspensions

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - One or More In-School Suspensions


Discipline of EL Students with Disabilities - One or More In-School Suspensions

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - One or More In-School Suspensions


 

DISC-9c: Discipline of Students with Disabilities - Only One Out-of-School Suspension

Discipline of Students with Disabilities - Only One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students with Disabilities - Only One Out-of-School Suspension


Discipline of Section 504 Students with Disabilities - Only One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - Only One Out-of-School Suspension


Discipline of EL Students with Disabilities - Only One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - Only One Out-of-School Suspension


 

DISC-9d: Discipline of Students with Disabilities - More than One Out-of-School Suspension

Discipline of Students with Disabilities - More than One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students with Disabilities - More than One Out-of-School Suspension


Discipline of Section 504 Students with Disabilities - More than One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - More than One Out-of-School Suspension


Discipline of EL Students with Disabilities - More than One Out-of-School Suspension

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - More than One Out-of-School Suspension


 

DISC-9e: Discipline of Students with Disabilities - Expulsions with Educational Services

Discipline of Students with Disabilities - Expulsions with Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students with Disabilities - Expulsions with Educational Services


Discipline of Section 504 Students with Disabilities - Expulsions with Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - Expulsions with Educational Services


Discipline of EL Students with Disabilities - Expulsions with Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - Expulsions with Educational Services


 

DISC-9f: Discipline of Students with Disabilities - Expulsions without Educational Services

Discipline of Students with Disabilities - Expulsions without Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students with Disabilities - Expulsions without Educational Services


Discipline of Section 504 Students with Disabilities - Expulsions without Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - Expulsions without Educational Services


Discipline of EL Students with Disabilities - Expulsions without Educational Services

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - Expulsions without Educational Services


 

DISC-9g: Discipline of Students with Disabilities - Expulsions Under Zero-Tolerance

Discipline of Students with Disabilities - Expulsions Under Zero-Tolerance

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Students with Disabilities - Expulsions Under Zero-Tolerance


Discipline of Section 504 Students with Disabilities - Expulsions Under Zero-Tolerance

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of Section 504 Students with Disabilities - Expulsions Under Zero-Tolerance


Discipline of EL Students with Disabilities - Expulsions Under Zero-Tolerance

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Discipline of EL Students with Disabilities - Expulsions Under Zero-Tolerance


 

DISC-10: Transfer to Alternative School for Students with Disabilities

Transfer to Alternative School for Students with Disabilities

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Transfer to Alternative School for Students with Disabilities


 

DISC-11: Instances of Suspension

Instances of Suspension with Section 504

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Instances of Suspension


Instances of Suspension with IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Instances of Suspension with IDEA


Instances of Suspension without IDEA

Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying Instances of Suspension without IDEA


 

DISC-12: School Days Missed Due to Out-of-School Suspension 

School Days Missed Due to Out-of-School Suspension

 Create a filter similar to the example below using the Query Wizard and the Student Data Type.

Filter Identifying School Days Missed Due to Out-of-School Suspension

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com