PennERA Proposals Data Collection

The PennERA Proposals data collection is a subset of the University Data Warehouse containing data from the Proposal Tracking module of PennERA. PennERA is the University's Electronic Research Administration system, which supports pre- and post-award administrative tasks related to the sponsored projects of Penn's academic research community. The PennERA Proposals data collection contains current and historic information about sponsored projects (e.g., grants and contracts) at PENN.

PennERA Upgrade to version B10 - Help Page
Please refer to the this page for information on the effects to the Warehouse of the April 2005 PennERA B10 upgrade, and for pointers on revising queries that involve period status information.

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

Data Diagrams
The diagram illustrates the architecture of the PennERA Proposals Business Objects Universe, and identifies joins. While viewing the diagram, you can click on a table name to access its documentation. If you need to print the diagram, print it in landscape 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 PennERA Proposals 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 PennERA Proposals Data Collection.