Aeries Database Changes 1/30/2020

Is New?TableFieldComments
TRUEBPW
New Banned Passwords (BPW) table for use with the Configure Password Requirements page.
TRUEDIT
New Digital Items (DIT) table for future use in Aeries.
TRUEDOF
New Digital Offering (DOF) table for future use in Aeries.
TRUEDDR
New Digital Discount Rates (DDR) table for future use in Aeries.
TRUEFTF
New Flex Periods (FTF) table for future use in Aeries.
TRUEFTT
New Flex Period Times (FTT) table for future use in Aeries.
TRUECCL
New Class Calendar (CCL) table for future use in Aeries.
TRUECCD
New Class Calendar Days (CCD) table for future use in Aeries.
TRUESSE
New Staff-Sections (SSE) table for future use in Aeries.
TRUESSM
New Staff-Scheduling Master (SSM) table for future use in Aeries.
FALSEDAYBSAdded a Bell Schedule (BS) field to the Calendar (DAY) table for future use in Aeries.
FALSESchedFSQ, CSQAdded new Class Calendar and Time Frames fields to Scheduling tables (MST, SMS, and SMB) for future use in Aeries.
FALSELOCPSF, DLFAdded Principal Signature (PSF) and District Logo (DLF) fields to the Schools (LOC) table. These fields can optionally print on a transcript report.
FALSETDFT61-70, WMFAdded fields to the Transcript Definitions (TDF) table including a new Watermark file (WMF) and ten new Yes/No options (T61-T70).
FALSEPGMPP, FTAdded Parental Permission (PP) and Funding Type (FT) fields to the Special Programs (PGM) table. These fields are currently only available to Texas districts.
FALSELACPP, FTRemoved unnecessary Parental Permission (PP) and Funding Type (FT) fields from the Language Assessment (LAC) table. These fields were only for use in Texas and deemed better placed in the Special Programs (PGM) table.
FALSEARS
Added the following fields to the Attendance Reporting Summary (ARS) table for use in Texas: Attendance Event Indicator (EI), Bilingual ESL-Program (BE), Reg Day Schl Prgm Deaf (RD), Instructional Setting (INS), Excess Hours Instr Setting (ECH), Total Eligible Minutes Present (MP), Total Ineligible Minutes Present (MI), Excess Minutes (ME), District of Service (DS), Flexible Attendance Program (FA), and CTE Code (CD).
FALSEWEBPWRemoved the "Check Constraint" on Web Users (ABI) Password field, allowing it to be blank since the data is no longer necessary.
FALSESUP, SSD
Deleted unnecessary STU "Relationship" indexes, the existing Foreign Key Constraints handle the relationship to STU already.
FALSEDSD
Deleted unnecessary index on ID field.
FALSEHSC
SqlModel.sql - the file used to create data structures for new Aeries SQL Databases no longer includes the Healthy Start Codes (HSC) table that was dropped from the Client software in 2011.
Login to post a comment