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 ACAD_DEGR_HONS:

Table: ACAD_DEGR_HONS - Student Degree Honors Table

Short Description: Students and awarded Degree Honors

Long Description: Lists Degree Honors. Join to this table from ACAD_DEGR. The Honors Code can mean 1, 2, or 3 honors awarded, which makes it difficult to count. Not all students receive honors.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
STDNT_DEGR	Number for a student's Degree Awarded (01, 02, etc.)
HONORS_CODE	Degree Honors Code

Criteria Notes:

Begin with record ACAD_DEGR, joining by EMPLID and STDNT_DEGR

Honors codes are combinations of honors, join to DEGR_HONORS_TBL for descriptions

Related Tables: ACAD_DEGR  ACAD_DEGR_PLAN  DEGR_HONORS_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.