Detailed List of Recent AERIES Changes

Version Date - 7/2/2020
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.
Many forms (SCH) have been disabled as they are now available in Aeries Web or no longer necessary: Copy One Students Records From Another School, Copy One Students Related Records From Another School, Copy Students From Another School, Define Required Fields For Data Entry, Import Grades, Import Grades/old, Mass Change Course Requests, Mass Change Every N ATT Code, Mass Change Section Numbers, and Mass Input Attendance Codes
Many forms (SCH and DST) have been disabled as they are now available in Aeries Web or no longer necessary: Mass Add Student Pictures, Physical Fitness Setup, Send Emails, Status Code Color Assignments, Streets, Student Documents, Testing Control Table, Update Absence Codes, Update Code Table, Update Cross Reference Table, and Update Tables To Copy.
Query (SCH and DST) - the "Change" command and form have been disabled as they are available in Aeries Web. Also deleted the "Query/old" form as it is no longer necessary.
Physical Fitness macros have been disabled as they are now available in Aeries Web: Recalculate Body Mass Index, Recalculate Percentage Body Fat, and Recalculate VO2max Scores.
Many forms (DST) have been disabled as they are now available in Aeries Web or no longer necessary: Copy Aeries Data From Summer Schools/CS, Define Fields to Sync/Lock, Define Tests To Print On Transcripts, Physical Fitness Setup, Pull ENR From Another Database/CS, and Update History From Summer Schools Grades/CS.
DST - The following forms have been disabled for Aeries Client as they were designed for Aeries XP and are no longer necessary: Run Timed Procedures, and Update Database from Local Copy.
Client Server Security (DST and AdminCS) has been disabled as it is available in Aeries Web.
Language Assessment (SCH and DST) - the buttons on the Functions tab have been disabled as of the 2019-20 school year.
Copy Recent CELDT test scores from TST to LAC (SCH and DST) - this macro has been disabled as of the 2019-20 school year.
AdminCS - Aeries Control Panel - added a reference to the location where Administrative Functions can be found in the Aeries Web version.
Version Date - 6/18/2020
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.
Increased the size of the following fields in the Aeries "model" databases to match recent changes made in SQL: Course Description (CRS.DE), Course Sequence (CRS.CSQ), Portal Web Account IP Addresses (PWA.LIP, PWA.CIP), and Staff Credentials Type (STC.TY). These changes will alleviate "The field is too small" errors when attempting to cache these tables.
DST - Combine Student Records form has been disabled as it is available in Aeries Web.
Version Date - 6/8/2020
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.
The Aeries Student Information System will now include SQL update calls (PutServerData and ExecuteCommand) when sending anonymous usage data back to Aeries Software. This information will be used to help identify trends with system usage.
Version Date - 5/21/2020
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 - 5/7/2020
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 - 4/23/2020
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 create new Alternate Course Requests (ACR) and Alternate Course Request Association (ACA) records for any Course Requests (SSS records) that currently have an Alternate Course (SSS.AC) populated.
Version Date - 4/10/2020
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 update the Date Option (DTO) in the District Analysis Indicators (DAI) table for the following indicator types: ADS Violation Count, ADS Disposition Count, Disposition Days, Intervention Count, and Program based on whether dates exist in the related tables.
Version Date - 3/30/2020
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..." - the Cross Reference (XRF) table Sex Type mappings changed to use the new Gender (GN) field for gender, instead of Sex (SX) in Student (STU) and Staff (STF).
Version Date - 3/12/2020
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 - Load CA State Standards has been disabled as it is now available in Aeries Web.
Version Date - 2/26/2020
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..." - while adding Gender to the Staff table (STF.GN), this update will prepopulate this new field based on existing data in STF.SX. Also, any field-level permission to STF.SX will be automatically copied over to STF.GN.
AdminCS - Aeries Control Panel - the following buttons have been disabled as they are now available in Aeries Web: Force Cascading DEL Tags, Database Cleanup, and Fix ENR Records. Also, the "View Recent Database Changes" button has been replaced with a link to our Aeries Database Changes forum.
AdminCS - Many forms have been disabled as they are now available in Aeries Web or no longer necessary: Aeries Control Panel/old, Combine Student Records, Copy Aeries Data From Summer Schools/CS, Define Fields to Sync/Lock, Define School-Based Codes/CS, Pull Attendance History From Another Database, Pull ENR From Another Database/CS, and Update History From Summer Schools Grades/CS.
AdminCS - Many macros have been disabled as they are now available in Aeries Web or no longer necessary: Check Users for Invalid Passwords, Delete CAASPP Interim Assessment Data, Fix CAR Duplicates, and Mass Add Discipline Incident IDs.
Textbook Accounting - added informational message box when run, once per user, per update, reminding the user of Textbook End of Life in 2020-21 and recommending transitioning to District Assets in Aeries Web.
Version Date - 2/13/2020
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 - added logic to avoid resetting previously set defaults for Define Fields to Sync/Lock from the Client on the new page available in Aeries Web.
Version Date - 1/30/2020
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 - added logic to set the District Rules "Force users to be on the newest version of Aeries to login.", with Warn after 30 days and Lock-Out after 60 days. The Aeries Client version is going away in the near future and this warning is to notify users who may be unaware of the upcoming change.
AdminCS - "Updating your SQL database…" or Force An Update macro - this process will remove unnecessary STU "Relationship" indexes on the Supplemental (SUP) and Secondary Student Data (SSD) tables, the existing Foreign Key Constraints handle the relationship to STU already.
AdminCS - "Updating your SQL database…" or Force An Update macro - this process will remove the "Check Constraint" against the WEB.PW field and clear any existing data from the field (ABI Password).
Version Date - 1/16/2020
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
Create ROP Extract - this form was not honoring Alt Ed Scheduling, fixed.
Version Date - 12/19/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 - 12/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..." - a new Program Services (PGS) table has been added to Aeries. This update will move existing data from the Programs table Services field (PGM.SR) into new PGS records. Please note, existing user-defined COD values will also be copied from "PGM.SR" to "PGS.SR". Also, existing CALPADS Cross Reference records will be updated to use the new PGS table instead of PGM.SR.
AdminCS - "Updating your SQL database..." - added logic to add missing hyphen to the Course Content Area Subcategory (CSC field) for codes entered in CRS, MST, SMS, SMB.
AdminCS - "Updating your SQL database..." - added missing fixed code values to the USYSGCOD table for use in Query descriptions.
Version Date - 11/22/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.
The Testing Control tables (CTL and CSN) have new records for use with the NWEA MAP test import. Please see the Web Detailed Revision Notes and Client Recent Database Changes for more information.
AdminCS - "Updating your SQL database..." - added logic to delete any user-defined codes that may exist for Student Race codes (STU.RC1) for Texas databases because a fixed set of codes has been added.
Version Date - 11/4/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 ensure the USYSGCOD.CAT (Category) field is populated.
Version Date - 10/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.
Aeries Control Panel (SCH and DST) - modified the warning label regarding using Aeries Web to include a link to our IdeaWall.
AdminCS - Aeries Control Panel - the "Fix ENR Records" process has been disabled as it is now available in Aeries Web.
AdminCS - "Updating your SQL database..." - added logic to remove invalid Required Field entries from TFR.
AdminCS - "Updating your SQL database..." - added logic to update the code table descriptions for the Eligibility Code stored in STU.SP, for use in Texas only.
Orchard.DisplayManagement.Shapes.Shape