Detailed List of Recent AERIES Database Changes

Date - 4/13/2018

Is New?	Table	Field	Comments
	INV		Added five new fields to the Interventions tables INA, INC, ING, INM, INP, INR, INS, INV, IPI, IRC, and ISS: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).
	DOC		Added five new fields to the Documents table DOC: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).

Date - 3/30/2018

Table	Field	Comments
LOC	CBC	New College Board School Code field for use with new Cal Grant GPA page.
STU	CGG	New Cal Grant GPA field for use with new Cal Grant GPA page.
FLI	SCL	New School Code field for use with new Cal Grant GPA page.

Date - 2/28/2018

Is New?	Table	Comments
New	CMP	New Composite Courses (CMP) table for use in Aeries Web.
New	NAV	New Navigation (NAV) table for use in Aeries Web.
	FOF	Added 8 new fields to the 504 Plans (FOF) table for use in Aeries Web.

Date - 2/2/2018

Is New?	Table	Field	Comments
	CON	PC	New Primary Contact (PC) field for the Contacts (CON) table, for use in Aeries Web.

Date - 1/26/2018

Is New?	Table	Field	Comments
New	OCM		New Other District Course Matches (OCM) table for use with Records Transfer in Aeries Web.
	RT_HIS	MID	New Match ID (MID) field for the Records Transfer History (RT_HIS) table, for use in Aeries Web.
	ODC	CN, CO	Dropping Course (CN) and Course Title (CO) fields from the Other District Courses (ODC) table as they are no longer necessary with the new Other District Course Matches (OCM) table.

Date - 1/19/2018

Is New?	Table	Field	Comments
New	FTP		New Financial Transaction Payments (FTP) table for use in Aeries Web.
	FTD		Added School (SCL), Code (CD), Transaction Type (TT) and Amount Paid (PD) to the Financial Transaction Details (FTD) table for use in Aeries Web.
	MII	SD, ED	Added Start Date (SD) and End Date (ED) to the Medical Insurance Information (MII) table for use in Aeries Web.
	ALL		Mass changed ALL image fields in SQL to varbinary(max) as the image field is being removed in a future release of SQL Server.

Date - 1/11/2018

Is New?	Table	Field	Comments
	HIS	SDE	Added Dual Enrollment Credit School to Transcripts (HIS.SDE) for use in Aeries Web.

Date - 12/21/2017

Is New?	Table	Field	Comments
	ADS	RF	Modified description of ADS.RF from "Referral" to "Referrer" to match the Assertive Discipline page in Aeries Web.

Date - 12/8/2017

Is New?	Table	Field	Comments
	PHL	TY	Added Type field to Page Hit Log (PHL.TY) for use in Aeries Web.

Date - 12/1/2017

Is New?	Table	Field	Comments
New	HSG		New table to store Graduation Status statistics for use in Aeries Web.
	APC		Added two new fields to the Academic Plan Course Requests (APC) table: Transaction Type (TRN), and Transaction Status (TRS) for use in Aeries Web.
	CER	SA	Increased College Entrance Requirements Subject Code (CER.SA) to 5 characters for use in Aeries Web.
	CRQ	PT	Added Preferred Term field to Course Requests Cross Reference (CRQ.PT) for use in Aeries Web.
	CSQ	PT	Added Show in Portal field to the Course Sequence (CSQ.PT) for use in Aeries Web.
	AUT		Added five new fields to the Authorizations table AUT: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).
	Language		Added five new fields to the Language Assessment tables LAC, LAF, and LAS: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).
	GRC	MK	Increased Mark field to 3 characters to match GRD, GRH, and HIS.

Date - 10/27/2017

Is New?	Table	Field	Comments
	CSE, CSV		Added five new fields to Special Education tables CSE and CSV: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).
	ACT		Added five new fields to the Activities table ACT: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).

Date - 10/20/2017

Is New?	Table	Field	Comments
	Test	IDs	Increased Test ID fields to 8 characters including: Test Scores ID (TST.ID), Test Exclusions ID (TEX.ID), Records Transfer Test ID (RT_TST.ID), Content Standard Scores Related Test ID (CST.RT), and Records Transfer Content Standard Scores Related Test ID (RT_CST.RT).

Date - 10/4/2017

Is New?	Table	Field	Comments
	DIS		Added 4 new fields to the Discipline (DIS) table for: Exact Time (ET), Location (LCN), Possible Motivation (PM), and Consequence (CN).
	GRD/GRH	TN2, TN3	Added additional teacher fields (TN2, TN3) to Grade Reporting (GRD) and Grade History (GRH) tables to match Scheduling.

Date - 9/29/2017

Is New?	Table	Field	Comments
	ATA	RA	Added Required for Attendance field to Supplemental Attendance Assignments (ATA.RA).

Date - 9/26/2017

Is New?	Table	Comments
New	WRL	New Web Request Log table for use in Aeries Web.
	Tests	Added five new fields to Testing tables CST, CTS, and TST: Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN).
	504	Added two new fields to the 504 tables FAP, FDE, FEC, FOF, FPP, and FSD: Insert User Name (IUN) and Update User Name (UUN).

Date - 9/13/2017

Is New?	Table	Field	Comments
	ANL		Added new fields to the Attendance Notification Log (ANL) table for: Message Text (MT), Delivered IDs (DID), and Error Text (ERR).

Date - 9/12/2017

Is New?	Table	Field	Comments
	MST	USA	Added new Use Supplemental Attendance (USA) flag to Master Schedule tables (MST, SMS, and SMB).

Date - 8/25/2017

Is New?	Table	Field	Comments
New	RTG		New Report Tags table for use with Aeries Web.

Date - 8/11/2017

Is New?	Table	Field	Comments
New	DDS		Added new District Data Sharing (DDS) table.
	IDN	CID	Added Student State ID field to the Student ID table (IDN.CID).
	ATP	SSI	Added Student Self Sign-In flag to Supplemental Attendance Programs (ATP.SSI).
	COD		Added default codes for Gradebook Assignment Status (GBS.ST) in preparation for a future Gradebook update in Web.
	TXT	AU	Increased size of saved Query author field (TXT.AU) to match account user names (UGN.UN).
	TPE		Since the 6/30 update, the trigger for the Third Party Extracts (TPE) table was being created incorrectly and included the default IDN record (IDN.ID=0) as part of it. This issue was not allowing the districts to add vendors for third party extracts, fixed.

Date - 7/14/2017

Table	Field	Comments
ATA/ATD		Modified the design of Supplemental Attendance Assignments (ATA) and Data (ATD) tables for use in Aeries Web.
ATS	PD	New Attendance Period field for Supplemental Attendance Sessions (ATD.PD).
FLF/FLR		New PFT17 layout for San Joaquin County Office of Education (PFT17SJC).

Date - 6/30/2017

Is New?	Table	Field	Comments
New	TPE		New Third Party Extract (TPE) table
	TPP		Added Insert (INS) and Delete (DL) fields to TPP

Date - 6/23/2017

Is New?	Table	Field	Comments
New	ISP		New Internship table for use in Aeries Web.
New	IVS		New Internship Visits table for use in Aeries Web.
	EMP		Added three new fields to Employers for use with new Internships tables in Aeries Web. Fields include: Class Group (EMP.CG), Sub Group (EMP.SG), and Internship Contract Type (EMP.ICT).
	HIS	SRC	Added a Source field to Transcripts (HIS.SRC) for future use in Aeries Web.

Date - 6/9/2017

Is New?	Table	Field	Comments
	AHS	SP	New Program field for Attendance History Summary table (AHS.SP). This field is also part of the Primary Key, which is now ID, YR, SCL, SP.

Date - 6/2/2017

Is New?	Table	Field	Comments
New	FTS		New Financial Transaction Summary (FTS) table for use in Aeries Web.
New	FTD		New Financial Transaction Details (FTD) table for use in Aeries Web.
New	FPS		New Financial Payment Schedule (FPS) table for use in Aeries Web.
	GRD/GRH	HR	New Hours field for Grade Reporting (GRD.HR, GRH.HR) copied from related Supplemental Attendance Sessions.
	HIS	HR	New Hours field for Transcripts (HIS.HR) copied from related Supplemental Attendance Sessions.
	RT_HIS	HR	New Hours field for Records Transfer Transcripts (RT_HIS.HR) copied from related Supplemental Attendance Sessions.

Date - 5/23/2017

Is New?	Table	Field	Comments
	SSB		Added 8 new fields to the Student Scheduling Schedules Backup table (SSB) from the Summer School Requests (SSR) table. They include: Term (TM), Status (TG), Preferred Field: AM/PM (PF), and User Codes 1-5 (U1 - U5).

Date - 5/19/2017

Table	Field	Comments
SSS		Added 8 new fields to the Student Course Requests table (SSS) from the Summer School Requests (SSR) table. They include: Term (TM), Status (TG), Preferred Field: AM/PM (PF), and User Codes 1-5 (U1 - U5).
DRT	TY	Added a Type field to the District Resource Titles table (DRT.TY).
DRI	MAC	Added a MAC Address field to the District Resource Items table (DRI.MAC).
ROL	SIP	Added a new Rollover Option field to Skip Inactive School Processing (ROL.SIP)
SED	ID	Renamed Scheduling Exclusions Student ID field from SED.ID1 to SED.ID, and added a relationship between the new table and IDN.

Date - 5/12/2017

Is New?	Table	Field	Comments
New	NAT		New Notification and Alert Thresholds (NAT) table for use in Aeries Web.

Date - 5/5/2017

Is New?	Table	Field	Comments
New	SRB		New Summer School Course Request Backup (SRB) table for use in Aeries Web.
	SBU	TBL	Added field to the Scheduling Backups table for Table (SBU.TBL).
	SST	ATM	Added field to the Summer School Terms table for Actual Term (SST.ATM).
	SSR	RT	Added field to the Summer School Course Requests table for Reject Tag (SSR.RT).
	SSB	RT	Increased size Student Scheduling Schedules Backup Reject Tag to 2 characters (SSB.RT).
New	CRF		New Course Fees (CRF) table for use in Aeries Web.
New	CDC		New Course Documents (CDC) table for use in Aeries Web.
New	CSQ		New Course Sequence (CSQ) table for use in Aeries Web.
	CER	UP, CP	Added fields to the College Entrance Requirement table for UC Credits Planned (CER.UP) and CSU Credits Planned (CER.CP).
	AHS		Added period fields for STAS calculations for alternative ed schools with positive attendance.

Date - 4/28/2017

Is New?	Table	Field	Comments
	ROL	ORP	Added a new Rollover Option field to Roll Only Most Recent Picture (ROL.ORP).
	SBV	SL	Added a new Standards Based Valid Marks field to Show in Legend (SBV.SL).

Date - 4/21/2017

Is New?	Table	Field	Comments
New	SED		Added a new Scheduling Exclusions (SED) table for use in Aeries Web.
	SSS	RT	Increased Scheduling Course Requests Reject Tag to 2 characters (SSS.RT).
	AHS		Added fields to the Attendance History Summary table for: Independent Study Incomplete (AHS.ISI), Independent Study Complete (AHS.ISC), and In School Suspension (AHS.ISS).
	AHC		Added fields to the Attendance History Codes table for: Temporarily Not Enrolled (AHC.NE), and Independent Study (AHC.IS).
	OGC	CC	Added a Count for Overall Credits field to Off Grade Courses (OGC.CC).
	VSN		Added fields to the Vision table for: Left Eye Result (VSN.LER), and Right Eye Result (VSN.RER).

Date - 4/14/2017

Is New?	Table	Field	Comments
	SSR	SE, TN	Added fields to the Summer School Course Requests for Section (SSR.SE) and Teacher (SSR.TN).

Date - 4/6/2017

Is New?	Table	Field	Comments
	GRC		Added fields for transitional grade mark points for use in Aeries Web.
	FAP	AD	504 Accommodation Plans Area of Need (FAP.AD) increased field size from 3 to 6.

Date - 3/31/2017

Is New?	Table	Field	Comments
New	OAT		New OAuth table (OAT) for use with Aeries Web.
	TPN		New Third Party Names fields for Consumer ID (TPN.CID), Consumer Secret Key (TPN.CSK), and One Roster (TPN.ORT) for future use in Aeries Web.
	RTR	PH	Records Transfer Inbound Requests - increased the Phone Number field (RTR.PH) to include formatting and extensions.

Date - 3/17/2017

Table	Field	Comments
SSR	SSC	The new Summer School Course Request tables "Summer School" (SC) fields have been renamed to "SSC" in order to allow access from any school a student attends. Tables affected include: SSA, SSC, SSR, and SST.
SBV	MK	The Standards Based Valid Marks "Mark" field (SBV.MK) has been increased to match the Mark fields in the Standards Based Grades table.
TCH	TMB, TFG	Teacher table now includes new fields for Total Males/Boys (TCH.TMB) and Total Females/Girls (TCH.TFG). These fields are for use in Aeries Web.

Date - 3/10/2017

Is New?	Table	Field	Comments
New	SCH		New Seating Chart table for use in Aeries Web.
New	SDT		New Seating Chart Details table for use in Aeries Web.
	TPS	CPR	Added a Career Pathways Flag to the Testing Pass Status table.
	CON	AN	Contacts table now includes a field for Attendance Notification for future use in Aeries Web.
	FLF/FLR		New records for PFT17 for the SPRG17 Testing Administration.
	usysGCOD		Updated CBEDS/CALPADS codes according to the new CALPADS code set.

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	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

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

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

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

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	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

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	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	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

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

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

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

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

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

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	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

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	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	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

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	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	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

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

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

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	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	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

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	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

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

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	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

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

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

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

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

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	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.