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

Table: FACILITY_TBL - Facility Table

Short Description: Setup table for faculty ID's (building and room)

Long Description: Description of facility ID. Shows BLDG_CD and room, capacity and LOCATION

Useful Fields:

Field Name	Field Descr
FACILITY_ID	Facility ID
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
BLDG_CD	Building Code
ROOM	Room number
DESCR	Facility ID description (building and room)
LOCATION	Location code of a Facility ID
ROOM_CAPACITY	Facility ID capacity

Criteria Notes:

Join from CLASS_MTG_PAT by FACILITY_ID

There is a location code on FACILITY_ID, separate from location code attached to a class section on CLASS_TBL. Used to validate the location value on CLASS_TBL.

Related Tables: BLDG_TBL  CLASS_MTG_PAT 

For updates, corrections or questions Email Stephen Forrest.