Data Warehouse Documentation

Forms

• MS SQL Database Access Request - Use the form to request access to SQL tables within a database. Database access is required to query the tables and use the MS Access Report Libraries.

• MS Access Report Library Move Request - Use the form to request moving Access objects (tables, queries, forms, reports, etc.) to the pertinent MS Access Sungard Plus Report Libraries (SIS, FRS, or SAM).

• Database Request for Applications Development - Use the form to request access to a database for application development.

• Oracle Object Move Request - Use the form to request moving Oracle database objects from a test to a production database.  See the Oracle Object Move Instructions for details.

• Oracle Script Execution Request - Use the form to request an Oracle Script be executed.

• SQL Object Move Request - Use the form to request moving SQL Server Data Warehouse objects (tables, views, stored procedures, user defined functions, DTS, etc.) from the test to the production database.

• IAS Report Developer Request - Use the form to request access to the Institutional Analysis System (IAS) tables.  The IAS contains student oriented snap-shot information for analytical reporting and analysis.  Users must possess a knowledge of Crystal Reports and have attended a training session as prerequisite for access.  To schedule training, please contact Daryl Wright in Institutional Research.

• Lawson Material Mgmt Request - Use the form to request access to the Lawson Materials Management or Accounts Payable areas, or to request access to the database for querying.

Sungard Plus ODS Table Help

• Financial Records System (FRS) Tables

• Graduate Admissions (GRD) Tables

• Student Billing and Receivables (SBR) Tables

• Student Information System (SIS) Tables

• Undergraduate Admissions (ADM) Tables

Web Report Library Forms 

• Web Report Library Access - Use the form to request access to Folders in the Web Report Library.  The Web Report Library is located at http://reports.utoledo.edu.

• Web Report Move Request - Use the form to request a report developed in Crystal Reports be moved to a folder in the Web Report Library.

• Report Specification Form - Use the form to provide specifications for the development of a report.

Web Report Library 

• Enterprise Reporting Web Folders - The document displays the current list of folders in the Web Report Library.

• Web Report Standards - The document provides standards and guidelines for reports that will be published in the University's web report library.

Banner Operational Data Store (ODS)

• Banner ODS Access Request Form - Use the form to request access to a Banner ODS subject area.

• Oracle Client Installation Instructions - The document includes instructions for installing Oracle client files on your computer so you can access Oracle database files.

• Banner ODS Reporting Views - The table contains a list of the reporting views available by subject or security area

• Banner ODS Metadata - Web documentation for the Banner Operational Data Store (3.0) reporting views.

Oracle Information 

• Oracle Database Overview - The document contains information and guidelines for creating new Oracle database objects.

• Oracle Object Move Instructions - Instructions for completing the Oracle Move Request Form to move Oracle objects to a production database.

Other Documentation

• Banner Data Access Levels - The document summarizes and contrasts the different levels of access to Banner information and data.

• Database Column Naming Standards - The document details database column naming standards for tables and columns.

• Database Object Naming Standards - The documents details standards for the different database objects for both Oracle and MS SQL databases.

• Production SQL Databases - Includes a list of the SQL production databases with a brief description.

• Steps to Link to a SQL Table within Access

• Steps to Refresh a Linked SQL Table within Access

• Report Object Move Request Procedures

• Report Object Move Request form example

• Column Abbreviation and Acronym Standards

• SQL Object Move Procedures

• Data Warehouse Connection Standards