Detailed List of Recent AERIES Changes

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.
Version Date - 2/2/2018
Comments
A new Primary Contact field has been added to the Contacts table, please see the Web Detailed Revision Notes for more information.
Define Required Fields For Data Entry - Emergency Contacts (CON) now allows requiring new fields: Educational Rights Holder (ERH), Attendance Notification (AN), and Primary Contact (PC). Please note that these fields are not visible on the Emergency Contacts form in Aeries Client but can be defined as required for the Web.
DST - Create CCGI Extract - The ATP code was not extracting, or using the previous value, when extracting work-in-progress records, fixed.
Version Date - 1/26/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 - 1/19/2018
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Version Date - 1/11/2018
Comments
Added Dual Enrollment Credit School to Transcripts (HIS.SDE) for use in Aeries Web.
DST - Import CASEMIS Files - due to expanding technologies that cannot be matched in the Client, this update will disable Import CASEMIS Files in the Client version.
Version Date - 12/21/2017
Comments
AdminCS - Force An Update macro - removed old logic to convert the Teacher Grades field (TCH.PD) to Low (TCH.LO) and High (TCH.HI). The old Grades field is not visible in Aeries Web and running Force An Update had the potential to replace updated information with old data.
Query now lists ADS.RF as "Referrer" instead of "Referral" to match the Assertive Discipline page in Aeries Web.
Version Date - 12/8/2017
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to update the End Date in the Gradebook Students table (GBU.D2) based on Course Attendance when a student is in multiple sections with different terms associated with the same gradebook.
Added Type field to Page Hit Log (PHL.TY) for use in Aeries Web.
Version Date - 12/1/2017
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
DST - Create CALPADS Extracts - updated CBEDS code range for CTE courses from 4000-5999 to 7000-8999
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to populate new IDN.CID (State ID) field based on existing data in STU.CID for use with the District Student Lookup in Aeries Web.
Version Date - 10/27/2017
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Students (SCH and DST) - updated the ControlTipText over the "Counted in CBEDS" (STU.CIC) field to properly reflect its use: "Flag can be set by the Student Counts (CBEDS) report when run on CBEDS Information Day." This field was previously flagged as old.
Version Date - 10/20/2017
Comments
DST - Create CBEDS ORA Files - the program has been updated to comply with the 2017-18 layout, July 14, 2017 - version 10.0.3
DST - Create CALPADS Extracts - the Direct Certification functions will stay disabled and will only be available in the Web version of Aeries. On the SPRG extract, special education records (code 144) will not be closed anymore based on the enrollment exit date. Also, the SPRG extract has been modified so there can be multiple 504 - FOF table (code 101) program records. Additionally, the logic for the Reduced (code 182) records was revised.
Increased Test ID fields to 8 characters including: Test Scores ID (TST.ID), Test Exclusions ID (TEX.ID), Records Transfer Test ID (RT_TST.ID), Content Standard Scores Related Test ID (CST.RT), and Records Transfer Content Standard Scores Related Test ID (RT_CST.RT).
Version Date - 10/4/2017
Comments
New fields have been added in Aeries, please see the Web Detailed Revision Notes or Recent Database Changes for more information.
Version Date - 9/29/2017
Comments
DST - Print Supplemental Attendance Report (CCLC/ASES and ASSETs) has been converted to Aeries Web. These reports will no longer allow processing for school years 2016-17 or later in Aeries Client.
Added Required for Attendance field to Supplemental Attendance Assignments (ATA.RA).
Version Date - 9/26/2017
Comments
Tables and fields have been modified in Aeries, please see the Web Detailed Revision Notes for more information.
AdminCS - Print Records with Invalid Key Values - report would not reprocess data on subsequent runs, fixed.
DST - Create CALPADS Extracts - disabled the Direct Certification buttons until the changes with the new rules are implemented. Please see the CALPADS Info button for more information.
Orchard.DisplayManagement.Shapes.Shape