Suggested Anthology Student Tables

The tables and notes listed below are suggestions as individual Anthology Student implementations may vary.

Faculty

Table	Description	Notes
SyStaff	Faculty information
AdTeacher	Defines staff as teachers	Used to determine Faculty Department based on the department in which the instructor teaches the most courses.
AdClassSched	Course section information	Used to determine Faculty Department based on the department in which the instructor teaches the most courses.
AdClassSchedTerm	Links course sections to terms	Used to determine Faculty Department based on the department in which the instructor teaches the most courses.
AdCourse	Course information	Used to determine Faculty Department based on the department in which the instructor teaches the most courses.
SyCampus	Campus definitions	Used to determine Faculty Department based on the department in which the instructor teaches the most courses.
AdTerm	Term definitions	Defines term logic to pull the appropriate data set relative to academic term.

Student

Table	Description	Notes
SyStudent	Student information
AdEnrollSched	Student enrollment in course sections	Ensure to pull only actively enrolled students (i.e. status of ‘current’, ‘scheduled’, or ‘grades posted’)
AdClassSchedTerm	Links course sections to terms
AmRace	Race code definitions
AmSex	Sex code definitions
AdProgram	Program definitions
AdTerm	Term definitions	Defines term logic to pull the appropriate data set relative to academic term.

Course

Table	Description	Notes
AdClassSched	Course section information
AdClassSchedTerm	Links course sections to terms
AdTerm	Term definitions	Defines term logic to pull the appropriate data set relative to academic term.
adCourse	Course information
syCampus	Campus definitions

Enrollment – Faculty

Table	Description	Notes
AdClassSched	Course section information
AdClassSchedTerm	Links course sections to terms
adCourse	Course information
AdTeacher	Defines staff as teachers
SyStaff	Faculty information
AdTerm	Term definitions	Defines term logic to pull the appropriate data set relative to academic term.

Enrollment – Student

Table	Description	Notes
AdEnrollSched	Student enrollment in course sections	Ensure to pull only actively enrolled students (i.e. status of ‘current’, ‘scheduled’, or ‘grades posted’)
AdClassSched	Course section information
AdClassSchedTerm	Links course sections to terms
AdCourse	Course information
SyStudent	Student information
AdTerm	Term definitions	Defines term logic to pull the appropriate data set relative to academic term.