Assertive Discipline Changes

Tags: Assertive Discipline, Discipline, Discipline changes, Dispositions, DSP, ADS

Major changes were released for the Assertive Discipline form.  Previously, each Assertive Discipline record could only store 3 different Disposition codes and there was only one set of related disposition fields for all 3 dispositions.  

The major enhancement will now allow multiple disposition records to be stored.  This allows the LEA to report to the State the final disciplinary action taken, as the action may progress for the student (i.e. suspension leading to expulsion).  This will also allow for the disciplinary action duration to be kept per disposition, enabling the LEA to keep track of the days of suspension as well as the days of expulsion under the same discipline record.

The Assertive Discipline form has undergone many enhancements, including making the form larger. The new Disposition (DSP) table will now be used to store multiple Disposition records.  The number of Dispositions that can be added to an Assertive Discipline record are unlimited in the DSP table however the form can only display up to 10 dispositions for a single ADS record.  The order in which the fields display on the Assertive Discipline form has also changed.  The new DSP disposition fields will display at the bottom of the form to allow new records to be added and displayed.  An option has been added that will allow you to view the old ADS disposition fields.  All old ADS disposition fields will be displayed with parenthesis around the field names.

The districts network administrator must verify that any user who can view or update Assertive Discipline (ADS) has matching permissions to the new DSP table.   Also, the Victims (VIC) and Witnesses (WIT) tables should have an additional level of security due to the confidential nature of the data.

All Disposition codes that are set up in the COD table for ADS.DS will be automatically converted over to the DSP.DS field in the COD table.  This will also include the ADS.RST, ADS.RL, ADS.AA, ADS.RS and ADS.ST codes.

Records with Disposition codes in the ADS table should be converted over to the DSP table using the Copy Dispositions From ADS to DSP macro.  Not all Disposition records can be converted using this macro. Any ADS record that has more than one disposition and information added to the disposition fields, such as Disposition Start Date (ADS.DD) cannot be converted.  We cannot determine which Disposition code goes with the entered data. 

After running the Copy Dispositions From ADS to DSP macro, run the Print ADS to DSP Conversion Audit Report to generate a report of the records that could not be converted.

All Disposition fields from the ADS table that have been setup on the Define Required Fields form that have Required Fields and Limited Dropdown settings for the Disposition and related data fields will be automatically copied so that they work appropriately with the DSP fields. The original settings for the ADS fields in the Define Required Fields form will be del-tagged.

These changes are to help Districts submit Discipline data cleanly to CALPADS.  Previously, some districts were creating multiple ADS records for the same student for the same incident with different Dispositions to track the student’s progression.  This affected their districts CALPADS reporting.  The changes made to ADS with the addition of the DSP table enable you to track all that information on a single discipline record and not have to use a work-around that caused issues with CALPADS reporting.

If the ADS records have the Days and Start and End Date fields associated with the most severe disposition, those records will be extracted correctly in the CALPADS EOY extract and do not need to be converted.

Please remember that it is VITAL that all Access Users are running on the latest Access Service Pack.  This is critical, especially for older versions of Access (Access XP/2003) that could potentially crash if they don’t have the latest service pack installed.  Please refer to our Compatibility document for specific details at the following link:  

Please note that your saved disposition Query statements will no longer be valid!  They will need to be rewritten to include both ADS and DSP disposition codes.  Examples are now available out on the web site at the following link:

We understand that these changes are extensive, but were necessary to allow Aeries to more closely match the data reporting requirements of the State.