Detailed List of Recent AERIES Changes

Version Date - 6/3/2019
Comments
AdminCS - "Updating your SQL database…" or Force An Update macro - the 5/31 update had the potential of giving Foreign Key errors when trying to apply the new relationship between Document Confirmation Log and Documents (FK_DCL_DCS), fixed.
Version Date - 5/31/2019
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.
Emergency Contacts - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client this has been disabled.
Medical - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client this has been disabled. Also, the Immunization reports have been disabled.
Version Date - 5/17/2019
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.
New Year Rollover forms and reports have been disabled for the 2018-19 school year. Please use the Aeries Web version.
Import Fixed Length Files (SCH and DST) - added the following message upon opening the form: "Please note that this form is not being updated with new testing file layouts as of the 2018-19 school year. Use Import Test Results page in Aeries Web for new layouts."
Version Date - 5/7/2019
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 - 4/26/2019
Comments
A new table has been added to Aeries for Pre-Enrollment Information (PEI), please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 4/19/2019
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 - Default Query Title (DAI.QTI) values will be added for databases that already have the LCAP Dashboards installed. Also, the text "> 3%" will be removed from LCAP Programs indicator and subgroup titles.
Version Date - 4/11/2019
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - because of the change of some CALPADS codes descriptions, the XRF description field for MST.INS and DSP.DS is being updated to match the current definition.
Added State field to the usysGCOD table to differentiate between California and Texas fixed codes
Version Date - 3/29/2019
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 - 3/22/2019
Comments
New 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) - this form has been disabled for the 2018-19 school year. Please use the Aeries Web version.
AdminCS - "Updating your SQL database..." or Force An Update macro - added 2900 "Fixed code" values to the usysGCOD table including ABS.TY, CON.NP, CRS.NA, CRS.CP, CTS.ST1, LOC.A-Z, and many more. The usysGCOD table is used by Query in the Aeries Web version to retrieve fixed code descriptions when using the "?" method.
AdminCS - "Updating your SQL database..." or Force An Update macro - because the "ClassSchedulingOld" and "CourseRequestsOld" pages have been renamed in Aeries Web, this version will del-tag those pages from User Favorites in the USO table.
Version Date - 3/13/2019
Comments
New tables have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Version Date - 2/22/2019
Comments
Letters to Parents - this process will be disabled based on the new District Setting in Aeries Web to "Disable School Based Attendance Letters".
Increased Inter/Intra District Transfer Code fields in the Students, Attendance, and Enrollment tables for future use. Also deleted unnecessary Attribution Code field from the Students table.
Version Date - 2/8/2019
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Create Pre-Enrolled Students (DST and AdminCS) - this form has been disabled for the 2018-19 school year. Please use the Aeries Web version.
Version Date - 1/30/2019
Comments
New gender fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Disabled some Student-related forms due to changing "Sex" to "Gender" in Aeries Web. Specifically: Carl Perkins (DST), Students, Student Demographic Update Information, and Aeries AIR - Online Student Enrollment.
Disabled many Student-related reports due to changing "Sex" to "Gender" in Aeries Web.
AdminCS - Aeries Control Panel has been modified to no longer display unnecessary processes that have already been converted for use in Aeries Web.
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. Also added logic in the Force An Update date selection to only update to the current revision date and not a future date.
AdminCS - "Updating your SQL database...", Force An Update macro, or Update Aeries SQL Databases - these processes had the potential to give errors when run on databases prior to 2017-18. This was caused by the Test Name field in the Testing Control Table (CTL.NM) being only 24 characters prior to February 2017. Today's update will ensure the field size is updated in these databases prior to default values being loaded.
Version Date - 1/17/2019
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/4/2019
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 ensure student totals are correctly calculated for all Elementary teachers. Specifically, the totals for teacher zero were not being updated in Aeries Web.
AdminCS - "Updating your SQL database..." or Force An Update macro - adjustments have been made to data in the CSN table for MAPREAD, parts 9 to 12. Due to a trailing space in the part name, this could result in a primary key error, fixed.
Version Date - 12/14/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 - 12/7/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.
AdminCS - "Updating your SQL database..." or Force An Update macro – runs a one-time data conversion on the Special Education (CSE) table to update existing values in several fields to the 2018-19 code set based on the latest Special Ed Data Model v3.2 from the CDE.
Version Date - 11/30/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 - 11/16/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 - 11/2/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.
NWEA MAP Test Results - the district form has been updated with the new parts for 2018-19. Also, there is new logic that will account for similar part descriptions (i.e. the difference is a word in plural, or an extra space), so no new parts need to be added. Due to these changes this page has been disabled in the school application, it will now only be available in the District.
Grade Reporting - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following forms have been disabled beginning with the 2018-19 school year: Create New Grade Reporting Table, Grade History, Grade Reporting Address Options, Grade Reporting Options, Grades, Grades By Teacher, Grades/History, Off Grade Courses, Read Grade Report Scanner Sheets (all), Transcript Definition, Transcript Setup And Printing, Transcripts, Update Grade Reporting Codes And Descriptions, Update Multiple Mark Headings And Descriptions, and Update Valid Marks.
Grade Reporting Cycle - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client certain buttons have been disabled beginning with the 2018-19 school year.
College Requests - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the Recompute and Print buttons have been disabled beginning with the 2018-19 school year.
Period Attendance Cycle - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client button "Z. Copy Absences to Grade Report Table" has been disabled beginning with the 2018-19 school year.
AdminCS - "Updating your SQL database..." or Force An Update macro - adjustments have been made to data in the FTD.PT field as well as the COD table to accommodate some new "credit" fixed codes being used for Aeries Financials. This process will only be run once per database.
Version Date - 10/22/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 - 10/3/2018
Comments
DST - Create CBEDS ORA Files - the program has been updated to comply with the 2018-19 layout, July 12, 2018 - version 11.0.1
Version Date - 9/28/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 copy the previously hard-coded values for Financial Payment Types (FTD.PT) into the COD table, allowing user-defined codes in Aeries Web.
Version Date - 9/21/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 - Force An Update macro - added a date selector to allow only running updates for the past 6 months by default.
AdminCS - "Updating your SQL database..." or Force An Update macro - added missing relationship between the Course (CRS) table and Composite Courses (CMP). Also added logic to copy the previously hard-coded values for Master Schedule Hourly Program (MST.HP) into the COD table, allowing user-defined codes in Aeries Web.
AdminCS - "Updating your SQL database..." or Force An Update macro - added logic to check for students without an assigned Permanent ID (STU.ID = 0) and give a warning that Aeries does not support students without IDs.
Define Required Fields for Data Entry - selecting the "Students" form from the dropdown had the potential to give the message "Modifications (Add/Change/Delete) to Students will be disabled soon in the Client version. Please use the Aeries Web version.", fixed. This message should only display when opening the Students form.
Orchard.DisplayManagement.Shapes.Shape