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

Table: STDNT_GROUP_TBL - Student Group TBL

Short Description: Setup table for Student Group codes

Long Description: Contains setup data on Student Groups. Join here from STDNT_GROUP_HIST for a description of the Student Group code.

Useful Fields:

Field Name	Field Descr
STDNT_GROUP	Code for Student Group
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
DESCR	Student Group description

Criteria Notes:

Join to this table for the STDNT_GROUP description

The category field does NOT meaningfully categorize groups, it is a security mechanism.

Related Tables: STDNT_GRPS_HIST  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.