Query Power Users

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

Table: U_SR_CARTERM_VW - Student Career Term Table
Short Description: Term activated students, without GPA data.

Long Description: This is a view of table STNDT_CAT_TERM, and does not contain any GPA/grade data. Contains students who are eligible to enroll, by Academic Career and Term. Details term and cumulative credit hours, transfer hours, and test credit hours.

Useful Fields:
Field NameField Descr
EMPLIDStudent/Person ID number
ACAD_CAREERCode for Academic Career. Value attached to the student.
STRMCode for Term
REG_CARD_DATEDate of first enrollment action for a term (set by tuition process)
WITHDRAW_CODENot Withdrawn, Withdrawn, or Cancelled
WITHDRAW_REASONReason for Withdrawn or Cancelled
WITHDRAW_DATEDate withdrawn or Cancelled
STDNT_CAR_NBRCareer Number assigned to Academic Program
ACAD_PROG_PRIMARYStudent's Primary Academic Program
ACADEMIC_LOADBased on hours, full-time, half-time, etc.
ACAD_LEVEL_BOTAcademic Level, or Classification, and beginning of a term
ACAD_LEVEL_EOTAcademic Level, or Classification, as of end of a term
ACAD_YEARAcademic Year of the term
FULLY_ENRL_DTEffectively the term begin date
FULLY_GRADED_DTEffectively the term end date
ELIG_TO_ENROLLStudent eligible to enroll for a term
UNT_TAKEN_PRGRSSTerm SMU hours taken
UNT_PASSD_PRGRSSTerm SMU Credit Hours
UNT_TAKEN_GPATerm SMU GPA credit hours
UNT_PASSD_GPATerm GPA hours passed
UNT_TAKEN_NOGPATerm SMU non-GPA hours
UNT_PASSD_NOGPATerm non-GPA hours passed
UNT_INPROG_GPATerm enrolled GPA hours
UNT_INPROG_NOGPATerm enrolled non-GPA hours
TOT_TAKEN_PRGRSSCumulative SMU hours taken
TOT_PASSD_PRGRSSCumulative SMU Credit Hours
TOT_TAKEN_GPACumulative SMU GPA credit hours
TOT_PASSD_GPACumulative GPA hours passed
TOT_TAKEN_NOGPACumulative SMU non-GPA hours
TOT_PASSD_NOGPACumulative non-GPA hours passed
TOT_INPROG_GPACurrent enrolled GPA hours
TOT_INPROG_NOGPACurrent enrolled non-GPA hours
TOT_TRNSFRCumulative Transfer credit hours
TOT_TEST_CREDITCumulative Test Credit hours
TOT_OTHERCumulative other hours
TOT_CUMULATIVECumulative credit hours (hrs, transfer, etc.)
REGISTEREDRegistered flag (set by tuition process)

Criteria Notes:
Begin with U_SR_CARTERM_VW when pulling students for a Term, and you do not have access to STDNT_CAR_TERM, or you want to exclude GPA/Grade data.
If pulling enrolled: WITHDRAW_CODE = NWD
You cannot join to STDNT_ENRL for enrollment status if you do not have access to grades; instead, set REGISTERED = R (this value is set by a billing process, and in rare instances enrollment is added so late that this flag is not set).

Related Tables: ACAD_CALTRM_TBL  XLATTABLE_VW 



For updates, corrections or questions Email Stephen Forrest.