Detailed List of Recent AERIES Changes

Version Date - 8/17/2018
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 8/10/2018
Comments
Aeries Control Panel (SCH and DST) - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following forms have been made read-only beginning with the 2018-19 school year: School Options, Calendar, Courses, Master Schedule, Teachers, and Staff.
Individualized Academic Plan - the Academic Plan has been greatly enhanced in Aeries Web. The Aeries Client does not have the new features and has been disabled in the 2018-19 school year.
State Seal of Biliteracy - This major feature will only be able to be run against prior year databases. The business logic behind the program has been changed and those changes are not supported in the Aeries Client.
Version Date - 8/3/2018
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to set existing Master Schedule and Scheduling Master grade-ranges based on the grade-range of the Schools when they are not already set. This only applies to records with a grade-range of zero-zero, in a school that doesn't include Kindergarten in its grade-range.
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to process existing Transcript (HIS) update permission to set new Transcript Comment and Grad Track permission. Please see the Web Detailed Revision Notes for more information.
AdminCS - "Updating your SQL database…" or Force An Update macro - has the potential to give Invalid Use of Null errors since the 7/24 update, fixed.
Version Date - 7/27/2018
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to process existing Parent Data Confirmation settings and set Parent Portal update permission to the Authorizations (AUT) and Medical History (MHS) tables accordingly. Also added logic to deny field-level update permission by default to Contact (CON) fields newly available for updating in Parent Data Confirmation. Please see the Web Detailed Revision Notes for more information on these changes.
AdminCS - "Updating your SQL database..." or Force An Update macro - the DateTimeStamp trigger for the User and Group Permissions table didn't include the recently added Year field (UGP.YR), fixed.
AdminCS - "Updating your SQL database..." or Force An Update macro - added scale scores in TNP (SPRG18) for CAASPP, CAA, and STS
Version Date - 7/24/2018
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to check for the rare situation where the Account IDs between Portal Accounts (PWA.AID) and the related Portal Account Student (PWS.AID) are not properly synced. The potential for this mismatch has been repaired in today's Web version. Also, will no longer prompt the "No users with invalid passwords" after each update, a warning message will only appear when there are invalid passwords in the database.
Version Date - 7/20/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 7/13/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Print Monthly Attendance Reports, Print Monthly Attendance Summaries, Year to Date (YTD) Attendance Totals, and YTD Attendance by Student - due to expanding technologies that cannot be matched in the Client, this update will disable YTD forms and reports in the Client version. Please note that these changes will not affect prior-year databases.
Attendance - due to expanding technologies that cannot be matched in the Client, this update will disable updating of Attendance in the Client version. Please note that these changes will not affect prior-year databases.
Discipline - due to expanding technologies that cannot be matched in the Client, this update will disable updating of Discipline in the Client version. This includes Assertive Discipline, Dispositions, Expulsions, Discipline, Victims and Witnesses. Please note that these changes will not affect prior-year databases.
AdminCS - "Updating your SQL database..." or Force An Update macro - updated the description for CALPADS codes E140 from "Left - Next School Unknown" to "Truant - Next School Unknown".
Import Grades - updated this form to allow importing of 3-character grade marks.
Version Date - 7/10/2018
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to evaluate invalid Free and Reduced Meals that were added and updated during the recent Parent Data Confirmation "Income Survey" process. New records that were added will be delete-tagged as the eligibility guidelines were incorrect. Existing records that were closed-out will be updated with their original end dates. Also the Information Confirmation Logs will be updated to reflect the now incomplete Income Survey process. Please be aware that parents that have already completed the Income Survey and the Final Data Confirmation will be prompted to complete these two steps in Parent Data Confirmation again.
Import Fixed Length Files - added new PFT18 layout for San Joaquin County Office of Education (PFT18SJC). Please note - this layout includes pass status for each category and will update the Physical Fitness Test Pass Flags.
AdminCS - "Updating your SQL database..." or Force An Update macro - added ELPAC parts to the Testing Control (CTL) table for districts who do not import ELPAC but rather enter the scores manually.
The ABI end of life was three years ago. The following deprecated forms and reports have been permanently removed from Aeries: Print ABI Lunch Count, Print Missing ABI Lunch Count, Print Temporary ABI Accounts, Create Temporary ABI Accounts, Web Users, and Migrate from ABI to New Portal (AdminCS).
Version Date - 6/29/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 6/22/2018
Comments
A new table has been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 6/15/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 6/8/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Free and Reduced Meals (SCH and DST) - due to expanding technologies that cannot be matched in the Client this form will become read-only in the 2018-19 school year.
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to delete any orphaned HSG records prior to fixing the missing relationship between IDN and HSG.
Version Date - 6/1/2018
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
usysGCOD – added Career Pathway code 999 – Multiple Pathways
Version Date - 5/25/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
AdminCS - New Year Cycle - added a noticeable label promoting the Rollover process in Web.
AdminCS - Copy Aeries Tables From Last Year/CS - added new tables for the 2018-19 Rollover.
AdminCS - Define Student Table Relationships/CS and SqlModel.sql - added logic to allow the Grade Reporting GPAs (GRG) table to be ID-based. Grade Reporting GPA calculations will now populate the new School field (GRG.SCL).
AdminCS - Aeries Control Panel - modified code that prevents the Database Cleanup routine from being run based on "DoNotCleanDB" value in DPT. A value of "True" prevents the entire process from being run, while a value of "Partial" runs everything except the hard-delete logic. This value must be manually added to the DPT table.
Version Date - 5/18/2018
Comments
New Charter School# field in Schools table (LOC.CH) for use with the new Physical Fitness Extract in Aeries Web.
Version Date - 5/8/2018
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - added additional data conversion for the new Service Learning tables.
Version Date - 5/4/2018
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Create ROP Extract - added an option to "Remove invalid characters from text fields". This was done specifically to remove unnecessary characters such as quotes from names and address fields. When the option is not selected, we will now wrap a single quote to create a valid value. For example, if a contact name is incorrectly entered as James O"Kelly, the option to Remove invalid characters will result in the field extracting as "James O Kelly", turning off the option will result in "James O""Kelly".
Version Date - 4/27/2018
Comments
The Aeries Student Information System will now start sending anonymous usage data back to Aeries Software. This information will be used to help improve the system and help to identify trends with system usage and errors.
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Create Fitness Extract (SCH and DST) - updated for the SPRG18 layout. There were no changes between the SPRG17 and SPRG18 files.
Import Fixed Length Files (SCH and DST) - added the PFT18 layout for the 2017-18 school year. Please note - this will load the State-defined Student Record Layout that vendors send to the State, not the results file that the vendor sends back including the PASS status.
AdminCS - "Updating your SQL database..." or Force An Update macro - added additional indexes to enhance overall system performance. These indexes were also added to SqlModel.sql for use with newly created databases.
Version Date - 4/13/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Print Street Address Error Listing - added support for Preschool and Transitional Kindergarten. Also default to Use Residential Address instead of Mailing, and show Address Verified option in Red until checked.
Version Date - 3/30/2018
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to clear out the Summer School Course Request options if used in the prior year.
AdminCS - Copy Aeries Tables From Last Year/CS - this form was not properly clearing out the Summer School Course Request options from the prior year, fixed.
Create ROP Extract - updated to include English Language Learner flag to the end of the record.
Version Date - 2/28/2018
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Orchard.DisplayManagement.Shapes.Shape