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 firstname.lastname@example.org 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 email@example.com, 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 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.