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

Table: PROG_RSN_TBL - Program Action Reason Table

Short Description: Setup table for program action reasons.

Long Description: Has the descriptions for the reason codes. Used in student records and admissions.

Useful Fields:

Field Name	Field Descr
PROG_ACTION	Action on a student's program, on student records or admissions application
PROG_REASON	Reason for an action on a student's program, on student records or admissions application
EFFDT	Date the data or action takes effect
DESCR	Reason description for a program action

Criteria Notes:

Join by both PROG_ACTION and PROG_REASON for the description of an action reason.

Related Tables: ACAD_PROG  ADM_MC_VW 

For updates, corrections or questions Email Stephen Forrest.