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

Table: ADM_MC_VW - Adm Appl Prog Vw for MC

Short Description: Student and their Admissions actions

Long Description: Contains history of Admissions actions. Defaults to current date but does save history. Where you will find SMU admit term, admit type, and last school attended.

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_ACTION	Code of the Academic Program action taken
PROG_REASON	Reason code associated with the Program Action
PROG_STATUS	Status of application. Applicant (AP), Admitted (AD), Cancelled (CN), etc.
ADMIT_TERM	Admit Term into SMU
ADMIT_TYPE	Admission Type (first year, transfer, etc.)
LAST_SCH_ATTEND	External Org Code for last school attended
ADM_APPL_CTR	Application Center. Of note, IU are international UG applicants.
ACTION_DT	The date the data raw was saved.
ADM_APPL_COMPLETE	Value is Y or N
ADM_APPL_CMPLT_DT	Date the application was marked as complete
ADM_APPL_DT	Date the application was first entered (complete or not)

Criteria Notes:

If joining to Student Records tables, only need join by EMPLID and ACAD_CAREER.

Begin with this table to pull students based on Admit Type and/or Admit Term.

Set PROG_ACTION = MATR to pull matriculation row, the last admission action prior to enrolling.

Some students have more then 1 MATR row per Career, select the higher Admit Term.

ADMIT_TYPE = FYR is First Years

ADMIT_TYPE = TRN or FYT is Transfers

ADMIT_TYPE = TRE is Evening Bachelors (first created in 2006, last applications in 2009)

Join to this table to pull Admit Term and Type

Readmitted students last admitted prior to 2000 will not have Admission data in the system.

Related Tables: ADM_INTERESTS  EXT_ORG_SCHL_VW  EXT_ORG_TBL  EXT_ORG_TBL_ADM  PROG_ACTION_TBL  PROG_RSN_TBL  STDNT_CAREER  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.