Aeries Database Changes 3/12/2020

Is New?TableFieldComments
TRUESPC
New Staff Pictures (SPC) table to allow loading of pictures for Staff members.
TRUECDI
New Code Table Image (CDI) table.
TRUEODR
New Online Store Order (ODR) table for use in the new Online Store.
TRUEOHI
New Online Store Order History (OHI) table for use in the new Online Store.
TRUEACR
New Alternate Course Requests (ACR) table for future use.
TRUEACA
New Alternate Course Request Association (ACA) table for future use.
TRUESAR
New Summer Alternate Course Requests (SAR) table for future use.
TRUESAA
New Summer Alternate Course Request Association (SAA) table for future use.
TRUEBAA
New Alternate Course Request Association Backup (BAA) table for future use.
TRUEBAC
New Alternate Course Requests Backup (BAC) table for future use.
TRUEBSA
New Summer Alternate Course Request Association Backup (BSA) table.
TRUESAB
New Summer Alternate Course Requests Backup (SAB) table for future use.
FALSESSCOLAdded Allow Online Course Request (OL) flag to the Summer School Courses (SSC) table for future use.
FALSESTUOSSAdded Summer Online Scheduling Group (OSS) field to the Students (STU) table for future use.
FALSESSTOSSAdded Summer Online Scheduling Group (OSS) field to the Summer School Terms (SST) table for future use.
FALSEDITPPLAdded PayPal (PPL) field to the Digital Items (DIT) table for use in the new Online Store.
FALSEFTDSINAdded Shopping Item Number (SIN) field to the Financial Transaction Details (FTD) table for use in the new Online Store.
FALSEDOCSRCIncreased field size of the Source (SRC) field in the Student Documents (DOC) table to support importing documents uploaded in the Online Enrollment process.
FALSEDAITSFIncreased field size of Test Score Field (TSF) in the District Analysis Indicators (DAI) table allowing a new indicator type of Retention Count.
FALSEIMSOPTAdded Import Options (OPT) to the Import Settings (IMS) table for future use on the Import Data into Aeries page.
FALSEIMJTLOAdded Table Level Options (TLO) to the Import Jobs (IMJ) table for future use on the Import Data into Aeries page.
FALSECRSEEAdded an Include for Extracurricular Activity Eligibility (EE) field to the Courses (CRS) table for UIL Eligibility in Texas.
FALSEECADI, RDAdded Ineligibility Effective Date (DI) and Eligibility Reevaluation Date (RD) fields to the Extracurricular Activities (ECA) table for use in Texas on the new UIL Eligibility page.
FALSEECPES, DI, RDAdded Eligibility Status (ES), Ineligibility Effective Date (DI) and Eligibility Reevaluation Date (RD) fields to the Extracurricular Eligibility History (ECP) table for use in Texas on the new UIL Eligibility page.
Login to post a comment