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

Table: ACAD_STDNG_ACTN - Academic Standing Action

Short Description: Actions for probation, suspension and dismissal

Long Description: Actions are placed by term. Probation is in effect for that term. Suspensions and dismissals begin with that term.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
STRM	Term
EFFDT	Date the data or action takes effect
ACAD_STNDNG_ACTN	Academic Standing Action that results in a status
ACAD_STNDNG_STAT	Academic Standing or Academic Status. DIS (dismissed), PRO (probation), SUS (suspension).

Criteria Notes:

Concentrate on the ACAD_STNDNG_STAT for the status as the result of the action

ACAD_PROG is not always populated.

Related Tables: ACAD_CALTRM_TBL  ACAD_PROG  STDNT_CAR_TERM  TERM_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.