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

Table: CLASS_MTG_PAT - Class Meeting Pattern Table

Short Description: Class meeting days, times, and facility ID

Long Description: Building, room number, start and end times, start and end dates, and meeting days. A class section may have multiple meeting patterns and the dates may vary. For example, a class might have a 1 week trip, which should have it's own meeting pattern in addition to the classroom meetings.

Useful Fields:

Field Name	Field Descr
CRSE_ID	Course ID number
CRSE_OFFER_NBR	Course Offer Number
STRM	Term
SESSION_CODE	Session Code, within a term
CLASS_SECTION	Class Section
CLASS_MTG_NBR	Class Meeting Pattern Number. Different for when a class section has multiple meeting patterns.
FACILITY_ID	Facility ID
MEETING_TIME_START	Start time of a class meeting
MEETING_TIME_END	End time of a class meeting
MON	Class meets on Monday (Y or N)
TUES	Class meets on Tuesday (Y or N)
WED	Class meets on Wednesday (Y or N)
THURS	Class meets on Thursday (Y or N)
FRI	Class meets on Friday (Y or N)
SAT	Class meets on Saturday (Y or N)
SUN	Class meets on Sunday (Y or N)
START_DT	Class meeting start date
END_DT	End Date of class meeting
STND_MTG_PAT	Meeting Pattern abbreviation

Criteria Notes:

Typically join from CLASS_TBL.

Join to FACILITY_TBL to get the building code and room number

It is better to use the day fields (MON, TUES, etc.) then to rely on the STND_MTG_PAT code (MWF, TR, etc.)

Related Tables: ACAD_CALTRM_TBL  CLASS_INSTR  CLASS_INSTSR  CLASS_TBL  FACILITY_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.