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 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 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.