Penn Computing

Penn Computing

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

  Query the warehouse
What you need
Access request forms
Password change
Query tool software
Training options
Tips
  
  Related information
About the warehouse
Data Administration
Remote access
Security
Support services
Warehouse updates
  
  Data collections
advancement
assets
brs
faculty
general ledger
position inventory
research
salary management
space@penn
student
   nightly load
   term extract
   worksheet
   portal
tuition distribution
cross-collection

Student Data Collection

The Student Data Collection is a subset of the University Data Warehouse containing current and historic information about students at Penn, including academic programs, enrollment, courses offered, and requirements fulfilled. These data can be found in several distinct collections:

Student data: nightly load
(known in Business Objects as STDTCANQ)
Data refreshed nightly from the Student Records System (SRS). Individuals who are granted access to this data are automatically entitles to use the BRS (Student Billing and Receivables) collection (known in Business Objects as BRS COMBINED), which is documented separately.

Student data: term extract
(known in Business Objects as STDTTERM)
"Snapshot" data extracted from the Student Records System (SRS) once per term.

Academic Planning Worksheet data
(known in Business Objects as Worksheet)
Data refreshed nightly from SRS, from Requirements Builder (REQBUILD) and from the web application AdvisorInTouch.

PennPortal statistics
(known in Business Objects as PPortal)
Data extracted nightly from SRS and from the PennPortal databases.

 

Prerequisites for access to Student Data

For people who want to write or modify their own queries:
  • SRS Training: contact the Office of the University Registrar for available training dates and times. It is also highly recommended that you have your own SRS account. If you do not, you must have a contact person in your office or department who does, who is willing to assist you when you need to cross-reference data from the warehouse with what's in SRS.
  • Student Data training: contact squant@isc.upenn.edu to be enrolled in the BlackBoard web course about using student data in the Data Warehouse. You must complete both SRS training and this online course before you begin writing your own ad-hoc queries against the student data collection.
  • Submit a completed Access Request Form
  • Have a software license for and know how to use a query tool

For people who will be using InfoView to run existing queries on the Business Objects repository:

  • Submit a completed Access Request Form
  • , indicating "InfoView-only" in the box provided.
  • Have a license for and know how to use InfoView

All users of Student Data, whether they write their own queries, or use data or reports extracted by someone else, agree to abide by University policy regarding confidentiality of student records, and by the Family Educational and Right to Privacy Act. Failure to abide by the policies and laws governing student data can result in disciplinary action, including termination.

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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