Detailed List of Recent AERIES Database Changes

Is New?	Table	Field	Comments
	FSI	SRC	Added Source (FSI.SRC) to the Foster Student Information table.
	RT_HIS	SNM	Added School Name (SNM) to the Records Transfer History (RT_HIS) table.
	DAY	WC, WM	Added Waiver Codes (DAY.WC, W1 - W26) and Minutes (DAY.WM, M1 - M26) to the Calendar table for use in Texas.
	ARP	IP	Added Instructional Program (ARP.IP) to the Attendance Reporting Periods table for use in Texas.

Is New?	Table	Field	Comments
New	DVD		New table for Data Validation Definitions (DVD) for future use.
New	DVR		New table for Data Validation Results (DVR) for future use.
New	DVC		New table for Data Validation Schools (DVC) for future use.
New	DVG		New table for Data Validation Groups (DVG) for future use.
New	DVU		New table for Data Validation Users (DVU) for future use.
	STU	RG, SCT	Added Repeat Grade (STU.RG) and School of Choice Transfer (STU.SCT) to the Student Demographics table.
	SSD	LE	Added Licensure Exam Status (LE) to the Secondary Student Data (SSD) table. Also deleted the following fields that were deemed unnecessary: First, Second, and Third Post Secondary Certification/Licensure (PS1 - PS3). These fields were for use in Texas only.
	ENR	ET	Added Entry Type (ET) to the Enrollment History (ENR) table. For use in Texas.
	ECD	PKT	Added PK School Type (PKT) to the Early Childhood Development table. For use in Texas.
	Sched	PKT	Added PK School Type (PKT) to the Scheduling tables: MST, SMS, and SMB. For use in Texas.

Is New?	Table	Field	Comments
	STU	IBC	Added IB Category (IBC) to the Student Demographics (STU) table for use with International Baccalaureate (IB) tests.
	CTS	TGR	Added Test Grade (TGR) to the College Test Scores (CTS) table for use with International Baccalaureate (IB) tests.
	STF		Deleted the following fields that were deemed unnecessary in the Staff (STF) table: Population Served (PSV), Class Type (CTY), and Service Code (SVC). These fields were for use in Texas only.
	STJ		Added two new fields to Staff Job Assignments (STJ) that were formerly in the Staff (STF) table: Population Served (PSV) and Service Code (SVC). These fields are for use in Texas.

Is New?	Table	Field	Comments
	FSC		Added Case Start Date (CSD), Office (OFC), Staff Supervisor (SS), Staff Supervisor Email (SSE), and Staff Supervisor Phone (SSP) to the Foster Student Legal Cases (FSC) table. Increased the size of the Responsible Agency (AGC) field.
	FSI		Added Social Services ID (SSID) and Parental Ed Rights Limited (PEL) to the Foster Student Information (FSI) table.
	FSP		Added Facility Name (FNM), Placement Start Date (SD), Confidential Placement (CP), Address (AD), and City (CY) to the Foster Student Placements (FSP) table.
	DCA	TI	Added Title field to the Document Archive (DCA.TI) table.

Is New?	Table	Field	Comments
New	ERL		New Electronic Score Report Log (ERL) table.
New	UCE		New UC ELC Extract (UCE) table.
New	DCA		New Document Archive (DCA) table.
	DCS		Redesigning the Documents (DCS) table.
	DCL		Redesigning the Document Confirmation Log (DCL) table.
	DCV		Redesigning the Document Visibility (DCV) table.
	ESI	ST	New Status (ST) field in the Extended Student Id (ESI) table.
	STU	Lookup	Updated the Student Lookup index (Stu_Lookup) to enhance performance.

Is New?	Table	Field	Comments
New	AWL		New Active Scheduling Wait List (AWL) table.
New	SWL		New Scheduling Wait List (SWL) table.
New	BWL		New Backup Scheduling Wait List (BWL) table.
New	LCN		New table for School Contacts (LCN).
	ROL		Added new Rollover Option fields for AUT Start Date After (ROL.SDA) and Increment (Bump) Staff Year (ROL.BSY)
	CRS	NC3	Added new Courses field for Next State Course Code (CRS.NC3) for future use.
	STU	SPE	Added new Student Personal Email (STU.SPE) field for use in Aeries Rollover.
New	ELO		Added new Expanded Learning Opportunities (ELO) table for use in Texas.
New	DPS		Added new District Programs of Study (DPS) table for use in Texas.
New	SPR		Added new School Programs (SPR) table for use in Texas.
	LOC		Added 2 new fields to the School Options (LOC) table for use in Texas.
	Sched		Added 5 new fields to the Scheduling (MST, SMS, and SMB) tables for use in Texas.

Is New?	Table	Field	Comments
	CON	LK	Contacts - A new lock field (CON.LK) has been added to give users the ability to lock down certain contact records so that they may not be changed in the parent portal.
	IMM		Immunizations table has 21 new fields for use with the updated CDPH 286 (1/19) Immunization Record (Blue Card).
	MNO		Medical Notes (MNO) has new fields for: Start Date (SD), End Date (ED), and Code (CD).
	CPH	LVL	Career Pathways History has a new Level field (CPH.LVL).
	CCP	RQ	Course Career Pathways has a new Required field (CCP.RQ).
	XRF	CD	Cross Reference Code (XRF.CD) field size has been increased to allow for more information.

Is New?	Table	Field	Comments
New	PEI		Added a new Pre-Enrollment Information (PEI) table for use with Summer School Course Requests in Aeries Web.

Is New?	Table	Field	Comments
	DAI	QTI	Added a new field to the District Analysis Indicators (DAI) table for Query Title (QTI), for use with Extended Query Fields.
	GRP		The Grade Report Mark Headings (GRP) table has three new sets for fields for each of the 12 marks: Term Start Date, Term End Date and Term State Codes. These fields are for future use in Aeries.

Is New?	Table	Field	Comments
	usysGCOD		Added State field to the table to differentiate between California and Texas fixed codes

Is New?	Table	Field	Comments
New	SRR		Added new Scheduling Run Results (SRR) table for use with the new Find Best Period process on the SMS Board in Aeries Web.

Is New?	Table	Field	Comments
	STU		Added new Elementary Counselors (CNS) field to the Student Data (STU) table. Also added new fields for future use in Texas. Please note the Texas fields will not be visible to California clients.
	IMM	MC2	Added new Immunization field for Meningococcal (MCV4) Date 2 (IMM.MC2) vaccination for use in Aeries Web.
	usysGCOD		Added 2900 "Fixed code" values to the usysGCOD table including ABS.TY, CON.NP, CRS.NA, CRS.CP, CTS.ST1, LOC.A-Z, and many more. The usysGCOD table is used by Query in the Aeries Web version to retrieve fixed code descriptions when using the "?" method.

Is New?	Table	Field	Comments
New	EFO		New Ed-Fi Options table (EFO) for future use in Aeries Web.
New	EFS		New Ed-Fi Schools table (EFS) for future use in Aeries Web.
New	EFR		New Ed-Fi Results table (EFR) for future use in Aeries Web.
	UGP		Added a new index to enhance performance for the Staff API.

Is New?	Table	Field	Comments
	STU	IT, NIT	Increased Inter/Intra District Transfer Code (IT) and Next Inter/Intra District Transfer Code (NIT) from the Students (STU) table for future use. Also deleted Attribution Code (ATR) as it is no longer necessary.
	ATT/ENR	IT	Increased Inter/Intra District Transfer Code (IT) in the Attendance (ATT) and Enrollment (ENR) tables for future use.

Is New?	Table	Field	Comments
	SSR		Redesigned the Summer School Requests (SSR) table to allow the same course multiple times within a term.
	SRB		Redesigned the Summer School Request Backups (SRB) table to allow the same course multiple times within a term.
	CSE	IC	Added IEP Continuer (IC) field to the Special Education (CSE) table.

Is New?	Table	Field	Comments
	STU	GN	Added new Gender (GN) field to the Students (STU) table for use in Aeries Web.
	IDN	GN	Added new Gender (GN) field to the Student Permanent ID (IDN) table for use in Aeries Web.
	Sched	GN	Added new Gender (GN) fields to scheduling (MST, SMS, SMB, ATS) tables for use in Aeries Web.
	Sched	TOG	Added new Total Other Gender (TOG) fields to scheduling (TCH, MST, SMS, SMB) tables for use in Aeries Web.
	CRS	CC	Added Course Cost (CC) field to the Courses (CRS) table for use in Aeries Web.
	SSD	HT	Added At Least Half-Time Student flag (HT) to the Secondary Student Data (SSD) table for future use in Aeries Web.

Is New?	Table	Field	Comments
New	CVR		Added new Civil Rights (CVR) table for use with the Civil Rights Data Collection (Beta) in Aeries Web.
New	CVT		Added new Civil Rights Totals (CVT) table for use with the Civil Rights Data Collection (Beta) in Aeries Web.
	LOC	NDS	Added new NCES ID Number (NDS) field to the Schools (LOC) table for use with the Civil Rights Data Collection (Beta) in Aeries Web.
	FRE	CTR	Added CTE Transportation (CTR) to the Free and Reduced Meals (FRE) table for future use.
	PGM	TY, CRI	Added Title I Participation Type (TY) and Crisis Indicator (CRI) fields to the Student Programs (PGM) table for future use.
	XRF	DE, DE1	Increased the description fields (DE and DE1) in the Cross Reference (XRF) table to allow longer text (varchar(max)).
	CTL		Added test parts 0 (CA Science Test) and 1 (Science) for CAST. Added part 3 (Science) for CAA.

Is New?	Table	Field	Comments
	LAC	US3	Added new US School Age 3 & Up (US3) date to the Language Assessment (LAC) table.

Is New?	Table	Field	Comments
	LTO	EM, RAA	Added School Notification Email (EM) and Return Address Alignment (RAA) fields for future use.
	CBS	TOT	Added Total (TOT) field for future use.

Is New?	Table	Field	Comments
New	DVS		New Devices (DVS) table for future use with Push Notification in the Aeries Mobile API.
	CSE		Increased the Plan Type (PT), Residence status (RS), and Infant setting (IS) fields in the Special Education (CSE) table to support the 2018-19 CASEMIS Import.
	usysGCOD		Updated Special Education codes according to the 2018-19 CASEMIS layout.
	SSD		Added Associates Degree (ADG), First Post-Secondary Certification/Licensure (PS1), Second Post-Secondary Certification/Licensure (PS2), and Third Post-Secondary Certification/Licensure (PS3) to the Secondary Student Data (SSD) table.
	STF		Added Professional Experience (PX), Teaching Experience (TX), Staff Type (TY), Service ID (SVC), Population Served (PSV), and Class Type (CTY) to the Staff (STF) table for future use. Also increased the Position Status (PS) field for future use.
	STE		Added Credential Level (LV) to the Staff Raw Credentials (STE) table for future use. Also increased the Basis (BS) and Document Number (DN) fields for future use.
	STJ		Added Role Type (RT), and Monthly Minutes (MMN) to the Staff Job Assignments (STJ) table for future use. Also increased the Job Classification (JC) field for future use.

Is New?	Table	Field	Comments
New	ECD		New Early Childhood Development (ECD) table.
New	CSH		New Special Education Instructional Setting History (CSH) table for future use.
	CSE		Added Child Funding Type (CFT), Medically Fragile (MF), PreSchool Child with Disabilities (PSD), and Early Childhood Intervention (ECI) to the Special Education (CSE) table for future use.
	LOC		Added Federal Tax ID (FID), FIPS Code (FC), Quality Rating and Improvement (QRS), Accreditation Status (ACC), School Website (WS), Charter Status (CHS), School Category (CT), District Category (DTY), and NSLP Status (NLP) to the School Location (LOC) table. Also increased the Title 1 Indicator (T1) field for future use.
	CRS		Added Service ID (SVC), Population Served (PSV), and Class Type (CTY) to the Courses (CRS) table for future use.
	Sched		Added Population Served (PSV), Class Type (CTY), and Monthly Minutes (MMN) to the Master Schedule (MST), Scheduling Master (SMS), and Scheduling Backup (SMB) tables for future use.
	Subject		Increased the Subject Area fields to 6 characters in the following tables: Courses (CRS.S1, S2, S3), Course Sequence (CSQ.SA), District Analysis Indicators (DAI.GS), High School Graduation (HSG.CD), and Graduation Requirements (REQ.CD).
	LAC	PP	Added Parental Permission (PP) to the Language Assessment (LAC) table for future use.
	STU		Added Attribution Code (ATR) and Multi-Birth Status (MBS) to the Students (STU) table for future use.

Is New?	Table	Field	Comments
	FTS	FPS	New Financial Payment Schedule field in the Financial Transactions Summary table designed for rebuilding the Payment Schedule when changes are made.
	ADS	DE	New Short Description field in the Assertive Discipline table.
	DSP		Added a new set of fields in the Administrative Decisions (Dispositions) table for optionally tracking Assigned and Served dates separately.
	OAT		OAuth - added a new index on the DEL and ACD fields to enhance performance.

Is New?	Table	Field	Comments
	ASL		Added a set of "First submission" Date/Times for each period (F0-F9) and all-day (FL) to indicate when attendance was first taken. The existing Date/Time fields (T0-T9, TL) will continue to store the most recent Date/Time that attendance was submitted.
	CSN		NWEA MAP - new parts have been added for 2018-19. MAPREAD: parts 8-12, MAPMATH: parts 7-15, MAPSCI: parts 4-7.

Is New?	Table	Field	Comments
New	ESD		New Encrypted Student Data (ESD) table that allows schools the option to collect Social Security Numbers for Students. This information will then be available to print on certain reports in the future.
New	CCI		New College and Career Indicators (CCI) table for future use.
New	RRQ		New Records Release (RRQ) table for future use.
New	RRI		New Records Release Items (RRI) table for future use.
	GRD	S1-S12	New Sequence fields in Grade Reporting (GRD.S1-S12) will alleviate the problem of creating duplicate HIS records when GRD is rolled twice.
	STU	AVI, AVD	New Address fields in Students (STU.AVI, STU.AVD) for future use.
	CON	EM	Increased size of email fields in Contacts (CON.EM, CON.CN1-CN4)

Is New?	Table	Field	Comments
	CPO	OD	Added Outcome Date (OD) to the Career Pathways Outcomes (CPO) table.

Is New?	Table	Field	Comments
	STU	DSL	Added Do not Send Letters (DSL) to the Students (STU) table for future use.
	CRS	HC	Added Hours for Completion (HC) to the Courses (CRS) table.
	HIS	DC	Added Date of Completion (DC) to the Transcripts (HIS) table.
	Grades	ABG	Added Attendance Based Grade (ABG) flag to the Grades (GRD), Grade History (GRH) and Transcripts (HIS) tables for future use.

Is New?	Table	Field	Comments
New	FBK		New table for App Feedback (FBK).
	LAC		Added Initial Test Date (ITD) and Initial Test Fluency (ITF) to the Language Assessment (LAC) table.

Is New?	Table	Field	Comments
	LTO		Added three new fields to the Letter Options (LTO) table: Analytics Indicator (AID), School District in Chart (SDC), and Show School in Chart (SSC).

Is New?	Table	Field	Comments
New	CBS		New Communications Batch (CBS) table for future use.
New	CBD		New Communications Batch Details (CBD) table for future use.
New	LTO		New Letter Options (LTO) table for future use.
	LET		Added Short Message (SM), Intervention Code (INV), and Custom Text (CT) to the Letters table (LET) for future use.
	LTL	PT	Modified the PrimaryKey of the Letter Log to include a new Part field (LTL.PT).
	LEA	PT	Modified the PrimaryKey of the Letter Table Audit to include a new Part field (LEA.PT).

Is New?	Table	Field	Comments
	TNP		Added scale scores in TNP (SPRG18) for CAASPP, CAA, and STS

Is New?	Table	Field	Comments
	FTD	SRT	Added a Sort field to the Financial Transaction Details table (FTD.SRT).
	FTP	ST	Added a Status field to the Financial Transaction Payments table (FTP.ST).
	STN	TI	Changed Standards Title (STN.TI) field to nvarchar instead of varchar, to support additional characters.
	SOC	EC	Changed Suspendable Offense Codes Ed Code Section (SOC.EC) field to nvarchar instead of varchar, to support additional characters.

Is New?	Table	Field	Comments
	YTD		Added Unverified Absence (UNV), Independent Study Incomplete (ISI), and Independent Study Complete (ISC) fields to the Year-to-Date (YTD) table for use in Aeries Web.
	ATT		Added ADA Code (ADA), Date (ADT), and Comment (ACO) to the Attendance (ATT) table for use in Aeries Web.
	XRF		Updated the description for CALPADS codes E140 from "Left - Next School Unknown" to "Truant - Next School Unknown".
	usysGCOD		Updated the description for CALPADS codes E140 from "Left - Next School Unknown" to "Truant - Next School Unknown".
	DAY	PD	Added Period field to the Calendar table (DAY.PD) for future use.

Is New?	Table	Field	Comments
	FLF/FLR		New PFT18 layout for San Joaquin County Office of Education (PFT18SJC).

Is New?	Table	Field	Comments
	BER	SCL	Added new School field (SCL) to the Behavioral Emergency Report table.

Is New?	Table	Field	Comments
New	TSI		New Temporary Student Information table.

Is New?	Table	Field	Comments
	FRE	PIR,PDT	Added new Free and Reduced fields for Parent Income Survey Response (PIR) and Parent Income Survey Response Date (PDT).
	OAT	JSN	Changed JSN field type from varchar(255) to varchar(max).
	PWA	CP	Added new field Confirmed Phone.

Is New?	Table	Field	Comments
	FTD		Added new Financial Transaction Detail fields for Resource ID (FTD.RID), Resource Item# (FTD.RIN) and Resource Fee Type (FTD.FT) for use with District Assets. Also increased the size of the Code field to match FEE.CD.

Is New?	Table	Field	Comments
New	FSA		New Foster Student Action Plans table.
New	FSC		New Foster Student Legal Cases table.
New	FSE		New Foster Student Ed Rights table.
New	FSG		New Foster Student Goals table.
New	FSH		New Foster Student History table.
New	FSI		New Foster Student Information table.
New	FSL		New Foster Student Attorneys table.
New	FSM		New Foster Student Meetings table.
New	FSN		New Foster Student Notes table.
New	FSP		New Foster Student Placements table.
New	FSR		New Foster Student Hearings table.
New	FSS		New Foster Student Team Contacts table.
New	FST		New Foster Student Summary Report Notes table.
New	SRD		New Synchronization Review Date table.
	DOC	RID	Added new Record ID field to the Documents table.
	DNT	VF	Increased Dental Visible Fillings to 2 characters to allow user-defined dropdown list.

Is New?	Table	Field	Comments
	ROL	UWA, CCS	Added new Rollover Option fields to define "Under what age" students should continue being rolled forward (ROL.UWA) and to allow users to Copy Custom SQL Modules (ROL.CCS).
	GRG	SCL	Added School field to the Grade Reporting GPAs table (GRG.SCL), allowing the table to be defined as ID-based.
	CON	C1D, C2D	Increased the size of the Primary Contact description fields (CON.C1D, C2D).
	HSG		The High School Graduation Status table (HSG) was missing a relationship to IDN, fixed.

Is New?	Table	Field	Comments
	LOC	CH	New Charter School# field in Schools table (LOC.CH) for use with the new Physical Fitness Extract in Aeries Web.

Is New?	Table	Field	Comments
New	SLA		New Service Learning Areas table.
New	SLH		New Service Learning Hours table.
New	SLQ		New Service Learning Organization Areas table.
	SLL	AC, HT	Added Service Learning Area Code (AC) and Hour Type (HT) to the Service Learning Log (SLL) table.

Is New?	Table	Field	Comments
New	NTF		New Notification table for use in the Aeries App.
New	NTU		New Notification Users table for use in the Aeries App.
	CTD	VW	Added "Is View?" option to the Custom Table Definitions table.
	DOC	TY	Increased size Documents Type to 4 characters (DOC.TY).
	FLF/FLR		New records for PFT18 for the SPRG18 Testing Administration.

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

Is New?	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.

Is New?	Table	Field	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.

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

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.

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.

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

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.

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

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.

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

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

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.

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

Is New?	Table	Field	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).

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

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

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

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.

Is New?	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).

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

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.

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.

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.

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

Is New?	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.

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

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.

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

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

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

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.

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.

Is New?	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.

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.

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.

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.

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

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.

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.

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.

Is New?	Table	Field	Comments
New	RCH		Report Card History is a new table for use in the Aeries Web version.

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.

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.

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

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.

Is New?	Table	Field	Comments
	TNP		Added records for SBAC 2015-16 (SPRG16) testing administration.

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

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

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.

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.

Is New?	Table	Field	Comments
	CON	NP	Added Notification Preference to the Contacts table for use with Loop Integration.

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.

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.

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.

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

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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

Is New?	Table	Field	Comments
	FLF,FLR		Updated CASEMIS layout according to the Technical Assistance Guide from Nov 25, 2015.

Is New?	Table	Field	Comments
	usysGCOD		Updated CBEDS codes (CTE Programs), Staff Assignments, and Staff Job Assignment codes as needed.

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

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.

Is New?	Table	Field	Comments
New	TSO		New table for Teacher Standards Options for future use in Aeries.net

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

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.

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.

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.

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.

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

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

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.

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

Is New?	Table	Field	Comments
	504		Removed unnecessary indexes on Insert Date (IDT) fields from all 504 Plan tables.

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.

Is New?	Table	Field	Comments
	SEC	CN	Added Course ID (CN) to the Section (SEC) table.

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.

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

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.

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

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

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

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.

Is New?	Table	Field	Comments
	usysGCOD		New State Test Settings (STS) values (TOMS).

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.

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

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.

Is New?	Table	Field	Comments
New	PHL		New table for "Page Hit Log" table for future use with Aeries.net.

Is New?	Table	Field	Comments
	LAC	EAC/EAD	Added new fields for Student English Language Acquisition Code and Student English Language Acquisition Date

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.

Is New?	Table	Field	Comments
	TPS	AGD	Added new field for Testing Pass Status - Algebra I Grade Passed (TPS.AGR)

Is New?	Table	Field	Comments
	ADH		Removed the SN (Stu#) field and renamed the SC field to SCL (School Code).

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

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.

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.

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.

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.

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

Is New?	Table	Field	Comments
	MLM/MLG	DA	Changed Medication Dose Amount fields (MLM.DA, MLG.DA) from Integer to Currency to allow decimals.

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.

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

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.

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

Is New?	Table	Field	Comments
	SOC		Added new fields for translations (CL1-6, DS1-6)

Is New?	Table	Field	Comments
	TNP		Added scale scores for the 2013-2014 CELDT Test Results.

Is New?	Table	Field	Comments
	COD		Added default COD values for SSD.PSP field.

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.

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.

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.

Is New?	Table	Field	Comments
	UGN	UTY	Increased User Type field size from 10 to 255.

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

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.

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.

Is New?	Table	Field	Comments
	GBT	TD	Increased Type Description field size from 30 to 255.

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.

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.

Is New?	Table	Field	Comments
	STAR	CSW	New field for CST or CMA Writing Test Score.

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.

Is New?	Table	Field	Comments
	usysGCOD		Added new Special Programs code 185 for Transitional Kindergarten.

Is New?	Table	Field	Comments
New	REL		New table for Religious information

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

Is New?	Table	Field	Comments
	SSO	EID	Added an EADMS ID field to the Single Sign On table.

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.

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.

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.

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.

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)

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.

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.

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.

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

Is New?	Table	Field	Comments
New	MLM		New Medications table for future use.
New	MLG		New Medications Log table for future use.

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.

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.

Is New?	Table	Field	Comments
New	PNP		New table for Parent Notification Preference.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

Is New?	Table	Field	Comments
	CTE	CM	Added "Completer?" field.

Is New?	Table	Field	Comments
	ADS	PM	Added Possible Motivation field.
	GBK	TY	Added Grading Type field.

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

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.

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.

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

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.

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.

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.

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.

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.

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.

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

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.

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!

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

Is New?	Table	Field	Comments
	PCT		Added new fields for the 2010-11 CELDT layout.

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.

Is New?	Table	Field	Comments
	FRE		Deleted unnecessary index on SCL field.
	INV		Added "SC" to the "SD" index (SC, SN, DT).

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.

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.

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

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.

Is New?	Table	Field	Comments
	TCH		Added two new fields for NCLB Core Area 1 (CA1) and 2 (CA2).

Is New?	Table	Field	Comments
	VAC		Updated the default record for Tdap Booster.

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.

Is New?	Table	Field	Comments
	PFT	VO	New field for Aerobic capacity (VO2max).

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.

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.

Is New?	Table	Field	Comments
	CRS	VLU	Added new CSU Validation Level.
	usysGCOD		Added 11 new Birthstate codes.

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.

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.

Is New?	Table	Field	Comments
	CSE	PAC	Added a Participation CST field to the Special Education table (PAC).

Is New?	Table	Field	Comments
	CSE		Added 8 Transition Information fields (TR1 - TR8).

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.

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.

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.

Is New?	Table	Field	Comments
	PAY	RA	Added a field for Remaining Balance Accounted For.

Is New?	Table	Field	Comments
	STAR	AME	Added new Accommodation/Modification "E" field to STAR.

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.

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

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.

Is New?	Table	Field	Comments
New	CTD		New table for Custom Table Definitions.
New	CTF		New table for Custom Table Fields.

Is New?	Table	Field	Comments
	CSE	ETH	Added new Ethnicity field to the Special Education table.

Is New?	Table	Field	Comments
	CSE	PI	New field for Parent Input.
	usysGCOD		Updated values for Special Education Data form.

Is New?	Table	Field	Comments
	PHE	LF	Increased Language Fluency from 1 character to 4 characters.

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.

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.

Is New?	Table	Field	Comments
	CSE	LU	Added Last Updated date.

Is New?	Table	Field	Comments
	LOC	TY	Added new LOC field for School Education Type.

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.

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.

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

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.

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.

Is New?	Table	Field	Comments
New	STJ		New table for Staff Job Assignments.

Is New?	Table	Field	Comments
	CRS		Added 2 new fields for Course Comments (CM) and Course Description (CD).

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.

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.

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.

Is New?	Table	Field	Comments
	STU	NID	Added Network Login ID to the Students table.

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.

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.

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

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.

Is New?	Table	Field	Comments
	STN	CA	Fixed misspelling of Category in field caption and description.

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.

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.

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.

Is New?	Table	Field	Comments
New	EXP		New table for Expulsions, related to Assertive Discipline (ADS).
	ADS		Added 26 fields to Assertive Discipline.

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.

Is New?	Table	Field	Comments
	GRD		Increased the field size on C1, C2 and C3 from 1 character to 2.

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.

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.

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.

Is New?	Table	Field	Comments
	ATN	TM, AU	Added 2 new fields to Attendance Notes: time (TM), and authorized by (AU)

Is New?	Table	Field	Comments
	SSD		Added 4 new fields to Secondary Student Data.

Is New?	Table	Field	Comments
	LOC	R14, R15	New fields for LOC Rules regarding updateability of student next school and school of residence fields.

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

Is New?	Table	Field	Comments
	SAP	GR	New grade level field for use with Student Assessment.

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.

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.