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

Table: ACAD_PROG_TBL - Academic Program Table

Short Description: Setup table for Academic Program codes

Long Description: Contains setup data on Academic Programs. Acad Plans belong to Acad Programs, and Acad Programs belong to Acad Groups. Use this table to see the long description for Acad Programs.

Useful Fields:

Field Name	Field Descr
ACAD_PROG	Code for Academic Program
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
DESCR	Academic Program description
DESCRSHORT	Academic Program short description
ACAD_CAREER	Code for Academic Career. Value attached to the program
LEVEL_LOAD_RULE	Code for determining full-time status based on hours
ACAD_GROUP	Code for Academic Group, or School
CIP_CODE	CIP Code (Federal Gov't assigned category)
ACAD_ORG	Code for Academic Organization, or Department, used in Acad Org tree.

Criteria Notes:

Join to this table from ACAD_PROG or ACAD_PLAN_TBL for the Program description, or to get ACAD_GROUP.

Join from STDNT_CAR_TERM, field PRIMARY_ACAD_PROG for a student's "primary Acad Group".

Related Tables: ACAD_GROUP_TBL  ACAD_ORG_TBL  ACAD_PLAN_TBL  ACAD_PROG  SCC_EMERG_C_QVW  SCC_EMERG_P_QVW  U_SR_ACADPG_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.