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

Table: ACAD_CALTRM_TBL - Academic Calendar Term Table

Short Description: Calendar dates for term

Long Description: Term calendar dates are by Academic Career. Degree conferral, census, drop deadlines.

Useful Fields:

Field Name	Field Descr
ACAD_CAREER	Academic Career of the calendar setup for a term
STRM	Term
DEGR_CONFER_DT	Degree conferral date
CENSUS_DT	Census date
LST_CANCEL_DT	Last day to drop a class without it appearing on a transcript
LST_WD_W_PEN_DT	Last day to withdraw in order to receive a grade of W

Criteria Notes:

Join to this record by ACAD_CAREER and STRM

Related Tables: ACAD_CALTRM_TBL  ACAD_STDNG_ACTN  CLASS_ATTRIBUTE  CLASS_INSTR  CLASS_MTG_PAT  CLASS_TBL  ENRL_REQ_DETAIL  STDNT_AWRD_DISB  STDNT_CAR_TERM  STDNT_ENRL  TERM_TBL  U_SL_OR_ARO_SES  U_SL_OR_STD_ARO  U_SL_OR_STD_CAN  U_SL_OR_STD_GST  U_SR_CARTERM_VW  U_SR_CENCAP_TBL  U_SR_CENSUS_CLS  U_SR_CENSUS_TRM  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.