Aeries Database Changes 1/29/2021

Is New?TableFieldComments
TRUEPRE
Drop and re-add the PRE table to be used for Texas Assessment Precode Accommodations. This table was previously used for the STAR Pre-Identification Form in Aeries Client but has not been in use since 2013.  For any databases found with existing data in the PRE table, the data will be moved to a new table called PRESTAR.
TRUELAV
New Language Acquisition Services (LAV) table for use in Texas.
TRUELAA
New Language Acquisition Assessment (LAA) table for use in Texas.
TRUEHAM
New Hearing Amplification (HAM) table for use in Texas.
FALSETDFT73Added an option to print "Department Code or Description" (T73) to the Transcript Definitions (TDF) table, used in combination with the option to "Show Department" (T69).
FALSETDFT74-T75Added option to "Print District GPAs" (T74) and "Print Rank for District GPAs" (T75) to the Transcript Definitions (TDF) table.
FALSETDFT76Added option to "Only Display Completed Endorsements" (T76) to the Transcript Definitions (TDF) table.
FALSECRSDCIncreased the Department Code (DC) in the Courses (CRS) table to 6 characters to allow for Course Category codes to be used in Texas.
FALSEGESSTUpdating values in Status (ST) field of the Graduation Endorsement Students (GES) table with new values to use consistent code values rather than long text. No structure changes, only modification of existing data.
FALSEDATL1M-L5MUpdating values in LvlGrdMarks (L1M - L5M) of the District Analysis Thresholds (DAT) table based on corresponding changes to Status (ST) field of the Graduation Endorsement Students (GES) table. No structure changes, only modification of existing data.
FALSEDAQQVUpdating values in Qualifying Value (QV) of the District Analysis Qualifications (DAQ) table based on corresponding changes to Status (ST) field of the Graduation Endorsement Students (GES) table. No structure changes, only modification of existing data.
FALSECSQ
Added fileds to the Course Sequences (CSQ) table to allow for up to 16 total courses per sequence instead of 6, plus new default term and year fields. New fields include: Course 7-16 (CN7-CN16), Default Term (DT1-DT16), and Default Year (YR1-YR16).
FALSECONELVAdded Education Level (ELV) to the Contacts (CON) table. Also added Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN). This update will copy existing user-defined COD and XRF values for Parental Education Level from STU.PED to CON.ELV for use with the new Education Level field.
FALSEPGMPYBAdded Prior Year Bilingual / ESL Summer (PYB) to the Special Program Details (PGM) table for use in Texas.
FALSEPOP
This update will create default Portal Option (POP) records for the new "Attendance to be Taken (Marked as Complete) by Section" option if the "Lock Teacher Attendance for a class after the teacher clicks the 'Attendance Complete' button" is selected.

Will the STU.PED go away for 21/22?  

Erin,


That field is designed to be used for parent/guardian records for all students, not just new students. By next year customers will need to extract separate Education Levels for their guardian records, so this will be coming from the CON table.. By adding this field now, our customers will have more time to gather data and enter it. We will be changing the Parent Data Confirmation process to allow collecting this info for Parent/Guardian records and have the parents themselves do the data entry.  

FALSECONELVAdded Education Level (ELV) to the Contacts (CON) table. Also added Insert Date (IDT), Insert User ID (IUI), Insert User Name (IUN), Update User ID (UUI), and Update User Name (UUN). This update will copy existing user-defined COD and XRF values for Parental Education Level from STU.PED to CON.ELV for use with the new Education Level field.


Can I ask if its just for NEWLY Added students as I can still edit those who were already entered into Aeries prior to 1/29.


Thank you


Erin Baker

Login to post a comment