This is a collection of queries related to Assertive Discipline (ADS/DSP) and Discipline (DIS) that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

EOY 3 Discipline Queries for Reconciling CALPADS Data


See: EOY 3 Discipline Queries and Reports


List of Students with an Assertive Discipline Flag

Provides a list of students with Grade, Name, Assertive Discipline Code, Description of the Code, Date, and Disposition with an Assertive Discipline Code.


LIST STU ADS FLG STU.GR STU.NM ADS.CD ADS.CD? ADS.DT ADS.DS IF FLG.TC = ADS


List of Students with an Assertive Discipline or Disposition on a Specific Date

List of students with Assertive Discipline or Disposition record information for a specific date


LIST STU ADS DSP STU.ID STU.NM STU.GR ADS.DT ADS.CD? DSP.DS DSP.DD DSP.ED IF ADS.DT = 08/20/2018 OR DSP.DD > 08/20/2018


Assertive Discipline Information for a Specific Disposition Entry and a Specific Disposition Start Date

List of students with Assertive Discipline information who received a Disposition Code entry on a specific Disposition Start Date


LIST STU ADS DSP STU.ID STU.NM STU.GR ADS.DT ADS.CD? DSP.DS DSP.DD DSP.ED IF DSP.DD = ##/##/20## 


List Identifying Students by ID Only with a Disposition of Suspension Sorted by Assertive Discipline Code

List identifying students sorted by ID only with ADS/DSP information for any student whose disposition was a suspension sorted by Assertive Discipline Code for the current year


LIST STU ADS DSP STU.ID ADS.DT ADS.CD? DSP.DS DSP.DY DSP.DD DSP.ED BY ADS.CD IF DSP.DS : SUS AND ADS.DT > 06/30/20XX


List of All Students with an Assertive Discipline Record for the Current School Year - Used for Reconciling Fall2 Data

List identify all Assertive Discipline entry on students sorted by School and Student Name and including Special Education status for the current school year to reconcile Assertive Discipline data with CALPADS.


LIST STU IDN CSE ADS DSP STU.SC STU.NM DSP.SC ADS.IID ADS.DT ADS.CD ADS.CD? DSP.DS DSP.DD DSP.ED DSP.DY ADS.CO CSE.DI CSE.XD BY STU.SC STU.NM IF DSP.DD > 06/30/####


List of Demographic Data and Assertive Discipline Records for Students for the Current Year 

List of student with demographic data if an Assertive Discipline record was added during the current school year


LIST STU ADS DSP STU.ID STU.NM STU.GR STU.SX STU.ETH STU.RC1 ADS.CD ADS.CD? ADS.DT DSP.DS DSP.DY DSP.DD DSP.ED DSP.AA DSP.PL DSP.RS IF ADS.DT > 06/30/20##


List of Suspensions

List of Suspended Students sorted by Student Name and Assertive Discipline Date


LIST STU ADS DSP STU.ID STU.NM ADS.DT ADS.CD DSP.DS BY STU.NM ADS.DT IF DSP.DS : SUS


List of Suspensions for Current School Year

List of Suspended Students for the current school year sorted by Student Name and Assertive Discipline Date


LIST STU ADS DSP STU.ID STU.NM ADS.DT ADS.CD DSP.DS BY STU.NM ADS.DT IF DSP.DS : SUS AND DSP.DD > 06/30/20##


List of Students with a Suspension, In-House Suspension, Period Suspension or Expulsion for the Current School Year

List of student who have Suspension or Expulsion records for the current year


LIST STU ADS DSP STU.SC STU.ID STU.CID STU.NM DSP.DS DSP.DY ADS.DT ADS.CD ADS.CD? IF ADS.DT > 06/30/20## AND DSP.DS = SUS OR DSP.DS = SUS-H OR DSP.DS = SUS-P OR DSP.DS = EXP


List of Students with a Discipline (DIS) record on a specific date


LIST STU DIS DIS.DT STU.NM STU.ID STU.GR DIS.CD? DIS.CN IF DIS.DT = 02/21/2022



List of Students with demographic data, by Discipline (DIS) record date for current school year


LIST STU DIS DIS.DT STU.NM STU.GR STU.GN STU.ETH STU.RC1 DIS.ET DIS.LCN DIS.CD DIS.CD? DIS.PM DIS.CN DIS.CO IF DIS.DT > 8/01/2021 AND DIS.DT < 6/30/2022  



List of Discipline (DIS) records by Student and date


LIST STU DIS STF STU.NM STU.GR DIS.DT DIS.CD? DIS.CN DIS.CO DIS.SID STF.LN BY STU.NM DIS.DT IF DIS.CD # " "



List of Students with a DIS Flag


LIST STU DIS FLG STU.NM STU.GR DIS.CD? DIS.DT FLG.CO IF FLG.TC = DIS