Detailed List of Recent AERIES Changes

Version Date - 9/13/2017
Comments
Added new fields to the Attendance Notification Log (ANL) table for: Message Text (MT), Delivered IDs (DID), and Error Text (ERR).
Version Date - 9/12/2017
Comments
Added new Use Supplemental Attendance (USA) flag to Master Schedule tables (MST, SMS, and SMB).
Version Date - 8/25/2017
Comments
A new table has been modified in Aeries, please see the Web Detailed Revision Notes for more information.
CELDT Pre-Identification Form (SCH and DST) - added option to run the RETEST v 1.0 from June 29, 2017.
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will now scan records in the User and Group Names (UGN) table looking for users with commonly used passwords or passwords matching their user name, and return a list of users whose passwords should be changed. The Aeries Web version shipping today will prompt these users to change their passwords too. There is also a new macro to "Check Users for Invalid Passwords" that will run this process.
AdminCS - "Updating your SQL database..." or Force An Update macro - added/updated codes and descriptions according to the CALPADS Code Set version 9.1 from August 10, 2017
Period Attendance, Daily Attendance - if there was no ATT cache and the first student showing was inactive, the user would receive a message stating that attendance had not been initialized, fixed.
Version Date - 8/18/2017
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - the TNP table has been updated with the new Scale Score ranges for CAASPP/SBAC (SPRG17) and California Alternate Assessment (CAA) 2017. Also, the trigger to update the DTS column in the Internship Visits (IVS) table was not defined correctly, fixed.
Version Date - 8/11/2017
Comments
Tables and fields have been modified in Aeries, please see the Web Detailed Revision Notes for more information.
Students, Period Attendance, Daily Attendance - these forms have been modified so they can update attendance for individual students once ATT has been initialized. Since the 7/14 update, this feature was disabled. Still, initializing attendance from the Aeries Client is no longer possible.
AdminCS - "Updating your SQL database..." or Force An Update macro - since the 6/30 update, the trigger for the Third Party Extracts (TPE) table was being created incorrectly and included the default IDN record (IDN.ID=0) as part of it. This issue was not allowing the districts to add vendors for third party extracts, fixed.
AdminCS - "Updating your SQL database..." or Force An Update macro - the process of scanning records in tables that include a Primary Key field with a Tab, Carriage Return, Line Feed, Leading Space, or Trailing Space in them will now run much faster. Also the report, Print Records with Invalid Key Values, would give errors if the Attorney General process had been run, fixed.
AdminCS - Create HTTP Update File macro will now include the SqlModel.sql script file when selecting to run for AdminCS. Also this macro now includes the NewVer.exe updater file, which now includes the SqlModel.sql script file.
Version Date - 7/28/2017
Comments
DST - Create CALPADS Extracts - adjusted the logic to update the FRE table from the Direct Certification file to include students with R - Reduced meals codes.
Version Date - 7/14/2017
Comments
Tables and fields have been modified in Aeries, please see the Web Detailed Revision Notes for more information.
Supplemental Attendance - due to expanding technologies that cannot be matched in the Client, this update will disable Supplemental Attendance in the Client version.
Import Fixed Length Files - added new PFT17 layout for San Joaquin County Office of Education (PFT17SJC). Please note - this layout includes pass status for each category and will update the Physical Fitness Test Pass Flags.
DST - Create CALPADS Extracts - running the identifier request before the school starts would not include the Golden State Seal and Seal of Biliteracy columns, fixed.
Create UC ELC Extract - the parental consent option was not working for the SUP table when a KEEP statement was used which included the SUP table, fixed.
Students, Enroll All Students in Attendance (macro) - initializing attendance from the Client version is no longer available. This process must now be run from Aeries Web.
AdminCS - Load CA State Standards - added a fourth tab for the California ELD standards
Version Date - 6/30/2017
Comments
Create UC ELC Extract - an option to include/exclude NSLP information in the TES extract has been added to the form.
Free And Reduced Meals form (usysFRE) - updated Free and Reduced meal assignment values for the 2017-18 school year, per the Federal Government's (USDA) Income Eligibility Guidelines.
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Version Date - 6/23/2017
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Supplemental Attendance - added warning that "Due to expanding technologies that cannot be matched in the Client, Supplemental Attendance will soon be disabled in the Client version. We recommend using the Web version to run this process".
Standards, Standards Based Options - Valid Marks, and Update Valid Marks - added logic to remove leading/trailing spaces from new marks and standards (STN.SD, SBV.MK, and GRC.MK).
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will now scan records in tables that include a Primary Key field with a Tab, Carriage Return, Line Feed, Leading Space, or Trailing Space in them. If any invalid records are found a message will appear prompting the new Print Records with Invalid Key Values report to be run. This process replaces the recent invalid courses process.
AdminCS - Print Records with Invalid Key Values - new report that will print out records that include a Primary Key field with a Tab, Carriage Return, Line Feed, Leading Space, or Trailing Space in them. This report replaces the recent invalid courses report.
AdminCS - "Updating your SQL database..." or Force An Update macro - Existing records in the User and Group Permissions (UGP) table with UGP.TC = "Mobile" will have UGP.TC changed to "EM2" due to a corresponding change in the Aeries Web version security areas.
Version Date - 6/16/2017
Comments
CELDT Pre-Identification Form - updated form according to the CELDT Pre-ID 2017-18 v.1.0 from March 31, 2017 layout.
Aeries Client Version now prepends the Log Comment with "Aeries Client" in the LOG.CO field.
Version Date - 6/9/2017
Comments
Daily Attendance, Period Attendance - a label has been added to the History Summary tab to indicate that the information is no longer accurate and instead use the Aeries Web version to review this information.
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will add a new Program field to the Attendance History Summary table (AHS.SP). Also,it will hard-delete all existing AHS records for the current school year. Please see the Web Detailed Revision Notes for more information.
Version Date - 6/2/2017
Comments
New tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Create UC ELC Extract - the SUP fields were not being shown in the Parental Consent dropdown unless the query form was opened before, fixed
Golden State Seal Merit Diploma - the college level option was not always being honored, fixed
Version Date - 5/23/2017
Comments
Please note that this Client update is required to repair the Scheduling Backup and Restore process in the 5/22/2017 Aeries Web update. Added 8 new fields to the Student Scheduling Schedules Backup table (SSB) from the Summer School Requests (SSR) table. They include: Term (TM), Status (TG), Preferred Field: AM/PM (PF), and User Codes 1-5 (U1 - U5).
Version Date - 5/19/2017
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
AdminCS - Copy Aeries Tables From Last Year/CS - Rollover includes new tables that have been added since last month's initial release. New tables include: CDC, CRF, CSQ, NAT, and SED.
DST - Create CALPADS Extracts - the Discipline extract (SDIS) was extracting the Removal to Interim Alternative Setting for non-special ed students, fixed. Also, the Career Technical Education extract has been disabled and is currently available only in the web version of Aeries.
Version Date - 5/12/2017
Comments
New Notification and Alert Thresholds (NAT) table for use in Aeries Web.
DST - Create CALPADS Extracts - adjusted the SENR ODS extract to include the Golden State Seal and Seal of Biliteracy columns.
Golden State Seal Merit Diploma - added option to include/exclude college level courses from the calculation.
Version Date - 5/5/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 - the Student Enrollment extract (SENR) has been updated to include the Golden State Seal and State Seal of Biliteracy columns, starting on May 9.
Language Assessment Data - modified the "Update English Language Proficiency" function to process SBAC records in addition to CST and CMA.
DST - Language Assessment Data - added "Update English Language Proficiency" button like SCH version. Also modified the function to process SBAC records in addition to CST and CMA.
Print Smarter Balanced Cards (SBAC) - CAASPP (SCH and DST) - report now allows the option to display the new legal name disclaimer on all cards instead of only on students with Legal Student Information.
Version Date - 4/28/2017
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
AdminCS - Aeries Control Panel and New Year Cycle - disabled the "Define Student Table Relationships" button as all tables are required to be ID-based for the 2017-18 Rollover.
AdminCS - Copy Aeries Tables From Last Year/CS, Update Student Data/CS, and Copy Inactive Students From All Schools In The District/CS - added new tables for the 2017-18 Rollover. Also added logic to ensure letter tags (STU.LT, STU.L2) and letter logs (LTL.CIS) are being properly cleared in all situations during the Rollover.
Print Pre-Rollover Audit Listing (SCH, DST and AdminCS) - the "Next" Field Comparison Options legend was mislabeled "Ignore Retained" instead of "Include Retained", fixed.
DST - Define Fields to Sync/Lock - added AdminCS form to the District software.
Golden State Seal Merit Diploma - when using the GPA option by Grade and Course, if the only piece of data to be included on the report came from HIS and fell under the "Other" qualifying group, the student was not being included on the report, fixed. Also, the GPA by Grade and Course was not skipping the College Level Dual Enrollment courses, fixed.
"Updating your SQL database..." or Force An Update macro - this process will now scan records in tables that include a Course ID field and search for Courses with a Tab, Carriage Return, Line Feed, or Space in them. If any invalid courses are found a message will appear prompting the new Print Records with Invalid Course IDs report to be run.
AdminCS - Print Records with Invalid Course IDs - new report that will print out records that include a Course ID with a Tab, Carriage Return, Line Feed, or Space in them.
Courses (SCH and DST) - added logic to ensure invalid characters of Tab, Carriage Return, Line Feed, or Space are not allowed within a new Course ID. Also disabled changing of Course IDs and added a message that Copy should be used instead.
Orchard.DisplayManagement.Shapes.Shape