Data Dictionary Keyword Search

This Data Dictionary contains student related Access.SMU database tables commonly used in the query tool. In the keyword search below you may enter the table name, field name, or the common name for the information you are seeking.

| List All Tables

Table Information for STDNT_ADVR_HIST:

Table: STDNT_ADVR_HIST - Student Advisor History

Short Description: Advisors attached to students

Long Description: Advisors attached to students

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
EFFDT	Date the data or action takes effect
ACAD_CAREER	Code for Academic Career. Value attached to the student.
ACAD_PROG	Code for Academic Program
ADVISOR_ID	ID number of the student's advisor

Criteria Notes:

You should outer join to this table by EMPLID and ACAD_PROG from record ACAD_PROG.

Use field ADVISOR_ID to pull data on the advisor

Related Tables: ACAD_PROG  INSTR_ADVISOR  U_CC_PDATA_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.