Data Warehouse: Advancement Data Collection -> Data Diagrams


	Query the warehouse
	What you need
	Access request forms
	Password change
	Query tool software
	Training options
	Tips

	Related information
	About the warehouse
	Data Administration
	Security
	Support services
	Warehouse updates

	Data collections
	advancement
	assets
	brim
	brs
	express mail
	facilities
	faculty
	general ledger
	infrastructure
	learning management
	position inventory
	research
	salary management
	student
	tuition distribution
	cross-collection

Advancement Collection Data Diagrams

The ATLAS Data Collection is described in the following diagrams. Each diagram illustrates the architiecture of a specific segment of the data collection and identifies the join criteria between tables.

The PEOPLE diagram provides access to the core warehouse tables for reporting on individual constituents -- alumni, students, parents, and friends of Penn.

The ORG diagram presents the tables used for reporting organization specific data.

The GIFTS - DETAIL diagram presents the tables designed to present detail information about gifts and pledges to Penn.

The GIFTS-SUMMARY diagram presents the tables designed for analyzing donors' gift histories and other trends over time.



Information Systems and Computing University of Pennsylvania Comments & Questions