Detailed List of Recent AERIES Changes

Version Date - 3/17/2017
Comments
Golden State Seal Merit Diploma - the qualification calculations have been adjusted to evaluate the student grades by semester instead of using the average GPA. Also, per the state, college level courses are no longer part of the calculations and waived courses do not qualify for GSSMD.
The new Summer School Course Request tables "Summer School" (SC) fields have been renamed to "SSC" in order to allow access from any school a student attends. Tables affected include: SSA, SSC, SSR, and SST.
The Standards Based Valid Marks "Mark" field (SBV.MK) has been increased to match the Mark fields in the Standards Based Grades table.
Teacher table now includes new fields for Total Males/Boys (TCH.TMB) and Total Females/Girls (TCH.TFG). These fields are for use in Aeries Web.
Attendance History now honors the new setting to only process Attendance History through Today instead of through the whole year. Please note this option can only be set in the Web version as it requires a nightly process to ensure accurate information.
Version Date - 3/10/2017
Comments
Many new tables and fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
Import Fixed Length Files (SCH and DST) - added the PFT17 layout for the 2016-17 school year. Please note - this will load the State-defined Student Record Layout that vendors send to the State, not the results file that the vendor sends back including the PASS status.
Create Fitness Extract (SCH and DST) - updated for the SPRG17 layout. There were no changes between the SPRG16 and SPRG17 files.
Updated CBEDS/CALPADS codes according to the new CALPADS code set.
Aeries Variables For Current School - option "S" regarding "Show all year total absences" or "Show current semester total absences" was inverted, fixed. Also added logic to Log changes to School option (LOC) values throughout the system. Specifically this can also be set from the "YTD Totals" option on the Period Attendance form, which was not previously being logged.
DST - Attendance Works Extracts - the form is no longer available and has been replaced by the new web version.
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will update the new 504 Accommodation Plans table, increasing the field sizes of the Responsible Role (FAP.RL) and Frequency (FAP.FN) fields from 6 to 50. Also this process had the potential to give duplicate key errors while attempting to add new records to the Content Standard Names (CSN) table, fixed. Creating a new SQL database from SqlModel.sql was giving errors regarding the "PrimaryKey_RT_CHI" index, fixed. Removed unnecessary index on Insert Date in 504 Evaluation Criteria (FEC.IDT).
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.
Orchard.DisplayManagement.Shapes.Shape