Universe Information

This section contains detailed information about each of the universes available for custom reporting. Click each universe name for complete information.

General Universe Information

Selecting a Universe

A universe is a database interface, which maps objects to fields in a database. The universe simplifies the report creation process by eliminating the need to know the database structure. It also provides automatic joins between database tables based on key values.

The name of the universe you choose for your report should begin with "EDW" or "DM". Any other universes listed are used solely for Standard Reports. If you open one of these universes, no classes or objects will be displayed, and you will therefore be unable to create a query.

In general, we recommend that you:

Review the universe descriptions and Quick Reference guides
review documentation in the Solution Library

Universe Mapping Document

This document is helpful in mapping Business Objects classes and objects to their corresponding physical table and column names within the Data Warehouse. This aids in bridging the gap between technical data structures and more general Business Objects users.

To view a specific universe, select using the drop down arrow on the Universe column.

Universe Mapping Document (8/8/22)

HR

OVERALL HR Universe_Guide (information for all HR-related universes)
Civil Service Applicant Tracking
- Civil Service Applicant Tracking includes:
  EDW - HR PRMS Employee Requisition
  EDW - HR PRMS Exam
  EDW - HR PRMS Extra Help
  EDW - HR PRMS Security
Deductions
- EDW - HR Deduction Administration
Employee Attributes
- EDW - HR Employee Administration
HireTouch
- HireTouch Universes includes:
  EDW - HR HireTouch Job Forms and Approvers
  EDW - HR HireTouch Job Applicants
HR Front End
- HR Front End Universes includes:
  EDW HR Front End Security
  EDW HR Front End Transactions
Position/Job Attributes
- EDW - HR Position/Job Hierarchy
Retiree Rehire
- EDW - HR Retiree Rehire
Time/Attendance Recorded
- EDW - HR Leave Tracking
- EDW - HR Reported Time

Finance

* - some universes appear under multiple categories

OVERALL Finance Universe Guide (information for all money-related universes)
Accounts Payable/Purchasing
- EDW - Finance PCard Transactions
- EDW - Finance Purchase Order/Invoices
Accounts Receivable
- EDW - Finance Accounts Receivable
Cash/General Ledger
C-FOAPAL Listings
- EDW - Finance C-FOAPAL
Encumbrances/Reservations
Expense/Revenue
Fixed Assets
- EDW - Finance Fixed Assets
Grants
Merchant Card
- EDW - Finance Merchant Card Transactions
myProposals (Kuali Coeus)
Payroll
Salary Planner/Budget
Space Allocation
- EDW - Finance Space Allocation
Travel & Expense Management
- EDW - Finance Travel & Expense
University Contracts Reporting Universe
- University Contracts Reporting

Students

OVERALL Student Universe Guide (information for all student-related universes)
Academic History
- EDW - STU Academic Records
- EDW - STU Records Directory
Census Reporting
Codebook
- EDW - STU Codebook
Course Catalog and Schedule
Enrollment and Curriculum
Financial Aid
Instructional Assignment Analysis
- EDW - STU Instructor Assignment
Recruiting & Admissions
- DM - STU Contact Analysis
- DM - STU Graduate Admissions
DM - STU Undergraduate Admissions

Other Universes

Service Desk Manager Reporting
- Change Management & Configuration Management includes:
  - EDW - Change Management
  - EDW - Configuration Management
- Help Desk Reporting
Service Desk Reporting
- Service Desk Reporting Universe
System Status Reporting
- System Status Reporting Universe