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

Table: ACAD_PLAN_OWNER - Academic Plan Owner Table

Short Description: Attaches Acad Plans to Acad Orgs

Long Description: Connects Acad Plans to Acad Orgs (departments). Pre-majors belong to DCI, and Minors belong to schools.

Useful Fields:

Field Name	Field Descr
ACAD_PLAN	Code for Academic Plan, or Major/Minor
EFFDT	Date the data or action takes effect
ACAD_ORG	Code for Academic Organization, or Department, used in Acad Org tree.

Criteria Notes:

Join to this table to get Department's that own Academic Plans.

Related Tables: ACAD_DEGR_PLAN  ACAD_ORG_TBL  ACAD_PLAN  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.