This article contains a listing of all tables and a brief description of their use in Aeries.
Table Code | Table name | Table Description |
ABS | Absence Codes | Codes used for recording absences |
ACA | Alternate Course Request Association | Stores the linking of Alternate Course Requests |
ACL | Attendance Create Log | Maintains a log of when and where new PAC files and DAC tables are created |
ACR | Alternate Course Request | Stores Alternate Course Requests |
ACT | Activities and Awards | Recording Activities in which student participates, and Awards received by student |
ADH | Address History | Stores a history of student address changes |
ADR | Name and Address | For recording Names and Addresses of Staff, Site Council, PTA, etc. |
ADS | Assertive Discipline | Contains data for one of the two Discipline Tables – More details than DIS (both can be used) |
AED | Adult Education | Stores Adult Education data |
AEF | Adult Education Fields | Stores Adult Education data |
AHC | Attendance History Codes | Stores a history of absence code descriptions |
AHD | Attendance History Details | Stores a detailed history of student attendance counts by code, period and year |
AHS | Attendance History Summary | Stores a summary of student enrollment, present, absent and tardy counts by year |
ANA | Attendance Notify Codes | Stores Attendance Notification Codes. |
ANC | Attendance Notify Config | Stores Attendance Notification Configuration. |
ANL | Attendance Notify Log | Stores Attendance Notification Log. |
ANS | Attendance Notify Schls | Stores Attendance Notification Schools. |
APC | Academic Plan Crs Req | Stores a student’s current academic plan |
APL | Academic Plan Log | Maintains a record of any change done to a student’s academic plan. |
ARC | At-Risk Configuration | Stores At-Risk Indicator information |
ARD | Attendance Reporting Data | Student Attendance details for TX Attendance Reporting |
ARH | Attendance Reporting Hours | Student Hourly CTE details for TX Attendance Reporting |
ARI | Student At-Risk Indicators | Stores Student At-Risk Indicators |
ARP | Attendance Reporting Periods | Attendance Reporting Periods for use in Texas |
ARR | Attendance Reporting Remote | Student Remote attendance details for TX Attendance Reporting |
ARS | Attendance Reporting Summary | Campus/District Summary details for TX Attendance Reporting |
ART | Attendance Reporting Tracks | Records instructional ranges (Instructional Periods or Instructional Minutes) for use in calculating Instructional Minutes in Texas schools. |
ASL | Tch Att Submission Log | Maintains a record when teachers submit attendance through Teacher Portal -Generates Missing Sheet Log |
ATA | Supp Att Assignments | Relationships of Student Numbers to Supplemental Attendance Session numbers |
ATC | Supp Att Calendar | Days that a Supplemental Attendance Session meets |
ATD | Supp Att Data | Supplemental Attendance tracking includes times in and out and total minutes by student |
ATL | Attendance Log | Maintains a record of when changes are made to student attendance |
ATN | Attendance Notes | For recording specific details for a particular student and date. |
ATP | Supp Att Programs | Contains details of Supplemental Attendance Programs offered |
ATR | Supp Att Staff | Relationships of Staff IDs to Supplemental Attendance Session numbers |
ATS | Supp Att Sessions | Contains details of Supplemental Attendance Sessions offered |
ATT | Attendance Data | Maintains Dates of Enrollment, Absences and Absence Reasons, and Un-enrollment |
AUT | Authorizations | Specific authorizations or prohibitions to student participation in specific programs |
AWL | Master Schedule Wait List | |
BAA | Backup | Alternate Course Request Association Backup |
BAC | Alternate Course Requests Backup | Alternate Course Requests Backup |
BEL | Bell Schedule | Bell Schedule for Secondary Schools, including Continuation or Alternative Schools |
BER | Behavioral Emergency Report | Tracks Mechanical Restraint, Physical Restraint, and Seclusion for State Reporting and Civil Rights Data Collection. |
BIL | Billing | For tuition billing of students – more detailed than the FEE table |
BPW | Banned Passwords | Stores Banned Passwords |
BSA | Association Backup | Summer Alternate Course Request Association Backup |
BSD | Bell Schedule Definition | Provides for a variety of Bell Schedules which can be assigned to the Calendar |
BST | Bell Schedule Times | Contains data from Bell Scheduler |
BWL | Backup Scheduling Wait List | |
CAC | Campaign Advertisement Connections | |
CAL | Class Attendance Log | Class Attendance Log for use with Flex Scheduling |
CAR | Course Attendance | Records changes in students’ class schedules so attendance can be tracked at the course level |
CAS | Class Attendance Submission Log | Class Attendance Submission Log for use with Flex Scheduling |
CAT | Class Attendance | Class Attendance for use with Flex Scheduling |
CBD | Communications Batch Details | District Attendance Letter Details |
CBS | Communication Batch | District Attendance Letter Summary |
CCC | College Course Credit | |
CCD | Class Calendar Dates | Class Calendar dates for Flex Scheduling |
CCH | Course Characteristics | Allows districts to define a course in more granular detail. |
CCI | College and Career Indicator | |
CCL | Class Calendars | Class Calendars for Flex Scheduling |
CCP | Course Career Pathways | Stores Career Pathways specific to each Course. |
CDC | Course Documents | Aeries Web Only. Contains documents specific to each Course. |
CDI | Code Table Image | |
CER | College Entrance Reqs | Stores College Entrance Requirements for each student. |
CCH | Course Characteristics | Stores more granular details about a Course. |
CHC | Course History Characteristics | Allows removal/addition Course Characteristics to a specific transcript record. |
CHD | Attendance History Details | Attendance History Details for Flex Scheduling |
CHI | Crs History Institutions | Names / Addresses of Districts & Schools outside the current district used by various drop-downs, such as Transcripts |
CMP | Composite Courses | |
CNF | Conference | Contains detail for one of the two Counselor Tables - More details than VIS (both can be used) |
COD | Code Table | Contains CODES for Multiple Tables |
COL | Colleges | Names and Addresses of Colleges – Can be DISTRICT MANAGED. |
CON | Contacts | Records of people to be contacted in case of emergency |
CPE | Career Pathway Exp | Stores Career Pathways Experiences for each student. |
CPH | Career Pathway History | Stores Career Pathways History for each student. |
CPO | Career Pathway Outcomes | Stores Career Pathways Outcomes for each student. |
CPR | Course Prerequisites | This table is in the Aeries SQL database for a planned future enhancement to Aeries to implement Course Requests |
CPW | Career Pathways | Stores Career Pathways details for each student. |
CRA | Custom Report Access | Contains which security groups can view each custom report. |
CRC | Custom Report Config | Stores the definition of each custom report. |
CRD | Course Request Defs | Contains codes used to setup course request packets |
CRF | Course Fees | Aeries Web Only. Contains fee information specific to each Course. |
CRG | Custom Report Groups | Stores which custom report items are on each custom report. |
CRI | Custom Report Items | Stores the definition of each custom report item. |
CRL | Custom Report Layout | Contains descriptions and colors for each of the 5 test levels. |
CRP | Course Request Packets | Contains the courses setup within the course request packets |
CRQ | Course Requests | Contains the list of courses offered to students in different grade levels during scheduling |
CRS | Courses | Contains details of Courses offered at a Secondary School |
CRT | College Requests Table | Stores transcript requests from Colleges |
CSA | Special Ed Alternate Assessment | Special Ed Alternate Assessment Data – Can be DISTRICT MANAGED |
CSD | Special Ed DIS Services | Special Ed Disability Services – Can be DISTRICT MANAGED |
CSE | Special Education Data | Special Education Demographic Information – Can be DISTRICT MANAGED |
CSI | Special Ed Infant Data | Special Ed Infant Services data – Can be DISTRICT MANAGED |
CSN | Content Standard Names | Contains descriptions of Content Standards Tests and Test Parts populated when loading STAR – Can be DISTRICT MANAGED |
CSQ | Course Sequence | Academic Plan - Course Sequences |
CSS | Special Ed Suspensions | Special Ed Student Suspensions – Can be DISTRICT MANAGED |
CST | Content Cluster Scores | Stores the Content Standard Scores that are loaded from STAR |
CSV | Special Ed Student Services | Special Ed Student Services data – Can be DISTRICT MANAGED |
CTD | Custom Table Definitions | These tables define the layout of custom tables defined in your Aeries SQL database and tell Aeries Web how to display and work with the table. These tables are updated from the Define Custom Tables page |
CTE | Career Tech Education | Career Technical Education, used by CALPADS. The information in this table is visible from the Students form, Student Secondary Data tab |
CTF | Custom Table Fields | These tables define the layout of custom tables defined in your Aeries SQL database and tell Aeries Web how to display and work with the table. These tables are updated from the Define Custom Tables page |
CTL | Test Control | Contains descriptions of Tests and Test Parts – Can be DISTRICT MANAGED |
CTS | College Test Scores | Test Scores to be included on College Transcripts |
CVR | Civil Rights Data | |
CVT | Civil Rights Data Totals | |
DAA | Data Alerts and Approvals | Alert and Responses Sent and Received |
DAC | Daily sheets | Created by Daily Attendance when Sheets are created |
DAG | Dst Analysis Stu Sub Grp | Aeries Web Only. Define sub groups for district analysis indicators |
DAI | Dst Analysis Indicator | Aeries Web Only. Stores Analysis Indicator Definitions for Aeries Analytics |
DAL | Dst Analysis Levels | Aeries Web Only. Table stores the titles, codes, and colors for each of the 1 rubric levels |
DAM | Data Alerts and Approvals Content | Content of Alert Sent and User initiating the Request |
DAQ | Dst Analysis Qualif | Aeries Web Only. Stores the qualifying level of each student for each Aeries Analytics Analysis Item |
DAS | Dst Analysis Summary | Aeries Web Only. Stores a summary of student level qualifications to different Aeries Analytics Analysis Items by school and grade |
DAT | Dst Analysis Thresholds | Aeries Web Only. Stores the low and high values for each Rubric level |
DAU | Data Alerts Users | Alert Recipients, Responding User and Status of Response - Read, Unread, etc. |
DAY | Calendar | Attendance Calendar – Can be DISTRICT MANAGED |
DCA | Document Archive | |
DCL | Document Access Log | Table used by Parent Data Confirmation to store a log of parent access to each document and records if they digitally confirmed the information in the document |
DCS | Documents | Table used by Parent Data Confirmation to store the basic info about each Document and the document itself |
DCV | Document Visibility | Table used by Parent Data Confirmation to store the Schools and Grades each document is visible to |
DDR | Discount Rates | |
DDS | District Data Sharing | |
DGG | District Grade Points | Stores grade points for weight factors added to District Defined GPAs. |
DGP | District GPAs | Stores District Defined GPAs. |
DGS | District GPA Schools and Cohorts | Stores Schools and Cohorts associated with each District Defined GPA |
DGW | District GPA Weight Factors | Stores weight factors added to District Defined GPAs |
DIG | Dashboard Item Groups | Aeries Web Only. Aeries Analytics Dashboard – stores which dashboard items are on each dashboard |
DIO | Dashboard Item Options | Aeries Web Only. Aeries Analytics Dashboard – stores the definition of each dashboard item |
DIP | Dashboard Item Push | Aeries Web Only. Table for Dashboard Item Push Sharing |
DIS | Discipline | Contains data for one of the two Discipline Tables – Less detail than ADS (both can be used) |
DLH | Dual Language Immersion | Contains multi-year data for student participation in Dual Language Immersion programs |
DNT | Dental | Contains history of details for Dental testing |
DOC | Student Documents | Stores any type of documentation. The table is ID based and it is not cached because of its potential big size |
DOF | Digital Offering | |
DPT | District Options Table | Stores various District Wide options and is used by various Reports and Forms |
DRA | District Resource Assign | Aeries Web Only. Contains all of the individual district resource assignments (who they’re checked out to) |
DRC | District Resource Course | Aeries Web Only. Contains information about courses each district resources applies to |
DRI | District Resource Items | Aeries Web Only. Contains all of the individual district resource copies |
DRT | District Resource Titles | Aeries Web Only. Contains information about district resources including title and other basic information |
DSD | District Supplemental | District Supplemental Student demographics (up to 150 District developed fields) |
DSP | Dispositions | For recording multiple dispositions for a specific assertive discipline offense |
DVC | Data Validation Schools | |
DVD | Data Validation Definitions | |
DVG | Data Validation Groups | |
DVR | Data Validation Results | |
DVU | Data Validation Users | |
ECA | Extracurricular Activity | Stores data to track Extracurricular Activity eligibility and participation |
ECD | Early Childhood Development | |
ECP | Extracurric Probation | Stores data to track Extracurricular Activity Probations |
EFD | Ed-Fi Data | |
EFE | Ed-Fi Entities | |
EFO | Ed-Fi Organization | |
EFR | Ed-Fi Results | |
EFS | Ed-Fi Schools | |
EML | E-Mail Log | Used to log the emails that are sent out of the Aeries system |
EMP | Employers (Work Permits) | Contains information concerning Employers for Student Work Permits – Can be DISTRICT MANAGED |
EMU | E-Mail Appropriate Use | Used to store how parents in ABI have configured their email address to be used |
ENH | Estimated New Hires | Contains Estimated New Hires information. This table is used to record the number of estimated new hires in each subject area for the following school year. This data is used for state reporting. |
ENR | Enrollment | Contains enrollment history for a student based on their Permanent ID |
EPL | Exam Performance Levels | Aeries Web Only. Define performance levels for each exam section |
ERL | Electronic Score Report Log | |
ESI | External Student ID | Stores identifying fields from 3rd party products such as Google (G Suite). |
ESN | Exam Sections | Aeries Web Only. Define sections of an exam, exam section can be tied to test part |
ESQ | Exam Section Questions | Aeries Web Only. Store exam questions that belong to an exam section |
ESR | Exam Scoring Rule | Contains grading rules for each exam question. |
ETA | Exam Testing Admin | Aeries Web Only. Define Testing Administrations of an exam. |
ETS | Exam Testing Admin Stu | Aeries Web Only. Store a snapshot of students along with their classes and teachers in an Exam Testing Admin. |
EVT | ABI Events | Stores the contents of the Event Calendar. |
EXA | Exam Response Answers | Aeries Web Only. Aeries Analytics Table for Exam Response Answers. |
EXC | Exam Question Choices | Aeries Web Only. Aeries Analytics Table for Exam Question Choices. |
EXG | Exam Passage Text Groups | Aeries Web Only. Aeries Analytics Table for Exam Passage Text Groups. |
EXH | Exam Schools | Aeries Web Only. Define which schools an exam can be given at. |
EXL | Exam Printing Log | Aeries Web Only. Aeries Analytics Table for Exam Printing Log. |
EXM | Exams | Aeries Web Only. Aeries Analytics Table for Exams. |
EXO | Exam Organization Folder | Aeries Web Only. Store folder structure of exams. |
EXP | Expulsions | Stores details for student expulsions. |
EXQ | Exam Questions | Aeries Web Only. Aeries Analytics Table for Exam Questions. |
EXR | Exam Responses | Aeries Web Only. Aeries Analytics Table for Exam Responses. |
EXS | Exam Question Standards | Aeries Web Only. Aeries Analytics Table for Exam Question Standards. |
EXT | Exam Passage Text | Aeries Web Only. Aeries Analytics Table for Exam Passage Text. |
EXV | Exam Versions | Aeries Web Only. Aeries Analytics Table for Exam Versions. |
FAP | 504 Accommodation Plans | Contains the accommodations that each 504 student needs. |
FAR | (OLD) Free and Reduced | Deprecated |
FBK | Feedback | |
FDE | 504 Disability Effects | Contains effects of the disabilities for 504 plans. |
FEC | 504 Evaluation Criteria | Contains evaluation criteria for each 504 plan. |
FEE | Fees and Fines | Contains records of Fees charged to and collected from Students |
FLF | Fixed Length Files | Contains definitions of field length files used by the Import Fixed Length Files form - Can be DISTRICT MANAGED. |
FLG | Red Flag Table | Stores the student number and specific table name flagged with a red flag indicator . |
FLI | File Location Info | File Location Information for use with the CALPADS Extracts page in Aeries Web. |
FLR | Fixed Length Rcd Layout | Contains definitions of field length record used by the Import Fixed Length Files form - Can be DISTRICT MANAGED. |
FOF | 504 Plans | Contains the details of each 504 plan. |
FPP | 504 Program Participants | Contains the basic info of individuals who participate in the 504 plan. |
FPS | Financial Payment Schedule | Aeries Web Only. Contains Payment Schedules for each student. |
FRE | Free and Reduced Meals | Contains data for Students whose parents have applied for Free or Reduced meals - Can be DISTRICT MANAGED. |
FRM | (OLD) Free and Reduced | Deprecated |
FSA | Foster Action Plans | |
FSC | Foster Legal Cases | |
FSD | 504 Student Disabilities | Contains student disabilities for each 504 plan. |
FSE | Foster Education Rights Holder | |
FSG | Foster Goals | |
FSH | Foster history | |
FSI | Foster Student Information | |
FSL | Foster Attorneys | |
FSM | Foster Meetings | |
FSN | Foster Notes | |
FSP | Foster Placements | |
FSR | Foster Hearings | |
FSS | Foster Team Contacts | |
FST | Foster Summary Report Notes | |
FTD | Financial Transaction Details | Aeries Web Only. Contains record of credits and debits for each student. |
FTF | Flexible Periods | Flex Periods used for Flex Scheduling |
FTS | Financial Transaction Summary | Aeries Web Only. Constains the current financial transaction summary for each student. |
FTT | Flexible Time Periods | Flex Period Times used for special bell schedules in Flex Scheduling |
GBA | Gradebook Assignments | Contains information about every teacher’s gradebook assignments |
GBB | Gradebook Backups | This table is used to store information about the Gradebook backups that are done |
GBC | Gradebook Scales | Used to store types of Grading Scales used by each teacher that is associated with individual Gradebook Assignments so that letter or character grades can be given instead of numeric values. |
GBD | Gradebook Standard Score | Stores the gradebook scores by standard for each assignment |
GBE | Gradebook Sections | Stores the Section or Teacher Numbers associated with an individual gradebook |
GBF | Gradebook File Linking | Store gradebook assignment’s file linking information. |
GBK | Gradebooks | Stores the different gradebooks created by the teachers |
GBL | Gradebook Access Log | Log used to track parents and/or students who view a teacher’s gradebook via Parent Portal |
GBM | Gradebook Scale Marks | Stores actual Marks used by each Gradebook Grading Scale in the GBC table. |
GBN | Gradebook Standards | Stores standards associated with each gradebook assignment. Used for the Load process from the Gradebook to Standards-Based Grade Reporting. |
GBO | Gradebook Options | Sets options for Teacher Grades |
GBR | Gradebook Terms | Stores terms associated with each gradebook. |
GBS | Gradebook Scores | Contains the scores received by students in a teacher’s gradebook |
GBT | Gradebook Assgmt Types | Contains definitions of the various assignment types by teachers |
GBU | Gradebook Students | Stores the information for students the teacher has allowed into the gradebook |
GBV | Gradebook Term Student | Stores student overall grade by term. |
GCM | Gradebook Custom Marks | Contains custom marks used with Gradebook |
GEA | Graduation Endorsement Requirements | Stores requirements for an Endorsement |
GEC | Graduation Endorsement Courses | Stores available courses per Endorsement Option |
GEO | Graduation Endorsement Options | Stores available options per Endorsement Requirement |
GEP | Graduation Endorsement Pathways | Stores pathways a student can take to achieve the Endorsements |
GES | Graduation Endorsement Students | Stores Student Endorsement Statuses |
GPA | Student GPAs | Stores student GPAs generated by District Defined GPAs. |
GPC | Grading Period Calculations | Stores definition of weighted grading er |
GPD | Grading Periods | Stores school defined data ranges for each marking period |
GRC | Grade Report Marks | Contains all the possible Grades or Marks and descriptions that might be given to a student - Can be DISTRICT MANAGED. |
GRD | Grade Reporting | Contains Grades given to Students for Grade Reporting |
GRG | Grade Reporting GPAs | Stores students Grade Reporting GPA data as calculated on recompute |
GRH | Grade Reporting History | Contains previous Grade Reporting data given to Students in the current school year |
GRO | Grade Reporting Options | Contains school and user options dealing with Grade Reporting |
GRP | Grade Reporting Printing | Contains the mark headings and descriptions to be printed on a report card and any messages |
GRS | Secondary Standards | Contains Standards Based Grades given to Secondary Students |
GSS | Grading Snapshots | Contains Gradebook overall grade information for a point in time. |
GTC | GATE Stu Characteristics | Stores student characteristics that triggered a particular GATE Referral. |
GTE | GATE | Stores main GATE information about a student. |
GTG | Gradebook To Grades | Defines percent range for each mark for Gradebook to Grades for Report Cards |
GTN | GATE Stu Notes | Stores various notes about a GATE Referral. |
GTR | GATE Stu Referrals | Stores information about each referral to the GATE program that has been made for a student. |
GTS | Gradebook Transfer Score | Stores the default grade that a student earned from the previous teacher. |
GTT | GATE Stu Tests | Stores information about tests administered to students pending GATE qualification. |
HIS | Course History | History of Grades given to a student, including those from other schools – Transcript Data |
HRN | Hearing | Contains history of details of Hearing Tests |
HSE | Healthy Start Events | Contains records of Healthy Start Program Services Rendered |
HWO | Height Weight Other | Contains history of details of Height and Weight of Student |
ICL | Information Confirmation | Table used by Parent Data Confirmation to store what and when data is confirmed by the parent. |
IDN | ID Number | Contains Permanent ID and other basic student information |
IMB | Immunizations Boosters | Stores student immunizations boosters (COVID-19) |
IMC | Instructional Minutes Certification | Used for weekly Teacher certification of instructional minutes |
IMM | Immunizations | Contains history of Immunizations for Student |
INA | Intervention Actions | Stores Actions for each Intervention Goal |
INC | Intervention Comments | Contains detailed information on the progress the student is making towards the established goals |
ING | Intervention Goals | Contains details regarding the intervention goals set for a student |
INM | Intervention Meetings | Contains meeting information (comments, attendees, etc.) regarding the student intervention |
INP | Intervention Practices | Contains instructional practices or strategies defined for the student and intervention |
INR | Intervention Resources | Stores Resources for each Intervention. |
INS | Intervention Stakeholder | Stores Stakeholders for each Intervention. |
INV | Interventions | Contains details of Intervention Actions taken |
IPI | Intervention Prior Inv | Stores Prior Interventions for each Intervention. |
IPR | Institution Programs | Stores the programs that the district offers. (CSIS use ONLY). - Can be DISTRICT MANAGED. |
IRC | Intervention Reasons | Stores Reasons and Concerns for each Intervention. |
ISA | Independent Study Agreements | Stores Independent Study Agreement records for a student. |
ISG | Independent Study Signatures | Stores Independent Study Agreement signatures for agreements. |
ISP | Internship | Stores product work hours for Independent Study agreements. |
ISS | Intervention Student Str | Stores Student Strengths for each Intervention. |
ISW | Independent Study Production Work Hours | |
IVS | Internship Visits | |
LAC | Language Assessment | Contains info about ESL students as well a stores info about initial tests taken by the student – Can be DISTRICT MANAGED. |
LAF | Lang Assess FLOSEM | Contains a test history of Oral Language Assessments test taken by the student – Can be DISTRICT MANAGED. |
LAS | Lang Assess Scores | Contains a test history of Language Assessments test taken by the student – Can be DISTRICT MANAGED. |
LCN | School Contacts | |
LEA | Letter Table Audit | Stores Attendance data relating to a student’s Letter |
LEC | Letter Table Codes | Stores which Absence Codes (ABS) count towards each Letter in LET – Can be DISTRICT MANAGED. |
LET | Letter Table | Stores Letter data (similar to existing LTR table) – Can be DISTRICT MANAGED. |
LGD | Log Details | Logs student detail changes specifically for CALPADS reporting. |
LKR | Lockers | Contains information about all the lockers in the school |
LNC | Lunch Count Data | Utilized through Teacher Portal to report the daily lunch count to the office |
LNK | ABI Links | Stores the URLs for the Online Resource Center |
LOC | Location data | Names, Addresses, and Function variables of schools within the District – Can be DISTRICT MANAGED. |
LOG | LOG | Records critical changes made to specific data by the users |
LSI | Legal Student Info | Contains student legal name and gender data |
LTA | Letter Table Audit | Stores Attendance data from CAT table for use with Flex Scheduling. Similiar to LEA. |
LTL | Letter Log | Logs the Letter Type, Student, Date and User who created Letters. |
LTR | Query Letters | Contains the contents of all letter texts available through Aeries |
MDF | Multi Data Profile Field | Stores Multi Data Profiles Fields to be included |
MDL | Multi Data Profile Color | Stores Multi Data Profiles layout colors |
MDP | Multi Data Profile Opt | Stores Multi Data Profiles basic information |
MED | Medical Data | Contains records of daily visits to the medical office |
MHS | Medical History | History of Major Medical concerns |
MII | Medical Insurance Info | Contains history of details for Medical Insurance |
MLG | Medication Log | Logs the dates and times medications are administered to a student |
MLM | Medications | Contains history of details of Medications |
MNO | Medical Notes | Contains confidential medical data regarding a student that is usually entered by nurses |
MSS | Master Schedule Settings | Contains Master Schedule Settings for use with Google Classrooms. |
MST | Master Schedule | Master Schedule |
NAT | Notification and Alert Thresholds | Stores data thresholds which will trigger alerts / notifications to be sent. |
NWS | News Events | Stores Schools and District News Articles. |
OAT | Oauth | |
OBC | Observation Codes | |
OBJ | Test Objectives | Test objectives for “Teacher Made Test” – Can be DISTRICT MANAGED. |
OBS | Observations | |
ODC | Other District Courses | This table is used to match incoming courses from Records Transfer with local courses. |
ODE | Other District Enroll | Used to track student enrollment outside of your district |
ODR | Digital Store Order | |
OGC | Off Grade Courses | Stores courses taken outside the normal grade range that could be in a student’s Course History and should be counted as a regular course |
OHI | Digital Store Order History | |
OPT | Options Table | Used by reports and Forms – School wide options which ADD to Variables |
OMT | Other Medical Tests | Stores additional medical tests, including COVID-19 tests. |
PAO | Portal Account Options | Contains Portal Account Options for use with Google Classrooms. |
PAY | Payments | Record of payments made through the Billing process |
PCT | CELDT Test Pre ID | Contains data for export for CELDT Pre ID - Can be DISTRICT MANAGED. |
PDR | Parent Document Requests | Holds the Document Requests |
PDT | Parent Document Translations | Holds the Translations by CL for Document Requests |
PEI | Pre-Enrollment Information | |
PFS | Physical Fitness Setup | Stores specific Tests selected by administrators to be performed at the school level. |
PFT | Physical Fitness | Contains results of Physical Performance Testing |
PGM | Special Program Details | Contains details of Special Programs in which students are participating |
PGR | Programming Screening | |
PGS | Program Services | |
PHE | CAHSEE Test Pre ID | Contains data for export for CAHSEE Pre ID – Can be DISTRICT MANAGED |
PHL | Portal Usage Log | Stores username, school, student id, date, and page information accessed by parents or students through the Parent Portal, Mobile Portal app, Aeries Student app or other vendor Student apps. |
PIC | Student Pictures | Stores student pictures. The table is ID based and it is not cached because of its potential big size. |
PNP | Parent Notification Pref | Aeries Web Only. Contains information about when parents want to receive Weekly Notification Emails. |
POP | Portal Options | Stores various options for the Teacher, Parent and Student Portals. |
PRC | PreRef Inv Codes | Stores Pre-Referral Intervention Codes. |
PRD | Parent Response Data | Stores parent response data for Housing Questionnaire |
PRE | Texas Assessment Precode Accommodations (before 2013 was STAR Test Pre ID) | Stores Texas Assessment Precode file data. |
PRESTAR | STAR Test Pre ID | Data previously stored in PRE table (Before 2013, PRE was used to contains data from variety of sources to create a Pre ID file for export to STAR). |
PRI | PreReferral Intervention | Stores Pre-Referral Interventions for each student. |
PRN | PreReferral Intervention | Stores Meetings and Contacts for each Pre-Referral Intervention. |
PRR | PreRef Inv Reasons | Stores Reasons and Concerns for each Pre-Referral Intervention. |
PRS | Parent Survey Response | Stores parent responses to survey items. |
PRT | Printer Margin Offsets | Provides alignment of printer to output a variety of reports on preprinted forms |
PSA | SABE Test Pre ID | Contains data for export for SABE Pre ID – Can be DISTRICT MANAGED |
PSB | Smarter Balanced Pre-ID | Contains data for export for Smarter Balanced Pre ID - Can be DISTRICT MANAGED. |
PSD | Payment Schedule Dates | Contains Payment Schedules for Billing |
PSS | Postsecondary Survey Results | Contains postsecondary survey results from students 6-12 months after their High School Completion |
PST | Payment Schedule Types | Defines the Payment Schedules available for Billing |
PWA | Parent Web Accounts | Parent and Student Account Management System stores accounts in this table. This table is not modified through Aeries because the system is self-managing – Can be DISTRICT MANAGED. |
PWS | Parent Accounts - Stus | Stores the students that can be seen by each PWA account. Student numbers are stored by Permanent ID Number. This table is global in AeriesCS – Can be DISTRICT MANAGED |
QRY | Query Statements | Storage of many QUERY statements for use by all users |
RAL | Record Access Log | Record of those who have accessed the student data, cumulative record or test scores |
RCH | Report Card History | Aeries Web Only. Contains a running history of report cards that have been created at the end of each marking period. |
REL | Religion | Contains Religious information |
REQ | Graduation Requirements | Maintains graduation requirements – Can be DISTRICT MANAGED. |
RET | Retentions | Record of Retention actions, whether retention occurred or was set aside and for what reason |
RFI | Referral for Inv | Stores Referrals for Intervention for each student. |
RFP | Referral for Inv Prior | Stores Prior Interventions for each Referral for Intervention. |
RFR | Referral for Inv Reasons | Stores Reasons and Concerns for each Referral for Intervention. |
RFS | Referral for Inv Stu Str | Stores Student Strengths for each Referral for Intervention. |
RHS | Report History | Logs reports run in Aeries Web |
RJN | Rejoinders | This table is used to log parent's protest to data retained in any student record (e.g., parent letter of protest to student's records) in accordance with California Ed. Code 49070(d) and 49072. |
ROL | Rollover Settings | Aeries Web Only. Stores settings used by the New Year Rollover process |
RPP | Report Printing Packets | Stores definitions of Reports to be printed in packets for various reasons |
RRI | Records Request Items | |
RRQ | Records Requests | |
RT_CHI | Records Transfer Course History Institutions | This is a records transfer holding table. It is used to store a copy of incoming CHI data before it's imported. |
RT_CST | Records Transfer Content Standards Scores | This is a records transfer holding table. It is used to store a copy of incoming CST data before it's imported. |
RT_CTS | Records Transfer College Test Scores | This is a records transfer holding table. It is used to store a copy of incoming CTS data before it's imported. |
RT_HIS | Records Transfer Course History | This is a records transfer holding table. It is used to store a copy of incoming HIS data before it's imported. |
RT_TST | Records Transfer Testing Data | This is a records transfer holding table. It is used to store a copy of incoming TST data before it's imported. |
RTG | Report Tags | |
RTM | Records Transfer Messages | Stores system and user messages specific to a records transfer (RTR or RTO) record. |
RTO | Records Transfer Outbound Requests | Stores data regarding student records which were requested from another school district. |
RTR | Records Transfer Inbound Requests | Stores data regarding student records which are being requested by another school district. |
RUN | Run Timed Procedures | Set of procedures that can be run at night to expedite use of the program during the day |
RVM | Rubric Value Marks | |
RVT | Rubric Value Types | |
SAA | Summer Alternate Course Request Assoc. | |
SAB | Summer Alternate Course Req. Backup | |
SAD | Student Assess Def | Contains Performance Indicators against which student success is measured |
SAG | Student Assess Grades | Stores Student Assessment Definition levels by grade |
SAP | Student Assess Perf | Contains the actual Performance Indicator Scores each student – NEW 5 Levels |
SAR | Summer Alternate Course Requests | |
SAS | (OLD) Stu Assess Setup | |
SAT | (OLD) SAT/ACT Scores | |
SAV | Save File for SEC | Contains Student Schedule Changes for use by the Add/Drop Report |
SBC | Standards-Based Comments | Contains Comments that are given at grading time to an Elementary student |
SBD | Standards-Based Details | Stores Standards-Based Template Details. |
SBE | Standards-Based Setup | Contains the Categories and Standards selected for Elementary report cards – Can be DISTRICT MANAGED |
SBG | Standards-Based Grades | Contains Grades given to Elementary Students |
SBH | Standards-Based History | History of Grades given to Elementary Students |
SBR | Standards-Based Courses | Stores a link between Courses (CRS) and Standards (STN) |
SBS | Standards-Based Template | Stores Standards-Based Templates. |
SBU | Scheduling Backups | This is a key to each backup table (i.e. backup title, date, sequence). Aeries Web only at this time. |
SBV | Standards-Based Marks | Contains all possible Grades or Marks and descriptions that might be given to Elementary students – Can be DISTRICT MANAGED |
SCD | School of Choice Decisions | |
SCG | School Groups | School Group School assignments |
SCH | Seating Chart Table | |
SCN | School of Choice Request Notes | |
SCO | Scoliosis | Contains history of details of Scoliosis Tests |
SCP | Scrip Purchases | Contains Student Scrip Purchases |
SCR | School of Choice Requests | |
SDT | Seating Chart Details | |
SEC | Student Classes | Relationships of Student Numbers to Master Schedule section numbers – Student Schedules |
SED | Scheduling Exclusions | |
SFL | Student Files | Student File Storage |
SGA | Student Group Analytics | |
SGD | Student Group Definition | Stores the definition of Student Groups |
SGM | Student Group Members | Stores the Students assigned to each Student Group |
SGS | Student Group Staff | Stores the Staff assigned to each Student Group |
SKT | Skills Type | |
SLA | Service Learning Areas | |
SLD | Service Learning Data | Aeries Web Only. Contains the specific Service Learning Requirements and Service Learning Hours Completed for each student for each grade level. |
SLH | Service Learning Hours | |
SLI | Service Learning Log Img | Aeries Web Only. Contains images and other documents related to each Service Learning Log (SLL) record. |
SLL | Service Learning Log | Aeries Web Only. Contains a log of Service Learning Hours worked by students for specific organizations. Records and pending approval until school personnel approve them. |
SLO | Service Learning Orgs | Aeries Web Only. Contains information about organizations that students can donate their time to for building Service Learning Hours. |
SLQ | Service Learning Org. Areas | |
SLR | Service Lrning Recipient | Aeries Web Only. Contains detailed information about specific organizations that students are donating their time to. Some records may be pending approval by school personnel or be linked to pre-approved organizations in the SLO table. |
SMB | Sched Master Sched Bkup | This table is exactly like SMS, only stores multiple sets of SMS data based on the # of backups made. Aeries Web only at this time. |
SMS | Sched Master Sched | The Master Schedule for the next semester or year – for planning purposes – Scheduling |
SOC | Susp Offense Codes | Retains specific data, usually Ed Code, which assist in determination of specific Suspension Action – Can be DISTRICT MANAGED |
SPC | Staff Pictures | Stores Staff pictures |
SPP | Student Program Participation | Contains Program Participation for each Student to provide for dis-aggregation of data |
SPR | School Programs | Contains details of Special Programs in which all students at a school are participating |
SPS | Student Program Setup | Defines which programs are to be used for dis-aggregation of data |
SPT | System Performance Test | Aeries Web Only. This table is used by back-end processes in Aeries Web to determine if the system is performing effectively. |
SRB | Summer Requests Backup | |
SRD | Synchronization Review Date | |
SSA | Summer School Availability | |
SSB | Student Scheduling Bkup | This table is exactly like SSS, only stores multiple sets of SSS data based on the # of backups made. Aeries Web only at this time. |
SSC | Summer School Courses | |
SSD | Secondary Student Data | Contains additional Student Data |
SSE | Staff Sections | Contains Staff records assigned to Master Schedule sections |
SSM | Staff-Scheduling Master | Contains Staff records assigned to Scheduling Master Schedule sections |
SSP | SAML Service Providers | |
SSO | Single Sign On | Aeries Web Only. Contains temporary information for facilitating Single-Sign-On capabilities with 3rd party systems. |
SSR | Summer School Course Requests | |
SSS | Student Scheduling | Contains Students Schedules for the next semester or year – for planning purposes. |
SST | Summer School Terms | |
SSU | Staff-Scheduling Master Backup | Stores multiple sets of Staff Section data from SSM based on the number of backups made. |
STA | Staff Assignments | Contains required information about the current assignments of staff members for State Reporting – Can be DISTRICT MANAGED |
STAR | STAR Test Results | Raw test scores imported from the STAR CD |
STC | Staff Credentials | Contains required information about the current credentials of staff members for State Reporting – Can be DISTRICT MANAGED |
STE | Staff Raw Credentials | Stores imported credential data from standard CTC file layout distributed to counties and districts |
STF | Staff | Contains CBEDS required demographic information about current staff members for State Reporting |
STG | Seating | Contains seating chart information – used by Attendance by Photograph in the Teacher Portal |
STH | Staff Highly Qualified | Stores the Highly Qualified Status for particular NCLB Core Areas for each staff member |
STJ | Staff Job Assignments | Contains job classifications and assignments for each staff member. |
STN | Standards | Contains all possible Categories and Standards that can be printed on a report card |
STO | Scrip Stores | Contains Information regarding Stores from which Students can purchase items using scrip |
STP | Scrip Store Percentages | Contains Percentages of purchases |
STR | Street table | Data of all streets, including from-to numbers to determine school of residence and next school |
STS | State Test Settings | Stores State Test Settings. |
STU | Student Data | Student demographics |
SUP | Supplemental | Supplemental Student demographics (up to 150 District developed fields) |
SWL | Scheduling Master Schedule Wait List | |
TAA | Teacher Stu Assoc Area | Aeries Web Only. Used by the Aeries Web Teacher Portal to store the ways a teacher is associated with students. This information is populated every time a teacher logs in to Aeries Web. |
TAD | Testing Administrations | Stores Testing Administration settings. |
TBC | Textbook Copies | Contains all of the individual textbook copies and their assignment (who they’re checked out to) |
TBL | Tables to Update | Aeries Client Only. The tables to update during Update District Database |
TBO | Textbook Options | Contains options about scanning and hand-entry of textbook assignment data |
TBT | Textbook Titles | Contains information about textbook titles including total copies and replacement costs |
TCH | Teachers | Contains basic information about Teachers |
TDF | Transcript Definition | Defines the content of the District’s Transcripts |
TEX | Testing Exceptions | Contains accommodations, modifications and info as to why a student missed a scheduled test |
TFL | Teacher Files | Aeries Web Only. Contains the files uploaded by teachers to link with Aeries Web Gradebook Assignments. |
TFR | Table-Field Rules | Defines which fields and drop downs on a form are required. |
TKN | Token | Store the token for the upcoming new Aeries Student app. |
TNP | Testing Number Possible | Stores specific Test ID’s and the total number that is possible for each part. |
TPE | Third Party Extracts | |
TPN | Third Party Names | Stores Third Party Names. |
TPO | Third Party Vendor Options | Stores Third Party Options) for use with Aeries APIs |
TPP | Third Party Permissions | Stores Third Party Permissions. |
TPS | Testing Pass Status | Stores calculated status for Algebra I, CAHSEE, and Physical Fitness |
TRM | Terms | Define school terms |
TSA | Teacher Stu Assoc | Aeries Web Only. Used by the Aeries Web Teacher Portal to store which students are linked to a teacher and how. This table is associated with the TAA table and is populated dynamically when a teacher logs in to Aeries Web. |
TSD | Teacher Standards | Stores teacher defined standards by class. |
TSI | Temporary Student Information | |
TSO | Teacher Standard Options | Stores standard grading options by teacher and class. |
TST | Testing data | Contains a history of State and Local standardized test scores |
TTC | Tables To Copy | Contains a list of tables to copy when transferring a student between schools |
TTM | Transcript Terms | Stores starting and ending dates for terms defined in HIS for all previous years. CSIS use ONLY. |
TTP | Things to Print (Trans) | Defines which Test Scores, Activities, Immunizations, Student fields etc. are to print on Transcripts |
TXT | Query Letter Text | Stores letters developed in the QUERY Letter Text Editor, some of which can be District Standard |
UAO | User Account Options | Contains User Account Options for use with Google Classrooms. |
UCE | UC ELC Extract | |
UGA | User and Group Assoc | Aeries Web security table to store User and Group Memberships. |
UGC | User/Group Codes | Aeries Web security table for code-based security. Currently used only in specific areas of the system such as Financials. |
UGN | User and Group Names | Aeries Web security table to store information about Users and Groups. |
UGP | User and Group Perm | Aeries Web security table to store permissions granted to Users and Groups. |
USO | User Options | Stores various options for individual users that need to be associated with an individual database |
USR | User Limitation (CS) | Aeries Client Only. Stores permissions for the different users to access various schools. |
UTZ | Utilization | System Check and Aerie |
VAC | Vaccination Requirements | Utilized to update required immunizations for the current state requirements. |
VER | Verification | Contains the sheet numbers of absence verification sheets printed |
VIC | Victims | Store information for Victims of harassment or any other offenses |
VIS | Visitation | Contains detail for one of the two Counselor Tables - Less detail than CNF (both can be used) |
VND | Vendors | Vendors for the Textbooks |
VSN | Vision | Contains history of details of Vision Tests |
WEB | WEB Users | Contains information about the valid users of ABI - Not used for Aeries Web |
WGM | Web Global Messages | Contains global messages displayed to users |
WIA | What if Assignments | Contains the assignment scores for the What If feature available in the Aeries Student app |
WIG | What if Grades | Contains the student ID, gradebook number, gradebook term and other settings for the What If feature available in the Aeries Student app |
WIH | What if History | Contains score goals and other settings for the What If feature available in the Aeries Student app |
WIT | Witness | Store information for Witnesses of harassment or any other offenses |
WPT | Work Permits | Record of Work Permits issued to Students |
WPV | Work Permit Visitations | Aeries Web Only. Contains information about visits to work places by CTE/ROP teachers when students are interning at places of employment. |
WRL | WRL Log | |
XRF | Cross Reference | Tool for District to match criteria required by Testing Pre-IDs and location of data in AERIES |
YTD | Year to Date Attendance | Contains Student Attendance data from the beginning of school to the current date |