| Date |
New Table? |
Table |
Field |
Comments |
| 2/19/2010 | | TCH | CID | Added Class ID (CID) to the Teacher table. |
| | | MST/SMS | CID | Added Class ID (CID) to the Master Schedule and Scheduling Master Schedule tables. |
| 2/5/2010 | | CSE | LU | Added Last Updated date. |
| 12/3/2009 | | LOC | TY | Added new LOC field for School Education Type. |
| 10/2/2009 | NEW | GRG | | Grade Reporting GPA is a new table to store up to 12 sets of GPAs (one for each grade reporting marking period). In a future update, the Recompute functions will update this table, so any user who enters Grades and/or recomputes Grade Reporting GPAs MUST have full permission to this table. |
| 8/21/2009 | NEW | ATL | | New table for Electronic Attendance Log - any user that enters Attendance data into Aeries must have Select and Insert permission to this table. |
| 6/26/2009 | NEW | usysGCOD | | New table in the AeriesCS database for use with Aeries.NET and custom reports. |
| | NEW | ATD | | Table has been dropped and re-added with a new PrimaryKey (SC, SN, SE, DT). |
| 6/19/2009 | NEW | CPR | | CPR is a new table in the Aeries SQL database. It will be used by Aeries.net to implement Course Prerequisites. This feature will be added to Aeries later. |
| | NEW | SBU | | SBU is a new table to track Scheduling Backups created by Aeries.net. Eventually, AeriesCS will also use this table instead of the SAVXXXXX.MDB file. |
| | NEW | SMB | | SMB is a new table to store backups of the SMS table created by Aeries.net. Eventually, AeriesCS will also use this table instead of the SAVXXXXX.MDB file. |
| | NEW | SSB | | SSB is a new table to store backups of the SSS table created by Aeries.net. Eventually, AeriesCS will also use this table instead of the SAVXXXXX.MDB file. |
| | NEW | ATA | | New table for Supplemental Attendance Assignments (Students). |
| | NEW | ATC | | New table for Supplemental Attendance Calendar (Dates). |
| | NEW | ATD | | New table for Supplemental Attendance Data. |
| | NEW | ATP | | New table for Supplemental Attendance Programs. |
| | NEW | ATR | | New table for Supplemental Attendance Staff Responsibilities. |
| | NEW | ATS | | New table for Supplemental Attendance Sessions. |
| 4/10/2009 | NEW | TPS | | New table for Testing Pass Status. This table is currently only used for storing Physical Fitness Testing (PFT) status data, but will be expanded to store CAHSEE Test and Algebra 1 Requirement status as well. |
| 4/3/2009 | NEW | STJ | | New table for Staff Job Assignments. |
| 3/27/2009 | | CRS | | Added 2 new fields for Course Comments (CM) and Course Description (CD). |
| 3/6/2009 | | STU | | Added many fields to the Students table including: Address Verified (AV), Ethnic Code (ETH), Race codes (RC1 - RC5), and User codes (U11 - U13). |
| | | COD | | Added default COD values for new STU.ETH and RC1 fields. |
| 2/13/2009 | | CON | CL | Added Correspondence Language to Emergency Contacts. |
| | | FLF | IE | Removed validation rules for use with Import or Add Data to Aeries form. |
| | | FLR | ATC | New field for use with Import or Add Data to Aeries form. |
| | | STU | RE | Increased field from 4 characters to 255. |
| | NEW | RHS | | Report History for Aeries.net. Districts running Aeries.net need to make sure that the AeriesNetUser SQL account has Insert and Update permissions to this table. |
| 1/30/2009 | | LAC | DC | Added Years in Program Date Calculated. |
| | | LAS | | Added fields SS (Speaking Score), SL (Speaking Level), LS (Listening Score), LL (Listening Level) and IT (Initial Test Name). Also increased CO (Comment) from 50 to 255 characters and dropped validation on DT (Date) field. |
| 1/16/2009 | | STU | NID | Added Network Login ID to the Students table. |
| 12/19/2008 | | COD | | Added 6 Correspondence Language and Description fields. |
| | | GRD, GRH | CO | Added a free text comment field to the Grades and Grade History tables. |
| 12/5/2008 | NEW | GRO | | New Grade Reporting Options table. Anyone using Grade Reporting or Standards Based Grade Reporting must have access to this table. Permissions should be similar to the OPT table. |
| | | CNF/VIS | TG | Added a status tag field to Counseling tables. |
| 11/14/2008 | | CSE | | Added four fields: Participation History (PA6), Participation Writing (PA7), Reason for Initial Evaluation Beyond 60 Days (EDL) and Reason for IEP in Place After 3rd Birthday (BDL). |
| 10/10/2008 | NEW | MNO | | New Table for Medical Notes. Permission should be set similarly to other IMM-related tables, though Medical Notes can be used for more confidential information. |
| | | CON | | Added Red Flag (RF) and Entered Date (ED) fields. |
| | | EXP | XRD | Added an Expulsion Readmit Date (XRD) field. |
| | | SOC | SSA | Added an Update SSA Date (SSA) field. |
| | | STU | | Changed field captions on all Red-Flag fields to include "No Longer Used". |
| | | STF | | Increased User Codes to 2 characters. |
| 9/19/2008 | | STN | CA | Fixed misspelling of Category in field caption and description. |
| 8/25/2008 | | STAR | | Added new fields for the 2008 STAR Test Results. |
| | | CSN | | Updated Title Description for SCIGRD5 and HISTGR8. Also added clusters for STS grades 5, 6 and 7 for the 2008 STAR file. |
| 8/1/2008 | NEW | FLG | | New table for storing Red Flags. Table is not yet used, but will need to have Select permission for any user who can view Students. |
| 7/25/2008 | | ADS | CO2 | Added a notes field to the Assertive Discipline table. |
| | | ADS | RL | Increased Return Location field to 3 characters. |
| | | EXP | ERD | Added an Expulsion Review Date to the Expulsions table. |
| | | STF | TI, IEX | Added Title and Internal Phone Extension fields. |
| 6/27/2008 | NEW | EXP | | New table for Expulsions, related to Assertive Discipline (ADS). |
| | | ADS | | Added 26 fields to Assertive Discipline. |
| 6/20/2008 | | CSE | PA5 | Added new Participation CAHSEE field to Special Education table. |
| | | GRH | | Increased the field size on C1, C2 and C3 from 1 character to 2. |
| | | STU | OID | Added an Old ID# field to the Students table. |
| 6/13/2008 | | GRD | | Increased the field size on C1, C2 and C3 from 1 character to 2. |
| 6/6/2008 | | CSE | | Adding four fields: Infant Referral Date (CSE.IRD), Infant Referred by (CSE.IRB), Infant Parental Consent (CSE.IPC), and Infant Initial Evaluation (CSE.IIE) |
| | | STF | | Adding new fields: Alternative Phone (STF.ATL), Alternative Extension (STF.AEX), and Email (STF.EM) |
| | | HIS | CO | Increased field size from 20 to 30. |
| 5/23/2008 | | PHE | | Updated for the 2007-08 CAHSEE Pre-Identification |
| | | TTP | LO, HI | Transcripts - new grade-range fields in Things to Print. |
| | | TDF | T52 | Transcripts - new option to print full middle name instead of middle initial. |
| 5/16/2008 | | PFT | | Added 2 new fields for Pass Flag (PF) and Pass Comment (PC). |
| | | STU | | Added 2 new fields for Student Mobile Phone (MPH) and Notes (CO3). |
| | | CNF | | Added Start Time (STI), End Time (ETI) and Total Time (TTI). |
| | | VIS | | Added new fields to exactly match the CNF table. |
| | | LOG | IP | Added an IP Address field to the LOG table. |
| 4/25/2008 | | ATN | TM, AU | Added 2 new fields to Attendance Notes: time (TM), and authorized by (AU) |
| 4/11/2008 | | SSD | | Added 4 new fields to Secondary Student Data. |
| 3/14/2008 | | LOC | R14, R15 | New fields for LOC Rules regarding updateability of student next school and school of residence fields. |
| 2/29/2008 | NEW | APC | | New table for Individualized Academic Plan Course Requests - as a first step towards our new Individualized Academic Plan module we are releasing the course request component. A new form will allow user entry of future course requests. Course requests will be stored in a new APC (Academic Plan Course Requests) table and changes will be logged in a new APL (Academic Plan Log) table. |
| | NEW | APL | | New table for Individualized Academic Plan Log. Note - any user who can update the Academic Plan Course Requests must have Select and Insert permission to APL. |
| | | LKR | | New fields in the Lockers table including status tag (TG), location (LO), position (PO), and 8 user codes (U1-U8). |
| 2/15/2008 | | SAP | GR | New grade level field for use with Student Assessment. |
| 2/1/2008 | NEW | PFS | | New table for Physical Fitness Setup. Any user involved with Physical Fitness Testing must have Select permission to this table. The Physical Fitness Setup can be viewed by these users, but requires full permission to update. |
| 1/25/2008 | | SAD | GD | New field for Grade Option. |
| | NEW | SAG | | New table for Student Assessment Grade Levels - related to SAD. |
| | NEW | DPT | | New table for District Options, similar to OPT. This table is currently only used for storing the Date/Time value for the Aeries Control Panel "Last run" labels, but will be expanded to store any district-wide option. Permission should be set similar to OPT. |
