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
BBR
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Research Inventory
Salary Management
Student
Travel Expense Management
Tuition Distribution
World Travel
Cross-Collection

Student Records System - Corporate Reports

The Business Objects Corporate Documents area provides access to pre-defined, prompt-driven reports that you can run to retrieve a standardized perspective on your data.

Using InfoView:

The InfoView web page allows you to view the list of corporate documents in the Business Objects repository and refresh and download those documents via the web. To access the corporate documents using InfoView (Business Objects users only):

  1. Point your browser to
    https://bobjprod.isc-seo.upenn.edu/InfoViewApp/logon.jsp
  2. Enter your Business Objects ID and password in the User Name and Password fields that appear. Click OK to continue to the InfoView Welcome page.
  3. The InfoView web portal allows you to view the list of reports in the Business Objects 'Public Folders', refresh those documents via the web, and if desired, save them to your desktop as Excel or pdf files. The 'Public Folders' are listed in InfoView when you navigate to 'Document List.' You will only be able to view or use reports in the public folders that you have access to. Documents should be renamed and saved to your own 'My Favorites' folder on the portal if you need to edit them using Webi. Documents can only be edited in Webi when placed in your 'My Favorites' folder.

Corporate Reports available in the Public folders in InfoView:

ACAD - matriculation, retention, TTD, graduation and attrition for a Grad group
For the specified Graduate Group, for students entering in the specified years, this report shows average Years in degree pursual, compares the Grad Group to the Cluster (clusters are groupings of similar academic areas), and shows a breakdown of students in the specified cohorts by ethnicity/citizenship, sex and age. Report prompts are for a range of entry years, degree, and graduate group. There are other reports in this same folder that retrieve similar data for a specified school, and also university-wide. Uses STDTCANQ universe. Requires “Provost Office Academic Reports” access request e-form.

Count Students as of Today
The report uses the warehouse data that is refreshed nightly from SRS. It contains detail and summary report tabs on students who are active as of the term specified when the report is executed. "Active" is defined as not exited as of the term specified, and not on leave of absence. The prompts are for a term and a divison. More than one division may be selected from the list of values, and it is an optional prompt: if no division is selected, the report will return data for all divisions for the selected term. The version number in the report title refers to the document revision number. Uses STDTCANQ universe.

Count Students with Tuition Billed   
To run this report you must have access to Student and BRS data. The report contains billing detail and summary report tabs on students who are active as of the term specified when the report is executed, who have been billed for tuition for the term. "Active" is defined as not exited as of the term specified, and not on leave of absence. Upon refresh, indicate the "BRS Detail" context, then answer the prompts for term and division or divisions.  The version number in the report title refers to the document revision number. Uses BRS_Combined universe.

Count PhD Students with Tuition Funded
To run this report you must have access to Student and BRS data. The report contains billing detail and summary report tabs on students who are active as of the term specified when the report is executed. "Active" is defined as not exited as of the term specified, and not on leave of absence. Upon refresh, indicate the "BRS Detail" context, then answer the prompts for term and division or divisions. Uses BRS_Combined universe.

Count Students with no Tuition Bill
To run this report you must have access to Student and BRS data. The report contains billing detail and summary report tabs on students who are active as of the term specified when the report is executed, and have not been billed for tuition for the term. "Active" is defined as not exited as of the term specified, and not on leave of absence. Upon refresh, answer the prompts for term and division or divisions.  The version number in the report title refers to the document revision number.  Uses custom SQL rather than a specific universe.

Count Students as of Fall 2011 census snapshot
This report should NOT be refreshed!  This is a snapshot of the Count Students as of Today report, taken on October 22, 2011, following the creation of the Fall 2011 Student Term Census extract. This report contains data elements not included in the SDDTTERM universe or the Public report “Count Students as of Census“. Uses STDTCANQ universe.

CIT_code report to schools
Courses InTouch (CIT) information about instructors and their CIT codes, as assigned in SRS. Uses STDTCANQ universe.

Classlst
Basic list of attendees in a specified course section.  Not to be used for cross listed courses. Uses STDTCANQ universe.

Course-CrseNum-Instructor
To list all courses within a range of course numbers for specific terms, with the instructor information. In addition, it provides basic enrollment information plus enrollment planning statistics. Users can also specify the TUITION_SCHOOL of interest, or use % as the wildcard to represent all non null TUITION_SCHOOLs at Penn. Uses STDTCANQ universe.

Course-CrseNum-Meeting
To list all courses within a range of course numbers for specific terms, with the building, room, days, and time. In addition, it shows enrollment. Users can also specify the TUITION_SCHOOL of interest, or use % as the wildcard to represent all non null TUITION_SCHOOLs at Penn. Uses STDTCANQ universe.

Course-Division-Instructor
To list all courses by division (where division is coded) for specific terms, with the instructor information. In addition, it provides basic enrollment data plus enrollment planning statistics. Users can also specify the SUBJECT_AREA of interest, or use % as the wildcard to represent all SUBJECT_AREAs within the division. Uses STDTCANQ universe.

Course-Division-Meeting
To list all courses by division (where division is coded) for specific terms, with the building, room, days, and time. In addition, it shows enrollment. Users can also specify the SUBJECT_AREA of interest, or use % as the wildcard to represent all SUBJECT_AREAs within the division. Uses STDTCANQ universe.

Course-Meeting
To list all courses for specific terms, with the building, room, days, and time. In addition, it shows enrollment. Users can specify the SUBJECT_AREA of interest, or use % as the wildcard to represent all SUBJECT_AREAs at Penn. Uses STDTCANQ universe.

Course-SectionNum-Instructor
To list all courses in a specified range of section numbers for specific terms, with the instructor information. In addition, it provides basic enrollment information plus enrollment planning statistics. Users can also specify the TUITION_SCHOOL of interest, or use % as the wildcard to represent all non null TUITION_SCHOOLs at Penn. Uses STDTCANQ universe.

Course-SectionNum-Meeting
To list all courses in a specified range of section numbers for specific terms, with the instructor information. In addition, it provides basic enrollment information plus enrollment planning statistics. Users can also specify the TUITION_SCHOOL of interest, or use % as the wildcard to represent all non null TUITION_SCHOOLs at Penn. Uses STDTCANQ universe.

Course-SubjectArea-Instructor
To list all courses for specific terms, with the instructor information. In addition, it provides basic enrollment data plus enrollment planning statistics. Users can specify the SUBJECT_AREA of interest, or use % as the wildcard to represent all SUBJECT_AREAs at Penn. Uses STDTCANQ universe.

Course-SubjectArea-Meeting
To list all courses for specific terms, with the building, room, days, and time. In addition, it shows enrollment. Users can specify the SUBJECT_AREA of interest, or use % as the wildcard to represent all SUBJECT_AREAs at Penn.  Uses STDTCANQ universe.

Crosslist-multi
Lists enrollments in courses specified, including crosslisted sections.  Can be used to report on enrollments for a specific course id or for all courses in a specific subject area.  Uses STDTCANQ universe.

Crosslist-one
Lists students enrolled in a course, including all crosslisted enrollments, when the PRIMARY course section is specified.  Uses STDTCANQ universe.

Currently on Leave
The prompt is for a Division.  The query can be run for one or multiple Divisions.Student on leave are identified as anyone with an unresolved entry in the LEAVE table.  This means anyone who has an entry in that table, where the Actual Return from Leave is either null, or is a term greater than the current term.The current term uses Current Academic Term from the PRESENT PERIOD table.  Leave actions include the SRS actions LV, AL, FLThe major (or grad group) is from the Major Minor Term Last class, and looks at only the primary major. Uses STDTCANQ universe.

DECLMAJS
Prompts for major or minor , term, division, degree level.  Returns a list of major(s) or minors in the selected areas with their name, email address, classification, and, if applicable, dual degree and joint degree codes.  Uses STDTCANQ universe.

DEMG - Enrollment by term for a Grad Group
This report retrieves census enrollment counts of grad students in the specified Grad Group, sorted by demographic categories. Prompts are for an academic term and graduate group. There are other reports in this same folder that retrieve similar data for a specified school, and also university-wide. Uses STDTCANQ universe. Requires “Provost Office Academic Reports” access request e-form.

Diagnostics - course term problems
Finds potential problems with course term data. Uses STDTCANQ universe.

Diagnostics - dual and joint degree data problems
Finds people with a joint degree flag, but who do not have a dual program in the specified term. Uses STDTCANQ universe.

Diagnostics - problems with leave of absence exit term
Finds students whose leave information may have been entered incorrectly in SRS. Uses STDTCANQ universe.

Diagnostics - students who should have graduated
Finds students who were pursuing a degree, with an Expected Degree Term that is in the past but they never were graduated or exited from Penn. Uses STDTCANQ universe.

Dual degrees in a term
Uses SRS designations D (dual) and J (joint) to find students in multiple programs for a specified term. Uses STDTCANQ universe.

ENROLL by division
Lists all students for the specified division(s) in a specified term, who are enrolled.  Enrolled is defined as total term registered credit > 0. Uses STDTCANQ universe.

EXAM - Benchmark exams for a Grad Group
 Details on students taking qualifying exams, prelims and oral exams, for PhD students in a specified Grad Group. Prompts are for a range of admit years and a graduate group. The reports have multiple tabs showing Masters' final exam, Qualification and Prelim information and average time-to-exam, and Oral Defense dates. There is another report in this same folder that retrieves similar data university-wide. Uses STDTCANQ universe. Requires “Provost Office Academic Reports” access request e-form.

Faculty Load
After prompting the user for a SRS Term, this query will populate the Faculty Load Reports from the Student Data Warehouse. Uses “Faculty Load” universe.

Student Degree List
Lists students who are expecting to complete a degree in a user-specified division in a user-specified term. Uses STDTCANQ universe.

Students on Hold
Lists all students in a specified division or divisions in a specified term, who have any type of hold (registration or financial). The hold information is displayed on two reports:  Active, and Cleared holds.  On the Active hold tab, the effective term of the hold is displayed, and there is a flag indicating whether the student is on Leave for the selected term. Uses STDTCANQ universe.

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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