Detailed List of Recent AERIES Changes

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.
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.
Orchard.DisplayManagement.Shapes.Shape