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

Table: STDNT_CAR_TERM - Student Career Term Table

Short Description: Term activated students

Long Description: Contains students who are eligible to enroll, by Academic Career and Term. Details term and cumulative credit hours, grade points, GPA, transfer hours, and test credit hours.

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
REG_CARD_DATE	Date of first enrollment action for a term (set by tuition process)
WITHDRAW_CODE	Not Withdrawn, Withdrawn, or Cancelled
WITHDRAW_REASON	Reason for Withdrawn or Cancelled
WITHDRAW_DATE	Date withdrawn or Cancelled
STDNT_CAR_NBR	Career Number assigned to Academic Program
ACAD_PROG_PRIMARY	Student's Primary Academic Program
ACADEMIC_LOAD	Based on hours, full-time, half-time, etc.
ACAD_LEVEL_BOT	Academic Level, or Classification, and beginning of a term
ACAD_LEVEL_EOT	Academic Level, or Classification, as of end of a term
ACAD_YEAR	Academic Year of the term
FULLY_ENRL_DT	Effectively the term begin date
FULLY_GRADED_DT	Effectively the term end date
ELIG_TO_ENROLL	Student eligible to enroll for a term
UNT_TAKEN_PRGRSS	Term SMU hours taken
UNT_PASSD_PRGRSS	Term SMU Credit Hours
UNT_TAKEN_GPA	Term SMU GPA credit hours
UNT_PASSD_GPA	Term GPA hours passed
UNT_TAKEN_NOGPA	Term SMU non-GPA hours
UNT_PASSD_NOGPA	Term non-GPA hours passed
UNT_INPROG_GPA	Term enrolled GPA hours
UNT_INPROG_NOGPA	Term enrolled non-GPA hours
GRADE_POINTS	Grade points for a term
TOT_TAKEN_PRGRSS	Cumulative SMU hours taken
TOT_PASSD_PRGRSS	Cumulative SMU Credit Hours
TOT_TAKEN_GPA	Cumulative SMU GPA credit hours
TOT_PASSD_GPA	Cumulative GPA hours passed
TOT_TAKEN_NOGPA	Cumulative SMU non-GPA hours
TOT_PASSD_NOGPA	Cumulative non-GPA hours passed
TOT_INPROG_GPA	Current enrolled GPA hours
TOT_INPROG_NOGPA	Current enrolled non-GPA hours
TOT_TRNSFR	Cumulative Transfer credit hours
TOT_TEST_CREDIT	Cumulative Test Credit hours
TOT_OTHER	Cumulative other hours
TOT_CUMULATIVE	Cumulative credit hours (hrs, transfer, etc.)
TOT_GRADE_POINTS	Cumulative grade points (SMU hrs)
CUR_GPA	Term GPA
CUM_GPA	Cumulative GPA as of the term
REGISTERED	Registered flag (set by tuition process)

Criteria Notes:

Begin with STDNT_CAR_TERM when pulling students for a Term.

If pulling enrolled: WITHDRAW_CODE = NWD and REGISTERED = R

To confirm enrollment in a class, join to STDNT_ENRL.

To include withdrawals in the count (count all who receive a grade): REGISTERED = R

Related Tables: ACAD_CALTRM_TBL  ACAD_STDNG_ACTN  ADM_INTERESTS  RELATIONSHIPS  SCC_EMERG_C_QVW  SCC_EMERG_P_QVW  SRVC_IND_DATA  STDNT_CAREER  STDNT_ENRL  TERM_TBL  U_SR_CUM_GPA  U_SR_TRN_CRS_VW  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.