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

Table: EXT_COURSE - External Courses

Short Description: Course list from a transcript

Long Description: Transcript courses from external institutions, does not show SMU equivalencies.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
EXT_ORG_ID	External Organization ID
UNT_TAKEN	Units (hours) for an external course
CRSE_GRADE_OFF	Official Grade
SCHOOL_SUBJECT	Subject of an external course
SCHOOL_CRSE_NBR	Catalog number of an external course
EXT_TERM	External Term (fall, spring, summer, etc.)
TERM_YEAR	Calendar year of term
DESCR	External Course description

Criteria Notes:

Join to TRNS_CRSE_DTL by EMPLID, EXT_COURSE_NBR, and EXT_ORG_ID = TRNSFR_SRC_ID to see the if/what SMU credit the work transferred into,

Related Tables: EXT_ACAD_DATA  EXT_ACAD_SUM  EXT_ORG_SCHL_VW  EXT_ORG_TBL  EXT_ORG_TBL_ADM  EXT_SUBJECT_TBL 

For updates, corrections or questions Email Stephen Forrest.