Eagle Software
Aeries Student Information System
Aeries Users' Conferences Aeries Users' Workshops

Detailed List of Recent AERIES Changes

Date Comments
9/7/2010C/S - Populate GBU Start Date (SCH and AdminCS) - the macro was not working for Elementary schools, fixed!
9/3/2010AdminCS - Fix CAR Duplicates - new macro that will assist in removing duplicate CAR records where the school, student, course, period, block, section and start date are the same.
 AdminCS - Fix CAR Missing End Dates - new macro that will assist in closing out CAR records for dropped sections where the CAR leave date is not populated.
 Period Attendance Cycle - modified the Attendance Audit button (1.) to offer to run the Attendance Audit Listing and/or the Course Attendance Audit.
 Student Class Schedules, Master Schedule, Master Schedule Display, Mass Change Section Numbers, Students, Student Enrollment Form - modified logic so that when updating the LOG for a single student, will log all of the CAR fields.
 Transcripts - added a "LimitRcds" button above the GPA fields that will allow users to select the grade-range of records to view and will save the users selection. Records below the low grade will display based on OGC logic. Also moved the Expected Grad Date to where the Grad Status and Date are located. If there is data in either the Grad Status or Date field, the Expected Grad Date will be hidden. Note - the transcript still prints the grades defined on the TDF form based on the CD selected.
 Graduation Requirements - added Grad Status Code and Grad Status Date to the form.
 Populate GBU Start Date (SCH and AdminCS) - new macro that will populate the Gradebook start date for students without one. The date will be based on either the Attendance start date (Elementary) or the Course Attendance start date (Secondary). The macro in AdminCS will run district-wide.
 Recent change to Query to allow Subject Area Codes descriptions from the REQ table caused users to receive no permission to REQ errors on various forms, fixed!
 Print Student Work Permit - the new report was requiring the Work Permit Letter Editor to be run, even though it did not print any of that information, fixed.
 Print Student Data Printout - removed logic that made select fields lowercase.
 Print Daily Present by Teacher/Month and Print Daily Present by Section - added logic to count Verified NOT Absent codes as either Absence or Present, based on the Count for ADA flag. Print Daily Present by Section was never showing an Average on the first day, fixed!
 Print Daily Apportionment by Month - added an option to include weekly averages.
 Create ROP Extract - program was counting days in the future in negative attendance schools, fixed. Also added an error message if a period was missing from the Bell Schedule.
 Free and Reduced – new FRE table will be utilized for upcoming enhancements to the Free and Reduced Meals form. The Free and Reduced (FRE) table will soon store all records currently in the FAR and/or FRM tables in one table and will allow the schools or district to not only access the same single source of data (given permissions to do so!) but will also store history instead of only one record.
 FAR and FRM Pre-Conversion Audit Report – new report that will provide a listing of all students who currently have Free and Reduced records in the FAR and/or FRM tables. This report can be utilized to analyze data stored in the FAR and FRM tables prior to converting these tables over to the FRE table.
 DST - Siblings - added option to show Parent/Guardian Info and Include Inactive Siblings. The form also now includes the school code, counselor and status tag for each sibling. Changed the STU.FK field label from "Family ID" to "Family Key" for consistency. Also added ability to open the Students form to the selected student by double-clicking on a sibling's school code, student number or name.
 C/S - Daily Attendance and Period Attendance – they were not downloading the ODE table for the Other District Enrollment tab, fixed.
 C/S - Print Letter to Parent - user would receive "someone else has already updated this record" errors when updating letter tags, fixed.
 C/S - Move Assigned Lockers to STU - added message that this function is not available for Client/Server users.
9/1/2010C/S - Student Class Schedules - form had the potential to not close out Course Attendance if sections were deleted in rapid succession for the same student, fixed!
8/27/2010Master Schedule - added logic to LOG all changes to SEC and CAR when using the "Copy", "Move All" or "Move Tagged" buttons. Also modified logic on these buttons to ensure CAR is always updated when necessary.
 Student Class Schedules - modified logic to ensure CAR is always updated when necessary. Also whenever CAR was updated for the current student and section, changed to update all sections for the current student. Added logic to LOG whenever "Restore" or "Reschedule" are used. ViewMST button - modified logic to ensure CAR is always updated when necessary, and logic to LOG addition of SEC data, and in Elementary with MST schools, changes to STU.CU.
 Student Scheduling Cycle - button "4. Copy Results to STU And MST Tables" - added logic to LOG the deletion and creation of SEC records.
 Course Attendance - modified to no longer allow users to blank out Start Dates.
 Daily Attendance, Period Attendance, and Students "UpdATT" button – added logic to LOG the Attendance initialization process.
 Schools - when changing School Type from Elementary and selecting to create a Master Schedule - added logic to LOG the Master Schedule creation.
 Work Permits - added a new report based on the CDE B1-4 report. There is an option to print the State regulations on the back or 2nd page (if not pre-printed). Also added an option to print the "Old Report".
 Employers - added logic to not allow an Employer Code of zero.
 Print Code Table (SCH and DST) - when printing all tables, and not page-breaking, was not displaying table names except on the top of each page, fixed!
 Query (SCH and DST) - added ability to get descriptions of Subject Area Codes from the REQ table (LIST CRS S1?)
 Print Billing Statement - added logic to show and hide date limits based on the option to "Show All Records", "Show Records between dates" and "Show Records before end date".
 District Student Enrollment History - this form is no longer available in Aeries. The Enrollment History form shows the exact same enrollment information; also the District Student Lookup form has most of the same data and is much easier to Search.
 DST - Print Attendance Audit Listing - was using the Home Room Period from LOC record 0 for Elementary w/ MST school analysis of Home Room Teacher, Student Teacher value and ATT Enrollment Teacher, fixed.
 The Update (UpdateXP.exe and UpdateCS.exe) will no longer include the file "rsWide39.ttf". This file is used specifically for printing Barcode fonts and extracting it was causing problems on certain systems. The file can be found on our website under "Other Useful Files".
8/20/2010Daily Attendance, Period Attendance, and Students "UpdATT" button – modified Attendance and Course Attendance initialization process to prevent the possibility of creating two sets of CAR-records, by adding logic to double check if CAR already exists upon the completion of ATT initialization. This was necessary as while one user is in the middle of Initializing ATT and about to initialize CAR, another user could open the Student Class Schedules form, and start the CAR-file initialization process causing duplicate CAR-records!
 Student Class Schedules, Master Schedule, Master Schedule Display, Mass Change Section Numbers, Students, Student Enrollment Form - added logic to LOG calls to the "AutoUpdateCAR" function when adding, changing and dropping classes.
 Print Course Attendance Audit - added a new error for "Active Course Attendance without Section".
 Course Attendance - added logic to LOG all changes to CAR records on this form.
 Import Fixed Length Files (SCH and DST) - added message when selecting a Physical Fitness layout, that we load the State-defined Student Record Layout that vendors send to the State, NOT the file that the State sends back.
 Transcript Definition - added "PFT status" to the list of things to print on the TTP tab.
 Print Student Transcripts - was not tagging AP courses as "a" in the "Work in Progress" section of the transcript, when the option is set in Update Valid Marks, fixed.
 Create UC ELC Extract – will now support the new UC Electronic Transcript Technical Specification Record Layout Version 2.2. These changes include creating the new Student Ethnicity Record (05 Record) and will update the Student Record (01 Record) with the data from the ETH and RC1-RC5 fields. If RC1 is 000 (invalid or blank) or 999 (declined to state) the remaining race fields will not be extracted, even if they have valid data. Also, if the new ETH and RC fields are blank the process will handle converting the old ethnicity code fields into the Ethnicity and Race fields for these records.
 DST - Create CalPASS Extract – will now support the new Fall 2010 Database and Data Element Dictionary V 2010.01. These changes will now add the data from the new Ethnicity and Race fields to the Student Data file. Also, if the new ETH and RC fields are blank the process will handle converting the old ethnicity code fields into the Ethnicity and Race fields for these records.
8/18/2010Students - form has had the potential to not drop classes and update course attendance when inactivating a student since the 7/2 version, fixed!
 Daily Attendance and Period Attendance – when a district database does not exist, added logic to hide the District Enrollment tab instead of giving an error message.
 District Student Enrollment History and Enrollment History - when a district database does not exist, do not allow these forms to be opened.
8/13/2010Create CASEMIS Student File (SCH and DST) - added code to skip students with Exit Reason 70 (returned to regular education) and 76 (transfer to another program). Only Exit Reason 77 (deceased) was being skipped.
 Students (SCH and DST) - form had potential to load slowly due to populating the usysCOD table, which was previously used for the SSD.HMT (Home Type). The HMT list now pulls from the COD table since early last year. Removed logic to populate the usysCOD table, which should speed up loading of the Students form.
 Billing - added a "Pay" button to allow an "Add" to be performed when updating Payments. This will allow the easy addition of unscheduled payments (i.e. Financial Assistance). Added an option when under-paying a payment to add a new payment in addition to the existing options. When under-paying a payment and choosing to increase a future payment, will now consider that payment made. Also, the Number or Payments, Payments Remaining and Balance had the potential to show incorrect data, fixed!
 Input Billing Payments - added option to create a new payment when the last payment for a bill is under paid. C/S - the "Update" button was pushing the entire BIL table back to the SQL Server, instead of only the record being updated, fixed!
 Print Billing Arrears and Print Billing Statement - added logic to not include payments that have been paid by increasing future payment amounts.
 DST - Create CALPADS Extracts - added Direct Cert Import and Fall 2 Beta Extracts. Added new code sets available to be translated. The Direct Cert Import has not been tested with any file provided by CALPADS. Please test this process on a test database before loading it into your live database.
 C/S - Master Schedule and Scheduling Master Schedule - when set for Scheduling in the Current Year, still had potential to receive duplicate key errors when adding new sections, fixed!
 C/S - Read Attendance Scanner Sheets (both versions), Read Period Attendance Scanner Sheets/23 Line, and Read Period Attendance Scanner Sheets/PAC File - modified form to compare and update Attendance data directly on the SQL server, in order to avoid discrepancies that may occur in the cache database.
 AdminCS - Copy Aeries Tables From Last Year/CS - Copy Security button was not copying over Groups/Roles that were either "public" or begun with "db_", fixed.
 AdminCS - Copy Security From Another Database/CS - new form based on Copy Aeries Tables From Last Year/CS that allows for copying security Groups/Roles and Users from another database.