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

Table: STDNT_ENRL - Student Enrollment Table

Short Description: Students and enrolled classes

Long Description: Shows student's enrolled classes, credit hours, and official grade.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
STRM	Code for Term
CLASS_NBR	Class Number, a unique value within each term for a class section.
CRSE_CAREER	Acad Career of the course
SESSION_CODE	Session Code, within a term (most useful in Summer)
STDNT_ENRL_STATUS	Student enrollment status in a class (enroll, drop, etc.)
ENRL_STATUS_REASON	Reason for change in student's enrollment status (enrolled, withdraw, etc.)
ENRL_ADD_DT	Date class added to student's schedule
ENRL_DROP_DT	Date student dropped a class
UNT_TAKEN	Term hours taken
UNT_PRGRSS	Term credit hours taken
GRADING_BASIS_ENRL	Grading type (ABC, pass/fail, etc.)
CRSE_GRADE_OFF	Official Grade in class
REPEAT_CODE	Code assigned to first instance of a repeated course
EARN_CREDIT	Student earned credit for the class
INCLUDE_IN_GPA	Include class in GPA
GRADE_POINTS	Grade points for a class
RQMNT_DESIGNTN	Code for requirement used to enroll in restricted course

Criteria Notes:

Join to this table to pull enrolled student's classes

Typically begin with STDNT_CAR_TERM prior to joining to STDNT_ENRL

To pull enrolled students: STDNT_ENRL_STATUS = E and ENRL_STATUS_REASON in ('ENRL','EWAT')

To pull enrolled students: STDNT_ENRL_STATUS = E ( in conjunction with not withdrawn on STDNT_CAT_TERM).

To include withdrawals in the count (count all who receive a grade): STDNT_ENRL_STATUS = E

Related Tables: ACAD_CALTRM_TBL  CLASS_TBL  ENRL_REQ_DETAIL  GRADE_ROSTER  STDNT_CAR_TERM  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.