Detailed List of Recent AERIES Database Changes

Date - 2/17/2017
Is New? Table Field Comments
New RT_HIS New Records Transfer Course History (Transcripts) table for use with Aeries Records Transfer. This is a records transfer holding table. It is used to store a copy of incoming HIS data before it's imported.
New RT_CHI New Records Transfer Course History Institutions table for use with Aeries Records Transfer. This is a records transfer holding table. It is used to store a copy of incoming CHI data before it's imported.
New ODC New Records Transfer Other District Courses table for use with Aeries Records Transfer. This is a records transfer setup table. It is used to store a cross reference of Courses for incoming HIS data.
New FEC New 504 Evaluation Criteria table for use in Aeries Web.
FOF MT, RF, CM 504 Plan table now includes fields for Meeting Type, Referral, and Case Manager.
FAP RL, FN, CD 504 Accommodation Plans table now includes fields for Responsible Role, Frequency, and Accommodation Code.
FSD CO, FN, SI 504 Student Disabilities table now includes fields for Disability Description, Frequency Note, and Significant Impairment.
FPP 504 Program Participants table now includes fields for Is Parent/Guardian (PG), Attended (AT), Responsible Contact Title (RCT), Responsible Contact ID (RC), and Responsible Contact Email (EM).
CON ERH Contacts table now includes a field for Educational Rights Holder.
Date - 2/3/2017
Is New? Table Field Comments
New SSR Summer School Course Requests is a new table for gathering course requests for the Summer School Management process in Aeries Web.
New SSA Summer School Availability is a new table for defining available summer schools.
New SSC Summer School Courses is a new table for selecting courses to be offered at each summer school.
New SST Summer School Terms is a new table for setting up summer school terms.
ABS NE, IS Absence Codes table now includes fields for Temporarily Not-Enrolled and Independent Study.
STF SF Staff table now includes a field for Suffix.
CSN Content Standard Names (CSN) table has been updated with the additional parts for Interim Assessment (ELA and Math).
ARP Drop and re-add the Attendance Reporting Periods table to include Track as part of the PrimaryKey. Table is for future use in Aeries.
New ARD Attendance Reporting Details is a new table for future use in Aeries.
New CCC College Course Credit is a new table for future use in Aeries.
CRS CSQ, NCI Courses table now includes fields for Course Sequence and Non-Campus Based Instruction for specific customers. Not for general use.
CSE DI3, MD Special Education Data table now includes fields for Tertiary Disability and Multiply Disabled for specific customers. Not for general use.
LOC RC Schools table now includes a field for Region Code for specific customers. Not for general use.
Date - 1/6/2017
Is New? Table Field Comments
IMM 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).
RTM DX, CO Added new Message Duplex (DX) and Message Comment (CO) fields in the Records Transfer Messages table (RTM) for use with Aeries Records Transfer
Date - 12/2/2016
Is New? Table Field Comments
TCH NTG Added Next Year Status Tag field in the Teachers table (TCH.NTG).
CRS NTG Added Next Year Status Tag field in the Courses table (CRS.NTG).
USR CG Added a Communication Group field to the User School Permissions table (USR.CG)
SGD CM,DG Added Communication Group (CM) and Dynamic Group (DG) fields to the Student Group Definitions (SGD) table.
New SGA Added a new Student Group Analytics (SGA) table to allow Student Groups to use Analytics Indicators for nightly updated groups.
Date - 11/4/2016
Is New? Table Field Comments
New RT_CST New Records Transfer College Test Scores table (RT_CTS) for use with Aeries Records Transfer. This is a records transfer holding table. It is used to store a copy of incoming CTS data before it's imported.
New SCR New School of Choice Requests (SCD) table for use by the upcoming School of Choice system in Aeries Web.
New SCN New School of Choice Request Notes (SCD) table for use by the upcoming School of Choice system in Aeries Web.
New SCD New School of Choice Decisions (SCD) table for use by the upcoming School of Choice system in Aeries Web.
PWA FA Added First Action (FA) to the Parent Web Accounts (PWA) table. This field will be used by the upcoming School of Choice system in Aeries Web.
Date - 10/28/2016
Is New? Table Field Comments
New RTO New Records Transfer Outbound Requests table (RTO) for use with Aeries Records Transfer. Stores data regarding student records which were requested from another school district.
New RTR New Records Transfer Inbound Requests table (RTR) for use with Aeries Records Transfer. Stores data regarding student records which are being requested by another school district.
New RTM New Records Transfer Messages table (RTM) for use with Aeries Records Transfer. Stores system and user messages specific to a records transfer (RTR or RTO) record.
New RT_TST New Records Transfer Testing Data table (RT_TST) for use with Aeries Records Transfer. This is a records transfer holding table. It is used to store a copy of incoming TST data before it's imported.
New RT_CST New Records Transfer Content Standards Scores table (RT_CST) for use with Aeries Records Transfer. This is a records transfer holding table. It is used to store a copy of incoming CST data before it's imported.
PIC Added five new fields to the Student Picture table (PIC) for different resolutions of the image: Thumbnail (TH), Small (SM), Medium (MD), Large (LG), and Extra Large (XL).
RCH Added three new fields to the Report Card History table (RCH) for: Term Description (TMD), Report Title (RPT), and Created Date (DT). These new fields will be automatically populated for existing records based on data in Grade Reporting Options and Standards Based Options.
Date - 10/14/2016
Is New? Table Field Comments
New RCH Report Card History is a new table for use in the Aeries Web version.
Date - 9/29/2016
Is New? Table Field Comments
SBD BLD Added a new field to add Bold font Standards in the Standards Based Templates table.
SBE BLD Added a new field to add Bold font Standards in the Standards Based Setup table.
Date - 9/9/2016
Is New? Table Field Comments
SBG Added 4 new Comment fields (CO1-CO4) to Standards Based Grades.
GBT CL Added a new Color field to Gradebook Assignment Types.
Date - 9/2/2016
Is New? Table Field Comments
SBV Standards Based Valid Marks (SBV) - added fields for Default Gradebook Scale Scores in Web to be used by teachers when loading the Gradebook Grades into Standards Based Grade Reporting.
SSO GEM Single Sign On (SSO) - added a Google Email Address field (GEM).
Date - 8/26/2016
Is New? Table Field Comments
New ESI New External Student ID table for use with Google Classroom and other 3rd party vendors in the Web version.
Date - 8/19/2016
Is New? Table Field Comments
TNP Added records for SBAC 2015-16 (SPRG16) testing administration.
Date - 8/5/2016
Is New? Table Field Comments
LAC LT, YEL Language Assessment Data includes two new fields: Long Term English Learner (LAC.LT) and Years as English Learner in US School (LAC.YEL).
Date - 7/29/2016
Is New? Table Field Comments
New ANA New Attendance Notification Attendance Codes (ANA) table for use with Loop.
New ANC New Attendance Notification Configurations (ANC) table for use with Loop.
New ANL New Attendance Notification Attendance Log (ANL) table for use with Loop.
New ANS New Attendance Notification Attendance Schools (ANS) table for use with Loop.
STU NP Added a Student Notification Preference field for use with Loop (STU.NP).
FEE Added three new fields to the Fee table to link with District Assets: Resource ID (RID), Resource Item Number (RIN), and Resource Fee Type (FT).
CSE SEI Added a new Special Education ID Number field to the Special Education table (CSE.SEI).
Date - 7/22/2016
Is New? Table Field Comments
New FLI New File Location Information table (FLI) has been added for use with the new CALPADS Extracts page in Aeries Web.
STN NL Standards table now includes a new Not Linkable field (STN.NL) for use with Gradebook to allow standards to be marked as not linkable to gradebook assignments.
Date - 7/13/2016
Is New? Table Field Comments
FLF/FLR Import AP Test Results modified description of the layout (AP03711) to include the current year. Also added a new PFT16 layout for San Joaquin County Office of Education (PFT16SJC).
STF CP, NP Staff table has two new fields designed for use with Loop integration: Mobile Phone (STF.CP) and Notification Preference (STF.NP).
DPT CD District Options - Code field (DPT.CD) has been increased for use with Single-Sign-On to Loop.
Date - 7/8/2016
Is New? Table Field Comments
CON NP Added Notification Preference to the Contacts table for use with Loop Integration.
Date - 7/1/2016
Is New? Table Field Comments
PRS TY Renamed the "Parent Residence Survey" table to "Parent Response to Survey" and modified the PrimaryKey to include a new Type field (PRS.TY). This will allow the table to be used for both the Residence Survey and the new Military Family responses in the Parent Data Confirmation process.
Date - 6/24/2016
Is New? Table Field Comments
EML EID Modified the PrimaryKey of the Email table to be an autonumber like LOG.TID. This will resolve certain errors when attempting to send multiple emails simultaneously.
DRI Increased District Resource Items Barcode field (DRI.BC) to 50 characters and added a Serial Number field (DRI.SR).
TBC BC Increased Textbook Copies Barcode field (DRI.BC) to 50 characters.
Date - 6/17/2016
Is New? Table Field Comments
ROL DNR New field in the Rollover Settings table for Do Not Roll (ROL.DNR). Field will be used to bypass matriculating students from a school. Students at the tagged school who are not copied elsewhere in the district will be copied to the Inactive School.
Date - 6/3/2016
Is New? Table Field Comments
GBA New fields have been added to this table for use with the API: Unique ID (GBA.UI) and External ID (GBA.EI).
Date - 5/27/2016
Is New? Table Field Comments
New ROL Rollover Settings (ROL) is a new table for use with the New Year Rollover (BETA) page in Aeries Web. The Rollover Settings include both District and School settings, with the option to push one school's settings to selected schools. This new table will roll forward to the new year in both the Web and Client rollover processes.
Date - 5/20/2016
Is New? Table Field Comments
New SBS New Standards Based Templates (SBS) table for use in Aeries Web.
New SBD New Standards Based Template Details (SBD) table for use in Aeries Web.
SBE CT New fields for Center Title in Standards Based Setup for use in Aeries Web.
New BER Added new Behavioral Emergency Report (BER) table for use in Aeries Web.
CTS Added CCR Benchmark fields for English and Math
COD Default codes for Behavioral Emergency Report
VIC Added five new fields for Basis of Harassment (BS, BR, BD, BB, BO) replacing B1-B4 fields. The BO field is for Sexual Orientation (not present before).
Date - 5/13/2016
Is New? Table Field Comments
CCP Updated Course Career Pathways table for use in Aeries Web.
UGP Updated User and Group Permissions table to allow for prior year security in Aeries Web.
UGN CPW Added Require Change Password field to the User and Group Names table.
Date - 5/6/2016
Is New? Table Field Comments
SBV NT Added Not Taught field to the Standards Based Valid Marks table.
CRS Added Course Title translation fields to the Course table for future use.
Date - 4/8/2016
Is New? Table Field Comments
SqlModel.sql - the file used to create data structures for new Aeries SQL Databases will now create all available tables to be ID-based by default. This is the first step towards a Web-based Rollover.
DAY Tracks Added additional Calendar Track fields T7 - T26 to allow for an upcoming enhancement to extend student tracks and calendars to A through Z.
TRM Tracks Added additional Term Track dates D1G - D1Z and D2G - D2Z to allow for an upcoming enhancement to extend student tracks and calendars to A through Z.
LOC K Increased Schools Attendance Tracks field to 2 characters allowing up to 26 tracks.
Date - 4/1/2016
Is New? Table Field Comments
New GTS New Gradebook Transfer Scores (GTS) table added for future use with Aeries Web. This table will allow teachers to transfer student grades in gradebook.
Date - 3/18/2016
Is New? Table Field Comments
New LSI New Legal Student Information (LSI) table for future use.
STF Added Network Login ID (NID), Alternate Email (AEM), Human Resources ID (HRID), and Comment (CO) to the Staff table.
usysGCOD Removed "Adult Ed" from Course Type (CRS.TY) codes.
Date - 2/26/2016
Is New? Table Field Comments
DRT/TBT VN Increased Vendor# (VN) in the District Resource Titles (DRT) and Textbook Titles (TBT) tables to match the Vendor ID (VND.ID) field.
Date - 2/19/2016
Is New? Table Field Comments
MST/SMS IT Added an Itinerant Teacher field.
SMB IT Added an Itinerant Teacher field.
DNT VC Increased Visible Cavities field to 2 character for future use as numeric rather than Y/N.
DAL Increased the Code 1 through Code 9 (CD1-CD9) fields to 10 character.
usysGCOD Added NSLP codes for FRE.SRC.
Date - 1/29/2016
Is New? Table Field Comments
New UAO New User Account Options table for use with Google Classrooms.
New PAO New Portal Account Options table for use with Google Classrooms.
New MSS New Master Schedule Settings table for use with Google Classrooms.
TNP Added scale scores for the 2015-2016 CELDT Test Results.
usysGCOD Updated State Test Settings (STS) values.
FLF/FLR New PSAT15F (Fixed Length) and PSAT15C (Comma Delimited) layouts for the 2015-2016 PSAT test.
CSE EV Added an Evaluation Flag field to the Special Education table.
Date - 12/11/2015
Is New? Table Field Comments
Mass changed "Home Language" fields to "Reporting Language" in the following tables: CSE, LET, LTR, PCT, PHE, PRE, PSA, STAR, and STU.
New CRL New table for Custom Report Layouts for use in Aeries.net.
CRC LID Added a Layout ID field (CRC.LID) to associate with the new Custom Report Layout table (CRL).
CRI R1-R5 Added five new Rubric fields (CRI.R1-R5).
Date - 12/4/2015
Is New? Table Field Comments
FLF,FLR Updated CASEMIS layout according to the Technical Assistance Guide from Nov 25, 2015.
Date - 11/6/2015
Is New? Table Field Comments
usysGCOD Updated CBEDS codes (CTE Programs), Staff Assignments, and Staff Job Assignment codes as needed.
Date - 10/30/2015
Is New? Table Field Comments
CTS Added 14 new fields to accommodate the new ACT scores.
COD Added codes for Test Scores Source field (TST.SRC) to the COD table.
CRI Added new fields: Filter By (FB), Filter Values (FV), and Enforce Security (ES).
Date - 10/16/2015
Is New? Table Field Comments
New CRC New table for Custom Report Configurations for use in Aeries.net.
New CRI New table for Custom Report Items for use in Aeries.net.
New CRA New table for Custom Report Access for use in Aeries.net.
New CRG New table for Custom Report Groups for use in Aeries.net.
Date - 10/2/2015
Is New? Table Field Comments
New TSO New table for Teacher Standards Options for future use in Aeries.net
Date - 9/25/2015
Is New? Table Field Comments
New CPW New table for Career Pathways.
New CCP New table for Course Career Pathways.
New CPE New table for Career Pathway Experiences.
New CPH New table for Career Pathway History.
New CPO New table for Career Pathway Outcomes.
STR Added new fields for Preschool and Transitional Kindergarten: GN1 (Grade -1 [TK]), GN2 (Grade -2 [PS]), NN1 (Next Year - 1 [TK]), and NN2 (Next Year -2 [PS]).
Date - 9/18/2015
Is New? Table Field Comments
New TAD Physical Fitness Testing includes a new setup table - Testing Administration Details (TAD). This table will store Testing Administrations and a date-range for when each Testing Administration is active. Users who can view Physical Fitness Testing must have at least Select permission to this table. Fitness Administrators should have full permission to the new table.
Date - 9/4/2015
Is New? Table Field Comments
STN MT1 Increased Standards - Mark Type 1 field to 2 characters.
SBV TY Increased Standards Based Valid Marks - Type field to 2 characters.
SBG MT Increased Standards Based Grades - Mark Type field to 2 characters.
SBH MT Increased Standards Based History - Mark Type field to 2 characters.
Date - 9/2/2015
Is New? Table Field Comments
STAR Added 49 fields for use with CAASPP 2015. Also, increasing the size of CCE, CCM, CCS, CCH, CCL, CCW, CCO fields from 3 to 4 characters.
CTL Added test parts for the Smarter Balanced (SBAC) test.
CSN Added claims (clusters) for the Smarter Balanced (SBAC) test.
TEX Increased the size of the SPC field from 1 to 6 characters.
Date - 8/28/2015
Is New? Table Field Comments
FRE SRC Added a Source field to the Free and Reduced Meals table to allow users to track the origin of the information.
COD Added codes for the new Free and Reduced Meals Source field to the COD table.
Date - 8/14/2015
Is New? Table Field Comments
New TSD Added a new Teacher Standards (TSD) table for use in Aeries.net
SSO SCU Added a new SchoolCity User ID to the Single Sign On table (SSO.SCU).
GBN Deleted the GBN to STN relationship
Date - 8/3/2015
Is New? Table Field Comments
UGN IDP Added an Identity Provider field to the User and Group Names table for use with Google Authorizations in Aeries.net
Date - 7/17/2015
Is New? Table Field Comments
STN GRN1, GRN2 Added new Standards fields for Preschool (STN.GRN2) and Transitional Kindergarten (STN.GRN1).
PFT GR Physical Fitness Table - dropped the Validation rule of "Between 0 And 18" to allow for Preschool (-2) and Transitional Kindergarten (-1) on the Grade field (PFT.GR).
FLF/FLR New PFT15 layouts for San Joaquin County Office of Education (PFT15SJC) and Educational Data Systems (PFT15EDS).
FOF Added a relationship between new tables FOF (504 Plans) and FAP (504 Accommodation Plans).
DAL SYS Added a new System field to the District Analysis Levels table.
Date - 7/10/2015
Is New? Table Field Comments
COD CBEDS codes have been updated according to the CALPADS Code Sets v.7.0
USYSGCOD CBEDS codes have been updated according to the CALPADS Code Sets v.7.0
Date - 7/1/2015
Is New? Table Field Comments
504 Removed unnecessary indexes on Insert Date (IDT) fields from all 504 Plan tables.
Date - 6/26/2015
Is New? Table Field Comments
SBE SHD Added a Shade field to the Standards Based Setup table.
New FOF New "504 Plans" table for future use. Permissions to the new 504 tables should be similar to the Student Programs (PGM) or GATE (GTE) tables.
New FSD New "504 Student Disabilities" table for future use. Permissions to the new 504 tables should be similar to the Student Programs (PGM) or GATE (GTE) tables.
New FDE New "504 Disability Effects" table for future use. Permissions to the new 504 tables should be similar to the Student Programs (PGM) or GATE (GTE) tables.
New FPP New "504 Program Participants" table for future use. Permissions to the new 504 tables should be similar to the Student Programs (PGM) or GATE (GTE) tables.
New FAP New "504 Accommodation Plans" table for future use. Permissions to the new 504 tables should be similar to the Student Programs (PGM) or GATE (GTE) tables.
Date - 6/19/2015
Is New? Table Field Comments
SEC CN Added Course ID (CN) to the Section (SEC) table.
Date - 6/12/2015
Is New? Table Field Comments
New PRS New table for Parent Residence Survey (PRS) for future use in Parent Data Confirmation and Aeries AIR - Online Student Enrollment.
TST SRC, TY Added Source (SRC) and Type (TY) fields to the Student Test Scores (TST) table.
DIO SGR, SYS Added Subgroup (SGR) and System (SYS) fields to the Dashboard Item Options (DIO) table.
DAG COR, PCT Added Core (COR) and Percentage (PCT) fields to the District Analysis Student Sub Groups (DAG) table.
DAI SYS Added a System (SYS) field to the District Analysis Indicators (DAI) table.
DAL Added three more sets of fields: CD6-CD9, DE6-DE9, and CL6-CL9 to the District Analysis Levels (DAL) table.
DAS Added three more sets of fields: TL6-TL9 to the District Analysis Summary (DAS) table.
DAT Added three more sets of fields: L6L-L9L, L6H-L9H, L6M-L9M, and L6V-L9V to the District Analysis Thresholds (DAT) table.
Date - 5/29/2015
Is New? Table Field Comments
SMB RM The Scheduling Master Backup table was limiting the Room# field (SMB.RM) to only 4 characters. Increased the Room# field to 6 characters to match the field in Scheduling Master Schedule (SMS.RM).
Date - 5/22/2015
Is New? Table Field Comments
Medical Hearing (HRN), Physicals (HWO), Scoliosis (SCO), and Vision (VSN) - a new Waiver field (WV) has been added to these tables.
Date - 5/1/2015
Is New? Table Field Comments
ALL Mass changed ALL Byte fields to Integer to avoid future data type conversion errors when fields are populated with values above 255 in Aeries.net. There were over 200 fields in AeriesCS defined as a Byte.
ALL Mass changed ALL text and ntext fields in SQL to nvarchar(max) as the text and ntext fields are being removed in a future release of SQL Server.
ALL Mass changed ALL "Comment" fields to Memo to allow more data to be input. Note - these fields prevented the record from being saved in Aeries.net when data exceeded the defined number of characters, fixed! Fields affected include: AUT.CO, DRA.CO, DRI.CO, FEE.CO, FRE.CO, GBK.CO, GTT.CO, LAF.CO, LAS.CO, LNC.CO, PAY.CO, PFT.PC, STE.RD1, STE.RD2, TBC.CO, TTC.CM, and UGN.CM.
STU Modified descriptions of the following fields: STU.ID to "Student ID", STU.CID to "State Student ID", STU.OID to "Old Student ID" and STU.OSI to "Old State Student ID".
Date - 4/17/2015
Is New? Table Field Comments
ADS RR Discipline - new field for Removal to Interim Alternative Setting Reason Code.
usysGCOD Added values for new Removal to Interim Alternative Setting Reason Code (ADS.RR).
GRP KY Grade Report Mark Headings - Key field is no longer an AutoNumber, it should always be 1.
SBH Standards Based History - added a new index on the SD, DEL and YR fields to enhance performance in Aeries.net
Date - 4/3/2015
Is New? Table Field Comments
IMM RPT Immunizations - the default value for the Record Presented Tag (IMM.RPT) has been changed from "3" to "0".
Date - 3/24/2015
Is New? Table Field Comments
DCS AIR Added a Use in AIR field to the Documents table.
ODE Increased many text fields to 255 characters to match the AeriesRegistration (AIR) database.
TNP Added scale scores for the 2014-2015 CELDT Test Results.
usysGCOD State Test Settings (STS.CD) codes - modified descriptions for: "Noise Buffers [NEA_NoiseBuf]", "Passages [TDS_TTS_Stim]", "Items (ELA) [TDS_TTS_Item]", and "Stimuli and Items (Math) [TDS_TTS_Stim&TDS_TTS_Item]". Added new codes for: "Items [TDS_TTS_Item]", "Passages and Items [TDS_TTS_Stim&TDS_TTS_Item]", and "Items (ELA) AND Stimuli and Items (Math) [TDS_TTS_ALL]".
MLM HM Added Medication given At Home (HM) field to the Medications table.
FLF/FLR Increased ID field to fit new "ReadiStep" import.
Date - 2/25/2015
Is New? Table Field Comments
usysGCOD New State Test Settings (STS) values (TOMS).
Date - 2/20/2015
Is New? Table Field Comments
ATT/ENR ITD Added Interdistrict Transfer Student's District of Residence (ITD) fields to the Attendance (ATT) and Enrollment (ENR) tables, for use with CALPADS.
Date - 1/9/2015
Is New? Table Field Comments
INV DY Intervention table had the potential to not cache data in the Days field that was entered through Aeries.net and produce "Data type conversion" errors, fixed!
New GBR New Gradebook Terms table for future use with Aeries.net
New GBV New Gradebook Term Students table for future use with Aeries.net
Date - 12/5/2014
Is New? Table Field Comments
usysGCOD New State Test Settings (STS) values for the CAASPP Paper Pencil Test.
usysGCOD Modified CSE codes based on 11/13/2014 CASEMIS TAG layout.
FLF/FLR Adjusted for the CASEMIS Student File based on 11/13/2014 CASEMIS TAG layout.
CSE IDL, TDL Added Reason the Annual IEP is Untimely (IDL) and Reason the Triennial Evaluation is Untimely (TDL).
ATP RST Added Restrict to Session Time to Supplemental Attendance Programs table.
Date - 11/21/2014
Is New? Table Field Comments
New PHL New table for "Page Hit Log" table for future use with Aeries.net.
Date - 10/30/2014
Is New? Table Field Comments
LAC EAC/EAD Added new fields for Student English Language Acquisition Code and Student English Language Acquisition Date
Date - 10/23/2014
Is New? Table Field Comments
LOC NSD Added Next Year Start Date to the School Options table (LOC.NSD).
ODE Added fields to the Other District Enrollment table for: Contact Name (CNM), Telephone (TL), Fax (FX), Student was Expelled (EXP), Student was Special Ed (SPE), and Student had 504 (FOF).
INV Added a field to the Interventions table for Location (LCN).
INA Added fields to the Intervention Actions table for: Start Date (SD) and End Date (ED).
INM Added fields to the Intervention Meetings table for: Location (LCN), Start Time (ST) and End Time (ET).
INS Added a field to the Intervention Stakeholders table for Email Address (EM).
STA Added fields to Staff Assignments table for Start Date (SD) and End Date (ED)
STJ Added fields to Staff Job Assignments table for Start Date (SD) and End Date (ED)
TNP Added raw and scale scores for 2014 CAASPP Test Results.
FLF/FLR Updated the CELDT09 description.
Date - 10/10/2014
Is New? Table Field Comments
TPS AGD Added new field for Testing Pass Status - Algebra I Grade Passed (TPS.AGR)
Date - 7/25/2014
Is New? Table Field Comments
ADH Removed the SN (Stu#) field and renamed the SC field to SCL (School Code).
Date - 7/18/2014
Is New? Table Field Comments
New SFL New table for "Student Files" for the Aeries.net Student Portal.
PGM HDT, RA, UY New Program fields for Homeless Dwelling Type (HDT), Runaway indicator (RA) and Unaccompanied Youth indicator (UY).
SSD FID New Secondary Student Data field for State Foster ID.
ABS PT New Absence Code field to indicate which attendance codes indicate a "Partial Day > 30 Minutes Truant". This will be used along with unexcused absences to create a total days of truancy aggregate in the Attendance History Summary (AHS) table.
AHC PT New Attendance History Code field to indicate which attendance codes indicate a "Partial Day > 30 Minutes Truant". This will be used along with unexcused absences to create a total days of truancy aggregate in the Attendance History Summary (AHS) table.
AHS TRU, SU New Attendance History Summary fields for Days or Truancy (TRU) and Suspensions (SU).
Date - 7/11/2014
Is New? Table Field Comments
LOC DAW, DAL Added new Days After Update fields for use with the new LOC Rule to "Force users to be on the newest version of Aeries to login.". DAW (Days After Warn) allows users to continue using an old version without warnings for a selected number of days after the update. DAL (Days After Lock) locks users out of Aeries after a selected number of days.
Date - 6/27/2014
Is New? Table Field Comments
New ADH New table for Address History designed for use in CALPADS reporting starting in the 2014-15 school year. This table is not yet being populated, but an upcoming update to Aeries will begin to use it. It is very important for Aeries System Administrators to configure the proper SQL security permissions now so that no issues are encountered when these tables start to be used. Here are the recommended permissions for the new tables in Aeries CS/SQL: grant full permissions to anyone with Update or Insert to the STU table. You may grant Read permission to those with Read permission to the STU table, but it is not required.
New LGD New table for Log Details designed for use in CALPADS reporting starting in the 2014-15 school year. This table is not yet being populated, but an upcoming update to Aeries will begin to use it. Here are the recommended permissions for the new tables in Aeries CS/SQL: grant Insert permission to everyone, similar to the LOG table.
Date - 5/9/2014
Is New? Table Field Comments
HRN Increased R1-R7 and L1-L7 from Byte to Integer to avoid errors when caching data that was entered in Aeries.net.
FLF, FLR Added PFT14.
Date - 5/6/2014
Is New? Table Field Comments
STU Added new fields for Next Special Program (NSP), Next Attendance Program 1 (NP1), Next Attendance Program 2 (NP2), and Next Grid Code (NGC).
STR Added new field Next Grid Code (NGC).
usysGCOD Updated Attendance Leave Reason codes (ATT.RS) with inactive tags so they no longer display in dropdown lists.
Date - 4/16/2014
Is New? Table Field Comments
New INA New Intervention Actions table related to Interventions.
New INR New Intervention Additional Resources table related to Interventions.
New INS New Intervention Stakeholders table related to Interventions.
New IPI New Intervention Prior Interventions table related to Interventions.
New IRC New Intervention Reasons and Concerns table related to Interventions.
New ISS New Intervention Student Strengths table related to Interventions.
New PRN New Pre-Referral Meetings and Contacts table related to Pre-Referral Interventions.
New MII New Medical Insurance Information table related to Immunizations.
New TPN New Third Party Names table used for API Security.
New TPP New Third Party Permissions table used for API Security.
INV Added new Intervention fields: "Translation Service Required" (TS), "Translation Language" (TL) and "Referral Sequence" (RSQ).
INC Added new Intervention Progress Comments fields: "Goal Sequence" (GSQ), "Old Percent Success" (OPS) and "New Percent Success" (NPS).
ING DE, PS Added new Intervention Goals fields: "Description" (DE) and "Percent Success" (PS).
RFI SD Added new Referral to Intervention field: "Status Date" (SD).
GBK DLB Added new Gradebook field: "Date Last Backed-up" (DLB).
Date - 4/4/2014
Is New? Table Field Comments
MLM/MLG DA Changed Medication Dose Amount fields (MLM.DA, MLG.DA) from Integer to Currency to allow decimals.
Date - 3/21/2014
Is New? Table Field Comments
New PRI New table for Pre-Referral Interventions - for future use in Aeries.net
New PRC New table for Pre-Referral Intervention Codes - for future use in Aeries.net
New PRR New table for Pre-Referral Intervention Reasons/Concerns - for future use in Aeries.net
New RFI New table for Referral for Intervention - for future use in Aeries.net
New RFP New table for Referral for Intervention - Prior Interventions - for future use in Aeries.net
New RFR New table for Referral for Intervention - Reasons/Concerns - for future use in Aeries.net
New RFS New table for Referral for Intervention - Student Strengths - for future use in Aeries.net
FLF/FLR New PSAT13F (Fixed Length) and PSAT13C (Comma Delimited) layouts for the 2013-2014 PSAT test.
Date - 2/28/2014
Is New? Table Field Comments
New STS New table for State Test Settings - updated on the Test Scores form. This table was designed to populate Smarter Balanced student test settings as described in the California TIDE User Guide.
usysGCOD Added values for State Test Settings (STS.CD).
Date - 2/21/2014
Is New? Table Field Comments
usysGCOD Added new fields to match COD table changes: Sort Order (SRT), Aeries Code (AC), Security Group (SG), Limit Visibility (LV) and Status Tag (TG). These fields are for future use.
Date - 1/31/2014
Is New? Table Field Comments
CSE, CSV Added "Staff ID" (SI) to CSE and CSV. Also "Extended School Year" (XY) to CSE, "Number of Sessions" (NS), and "Session Type" (TY) to CSV
Date - 1/17/2014
Is New? Table Field Comments
SOC Added new fields for translations (CL1-6, DS1-6)
Date - 1/10/2014
Is New? Table Field Comments
TNP Added scale scores for the 2013-2014 CELDT Test Results.
Date - 12/6/2013
Is New? Table Field Comments
COD Added default COD values for SSD.PSP field.
Date - 11/8/2013
Is New? Table Field Comments
New CER A new table that will store the College Entrance Requirements Status for students. This is for future use in Aeries.net.
Date - 11/1/2013
Is New? Table Field Comments
COD Added new COD fields: Category (CAT), Sort Order (SRT), Aeries Code (AC), Security Group (SG), Limit Visibility (LV) and Status Tag (TG). These fields are for future use.
Date - 10/25/2013
Is New? Table Field Comments
ADS Added new Assertive Discipline (ADS) fields for: Substitute Teacher Referral (SR) and PreReferral Interventions 1-3 (PI1, PI2, and PI3). These fields are for future use.
Date - 10/4/2013
Is New? Table Field Comments
UGN UTY Increased User Type field size from 10 to 255.
Date - 9/27/2013
Is New? Table Field Comments
New ESR New table for Exam Scoring Rule.
EXA LBL, RL Added Question Label (LBL) and Applied Rule (RL) to the Exam Response Answers table.
EXV LBL Added Question Label (LBL) to the Exam Responses table.
PWA ADM, SLT Added Admin Account Flag (ADM) and Password Salt (SLT) to the Parent Web Accounts table.
UGN SLT Added Password Salt (SLT) to the Parent Web Accounts table.
ASL Changed table description "Teacher Attendance Submission Log".
LNC Changed table description "Lunch Count Data".
Date - 9/19/2013
Is New? Table Field Comments
New GRS New table for Secondary Standards Based Grading.
PWA PCC Increased Password Change Code field size from 50 to 255.
EXS_STN Removed relationship from STN to EXS.
GBD_STN Removed relationship from STN to GBD.
Date - 9/13/2013
Is New? Table Field Comments
SBG Added Marks 5-12 and Teacher Number 5-12 to support secondary standards-based grading.
EXS_STN Added new relationship from STN to EXS.
GBD_STN Added new relationship from STN to GBD.
Date - 9/6/2013
Is New? Table Field Comments
GBT TD Increased Type Description field size from 30 to 255.
Date - 8/23/2013
Is New? Table Field Comments
COD Added new MST.ESR code for Other English Learner Service.
usysGCOD Added and updated additional CALPADS codes for CRS.C3, CTE.CD, and STA.CD.
Date - 8/16/2013
Is New? Table Field Comments
SBR RC, SRT Added new fields for Include on Report Card (RC) and Sort Order (SRT).
usysGCOD Added and updated CALPADS codes for CRS.C3, CTE.CD, PGM.CD and STA.CD.
Date - 8/2/2013
Is New? Table Field Comments
STAR CSW New field for CST or CMA Writing Test Score.
Date - 7/12/2013
Is New? Table Field Comments
STF EL Increased Staff Education Level field size from 1 to 2.
STC CD Increased Staff Credentials Code field size from 2 to 4.
UGN PLC Added a Password Last Changed field.
Date - 6/21/2013
Is New? Table Field Comments
usysGCOD Added new Special Programs code 185 for Transitional Kindergarten.
Date - 6/14/2013
Is New? Table Field Comments
New REL New table for Religious information
Date - 6/7/2013
Is New? Table Field Comments
New PSB New table for use with Smarter Balanced Pre-Identification Form.
ENR Added an index on SC, SN, DEL to enhance performance of the Print Pre-Rollover Audit Listing report in Aeries.net
Date - 5/31/2013
Is New? Table Field Comments
SSO EID Added an EADMS ID field to the Single Sign On table.
Date - 5/24/2013
Is New? Table Field Comments
New SSO New table for Single Sign On - Aeries.net only.
STU MC Increased Message Code field to 3 characters.
EXQ, EXT VN Increased Version field to 5 characters.
Date - 5/17/2013
Is New? Table Field Comments
New INC New table for Intervention Comments - related to Interventions (INV).
New ING New table for Intervention Goals - related to Interventions (INV).
New INM New table for Intervention Meetings - related to Interventions (INV).
New INP New table for Intervention Practices - related to Interventions (INV).
INV Added Category, Level, Placement, Reason, Provider and Display to Parent fields.
TTC Added new Interventions-related tables.
Date - 5/3/2013
Is New? Table Field Comments
TPS Added 42 new fields for Elementary (5), Middle (7) and High (9) School Physical Fitness status. There are 14 fields per grade level: 6 Category Pass Flags (PF1#-PF6#), 6 Category Pass Dates (PD1#-PD6#), an Overall Pass Flag (PFO#) and an Overall Pass Date (PDO#).
GBA RA Added a Rubric Assignment field to the Gradebook Assignments table.
Date - 4/19/2013
Is New? Table Field Comments
New SPT New table for System Performance Test.
DAI TY Increased Type of Assessment Item field size from 20 to 255.
Date - 3/29/2013
Is New? Table Field Comments
CHI SCH Increased field size from Integer (32,767) to Long (2,147,483,647)
HIS ST Increased field size from Integer (32,767) to Long (2,147,483,647)
Date - 3/22/2013
Is New? Table Field Comments
ESN LT Added Performance Level Type field to the ESN table.
EPL CL Added Color field to the EPL table.
Date - 2/26/2013
Is New? Table Field Comments
New SLD New table for Service Learning Data, related to IDN - Aeries.net only.
New SLR New table for Service Learning Recipients - Aeries.net only.
New SLL New table for Service Learning Log - Aeries.net only.
New SLI New table for Service Learning Log Images - Aeries.net only.
New SLO New table for Service Learning Organizations - Aeries.net only.
Date - 12/21/2012
Is New? Table Field Comments
New WPV New table for Work Permit Visitations for future use.
TTC WPV Added Work Permit Visitations table to Tables to Copy.
GBA ETA New field for Exam Testing Admin.
PRG Deleted table - Progress Reporting was discontinued as of Fall 2005.
FAR/FRM Deleted tables - Free and Reduced Meals now uses the FRE table.
SSD MIG Dropped unnecessary index on this field.
Date - 11/30/2012
Is New? Table Field Comments
New ETA New table for Exam Testing Administrations.
New ETS New table for Exam Testing Administration Students.
EXR TA New field for Testing Administration ID, related to the new ETA table.
ASL C0-C9 Added ten period comment fields (C0-C9).
Date - 11/16/2012
Is New? Table Field Comments
New MLM New Medications table for future use.
New MLG New Medications Log table for future use.
Date - 11/9/2012
Is New? Table Field Comments
TCH_PRG Deleted relationship - Progress Reporting was discontinued as of Fall 2005.
CRS_PRG Deleted relationship - Progress Reporting was discontinued as of Fall 2005.
STU_FRM Deleted relationship - Free and Reduced now stored in FRE.
STU_FAR Deleted relationship - Free and Reduced now stored in FRE.
IDN_FAR Deleted relationship - Free and Reduced now stored in FRE.
Date - 11/2/2012
Is New? Table Field Comments
AHC SC/SCL Attendance History Codes - changed SC field to SCL to allow caching of the data in SCH. Also re-created PrimaryKey index to include SCL field.
AHD, AHS SCL Attendance History Details and Summary - re-created PrimaryKey index to include SCL field.
SSD MIG New field to store the existing COE Migrant ID. The existing SSD.MID field will store the State Migrant ID (starts with "06", 11-digit long). ID numbers in SSD.MID that do not start with “06” will be copied to the SSD.MIG field.
TTC Dropped the old Free and Reduced (FRM) table. The new Free and Reduced (FRE) table was placed in Tables to Copy over a year ago.
Date - 10/19/2012
Is New? Table Field Comments
New PNP New table for Parent Notification Preference.
Date - 9/27/2012
Is New? Table Field Comments
New DSP New Dispositions table for future use with Assertive Discipline. Note - any user who can view or update Assertive Discipline must have matching permissions to this new table.
LAC Changed all Byte fields to Integer to avoid "Data type conversion" errors caching data that was entered in Aeries.net.
Date - 8/31/2012
Is New? Table Field Comments
DIS Added new fields: Staff ID (SID), User Created (UN), Last Updated By (LUB), Last Updated Date (LUD) and Status (ST).
CTL Populated table with defaults for use with STAR Test Results and other test loads.
Date - 8/24/2012
Is New? Table Field Comments
GBB Added new fields: GBB.XB (XML Backup) & GBB.CO (Comment).
New EPL New table for Exam Performance Levels.
New ESN New table for Exam Section Names.
New ESQ New table for Exam Section Questions.
Date - 8/17/2012
Is New? Table Field Comments
New PIC New table to store student picture (one per school year).
New DOC New table to store student related documentation.
New EXH New table for "Exam Schools" that indicates which schools an exam is designed for.
New EXO New table for "Exam Organization" to store the folder structure for exams in the Aeries Analytics.
EXM New fields: OW (Owner), SA (Subject Area), FID (Folder ID), G0-G12 (Grades 0-12).
New TFL New table for "Teacher Files" for the new Aeries.net Teacher Portal.
New GBF New table for "Gradebook File Linking" that links gradebook assignments to uploaded files in TFL.
Date - 8/15/2012
Is New? Table Field Comments
LOC R26 Added new LOC Rules R26 for future use which acts as a trigger to set the defaults for pre-existing LOC Rule 20 and 21. New LOC Rules include: Assign Primary Contact (STU.FW/STU.MW) from Emergency Contacts form (LOC.R18), Display Verification Pass Code (STU.VPC) on Students form (LOC.R19), Force use of District Student Lookup when adding a student (LOC.R20), Force new student number (STU.SN) when transferring a student (LOC.R21), Automatically populate student photograph (STU.BM) with permanent ID (STU.ID) (LOC.R22), Update inactive student records when changes are made to active copies of that student (LOC.R23), Force use of Student Enrollment Form when adding a student (LOC.R24) and Update student records when changes are made to pre-enrolled copies of that student (LOC.R25).
CON Added 4 fields to allow users to link Emergency Contacts and Students form FW/MW fields.
GBK SD The GBK.SD field has been increased to 20 characters to match the STN table which was changed previously.
STN Added table to DstModel to allow caching of standards by AdminCS and DST.
Date - 8/3/2012
Is New? Table Field Comments
SBE, STU RC Added Report Card type to Standards Based Setup and Students.
SBE LV, SRT Added Level and Sort fields to the Standards Based Setup table.
Date - 7/27/2012
Is New? Table Field Comments
VAC Deleted 7th grade requirement for HepB and modified the DTP requirement for 7th - 12th grade to only 7th grade.
Date - 7/20/2012
Is New? Table Field Comments
ATP/ATS SD, ED Added date-range to Supplemental Attendance Programs and Sessions.
ATS CG, CN Added Count in Grades and Course ID to Supplemental Attendance Sessions.
EMP Added fields: Course ID (CN), Class (CL), Contact First Name (CFN), Contact Last Name (CLN), Contact Position (CPS), Fax (FX), Email (EM), Year (YR), Status Tag (TG), Original Contact Date (OCD), Current Contact Date (CCD), Instructor (INS), Position (POS), Contact (CNT), Expiration Date (XD).
New DRT New table for District Resource Titles - Aeries.net only
New DRI New table for District Resource Items - Aeries.net only
New DRC New table for District Resource Courses - Aeries.net only
New DRA New table for District Resource Assignments - Aeries.net only
usysGCOD Added new Non Classroom Based or Support Assignment Code.
Date - 7/6/2012
Is New? Table Field Comments
New POP New table for Portal Options. This is the replacement for the ABI Options SQL database and will be used by Aeries.net.
Date - 6/25/2012
Is New? Table Field Comments
GBA IBS New field for "Input By Standard" that will be used by the new teacher portal gradebook.
UGP MU, AD New fields for "Mass Update" and "Administer".
Date - 6/15/2012
Is New? Table Field Comments
New DIP New table for Dashboard Item Push Sharing.
DIO SCH Changed field to allow more than 255 characters.
TTC CTE Added Career Technical Education table to Tables to Copy.
CTE Added Cascade Update and Cascade Delete on relationship between CTE and IDN.
Date - 5/18/2012
Is New? Table Field Comments
CTE CM Added "Completer?" field.
Date - 5/11/2012
Is New? Table Field Comments
ADS PM Added Possible Motivation field.
GBK TY Added Grading Type field.
Date - 4/27/2012
Is New? Table Field Comments
New CTE New table for Career Technical Education, used by CALPADS. The information in this table is visible from the Students form, Student Secondary Data tab
Date - 4/13/2012
Is New? Table Field Comments
STU Increased name fields (LN, FN, MN, LNA, FNA, MNA) to 100 characters.
IDN Increased name fields (LN, FN, MN) to 100 characters.
SOC SL Added new Severity Level field to the Suspendable Offense Codes table.
Date - 4/6/2012
Is New? Table Field Comments
Multiple SD Changed all Standard ID (SD) fields in the database to 20 characters. Tables affected: STN, GBN, SBE, GBG, SBH, SBR.
DAI TSF Changed DAI.TSF to be 20 characters.
SGM ID The caption for the ID field was incorrect, fixed.
Date - 3/30/2012
Is New? Table Field Comments
New DAG New Aeries Analytics Table for District Analysis Student Sub Groups.
New EXA New Aeries Analytics Table for Exam Response Answers.
New EXC New Aeries Analytics Table for Exam Question Choices.
New EXG New Aeries Analytics Table for Exam Passage Text Groups.
New EXL New Aeries Analytics Table for Exam Printing Log.
New EXM New Aeries Analytics Table for Exams.
New EXQ New Aeries Analytics Table for Exam Questions.
New EXR New Aeries Analytics Table for Exam Responses.
New EXS New Aeries Analytics Table for Exam Question Standards.
New EXT New Aeries Analytics Table for Exam Passage Text.
New EXV New Aeries Analytics Table for Exam Versions.
New GBD New Table for Gradebook Standard Scores. This table will be used by the new Gradebook in development.
New TAA New table for "Teacher Association Areas" that will be used by the new teacher portal to temporarily store the areas that result in a teacher being linked to students. This areas include things like section numbers in SEC and CAR.
New TSA New table for "Teacher Student Access" that will be used by the new teacher portal to temporarily store the SC, SN, ID values that a teacher can access. This data will get refreshed periodically but will be used throughout the system so that the complex query of looking at many different tables for which students a teacher has access to doesn't have to be run all over the place.
GBA Added new fields: TY (Type -Formative or Summative), EID (Exam ID), ESD (Exam Start Date), & EED (Exam End Date).
STN Many changes to support new features in Aeries Analytics. Changed STN.TI to indicate that it should be varchar(6000). Changed STN.CA to be 20 characters. Added a bunch of new fields: BID (AB ID), TS (Type of Standard), ST (State #), SQ (Sequence), GR9 (Grade9), GR10 (Grade 10), GR11 (Grade 11), GR12 (Grade 12), & DE (Description).
Date - 12/16/2011
Is New? Table Field Comments
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.
Date - 12/2/2011
Is New? Table Field Comments
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.
Date - 11/4/2011
Is New? Table Field Comments
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.
TNP Added scale scores for the 2011-2012 CELDT Test Results.
Date - 9/9/2011
Is New? Table Field Comments
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.
Date - 8/26/2011
Is New? Table Field Comments
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.
Date - 8/19/2011
Is New? Table Field Comments
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".
STU RP New Total At-Risk Points field for use by Aeries Analytics.
Date - 8/16/2011
Is New? Table Field Comments
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
Date - 7/29/2011
Is New? Table Field Comments
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.
Date - 7/8/2011
Is New? Table Field Comments
RHS Please note - as of the July 1, 2011 update ALL users must have Select and Insert permission to the RHS table!
Date - 7/1/2011
Is New? Table Field Comments
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).
Date - 6/24/2011
Is New? Table Field Comments
PCT Added new fields for the 2010-11 CELDT layout.
Date - 6/6/2011
Is New? Table Field Comments
MHS PC Added new Parent Comment field to Medical History table.
AUT Added Effective End Date (EED) and Source (SRC) to Authorizations table.
Date - 5/20/2011
Is New? Table Field Comments
FRE Deleted unnecessary index on SCL field.
INV Added "SC" to the "SD" index (SC, SN, DT).
Date - 5/13/2011
Is New? Table Field Comments
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.
Date - 4/15/2011
Is New? Table Field Comments
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.
Date - 4/8/2011
Is New? Table Field Comments
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".
Date - 4/1/2011
Is New? Table Field Comments
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.
Date - 3/23/2011
Is New? Table Field Comments
TCH Added two new fields for NCLB Core Area 1 (CA1) and 2 (CA2).
Date - 3/18/2011
Is New? Table Field Comments
VAC Updated the default record for Tdap Booster.
Date - 2/18/2011
Is New? Table Field Comments
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.
Date - 2/11/2011
Is New? Table Field Comments
PFT VO New field for Aerobic capacity (VO2max).
Date - 1/28/2011
Is New? Table Field Comments
IMM TE, TED Added new Tdap Booster Exemption (TE) and Tdap Booster Exemption Date (TED).
VAC Updated the default record for Tdap Booster.
Date - 1/14/2011
Is New? Table Field Comments
SSD FE1 Added new Engaged in further education/training in related/unrelated program field to Secondary Student Data for use with Carl Perkins.
Date - 12/17/2010
Is New? Table Field Comments
CRS VLU Added new CSU Validation Level.
usysGCOD Added 11 new Birthstate codes.
Date - 12/10/2010
Is New? Table Field Comments
IMM Added new Tdap Booster (TB) field and 4 additional sets of "Other Immunization" fields.
VAC Added a default record for Tdap Booster.
Date - 12/3/2010
Is New? Table Field Comments
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.
Date - 11/18/2010
Is New? Table Field Comments
CSE PAC Added a Participation CST field to the Special Education table (PAC).
Date - 11/5/2010
Is New? Table Field Comments
CSE Added 8 Transition Information fields (TR1 - TR8).
Date - 10/1/2010
Is New? Table Field Comments
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.
Date - 9/24/2010
Is New? Table Field Comments
FRE SS Free and Reduced – changed the Social Security Number field from a numeric field to a text field, to allow leading zeroes.
Date - 9/3/2010
Is New? Table Field Comments
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.
Date - 8/13/2010
Is New? Table Field Comments
PAY RA Added a field for Remaining Balance Accounted For.
Date - 8/5/2010
Is New? Table Field Comments
STAR AME Added new Accommodation/Modification "E" field to STAR.
Date - 7/23/2010
Is New? Table Field Comments
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.
Date - 7/2/2010
Is New? Table Field Comments
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).
Date - 6/25/2010
Is New? Table Field Comments
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.
Date - 6/23/2010
Is New? Table Field Comments
New CTD New table for Custom Table Definitions.
New CTF New table for Custom Table Fields.
Date - 6/18/2010
Is New? Table Field Comments
CSE ETH Added new Ethnicity field to the Special Education table.
Date - 6/11/2010
Is New? Table Field Comments
CSE PI New field for Parent Input.
usysGCOD Updated values for Special Education Data form.
Date - 5/21/2010
Is New? Table Field Comments
PHE LF Increased Language Fluency from 1 character to 4 characters.
Date - 4/23/2010
Is New? Table Field Comments
New ODE New table for Other District Enrollment.
SMB CID Added Class ID field to the Scheduling Master Schedule Backup table.
Date - 2/19/2010
Is New? Table Field Comments
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.
Date - 2/5/2010
Is New? Table Field Comments
CSE LU Added Last Updated date.
Date - 12/3/2009
Is New? Table Field Comments
LOC TY Added new LOC field for School Education Type.
Date - 10/2/2009
Is New? Table Field Comments
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.
Date - 8/21/2009
Is New? Table Field Comments
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.
Date - 6/26/2009
Is New? Table Field Comments
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).
Date - 6/19/2009
Is New? Table Field Comments
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.
Date - 4/10/2009
Is New? Table Field Comments
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.
Date - 4/3/2009
Is New? Table Field Comments
New STJ New table for Staff Job Assignments.
Date - 3/27/2009
Is New? Table Field Comments
CRS Added 2 new fields for Course Comments (CM) and Course Description (CD).
Date - 3/6/2009
Is New? Table Field Comments
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.
Date - 2/13/2009
Is New? Table Field Comments
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.
Date - 1/30/2009
Is New? Table Field Comments
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.
Date - 1/16/2009
Is New? Table Field Comments
STU NID Added Network Login ID to the Students table.
Date - 12/19/2008
Is New? Table Field Comments
COD Added 6 Correspondence Language and Description fields.
GRD, GRH CO Added a free text comment field to the Grades and Grade History tables.
Date - 12/5/2008
Is New? Table Field Comments
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.
Date - 11/14/2008
Is New? Table Field Comments
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).
Date - 10/10/2008
Is New? Table Field Comments
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.
Date - 9/19/2008
Is New? Table Field Comments
STN CA Fixed misspelling of Category in field caption and description.
Date - 8/25/2008
Is New? Table Field Comments
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.
Date - 8/1/2008
Is New? Table Field Comments
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.
Date - 7/25/2008
Is New? Table Field Comments
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.
Date - 6/27/2008
Is New? Table Field Comments
New EXP New table for Expulsions, related to Assertive Discipline (ADS).
ADS Added 26 fields to Assertive Discipline.
Date - 6/20/2008
Is New? Table Field Comments
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.
Date - 6/13/2008
Is New? Table Field Comments
GRD Increased the field size on C1, C2 and C3 from 1 character to 2.
Date - 6/6/2008
Is New? Table Field Comments
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.
Date - 5/23/2008
Is New? Table Field Comments
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.
Date - 5/16/2008
Is New? Table Field Comments
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.
Date - 4/25/2008
Is New? Table Field Comments
ATN TM, AU Added 2 new fields to Attendance Notes: time (TM), and authorized by (AU)
Date - 4/11/2008
Is New? Table Field Comments
SSD Added 4 new fields to Secondary Student Data.
Date - 3/14/2008
Is New? Table Field Comments
LOC R14, R15 New fields for LOC Rules regarding updateability of student next school and school of residence fields.
Date - 2/29/2008
Is New? Table Field Comments
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).
Date - 2/15/2008
Is New? Table Field Comments
SAP GR New grade level field for use with Student Assessment.
Date - 2/1/2008
Is New? Table Field Comments
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.
Date - 1/25/2008
Is New? Table Field Comments
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.
Orchard.DisplayManagement.Shapes.Shape