This article contains a listing of all tables and a brief description of their use in Aeries.


Table CodeTable nameTable Description
ABSAbsence CodesCodes used for recording absences
ACLAttendance Create LogMaintains a log of when and where new PAC files and DAC tables are created
ACTActivities and AwardsRecording Activities in which student participates, and Awards received by student
ADHAddress HistoryStores a history of student address changes
ADRName and AddressFor recording Names and Addresses of Staff, Site Council, PTA, etc.
ADSAssertive DisciplineContains data for one of the two Discipline Tables – More details than DIS (both can be used)
AHCAttendance Hist CodesStores a history of absence code descriptions
AHDAttendance Hist DetailsStores a detailed history of student attendance counts by code, period and year
AHSAttendance Hist SummaryStores a summary of student enrollment, present, absent and tardy counts by year
ANAAttendance Notify CodesStores Attendance Notification Codes.
ANCAttendance Notify ConfigStores Attendance Notification Configuration.
ANLAttendance Notify LogStores Attendance Notification Log.
ANSAttendance Notify SchlsStores Attendance Notification Schools.
APCAcademic Plan Crs ReqStores a student’s current academic plan
APLAcademic Plan LogMaintains a record of any change done to a student’s academic plan.
ARDAttendance Rptg Data
ARPAttendance Rptg Periods
ASLTch Att Submission LogMaintains a record when teachers submit attendance through Teacher Portal -Generates Missing Sheet Log
ATASupp Att AssignmentsRelationships of Student Numbers to Supplemental Attendance Session numbers
ATCSupp Att CalendarDays that a Supplemental Attendance Session meets
ATDSupp Att DataSupplemental Attendance tracking includes times in and out and total minutes by student
ATLAttendance LogMaintains a record of when changes are made to student attendance
ATNAttendance NotesFor recording specific details for a particular student and date.
ATPSupp Att ProgramsContains details of Supplemental Attendance Programs offered
ATRSupp Att StaffRelationships of Staff IDs to Supplemental Attendance Session numbers
ATSSupp Att SessionsContains details of Supplemental Attendance Sessions offered
ATTAttendance DataMaintains Dates of Enrollment, Absences and Absence Reasons, and Un-enrollment
AUTAuthorizationsSpecific authorizations or prohibitions to student participation in specific programs
BELBell ScheduleBell Schedule for Secondary Schools, including Continuation or Alternative Schools
BERBehavioral Emergency RepTracks Mechanical Restriction, Physical Restriction, and Seclusion for Civil Rights Data Collection.
BILBillingFor tuition billing of students – more detailed than the FEE table
BSDBell Schedule DefinitionProvides for a variety of Bell Schedules which can be assigned to the Calendar
BSTBell Schedule TimesContains data from Bell Scheduler
CARCourse AttendanceRecords changes in students’ class schedules so attendance can be tracked at the course level
CCCCollege Course Credit
CCPCourse Career PathwaysStores Career Pathways specific to each Course.
CDCCourse DocumentsAeries Web Only.  Contains documents specific to each Course.
CERCollege Entrance ReqsStores College Entrance Requirements for each student.
CHICrs History InstitutionsNames / Addresses of Districts & Schools outside the current district used by various drop-downs, such as Transcripts
CNFConferenceContains detail for one of the two Counselor Tables - More details than VIS (both can be used)
CODCode TableContains CODES for Multiple Tables
COLCollegesNames and Addresses of Colleges – Can be DISTRICT MANAGED.
CONContactsRecords of people to be contacted in case of emergency 
CPECareer Pathway ExpStores Career Pathways Experiences for each student.
CPHCareer Pathway HistoryStores Career Pathways History for each student.
CPOCareer Pathway OutcomesStores Career Pathways Outcomes for each student.
CPRCourse PrerequisitesThis table is in the Aeries SQL database for a planned future enhancement to Aeries to implement Course Requests
CPWCareer PathwaysStores Career Pathways details for each student.
CRACustom Report AccessContains which security groups can view each custom report.
CRCCustom Report ConfigStores the definition of each custom report.
CRDCourse Request DefsContains codes used to setup course request packets
CRFCourse FeesAeries Web Only.  Contains fee information specific to each Course.
CRGCustom Report GroupsStores which custom report items are on each custom report.
CRICustom Report ItemsStores the definition of each custom report item.
CRLCustom Report LayoutContains descriptions and colors for each of the 5 test levels.
CRPCourse Request PacketsContains the courses setup within the course request packets
CRQCourse RequestsContains the list of courses offered to students in different grade levels during scheduling
CRSCoursesContains details of Courses offered at a Secondary School
CRTCollege Requests TableStores transcript requests from Colleges
CSASpecial Ed Alt AssessCASEMIS Alternate Assessment Data – Can be DISTRICT MANAGED
CSDSpecial Ed ServicesCASEMIS Disability Services – Can be DISTRICT MANAGED
CSECalif Spec EducationCASEMIS Demographic Information – Can be DISTRICT MANAGED
CSISpecial Ed Infant DataCASEMIS Infant Services data – Can be DISTRICT MANAGED
CSNContent Standard NamesContains descriptions of Content Standards Tests and Test Parts populated when loading STAR – Can be DISTRICT MANAGED
CSQCourse Sequence
CSSSpecial Ed SuspensionsCASEMIS Student Suspensions  – Can be DISTRICT MANAGED
CSTContent Cluster ScoresStores the Content Standard Scores that are loaded from STAR
CSVSpecial Ed ServicesCASEMIS Student Services data  – Can be DISTRICT MANAGED
CTDCustom Table DefinitionsThese 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
CTECareer Tech EducationCareer Technical Education, used by CALPADS. The information in this table is visible from the Students form, Student Secondary Data tab
CTFCustom Table FieldsThese 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
CTLTest ControlContains descriptions of Tests and Test Parts  – Can be DISTRICT MANAGED
CTSCollege Test ScoresTest Scores to be included on College Transcripts
DACDaily sheetsCreated by Daily Attendance when Sheets are created
DAGDst Analysis Stu Sub GrpAeries Web Only.  Define sub groups for district analysis indicators
DAIDst Analysis IndicatorAeries Web Only.  Stores Analysis Indicator Definitions for Aeries Analytics
DALDst Analysis LevelsAeries Web Only.  Table stores the titles, codes, and colors for each of the 1 rubric levels
DAQDst Analysis QualifAeries Web Only.  Stores the qualifying level of each student for each Aeries Analytics Analysis Item
DASDst Analysis SummaryAeries Web Only.  Stores a summary of student level qualifications to different Aeries Analytics Analysis Items by school and grade
DATDst Analysis ThresholdsAeries Web Only.  Stores the low and high values for each Rubric level
DAYCalendarAttendance Calendar  – Can be DISTRICT MANAGED
DCLDocument Access LogTable 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
DCSDocumentsTable used by Parent Data Confirmation to store the basic info about each Document and the document itself
DCVDocument VisibilityTable used by Parent Data Confirmation to store the Schools and Grades each document is visible to
DDS 
DIGDashboard Item GroupsAeries Web Only.  Aeries Analytics Dashboard – stores which dashboard items are on each dashboard
DIODashboard Item OptionsAeries Web Only.  Aeries Analytics Dashboard – stores the definition of each dashboard item
DIPDashboard Item PushAeries Web Only.  Table for Dashboard Item Push Sharing
DISDisciplineContains data for one of the two Discipline Tables – Less detail than ADS (both can be used)
DNTDentalContains history of details for Dental testing
DOCStudent DocumentsStores any type of documentation. The table is ID based and it is not cached because of its potential big size
DPTDistrict Options TableStores various District Wide options and is used by various Reports and Forms
DRADistrict Resource AssignAeries Web Only.  Contains all of the individual district resource assignments (who they’re checked out to)
DRCDistrict Resource CourseAeries Web Only.  Contains information about courses each district resources applies to
DRIDistrict Resource ItemsAeries Web Only.  Contains all of the individual district resource copies
DRTDistrict Resource TitlesAeries Web Only.  Contains information about district resources including title and other basic information
DSDDistrict SupplementalDistrict Supplemental Student demographics (up to 150 District developed fields)
DSPDispositionsFor recording multiple dispositions for a specific assertive discipline offense
ECAExtracurricular ActivityStores data to track Extracurricular Activity eligibility and participation
ECPExtracurric ProbationStores data to track Extracurricular Activity Probations
EMLE-Mail LogUsed to log the emails that are sent out of the Aeries system
EMPEmployers (Work Permits)Contains information concerning Employers for Student Work Permits  – Can be DISTRICT MANAGED
EMUE-Mail Appropriate UseUsed to store how parents in ABI have configured their email address to be used
ENHEstimated New HiresContains 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.
ENREnrollmentContains enrollment history for a student based on their Permanent ID
EPLExam Performance LevelsAeries Web Only.  Define performance levels for each exam section
ESIExternal Student IDStores identifying fields from 3rd party products such as Google (G Suite).
ESNExam SectionsAeries Web Only.  Define sections of an exam, exam section can be tied to test part
ESQExam Section QuestionsAeries Web Only.  Store exam questions that belong to an exam section
ESRExam Scoring RuleContains grading rules for each exam question.
ETAExam Testing AdminAeries Web Only.  Define Testing Administrations of an exam.
ETSExam Testing Admin StuAeries Web Only.  Store a snapshot of students along with their classes and teachers in an Exam Testing Admin.
EVTABI EventsStores the contents of the Event Calendar.
EXAExam Response AnswersAeries Web Only.  Aeries Analytics Table for Exam Response Answers.
EXCExam Question ChoicesAeries Web Only.  Aeries Analytics Table for Exam Question Choices.
EXGExam Passage Text GroupsAeries Web Only.  Aeries Analytics Table for Exam Passage Text Groups.
EXHExam SchoolsAeries Web Only.  Define which schools an exam can be given at.
EXLExam Printing LogAeries Web Only.  Aeries Analytics Table for Exam Printing Log.
EXMExamsAeries Web Only.  Aeries Analytics Table for Exams.
EXOExam Organization FolderAeries Web Only.  Store folder structure of exams.
EXPExpulsionsStores details for student expulsions.
EXQExam QuestionsAeries Web Only.  Aeries Analytics Table for Exam Questions.
EXRExam ResponsesAeries Web Only.  Aeries Analytics Table for Exam Responses.
EXSExam Question StandardsAeries Web Only.  Aeries Analytics Table for Exam Question Standards.
EXTExam Passage TextAeries Web Only.  Aeries Analytics Table for Exam Passage Text.
EXVExam VersionsAeries Web Only.  Aeries Analytics Table for Exam Versions.
FAP504 Accommodation PlansContains the accommodations that each 504 student needs.
FAR(OLD) Free and ReducedContains data for Students whose parents have applied for Free or Reduced meals - Can be DISTRICT MANAGED.
FDE504 Disability EffectsContains effects of the disabilities for 504 plans.
FEC504 Evaluation CriteriaContains evaluation criteria for each 504 plan.
FEEFees and FinesContains records of Fees charged to and collected from Students
FLFFixed Length FilesContains definitions of field length files used by the Import Fixed Length Files form - Can be DISTRICT MANAGED.
FLGRed Flag TableStores the student number and specific table name flagged with a red flag indicator .
FLIFile Location InfoFile Location Information for use with the CALPADS Extracts page in Aeries Web.
FLRFixed Length Rcd LayoutContains definitions of field length record used by the Import Fixed Length Files form - Can be DISTRICT MANAGED.
FOF504 PlansContains the details of each 504 plan.
FPP504 Program ParticipantsContains the basic info of individuals who participate in the 504 plan.
FPSFinancial Payment ScheduleAeries Web Only.  Contains Payment Schedules for each student.
FREFree and Reduced MealsContains data for Students whose parents have applied for Free or Reduced meals - Can be DISTRICT MANAGED.
FRM(OLD) Free and ReducedContains data for Students whose parents have applied for Free or Reduced meals.
FSD504 Student DisabilitiesContains student disabilities for each 504 plan.
FTDFinancial Transaction DetailsAeries Web Only.  Contains record of credits and debits for each student.
FTSFinancial Transaction SummaryAeries Web Only.  Constains the current financial transaction summary for each student.
GBAGradebook AssignmentsContains information about every teacher’s gradebook assignments
GBBGradebook BackupsThis table is used to store information about the Gradebook backups that are done
GBCGradebook ScalesUsed 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.
GBDGradebook Standard ScoreStores the gradebook scores by standard for each assignment
GBEGradebook SectionsStores the Section or Teacher Numbers associated with an individual gradebook
GBFGradebook File LinkingStore gradebook assignment’s file linking information.
GBKGradebooksStores the different gradebooks created by the teachers
GBLGradebook Access LogLog used to track parents and/or students who view a teacher’s gradebook via Parent Portal
GBMGradebook Scale MarksStores actual Marks used by each Gradebook Grading Scale in the GBC table.
GBNGradebook StandardsStores standards associated with each gradebook assignment.  Used for the Load process from the Gradebook to Standards-Based Grade Reporting.
GBOGradebook OptionsSets options for Teacher Grades
GBRGradebook TermsStores terms associated with each gradebook.
GBSGradebook ScoresContains the scores received by students in a teacher’s gradebook
GBTGradebook Assgmt TypesContains definitions of the various assignment types by teachers
GBUGradebook StudentsStores the information for students the teacher has allowed into the gradebook
GBVGradebook Term StudentStores student overall grade by term.
GRCGrade Report MarksContains all the possible Grades or Marks and descriptions that might be given to a student - Can be DISTRICT MANAGED.
GRDGrade ReportingContains Grades given to Students for Grade Reporting
GRGGrade Reporting GPAsStores students Grade Reporting GPA data as calculated on recompute
GRHGrade Reporting HistoryContains previous Grade Reporting data given to Students in the current school year 
GROGrade Reporting OptionsContains school and user options dealing with Grade Reporting
GRPGrade Reporting PrintingContains the mark headings and descriptions to be printed on a report card and any messages
GRSSecondary StandardsContains Standards Based Grades given to Secondary Students
GTCGATE Stu CharacteristicsStores student characteristics that triggered a particular GATE Referral.
GTEGATEStores main GATE information about a student.
GTGGradebook To GradesDefines percent range for each mark for Gradebook to Grades for Report Cards
GTNGATE Stu NotesStores various notes about a GATE Referral.
GTRGATE Stu ReferralsStores information about each referral to the GATE program that has been made for a student.
GTSGradebook Transfer ScoreStores the default grade that a student earned from the previous teacher.
GTTGATE Stu TestsStores information about tests administered to students pending GATE qualification.
HISCourse HistoryHistory of Grades given to a student, including those from other schools – Transcript Data
HRNHearingContains history of details of Hearing Tests
HSEHealthy Start EventsContains records of Healthy Start Program Services Rendered
HWOHeight Weight OtherContains history of details of Height and Weight of Student
ICLInformation ConfirmationTable used by Parent Data Confirmation to store what and when data is confirmed by the parent.
IDNID NumberContains Permanent ID and other basic student information
IMMImmunizationsContains history of Immunizations for Student
INAIntervention ActionsStores Actions for each Intervention Goal.
INCIntervention CommentsContains detailed information on the progress the student is making towards the established goals
INGIntervention GoalsContains details regarding the intervention goals set for a student
INMIntervention MeetingsContains meeting information (comments, attendees, etc.) regarding the student intervention
INPIntervention PracticesContains instructional practices or strategies defined for the student and intervention
INRIntervention ResourcesStores Resources for each Intervention.
INSIntervention StakeholderStores Stakeholders for each Intervention.
INVInterventionsContains details of Intervention Actions taken
IPIIntervention Prior InvStores Prior Interventions for each Intervention.
IPRInstitution ProgramsStores the programs that the district offers.  (CSIS use ONLY).  - Can be DISTRICT MANAGED.  
IRCIntervention ReasonsStores Reasons and Concerns for each Intervention.
ISPInternship
ISSIntervention Student StrStores Student Strengths for each Intervention.
IVSInternship Visits
LACLanguage AssessmentContains info about ESL students as well a stores info about initial tests taken by the student – Can be DISTRICT MANAGED. 
LAFLang Assess FLOSEMContains a test history of Oral Language Assessments test taken by the student – Can be DISTRICT MANAGED.
LASLang Assess ScoresContains a test history of Language Assessments test taken by the student – Can be DISTRICT MANAGED.
LEALetter Table AuditStores Attendance data relating to a student’s Letter
LECLetter Table CodesStores which Absence Codes (ABS) count towards each Letter in LET – Can be DISTRICT MANAGED.
LETLetter TableStores Letter data (similar to existing LTR table) – Can be DISTRICT MANAGED..
LGDLog DetailsLogs student detail changes specifically for CALPADS reporting.
LKRLockersContains information about all the lockers in the school
LNCLunch Count DataUtilized through Teacher Portal to report the daily lunch count to the office
LNKABI LinksStores the URLs for the Online Resource Center
LOCLocation dataNames, Addresses, and Function variables of schools within the District – Can be DISTRICT MANAGED.
LOGLOGRecords critical changes made to specific data by the users
LSILegal Student InfoContains student legal name and gender data
LTLLetter LogLogs the Letter Type, Student, Date and User who created Letters.
LTRQuery LettersContains the contents of all letter texts available through Aeries
MDFMulti Data Profile FieldStores Multi Data Profiles Fields to be included
MDLMulti Data Profile ColorStores Multi Data Profiles layout colors
MDPMulti Data Profile OptStores Multi Data Profiles basic information
MEDMedical DataContains records of daily visits to the medical office 
MHSMedical HistoryHistory of Major Medical concerns
MIIMedical Insurance InfoContains history of details for Medical Insurance
MLGMedication LogLogs the dates and times medications are administered to a student
MLMMedicationsContains history of details of Medications
MNOMedical NotesContains confidential medical data regarding a student that is usually entered by nurses
MSSMaster Schedule SettingsContains Master Schedule Settings for use with Google Classrooms.
MSTMaster ScheduleMaster Schedule
NATNotification and Alert ThresholdsStores data thresholds which will trigger alerts / notifications to be sent.
NWSNews EventsStores Schools and District News Articles.
OATOauth
OBJTest ObjectivesTest objectives for “Teacher Made Test” – Can be DISTRICT MANAGED.
ODCOther District CoursesThis table is used to match incoming courses from Records Transfer with local courses.
ODEOther District EnrollUsed to track student enrollment outside of your district
OGCOff Grade CoursesStores courses taken outside the normal grade range that could be in a student’s Course History and should be counted as a regular course
OPTOptions TableUsed by reports and Forms – School wide options which ADD to Variables
PALParent Attendance LogContains a log of all Attendance record changes made by parents through ABI
PAOPortal Account OptionsContains Portal Account Options for use with Google Classrooms.
PAYPaymentsRecord of payments made through the Billing process
PCTCELDT Test Pre IDContains data for export for CELDT Pre ID - Can be DISTRICT MANAGED.
PFSPhysical Fitness SetupStores specific Tests selected by administrators to be performed at the school level.
PFTPhysical FitnessContains results of Physical Performance Testing
PGMSpecial Program DetailsContains details of Special Programs in which students are participating
PHECAHSEE Test Pre IDContains data for export for CAHSEE Pre ID  – Can be DISTRICT MANAGED
PHLPage Hit LogStores Page Hit Log.
PICStudent PicturesStores student pictures. The table is ID based and it is not cached because of its potential big size.
PNPParent Notification PrefAeries Web Only.  Contains information about when parents want to receive Weekly Notification Emails.
POPPortal OptionsStores various options for the Teacher, Parent and Student Portals.
PRCPreRef Inv CodesStores Pre-Referral Intervention Codes.
PRESTAR Test Pre IDContains data from variety of sources to create a Pre ID file for export to STAR  – Can be DISTRICT MANAGED
PRGProgress ReportingContains marks for Progress Reports to parents
PRIPreReferral InterventionStores Pre-Referral Interventions for each student.
PRMABI Account PermissionsStores Counselor-Style Accounts that can have their permissions managed by ABI administrators to view and/or update certain tables. This table is global in AeriesCS.  – Can be DISTRICT MANAGED
PRNPreReferral InterventionStores Meetings and Contacts for each Pre-Referral Intervention.
PRRPreRef Inv ReasonsStores Reasons and Concerns for each Pre-Referral Intervention.
PRSParent Survey ResponseStores parent responses to survey items.
PRTPrinter Margin OffsetsProvides alignment of printer to output a variety of reports on preprinted forms
PSASABE Test Pre IDContains data for export for SABE Pre ID  – Can be DISTRICT MANAGED
PSBSmarter Balanced Pre-IDContains data for export for Smarter Balanced Pre ID - Can be DISTRICT MANAGED.
PSDPayment Schedule DatesContains Payment Schedules for Billing
PSTPayment Schedule TypesDefines the Payment Schedules available for Billing
PWAParent Web AccountsParent 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.
PWSParent Accounts - StusStores 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
QRYQuery StatementsStorage of many QUERY statements for use by all users
RALRecord Access LogRecord of those who have accessed the student data, cumulative record or test scores
RCHReport Card HistoryAeries Web Only.  Contains a running history of report cards that have been created at the end of each marking period.
RELReligionContains Religious information
REQGraduation RequirementsMaintains graduation requirements   – Can be DISTRICT MANAGED.
RETRetentionsRecord of Retention actions, whether retention occurred or was set aside and for what reason
RFIReferral for InvStores Referrals for Intervention for each student.
RFPReferral for Inv PriorStores Prior Interventions for each Referral for Intervention.
RFRReferral for Inv ReasonsStores Reasons and Concerns for each Referral for Intervention.
RFSReferral for Inv Stu StrStores Student Strengths for each Referral for Intervention.
RHSReport HistoryLogs reports run in Aeries Web
RJNRejoindersThis 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.
ROLRollover SettingsAeries Web Only.  Stores settings used by the New Year Rollover process
RPPReport Printing PacketsStores definitions of Reports to be printed in packets for various reasons
RT_CHIRecords Transfer Course History InstitutionsThis is a records transfer holding table.  It is used to store a copy of incoming CHI data before it's imported.
RT_CSTRecords Transfer Content Standards ScoresThis is a records transfer holding table.  It is used to store a copy of incoming CST data before it's imported.
RT_CTSRecords Transfer College Test ScoresThis is a records transfer holding table.  It is used to store a copy of incoming CTS data before it's imported.
RT_HISRecords Transfer Course HistoryThis is a records transfer holding table.  It is used to store a copy of incoming HIS data before it's imported.
RT_TSTRecords Transfer Testing DataThis is a records transfer holding table.  It is used to store a copy of incoming TST data before it's imported.
RTG 
RTMRecords Transfer MessagesStores system and user messages specific to a records transfer (RTR or RTO) record.
RTORecords Transfer Outbound RequestsStores data regarding student records which were requested from another school district.
RTRRecords Transfer Inbound RequestsStores data regarding student records which are being requested by another school district.
RUNRun Timed ProceduresSet of procedures that can be run at night to expedite use of the program during the day
SADStudent Assess DefContains Performance Indicators against which student success is measured
SAGStudent Assess GradesStores Student Assessment Definition levels by grade
SAPStudent Assess PerfContains the actual Performance Indicator Scores each student – NEW 5 Levels
SAR(OLD) Stu Assess Rptg
SAS(OLD) Stu Assess Setup
SAT(OLD) SAT/ACT Scores
SAVYesterdays SectionsContains Student Schedule Changes for use by the Add/Drop Report
SBCStandards-Based CommentsContains Comments that are given at grading time to an Elementary student
SBDStandards-Based DetailsStores Standards-Based Template Details.
SBEStandards-Based SetupContains the Categories and Standards selected for Elementary report cards  – Can be DISTRICT MANAGED
SBGStandards-Based GradesContains Grades given to Elementary Students
SBHStandards-Based HistoryHistory of Grades given to Elementary Students
SBRStandards-Based CoursesStores a link between Courses (CRS) and Standards (STN)
SBSStandards-Based TemplateStores Standards-Based Templates.
SBUScheduling BackupsThis is a key to each backup table (i.e. backup title, date, sequence). Aeries Web only at this time.
SBVStandards-Based MarksContains all possible Grades or Marks and descriptions that might be given to Elementary students   – Can be DISTRICT MANAGED
SCDSchool of Choice Decisions
SCHSeating Chart Table
SCNSchool of Choice Request Notes
SCOScoliosisContains history of details of Scoliosis Tests
SCPScrip PurchasesContains Student Scrip Purchases
SCRSchool of Choice Requests
SCSSTAR Cluster ScoresContains Student Cluster Scores imported from the SAT-9 CD used in Reports
SDTSeating Chart Details
SECStudent ClassesRelationships of Student Numbers to Master Schedule section numbers – Student Schedules
SEDScheduling Exclusions
SFLStudent FilesStudent File Storage
SGAStudent Group Analytics
SGDStudent Group DefinitionStores the definition of Student Groups
SGMStudent Group MembersStores the Students assigned to each Student Group
SGSStudent Group StaffStores the Staff assigned to each Student Group
SLDService Learning DataAeries Web Only.  Contains the specific Service Learning Requirements and Service Learning Hours Completed for each student for each grade level.
SLIService Learning Log ImgAeries Web Only.  Contains images and other documents related to each Service Learning Log (SLL) record.
SLLService Learning LogAeries Web Only.  Contains a log of Service Learning Hours worked by students for specific organizations.  Records and pending approval until school personnel approve them.
SLOService Learning OrgsAeries Web Only.  Contains information about organizations that students can donate their time to for building Service Learning Hours.
SLRService Lrning RecipientAeries 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.
SMBSched Master Sched BkupThis table is exactly like SMS, only stores multiple sets of SMS data based on the # of backups made. Aeries Web only at this time.
SMSSched Master SchedThe Master Schedule for the next semester or year – for planning purposes – Scheduling
SOCSusp Offense CodesRetains specific data, usually Ed Code, which assist in determination of specific Suspension Action  – Can be DISTRICT MANAGED
SPPStudent Program ParticipContains Program Participation for each Student to provide for dis-aggregation of data 
SPSStudent Program SetupDefines which programs are to be used for dis-aggregation of data
SPTSystem Performance TestAeries Web Only.  This table is used by back-end processes in Aeries Web to determine if the system is performing effectively.
SRBSummer Requests Backup
SSASummer School Availability
SSBStudent Scheduling BkupThis table is exactly like SSS, only stores multiple sets of SSS data based on the # of backups made. Aeries Web only at this time.
SSCSummer School Courses
SSDSecondary Student DataContains additional Student Data 
SSOSingle Sign OnAeries Web Only.  Contains temporary information for facilitating Single-Sign-On capabilities with 3rd party systems.
SSRSummer School Course Requests
SSSStudent SchedulingContains Students Schedules for the next semester or year – for planning purposes.
SSTSummer School Terms
STAStaff AssignmentsContains CBEDS required information about the current assignments of staff members  – Can be DISTRICT MANAGED
STARSTAR Test ResultsRaw test scores imported from the STAR CD
STCStaff CredentialsContains CBEDS required information about the current credentials of staff members  – Can be DISTRICT MANAGED
STEStaff Raw CredentialsStores imported credential data from standard CTC file layout distributed to counties and districts
STFStaffContains CBEDS required demographic information about current staff members
STGSeatingContains seating chart information – used by Attendance by Photograph in the Teacher Portal
STHStaff Highly QualifiedStores the Highly Qualified Status for particular NCLB Core Areas for each staff member
STJStaff Job AssignmentsContains job classifications and assignments for each staff member.
STNStandardsContains all possible Categories and Standards that can be printed on a report card
STOScrip StoresContains Information regarding Stores from which Students can purchase items using scrip
STPScrip Store PercentagesContains Percentages of purchases
STRStreet tableData of all streets, including from-to numbers to determine school of residence and next school
STSState Test SettingsStores State Test Settings.
STUStudent DataStudent demographics
SUPSupplementalSupplemental Student demographics (up to 150 District developed fields)
TAATeacher Stu Assoc AreaAeries 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.
TADTesting Administrations Stores Testing Administration settings.
TBCTextbook CopiesContains all of the individual textbook copies and their assignment (who they’re checked out to)
TBLTables to UpdateAeries Client Only.  The tables to update during Update District Database
TBOTextbook OptionsContains options about scanning and hand-entry of textbook assignment data
TBTTextbook TitlesContains information about textbook titles including total copies and replacement costs
TCHTeachersContains basic information about Teachers
TDFTranscript DefinitionDefines the content of the District’s Transcripts
TEXTesting ExceptionsContains accommodations, modifications and info as to why a student missed a scheduled test
TFLTeacher FilesAeries Web Only.  Contains the files uploaded by teachers to link with Aeries Web Gradebook Assignments.
TFRTable-Field RulesDefines which fields and drop downs on a form are required.
TNPTesting Number PossibleStores specific Test ID’s and the total number that is possible for each part.
TPE 
TPNThird Party NamesStores Third Party Names.
TPPThird Party PermissionsStores Third Party Permissions.
TPSTesting Pass StatusStores calculated status for Algebra I, CAHSEE, and Physical Fitness
TRMTermsDefine school terms
TSATeacher Stu AssocAeries 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.
TSDTeacher StandardsStores teacher defined standards by class.
TSOTeacher Standard OptionsStores standard grading options by teacher and class.
TSTTesting dataContains a history of State and Local standardized test scores
TTCTables To CopyContains a list of tables to copy when transferring a student between schools
TTMTranscript TermsStores starting and ending dates for terms defined in HIS for all previous years.  CSIS use ONLY.
TTPThings to Print (Trans)Defines which Test Scores, Activities, Immunizations, Student fields etc. are to print on Transcripts 
TXTQuery Letter TextStores letters developed in the QUERY Letter Text Editor, some of which can be District Standard
UAOUser Account OptionsContains User Account Options for use with Google Classrooms.
UGAUser and Group AssocAeries Web security table to store User and Group Memberships.
UGNUser and Group NamesAeries Web security table to store information about Users and Groups.
UGPUser and Group PermAeries Web security table to store permissions granted to Users and Groups.
USOUser OptionsStores various options for individual users that need to be associated with an individual database
USRUser Limitation (CS)Aeries Client Only.  Stores permissions for the different users to access various schools.
VACVaccination RequirementsUtilized to update required immunizations for the current state requirements.
VERVerificationContains the sheet numbers of absence verification sheets printed
VICVictimsStore information for Victims of harassment or any other offenses
VISVisitationContains detail for one of the two Counselor Tables - Less detail than CNF (both can be used)
VNDVendorsVendors for the Textbooks
VSNVisionContains history of details of Vision Tests
WEBWEB UsersContains information about the valid users of ABI - Not used for Aeries Web
WGMWeb Global MessagesContains global messages displayed to users
WITWitnessStore information for Witnesses of harassment or any other offenses
WPTWork PermitsRecord of Work Permits issued to Students
WPVWork Permit VisitationsAeries Web Only.  Contains information about visits to work places by CTE/ROP teachers when students are interning at places of employment.
WRL 
XRFCross ReferenceTool for District to match criteria required by Testing Pre-IDs and location of data in AERIES
YTDYear to Date AttendanceContains Student Attendance data from the beginning of school to the current date
ZFSForms SecuritySecurity by form – suggest this be used after basic Security is implemented