Tutor and Tutee tables

Useful Views

vTutorModule: returns information about tutors such as (this is not a full list of fields):

 

Studentid, Pidm, Name, Address, Phone, Status, Major, Goal, Gender, Birthdate, DBO.Vstudent.Age, DBO.Vstudent.Ageatterm, DBO.Vstudent.Censusagegroup, DBO.Vstudent.Ethnicity, Highschool, Eng251_Elig, Mathplace, Read_Level, Overall_Gpa, Term_Gpa, Cos_Degree_Units_Passed, Cos_Degree_Gpa, Csu_Degree_Units_Passed, Csu_Degree_Gpa, Uc_Degree_Units_Passed, Uc_Degree_Gpa, Eops, Drc, Drc_CODES, Vatea, Puente, Cohort_CODES

 

vTutorsTuteesSubjects: returns these fields:

 

Term, Tuteeid, Tutorid, SessionSubject, SessionDate, SessionStartTime, SessionEndTime

History

StudentNet.dbo.Tutor and Tutee tables

These tables were developed to work with the Tutor system section of the EIS by Dr. Luis Leal. Since that time, some adjustments have been made and some fields are no longer used. These fields are marked below with an * and grey color. The tables could use some further adjustments, but the system is working for now. The data in these tables is populated from existing data already in the Data Warehouse.