Organizational Database
Overview
Basics
The organizational databases provide the university's organizational
structure in an easy-to-access database. There are five components of
the database, specifically:
- Division Table
- College Table
- School Table
- Department Table
- Sub-Department Table
Each table (except the Division Table) is tied to the previous table
through an organizational attribute. This provides documentation of
the formal university reporting structure.
Maintenance
All maintenance of the various organizational tables is done in the
web environment. Relational integrity is preserved.
Deletion of organizational entities is permitted, but only if other
organizational entities do not rely on the value.
Data entry and storage is in mixed case mode for ease of readability.
Contents
The Division Table has minimal information associated with it (name,
abbreviation, etc.). Each of the other tables has basic information
and extended information associated with it. The basic information
includes:
- Name
- Abbreviation (Short Name)
- Address
- Telephone Number
- Higher level organization to which it reports
Extended information includes:
- Person responsible for the organizational unit
- Primary FRS account number for the organizational unit
- Email address for contacting this organizational unit
Inquiry
The information listed above is available to campus for inquiry
through the AIMS online system. An index is provided for each
organizational table that includes a context-sensitive search.
OIT--Applications Support
Last Modified: Friday, 27-Feb-2004 10:00:17 CST
©2004 All Rights Reserved