Detailed List of Recent AERIES Changes

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.
Version Date - 4/21/2017
Comments
Scheduling Exclusions (SED) is a new table for use in Aeries Web. Also the Scheduling Course Requests Reject Tag has been increased to 2 characters (SSS.RT). Please see the Web Detailed Revision Notes for more information.
Attendance History includes new fields specifically for use in Aeries Web. Updating of Attendance History from the Client has been disabled in this update. Please see the Web Detailed Revision Notes for more information.
DST - Create CALPADS Extracts - added new NSLP code to the Direct Certification import. Also, added a message for the Student Absence Summary extract (in the EOY tab) indicating that the extract will only be available in the web version.
Print Smarter Balanced Cards (SBAC) - CAASPP (SCH and DST) - report will now offer the option to print a legal name disclaimer when there are students with Legal Student Information (LSI) in the school. Disclaimer states: "* Use your legal name when signing into CAASPP. Please check with the office if you have any questions.".
Transcript Definitions now includes an option to "Hide Comment (STU.CO)" when printing a transcript.
Off Grade Courses - now includes a new field to "Count in Overall Credits" (OGC.CC), that will default to match the current "Count in GPA" field. This option will affect the Credit Attempted and Completed at the bottom-left of the Student Transcript.
Vision table now includes new fields Left Eye Result (VSN.LER), and Right Eye Result (VSN.RER), available for use in Aeries Web.
Orchard.DisplayManagement.Shapes.Shape