Penn Computing

Penn Computing

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

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

Help for Student Records System Data Queries

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 regist@pobox.upenn.edu for upcoming dates. The online course about student data is a self-paced tutorial, found on knowledgelink.upenn.edu.  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 student-wh@lists.upenn.edu, 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.

Previous Student Data User Group Meetings

The list is also the place to send E-mail 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.

Office Hours.  The Data Administration student support team holds Office Hours approximately 5 times a year.  Office Hours are hands-on, informal training sessions for people new to the student data collection.  We walk through a common query together, and then have time for general questions and answers when you can present your particular query challenges and get assistance from a data analyst.


  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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