Detailed List of Recent AERIES Changes

Version Date - 2/17/2017
Comments
Many new tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Auto-Create/Manage Portal Accounts will no longer delete an old account when changing an email address and choosing NOT to replace the existing account. This logic matches how the Web version handles Portal Accounts. Forms affected include Emergency Contacts, Students, Student Enrollment Form, and Student Demographic Update Information.
Schools (SCH and DST) - added logic to uppercase changes to the State (LOC.ST) field. Also added a label addressing the disabled Terms section of this form.
DST - Civil Rights Data Collection Options - Updated Extract Logic: Per CRDC any table that has counts and is related to a Yes/No table cannot report zeroes as a count if the answer is "No;" it has to be an empty string. Adjusted logic for Table 26, Part 2 (Offenses, Number of Incidents) because in some cases it could underreport. Loading students for Part 2 Table 1 (Students who Passed Algebra I in Grade 7) had the potential to fail in certain instances, fixed.
Version Date - 2/10/2017
Comments
DST - Create CALPADS Extracts - in some cases, the exit reason 440 could prevent extracting SPRG program records from PGM, fixed. Also, adjusted code in the SDEM extract to no longer include staff who left the previous year.
Golden State Seal Merit Diploma - removed CST qualification options from the form and report, since it no longer applies for the 2017 graduating year.
Version Date - 2/3/2017
Comments
Many new tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Content Standard Names (CSN) table has been updated with the additional parts for Interim Assessment (ELA and Math).
Version Date - 1/13/2017
Comments
DST - Civil Rights Data Collection Options - elementary schools that include middle school grade levels could receive an error (due to Algebra I and Geometry options) if they use "self-contained" classes, fixed.
DST - CAASPP Student Test Assignment/Paper Pencil form is no longer available in the Client version, please use the new "CAASPP Export Files" in Aeries Web.
New Attendance Reporting Periods table (ARP) for future use in Aeries.
Version Date - 1/6/2017
Comments
Added new Immunization fields for Meningococcal (MCV4) vaccination for use in Aeries Web. Fields include: Meningococcal Vaccination Date (MC1), Exemption Flag (MCE), Exemption Date (MCD), and Exemption Comment (MCC).
DST - Print ASAM Enrollment Summary - added support for Preschool and Transitional Kindergarten.
Terms are no longer editable in the Client version due to cascade updating that must be performed against Gradebook tables that do not exist in the Client.
Added new Message Duplex (DX) and Message Comment (CO) fields in the Records Transfer Messages table (RTM) for use with Aeries Records Transfer in Aeries Web.
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will set existing User School Permissions records - Communications Group fields to "True" in USR.CG. This process will only be run once per database.
Version Date - 12/16/2016
Comments
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will clear out the new picture resolution fields that were specifically added for use in Aeries Web. This process will only be run once per database. Modifying an image in Aeries Client will now clear the additional resolution fields to avoid mismatches between Web and Client student photos.
Students - modifying an image in Aeries Client will now clear the additional resolution fields to avoid mismatches between Web and Client student photos.
Mass Add Student Pictures (SCH and DST) - modifying an image in Aeries Client will now clear the additional resolution fields to avoid mismatches between Web and Client student photos.
Print Hourly Attendance Report and Print Monthly Attendance Summary/Continuation - had the potential to print negative hours when the Bell Schedule was modified in both Aeries Web and Client, fixed.
AdminCS - Update Aeries SQL Databases - modified to ensure proper handling of the new option to Delete tempSS Tables.
Test Scores - the Test Settings (STS) tab is no longer available in this version and will only be accessible through the web application.
Smarter Balanced Assessment Consortium (SBAC) - CAASPP/TIDE (SCH and DST) - disabled buttons to generate file with Test Settings.
DST - Print Smarter Balanced Assessment Cards (SBAC) - CAASPP - removed "CA" from the SSID.
Version Date - 12/9/2016
Comments
DST - Civil Rights Data Collection Options - the extracts for Part 1 and Part 2 have been updated according to the new CRDC Data Layout for 2015-16. The "Non-Submitted" Extracts (NS Extracts) are also available.
Testing Number Possible - the TNP table has been updated with the California Alternate Assessments Scaled Scores ranges.
Version Date - 12/2/2016
Comments
Courses and Teachers tables now include a Next Year Status tag (CRS.NTG and TCH.NTG). The Courses and Teachers forms in Client will automatically set these new fields based on changes to the current year Status tag (CRS.TG and TCH.TG). The Next Year Status tags can only be set independently in Aeries Web.
Supplemental Attendance Class Roster - added the ability to include separate signature lines for both Time-In and Time-Out columns on the 1 Day Roster.
Added a new Student Group Analytics (SGA) table to allow Student Groups to use Analytics Indicators for nightly updated groups.
Added Communication Group (CM) and Dynamic Group (DG) fields to the Student Group Definitions (SGD) table.
Added Communication Group (CG) to the User School Permissions (USR) table.
NWEA MAP Test Results - the testing administration value has been changed to be YYMM since the test can be taken multiple times.
Testing Control Tables - the California Alternate Assessments (CAA) parts have been added to the CTL table.
Test Exclusions - two Incomplete Reason codes for CAA have been added to the COD table (TEX INC)
Version Date - 11/18/2016
Comments
DST - Attendance Works - the form has been updated to allow non-admin users to run the extract. Only the information that they are allowed to see will be extracted. Added support for the TK grade level of -1. Modified the Zip Code extract to sort (descending) by the number of students counted for each zip code. The count will show on the second column, but only as a reference, as it is not part of the extract. Also, the Free and Reduced column had the potential to skip some FRE students, fixed.
DST - Create CCGI Extracts - in some cases the ATP record pulled was ‘111111’ rather than the ATP code for that school listed on the CCGI form, fixed.
DST - Civil Right Data Collection Options - the form has been updated according to the requirements for the 2015-16 submission. Two new tabs have been added to set up Courses Taught by Certified Teachers (Part 1) the set up the restraint and seclusion codes (Part 2). Also a Fall and Spring end dates have been added to the Code Locations / Dates tab. These dates are used by Tables 16, 18, and 22 (Part 1).
DST - Print Civil Rights Data Collection Totals and Print Civil Rights Data Collection Details - the reports have been updated according to the requirements for the 2015-16 submission.
DST - Import Fixed Length Files - CELDT09: during the update, the process to validate blank test dates on the file had the potential of producing a duplicate primary key error, fixed.
Print Cal Grant GPA Listing - since the removal of the SSN option, the report had the potential of not printing if the last extract layout used was the one including the SSN, fixed.
Student Enrollment Form, Supplemental and User Define Student Data - forms had the potential to display a "control too large" error when there were a large number of fields in the table, fixed.
Version Date - 11/4/2016
Comments
DST - Create CALPADS Extracts - a new extract option has been added to the Enrollment tab to allow creating the SINF extract for all students. This has been implemented in case mass updates that affect the SINF information are performed. If the mass update process does not update the LGD table, the changes will not be extracted since the regular SINF runs based on the LGD information.
Print Daily Attendance Summary and Print Daily Attendance Summary By Program - decreased the font size on all footers to allow for over 4 digit totals.
New Records Transfer College Test Scores table (RT_CTS) for use with Aeries Records Transfer. This is a records transfer holding table. It is used to store a copy of incoming CTS data before it's imported.
Tables have been added for use by the upcoming School of Choice system in Aeries Web: School of Choice Requests (SCD), School of Choice Request Notes (SCD), and School of Choice Decisions (SCD). Also added First Action to the Parent Web Accounts table (PWA.FA) for use by School of Choice.
Version Date - 10/28/2016
Comments
Social Security Numbers are confidential information and determined unnecessary to be stored in Aeries. Therefore the data has been removed from the existing Aeries tables system-wide and relocated to a temporary table for review. Pages affected include Staff, Students, Transcript Definitions, and Work Permits. Please note that the SSN on Work Permits should be manually filled in after the report is generated from Aeries.
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will now scan the Standards table (STN) looking for recursive data where the category of a standard loops back to itself. If any recursive standards are found a message will appear prompting the new Print Recursive Standards report to be run.
AdminCS - Print Recursive Standards - new report that will scan the Standards table (STN) looking for recursive data where the category of a standard loops back to itself. Report lists Standard ID, Title, Type, and Category.
AdminCS, DST, and SCH - Print Database Table Information - report has been updated with all of the latest tables and fields.
Print Monthly Attendance Summary - will now delete all YTD records when run for Month 1.
AdminCS - Clean PWA and PWA Tables macro - fixed misspelling of "have" in a message box.
DST - Language Assessment - fixed misspelling of "School" in the ControlTipText of the School field.
New tables have been added for use with the upcoming Aeries Records Transfer. Tables include: Records Transfer Outbound Requests (RTO), Inbound Requests (RTR), Messages (RTM), Testing Data (RT_TST), and Content Standards Scores (RT_CST).
New fields have been added to the Student Picture table (PIC) for different resolutions of the image: Thumbnail (TH), Small (SM), Medium (MD), Large (LG), and Extra Large (XL). For use in Aeries Web Version and the upcoming Mobile App.
New fields have been added to the Report Card History table (RCH) for: Term Description (TMD), Report Title (RPT), and Created Date (DT). These new fields will be automatically populated for existing records based on data in Grade Reporting Options and Standards Based Options.
Orchard.DisplayManagement.Shapes.Shape