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.

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