Detailed List of Recent AERIES Changes

Version Date - 10/3/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.
AdminCS - "Updating your SQL database..." - updated the Vaccination Requirements table (VAC) to properly handle the Tdap and HepB requirements.
AdminCS - "Updating your SQL database..." - Updated CBEDS/CALPADS codes according to the new CALPADS code set (v.11.0) for the 2019-20 school year.
AdminCS - Aeries Log Table Analysis - this form had the potential to give "The field is too small" errors, fixed.
Version Date - 9/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 - 9/6/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.
AdminCS - "Updating your SQL database..." - this update will prepopulate a new Parent View flag (ERL.PV) for students whose parents have already downloaded the Electronic Score Reports as determined by the existence of PHL records for State Score Reporting.
Version Date - 8/23/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.
AdminCS - "Updating your SQL database..." - added logic to convert existing Required Field records in TFR to the new method, exchanging form names (i.e. Courses and subCON) for table names (i.e. CRS and CON). For use in Aeries Web.
Define Required Fields for Data Entry - added a warning "This page is now available in the Aeries Web version. Please note that changes made on this Client form will NOT be reflected in Aeries Web!"
Due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following forms have been disabled: Elementary Classes, Elementary Classes for Next Year, Language Assessment, Lockers, Scheduling Master Schedule, and Special Education Data. These were the only forms available from Define Required Fields for Data Entry that were not already disabled.
Version Date - 8/21/2019
Comments
The Testing Control tables (CTL, CSN, and TNP) have new records for use with the SPRG19 CAASPP Test Load. Please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
AdminCS - "Updating your SQL database…" - redesigned the Grade Reporting GPAs (GRG) table to include the School Code (SCL) field as part of the Primary Key, allowing tracking of records as students transfer schools mid-year. Because of this structural change, updating of this table has been disabled in Aeries Client. The processes related to the GRG table have not been disabled, but the table will not be updated or display in Aeries Client.
Create UC ELC Extract - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client this has been disabled.
Added Received Industry Certificate (RC) to the Secondary Student Data (SSD) table for future use.
Version Date - 8/8/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.
AdminCS - "Updating your SQL database…" - added logic to delete-tag and warn when invalid Physical Fitness Tests existed where Test Admin is "1". This was caused when a student did not take the test, and the records were loaded in Aeries Web, fixed.
AdminCS - "Updating your SQL database…" - added logic to ensure that all School Holiday (#) and Not in Session (@) codes in the Calendar Holiday Code (DAY.HO) are propagated through all Track Holidays (DAY.T1 thru DAY.T26).
Version Date - 7/26/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.
AdminCS - "Updating your SQL database..." or Force An Update macro - because the "Attendance by Photo (New)" and "Attendance by Photo" pages were renamed to "Attendance by Photo" and "Attendance by Photo - Old", respectively, this version will update those page names under User Favorites in the USO table.
Due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following forms have been disabled: College Requests, Input CAHSEE Scores, District Supplemental Data, Special Programs, Student Class Schedules, and Supplemental Data.
Version Date - 7/12/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…" - added logic to warn that IB College Test Score codes are no longer user-defined and that existing values may need to be changed.
Due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following forms have been disabled: Class Scheduling, Course Attendance, Define Student Grade Levels, Extracurricular Activities, GATE, Interventions, and Miscellaneous Student Data.
Discipline - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following has been disabled on this form: SSA Date, Red Flag and Red Flag Comment, and the <<New Record>> link at the bottom of the record selection list. Please note, most information on this form was already read-only.
Siblings - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following has been disabled on this form: Family Key, Red Flag, and Red Flag Comment. Please note, most information on this form was already read-only.
Version Date - 6/21/2019
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Calendar - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following has been disabled: Bell Schedule pop-up.
Attendance - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client the following have been disabled: Attendance Note envelope, Other District Enrollment tab.
College Entrance Tests/Requirements - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client this has been disabled.
Define College Entrance Test Codes (SCH and DST) - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client this has been disabled.
Counseling - due to planned or already existing changes made to Aeries Web that are incompatible with the Aeries Client this has been disabled.
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.
Orchard.DisplayManagement.Shapes.Shape