Undergraduate Admissions (UAD)

Support Contact

Dominique Pfaff, (510) 987-0394,

Description

The Undergraduate Admissions System (UAD) collects, validates, and integrates information about applicants for undergraduate admission to the University of California. Input is received monthly from the campuses as well as from the central processor. At the end of the application cycle, undergraduate admission information is incorporated into various Corporate Student System databases.

Customers

Educational Outreach
Financial Management:
    Financial Planning and Analysis
Student Academic Services:
    Admissions and Outreach
    MESA
    Puente Project

Access

Corporate Undergraduate Admissions data resides in the UCOP Corporate Data Warehouse (CDW). Standard reports are available via the Web through the Corporate Systems Gateway (CSG). These reports are parameter-driven, which allows standard reports to be tailored to meet specific requests. Direct access to the data is also available for those who wish to program their own data requests. See the Corporate Student Data Warehouse Web page for further information on the methods of access that are offered, and how to obtain authorization.

Technical Information

The UAD production system runs in the IBM mainframe environment using the MVS operating system. Data is stored in FOCUS databases and production jobs are written in FOCUS and COBOL. Data from the system is extracted and loaded into the Corporate Data Warehouse on a routine basis. The Corporate Data Warehouse uses the Sybase IQ database management software running on the UNIX platform.

Input Specifications
Database Information
Data Element Definitions: by request from