Detailed List of Recent AERIES Changes

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.
Version Date - 4/14/2017
Comments
DST - Civil Rights Data Collection Options – Part 2: the logic for Table 1 (7th grade students passing Algebra I) has been adjusted to only include the students that were enrolled in the Algebra I courses in Part 1.
Added fields to the Summer School Course Requests for use in Aeries Web.
Version Date - 4/6/2017
Comments
New fields have been added to Aeries, please see the Web Detailed Revision Notes for more information.
AdminCS - "Updating your SQL database..." or Force An Update macro - this process will update the new 504 Accommodation Plans table, increasing the field size of the Area of Need (FAP.AN) field from 3 to 6. Also updating older databases had the potential to error when attempting to add indexes including the "SC" field to ID-based tables, fixed.
Version Date - 3/31/2017
Comments
Civil Rights Data Collection Options – the logic for the Algebra I tables in Part 2 (tables 2 and 3) has been adjusted to only include the students that were enrolled in the Algebra I courses in Part 1. Logic has been adjusted for the AP tables in part 2 to reflect the number of AP tests that the AP students took rather than the number of AP students that took an AP test. If no district calendar was defined, then an error message when processing Retentions appeared, fixed. Also, when using the Next Grade option for Retentions, there was the potential of miscalculating the number of retentions per grade level, fixed. The LEP and IDEA total were reflecting the number of students who missed school days, instead of number of school days missed by those students, fixed. Instances of suspension was counting the number of students instead of the number of instances, fixed. Adjusted race determination logic so that multiple races in the same subgroup are reported with that subgroup instead of "Two or More Races". For example, multiple Asian races will now be reported in the "Asian" subgroup.
AdminCS - “Updating your SQL database..." or Force An Update macro - added "Get_Description_New" function in SQL, which will now be used in Aeries Web Query. Also, modified the existing "Get_Description" function in SQL - in some cases descriptions for codes with leading zeros were not returned properly, fixed. Note: the existing "Get_Description" function is no longer used by Aeries but was kept to accommodate customers' own SQL scripts that rely on this function.
Standards - logic has been added to prevent circular references when modifying a standard's Category field. Also logic has been added to trim leading/trailing spaces from Standard IDs.
Records Transfer Inbound Requests - increased the Phone Number field (RTR.PH) to include formatting and extensions.
New OAuth table (OAT) for use with Aeries Web.
New Third Party Names fields for Consumer ID (TPN.CID), Consumer Secret Key (TPN.CSK), and One Roster (TPN.ORT) for future use in Aeries Web.
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.
Orchard.DisplayManagement.Shapes.Shape