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

Table: U_SL_OR_ARO_SES - SL - OR Setup

Short Description: Setup table for AARO sessions

Long Description: AARO sessions dates, capacity, and description

Useful Fields:

Field Name	Field Descr
STRM	Term
U_SL_OR_SESSION_CD	AARO Session code (FYR, TRN, Intl, Final)
SESSIONIDNUM	AARO Session number for an AARO term
DESCR	AARO Session description
FROMDATE	AARO Session begin date
THRUDATE	AARO Session end date
FROM_DATE	Registration open date for AARO session
TO_DATE	Registration close date for AARO session
U_SL_OR_SPACE_TOT	ARRO session total space allocated

Criteria Notes:

Join from U_SL_OR_STD_ARO to get session setup data

Related Tables: ACAD_CALTRM_TBL  U_SL_OR_STD_ARO  U_SL_OR_STD_CAN  U_SL_OR_STD_GST  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.