TABLE OF CONTENTS
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.
Discipline 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
Texas Discipline Queries
List of Discipline (DIS) records by Student and date
List of a comprehensive listing of Assertive Discipline (ADS) and Dispositions (DSP) based a on specific date
LIST STU IDN CSE ADS DSP STU.ID STU.NM STU.GR ADS.DT ADS.IID ADS.SRF ADS.CD ADS.CD? DSP.DS DSP.DS? DSP.IDY DSP.IDD DSP.IED DSP.IRD DSP.DY DSP.DD DSP.ED DSP.RD DSP.RDD CSE.DI CSE.XD IF ADS.DT >= ##/##/20##
List of referrals coded with 'Yes' for Safe and Supportive Schools Program (SSSP)
NOTE: Be sure to select Include Inactive Students.
LIST STU ADS DSP STU.SC STU.GR STU.ID STU.FN STU.LN ADS.IID ADS.DT ADS.INI? ADS.CD? ADS.CO ADS.SSP ADS.SDT BY STU.SC IF ADS.DT >= 8/16/23 AND ADS.SSP = Y AND STU.TG # *