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

Table: ACAD_PROG - Student Academic Program

Short Description: Students and their Academic Programs

Long Description: Lists which students are in which Academic Programs at any point in time. Defaults to current date, but does have history. This is where you will find when the Program Actions (Plan Change, Discontinue, Complete, etc.) took place.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
STDNT_CAR_NBR	Career Number assigned to Academic Program
EFFDT	Date the data or action takes effect
EFFSEQ	Sequence for actions with the same Effective Date
ACAD_PROG	Code for Academic Program
PROG_STATUS	Student's status in Academic Program
PROG_ACTION	Code of the Academic Program action taken
ACTION_DT	Actual date the data was entered (as opposed to when it takes effect)
PROG_REASON	Code for the reason for the Program Action
ADMIT_TERM	Admit Term into the Academic Program
EXP_GRAD_TERM	Expected graduation term
REQ_TERM	Term used in degree, DPR requirements
COMPLETION_TERM	Term the Program/Plan was completed

Criteria Notes:

Begin at this table when pulling student's Program/Plan, then to ACAD_PLAN.

To pull active in a Program: PROG_STATUS = AC

To pull completed Program: PROG_STATUS = CM

Field ADMIT_TERM is when the student was admitted into the Program, not necessarily admitted into SMU.

Codes for degree candidates. ELIG = eligible to apply for graduation. ACG = applied to graduate. CAND = approved as a degree candidate

When joining from STDNT_CAR_TERM or STDNT_ENRL, do not include STDNT_CAR_NBR in the join.

When joining to ACAD_PROG, do not join by EFFSEQ

Related Tables: ACAD_DEGR  ACAD_PLAN  ACAD_PROG_TBL  ACAD_STDNG_ACTN  ADM_INTERESTS  PROG_ACTION_TBL  PROG_RSN_TBL  RELATIONSHIPS  STDNT_ADVR_HIST  STDNT_CAREER  U_SR_ACADPG_TBL  U_SR_HONORS_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.