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

Table: U_SL_OR_STD_ARO - Student ARRO Registration

Short Description: AARO registration

Long Description: ARRO registration data

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)
PREFERRED_NAME	AARO Nametag first name
U_SL_ADV_GROUP	AARO Advising Group
ADVISOR_ID	ID number of the student's advisor

Criteria Notes:

Cancellations are stored on U_SL_OR_STD_CAN. Exclude cancellations with a "not in list" subquery.

Join to U_SL_OR_ARO_SES for session setup data

Related Tables: ACAD_CALTRM_TBL  U_SL_OR_ARO_SES  U_SL_OR_STD_CAN  U_SL_OR_STD_GST  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.