Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

Current Load Status
Regular Availability
FAQs & Tips
Password Changer
Support services
About the Data Warehouse
Data Administration
Express Mail
General Ledger
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Travel Expense Management
Tuition Distribution

Student Term Census Extract - Help

Overview. Student data is complex, and prerequisite training in SRS and an online course is required. In addition, there is an established user community here at Penn that meets periodically, and a listserv is available to help you query Student data in the warehouse.

Training.  SRS training is a hands-on class taught by an instructor in Student Registration and Financial Services.  Contact the Registrar’s Office for upcoming dates. The online course about student data is a self-paced tutorial, found on  The tutorial explains the overall data model, walks through numerous examples, questions and answers, and describes the canned queries available for this data collection.

Listserv and user group. The users of the Student Data Collection in the Data Warehouse across the University have a wide range of expertise, and are a valuable resource when questions come up about student data: where it comes from and how it is used. When you are granted access to the data, you will automatically be given a subscription to the, the list devoted to users of the Student Data Collection, and you will be invited to meetings of the Student Data Collection user group. When you have questions or comments about the data, please send e-mail to the list or bring them up at a user group meeting. Announcements about dates for user group meetings will be sent to the list.

The list is also the place to send email if you notice that some documentation needs updating. For documentation published on the Web, please specify the URL for the documentation that needs to be updated. For Business Objects documentation, please specify the Universe, Class, and Object.

Canned Queries. A good place to get started is to take a look at the existing Business Objects queries on the repository. You can review the Query Panel, and even look at the SQL the query generates. If you have suggestions for the existing queries or new queries to share, post your suggestions to the student-wh list, or bring your ideas to the next user group meeting.

  Collection Information:

Information Systems and Computing
University of Pennsylvania
Comments & Questions

Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania