| Date |
New Table? |
Table |
Field |
Comments |
| 12/16/2011 | NEW | SGD | | New table for Student Group Definition. |
| | NEW | SGS | | New table for Student Group Staff information. |
| | NEW | SGM | | New table for Student Group Members information. |
| 12/2/2011 | | PRE | | Updated for the 2011-12 STAR Pre-ID layout. |
| | | MST | ISI/DLI | Added "ISI" (Independent Study Indicator) and "DLI" (Distance Learning Indicator) fields for CALPADS Fall 2 reporting. |
| | | SMS | ISI/DLI | Added "ISI" (Independent Study Indicator) and "DLI" (Distance Learning Indicator) fields for CALPADS Fall 2 reporting. |
| | | SMB | ISI/DLI | Added "ISI" (Independent Study Indicator) and "DLI" (Distance Learning Indicator) fields for CALPADS Fall 2 reporting. |
| | | TCH | ISI/DLI | Added "ISI" (Independent Study Indicator) and "DLI" (Distance Learning Indicator) fields for CALPADS Fall 2 reporting. |
| | | PGM | CPA | Increased the "CPA" (California Partnership Academy) field to 5 characters. |
| 11/4/2011 | | CON | LW | Added a Student Lives With field to the Emergency Contact table. |
| | NEW | AHC | | New table for Attendance History Codes - stores a history of absence code descriptions. |
| | NEW | AHS | | New table for Attendance History Summary - stores a summary of student enrollment, present, absent and tardy counts by year. |
| | NEW | AHD | | New table for Attendance History Detail - stores a detailed history of student attendance counts by code, period and year. |
| | NEW | VIC | | New table for Victims for future use. |
| | NEW | WIT | | New table for Witnesses for future use. |
| | | FLF/FLR | | New records for SAT11 for the 2011 SAT test. |
| | | TNP | | Added scale scores for the 2011-2012 CELDT Test Results. |
| 9/9/2011 | | FLF/FLR | | New PFT11 layouts for San Joaquin County Office of Education (PFT11SJC) and Educational Data Systems (PFT11EDS). |
| | | COD | | Changed description of CSE.DI = 210 from "Mental Retardation (MR)" to "Mental Retardation/Intellectual Disability (MR/ID)". |
| | NEW | DIG | | New table for Dashboard Item Groups. |
| | NEW | DIO | | New table for Dashboard Item Options. |
| 8/26/2011 | | FLF/FLR | | New records for AP03711 for the AP Record Layout 2011 (.csv). |
| | | CHI | | Added new fields to Course History Institutions: User Codes 1-8 (U1-U8), Grade-Range (LO-HI), Contact Name (CN), Telephone (TL), Fax (FX) and Zip Code Extension (ZX). |
| | | DAI | | Increased DAI.TY (Type of Assessment Item) field to 20 characters, and added DAI.OI (Other Information) field. Also removed relationship to DAL. |
| 8/19/2011 | NEW | DAI | | New table for the Early Warning System called "District Analysis Items". |
| | NEW | DAL | | New table for the Early Warning System called "District Analysis Levels". |
| | NEW | DAQ | | New table for the Early Warning System called "District Analysis Qualifications". |
| | NEW | DAS | | New table for the Early Warning System called "District Analysis Summary". |
| | NEW | DAT | | New table for the Early Warning System called "District Analysis Thresholds". |
| | NEW | STU | RP | New Total At-Risk Points field for use by Aeries Analytics. |
| 8/16/2011 | | STAR | | Added new fields for the 2011 STAR Test Results. |
| | | CSN | | Updated for the 2011 STAR Test Results. |
| | | TNP | | Adding new CST, CMA, and STS Raw and Scale scores for SPRG11 |
| 7/29/2011 | | TRM | H1, H2 | Added 1st Half End and 2nd Half Start dates to the Term table. |
| | NEW | DCS | | New table for "Documents" for new ABI Parent Summer Re-Registration Process. This table stores the basic info about each Document and the document itself. |
| | NEW | DCV | | New table for "Document Visibility" for new ABI Parent Summer Re-Registration Process. This table stores the Schools and Grades each document is visible to. |
| | NEW | DCL | | New table for "Document Log" for the new ABI Parent Summer Re-Registration Process. This table stores a log of parent access to each document and records if they confirm the contents of the document. |
| | NEW | ICL | | New table for "Information Confirmation Log" for new ABI Parent Summer Re-Registration Process. This table stores what and when data is confirmed to be correct by the parent. |
| 7/8/2011 | | RHS | | Please note - as of the July 1, 2011 update ALL users must have Select and Insert permission to the RHS table! |
| 7/1/2011 | | STR | | Added 38 school code fields (19 Schools by Year, 19 Schools by Next Year). |
| | | UGN | TN/SID | Changed the Teacher Number (TN) field to Staff ID (SID). |
| 6/24/2011 | | FLF/FLR | | New records for PFT11 for the SPRG11 Testing Administration. |
| | | PCT | | Added new fields for the 2010-11 CELDT layout. |
| 6/6/2011 | | MHS | PC | Added new Parent Comment field to Medical History table. |
| | | AUT | | Added Effective End Date (EED) and Source (SRC) to Authorizations table. |
| 5/20/2011 | | FRE | | Deleted unnecessary index on SCL field. |
| | | INV | | Added "SC" to the "SD" index (SC, SN, DT). |
| 5/13/2011 | | PFT | | Added Pass Flags for each of the 6 Categories (PF1-PF6) and a Body Mass Index (BM) field to the Physical Fitness Testing table. |
| | | STU | RSY | Added a Record Added System field. |
| 4/15/2011 | NEW | ECA | | New table for Extracurricular Activities. |
| | NEW | ECP | | New table for Extracurricular Activity Probations. |
| | | CRS | PE | Added a Physical Education tag to the Course table for use with Extracurricular Activities. |
| | | ACT | | Added 4 fields for use with Extracurricular Activities form: Season (SE), Status (ST), Transportation Date (TD) and Transportation Status (TS). |
| | | IMM | TBE, TBD | Added TB Skin Test Exemption (TBE) and TB Skin Test Exemption Date (TBD) fields to the Immunizations table. |
| | | UGP | SC, FC | Added School Code (SC) and Field Code (FC) as part of the PrimaryKey index in preparation to support ABI using this table for field level security. |
| 4/8/2011 | | PWA | | Added LN (Last Name), FN (First Name), LC (Login Count), LIP (Last Login IP Address), LDT (Last Login Date/Time), CIP (Current Login IP Address), CDT (Current Login Date/Time), LPR (Last Page Request Date/Time), CD (Creation Date), XD (Expiration Date). |
| | | UGN | | Added LIP (Last Login IP Address), CDT (Current Login Date/Time), LPR (Last Page Request Date/Time), ID (Student ID), and TN (Teacher Number) fields to UGN. Also modified the IP field description to: "Current Login IP Address". |
| 4/1/2011 | | IMM | | Added a DTP Type (DTT) and Physical Exemption Date (HED). |
| | | TCH | IT | Added a field for Itinerant Teacher Indicator in Elementary Schools. This field, when flagged will inspire the CALPADS CRSE extract to include this teacher as a reported class, even without any students. |
| 3/23/2011 | | TCH | | Added two new fields for NCLB Core Area 1 (CA1) and 2 (CA2). |
| 3/18/2011 | | VAC | | Updated the default record for Tdap Booster. |
| 2/18/2011 | NEW | MDP | | New table for Multi Data Profile |
| | NEW | MDF | | New table for Multi Data Profile - Fields |
| | NEW | MDL | | New table for Multi Data Profile - Layout |
| | | Sched | SG, CG | Increased Scheduling Group to 2 characters in MST, SMS, SMB and STU; Increased Team Course Group to 2 character in MST, SMS and SMB. |
| | | Sched | PL | Added Permanent Lock to the SEC, SSS and SSB tables. |
| 2/11/2011 | | PFT | VO | New field for Aerobic capacity (VO2max). |
| 1/28/2011 | | IMM | TE, TED | Added new Tdap Booster Exemption (TE) and Tdap Booster Exemption Date (TED). |
| | | VAC | | Updated the default record for Tdap Booster. |
| 1/14/2011 | | SSD | FE1 | Added new Engaged in further education/training in related/unrelated program field to Secondary Student Data for use with Carl Perkins. |
| 12/17/2010 | | CRS | VLU | Added new CSU Validation Level. |
| | | usysGCOD | | Added 11 new Birthstate codes. |
| 12/10/2010 | | IMM | | Added new Tdap Booster (TB) field and 4 additional sets of "Other Immunization" fields. |
| | | VAC | | Added a default record for Tdap Booster. |
| 12/3/2010 | | PRE | | Updated for the 2010-11 STAR Pre-ID layout. |
| | | XRF | | Updated PRE.LF codes for the 2010 STAR Pre ID. |
| | | ATD | CD | Added a Code to Supplemental Attendance Data. |
| | | usysGCOD | | Added new CSE.TR8 value for use with Special Education Data. |
| 11/18/2010 | | CSE | PAC | Added a Participation CST field to the Special Education table (PAC). |
| 11/5/2010 | | CSE | | Added 8 Transition Information fields (TR1 - TR8). |
| 10/1/2010 | | SSD | PSC, IRC | Added two new Tech Prep fields to Secondary Student Data for use with Carl Perkins. |
| | | CON | | Added a set of new Military fields to the Emergency Contacts table. Fields include: Military Branch (MBR), Military Rank (MRA), Military Status Tag (MTG), Date Military Record Added (MDT), Military Supervisor Name (MSN), Military Supervisor Telephone (MSP) and five Military User Codes (MU1-MU5). |
| | | ADS | S54 | Added a Discipline field to indicate that Student has 504 Plan. |
| 9/24/2010 | | FRE | SS | Free and Reduced – changed the Social Security Number field from a numeric field to a text field, to allow leading zeroes. |
| 9/3/2010 | NEW | FRE | | 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. |
| 8/13/2010 | | PAY | RA | Added a field for Remaining Balance Accounted For. |
| 8/5/2010 | | STAR | AME | Added new Accommodation/Modification "E" field to STAR. |
| 7/23/2010 | | TDF | T53-T60 | Added 8 new option fields, mostly for future use. TDF.T53 is the option to "Include City & State with School?" in the term headings. |
| | | GRC | PA | Added a field for Advanced Placement point value. |
| 7/2/2010 | | STU | | Added 6 new fields including: End of Year Next School (ENS), Summer Withdrawal Next School (SNS), Summer Leave Date (SLD), Next Inter/Intra District Transfer Code (NIT), Next Inter/Intra District Transfer District (NTD), and Next Residence School (NRS). |
| | | ATT | | Added 3 new fields including: Reporting Home School (HS), Inter/Intra District Transfer Code (IT) and Non Public School (NPS). |
| | | ENR | | Added 2 new fields including: Inter/Intra District Transfer Code (IT) and Non Public School (NPS). |
| 6/25/2010 | | CHI | NM | Increased Course History Institutions Name field to 255 characters. |
| | | ODE | DNM, SNM | Increased Other District Enrollment District and School Name fields to 255 characters. |
| 6/23/2010 | NEW | CTD | | New table for Custom Table Definitions. |
| | NEW | CTF | | New table for Custom Table Fields. |
| 6/18/2010 | | CSE | ETH | Added new Ethnicity field to the Special Education table. |
| 6/11/2010 | | CSE | PI | New field for Parent Input. |
| | | usysGCOD | | Updated values for Special Education Data form. |
| 5/21/2010 | | PHE | LF | Increased Language Fluency from 1 character to 4 characters. |
| 4/23/2010 | NEW | ODE | | New table for Other District Enrollment. |
| | | SMB | CID | Added Class ID field to the Scheduling Master Schedule Backup table. |
| 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. |
