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

Table: U_SL_OR_STD_GST - Student Guest Regis

Short Description: AARO guests

Long Description: Student's relations and guest attending AARO

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
STRM	Term
U_SL_OR_SESSION_CD	AARO Session code (FYR, TRN, Intl, Final)
SESSIONIDNUM	AARO Session number for an AARO term
LAST_NAME	Last Name of an AARO guest
FIRST_NAME	First Name of AARO guest

Criteria Notes:

Start at U_SL_OR_STD_ARO, excluding cancellations, and then here to get guests

Related Tables: ACAD_CALTRM_TBL  U_SL_OR_ARO_SES  U_SL_OR_STD_ARO  U_SL_OR_STD_CAN  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.