Sponsored Projects Data Collection

Fall, 2003: As part of the Research Services System conversion to PennERA, the Sponsored Projects data collection is no longer being updated. Please refer to the conversion help page for pointers about mapping Sponsored Projects queries to PennERA Proposals queries, and other relevant news.

The Sponsored Projects Data Collection is a subset of the University Data Warehouse containing current and historic information about sponsored projects (e.g., grants and contracts) at PENN.

Refresh Schedule
Includes the collection's refresh schedule, source of the collection's data, and the time span covered.

Data Diagrams
Each diagram illustrates the architecture of a specific Business Objects universe, and identifies joins. While viewing a diagram, you can also display its table documentation. If you need to print a diagram, print it in portrait orientation.

Tables and Data Elements
To ensure you have the most recent version, use the documentation online as opposed to printing it.

Data Security
Lists policies and guidelines that are specific to this data collection, questions you should ask before you fulfill a request for Sponsored Projects data, and how to safeguard data stored on your personal computer. Also includes a link to Penn's Information and Security Privacy page.

Help
Explains how to get help when querying the Sponsored Projects Data Collection.