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