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:

Table: ACAD_DEGR - Student Degree Table

Short Description: Students and awarded Degrees

Long Description: Lists student's degrees awarded, with completion term. Start with this table when pulling degrees awarded.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
STDNT_DEGR	Number for a student's Degree Awarded (01, 02, etc.)
DEGREE	Code for the Degree
ACAD_CAREER	Code for Academic Career. Value attached to the student.
COMPLETION_TERM	Term the Degree was completed
DEGR_CONFER_DT	Date of Degree Conferral

Criteria Notes:

Begin with this table when pulling degrees awarded.

For majors/minors awarded, join to ACAD_DEGR_PLAN by EMPLID and STDNT_DEGR.

School is not attached to Degrees Awarded. Consult ACAD_DEGR_PLAN notes.

Related Tables: ACAD_DEGR_HONS  ACAD_DEGR_PLAN  ACAD_PROG  DEGREE_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.