Return to Navigation

Student Records Reports: A-Z

This table lists the Student Records reports, sorted alphanumerically by report ID. The reports listed are Crystal and SQR reports.

See the product documentation for PeopleTools: Process Scheduler

Note: On June 1, 2011, Oracle discontinued distribution of SAP’s Business Objects Enterprise and Crystal Reports with PeopleTools. Existing customers may use Business Objects Enterprise and Crystal Reports licenses previously received from Oracle. Customers who wish to use future versions of Business Objects and Crystal Reports products with PeopleSoft will need to obtain appropriate license and support directly from SAP/Business Objects.

Report ID and Report Name

Description

Navigation

Run Control Page

CCDATADC

Data Dictionary

Lists all the fields in your database with their basic information, including field name, description, filed type, field size and field format.

Reporting Tool: SQR

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Data Dictionary

PRCSRUNCNTL

SR201

Schedule of Classes

Lists a variety of details for each class that you schedule.

Reporting Tool: SQR

select Curriculum Management, then select Schedule of Classes, then select Print Class Schedule

RUNCTL_SRYSCHD

SR301

Course Catalog

Generates the Course Catalog report based on the selection criteria and report options you specify at runtime.

Reporting Tool: SQR

select Curriculum Management, then select Course Catalog, then select Print Course Catalog

RUNCTL_SRYCATLG

SR704

Academic Level / Load Rule

Generates a report of the Level Load Rule Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Reports, then select Level Load Rule Table

PRCSRUNCNTL

SR704A

Academic Level

Generates a report of the Academic Level Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Reports, then select Academic Level Tbl

PRCSRUNCNTL

SR704B

Academic Load

Generates a report of the Academic Load Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Reports, then select Academic Load Tbl

PRCSRUNCNTL

SR705A

Grade Basis Exception Mapping Detail

Generates a report for Grade Basis mapping Detail.

Reporting Tool: Crystal

select Set Up SACR, then select Products Related, then select Student Records, then select Reports, then select Grade Basis Map Detail

PRCSRUNCNTL

SR706

Degree

Generates a report of the Degree Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Academic Structure, then select Reports, then select Degree Table

PRCSRUNCNTL

SR711

Degree Honors

Generates a report of the Degree Honors Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Degree Honors Table

PRCSRUNCNTL

SR712

External Subject

Lists all the external subjects defined in your PeopleSoft system, including effective date and descriptions, as defined on the External Subject Table page.

Reporting Tool: Crystal

select Set Up SACR, then select Common Definitions, then select Reports, then select External Subject Table

PRCSRUNCNTL

SR713

External Term

Lists all the external terms defined in your PeopleSoft system, including detail about each external term, as defined on the External Term page.

Reporting Tool: Crystal

select Set Up SACR, then select Common Definitions, then select Reports, then select External Term Table

PRCSRUNCNTL

SR714

Extracurricular Activity

Lists all the extracurricular activities defined in your PeopleSoft system, including detail about each extracurricular activity, as defined on the Extracurricular Activity Table page.

Reporting Tool: Crystal

select Set Up SACR, then select Common Definitions, then select Reports, then select Extra Activity Table

PRCSRUNCNTL

SR716

Program Action

Lists all the program actions defined in your PeopleSoft system, including effective date and descriptions, as defined on the Program Action Table page.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Program Action

PRCSRUNCNTL

SR717

Academic Program Action Reason

Lists, by setID, all the program actions reasons defined in your PeopleSoft system, including effective date, descriptions, and associated program actions. This report references fields as defined on the Program Action Reason Table page.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Program Reason Table

PRCSRUNCNTL

SR718

Enrollment Reason

Lists, by setID and academic career, all the enrollment reasons defined in your PeopleSoft system, including detail about each enrollment reason. This report references fields as defined on the Enrollment Action Reason Table page.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Enrollment Reason Table

PRCSRUNCNTL

SR719

Exam Code

Generates a report for the Exam Code Table.

Reporting Tool: Crystal

select Curriculum Management, then select Schedule of Classes, then select Exam Code Table Report

PRCSRUNCNTL

SR720

Requirement Designation

Generates a report for Requirement Designation Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Requirement Designation Table

PRCSRUNCNTL

SR727

Instructor / Advisor

Generates a report for Instructor/Advisor Table.

Reporting Tool: Crystal

select Curriculum Management, then select Instructor/Advisor Information, then select Instructor / Advisor Report

PRCSRUNCNTL

SR727A

Instructor Advisor Role

Generates a report for Instructor Advisor Role Table.

Reporting Tool: Crystal

select Curriculum Management, then select Instructor/Advisor Information, then select Instructor/Advisor Role Table

PRCSRUNCNTL

SR733

Grading Scheme

Generates a report of the grading scheme table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Repeat Scheme Table

PRCSRUNCNTL

SR733A

Grading Basis

Generates a report of the grade basis table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Grading Basis Table

PRCSRUNCNTL

SR733B

Grade Table

Generates a report of the Grade Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Grade Table

PRCSRUNCNTL

SR733C

Grade Basis Choice

Generates a report of the Grade Basis Choice Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Grade Basis Choice

PRCSRUNCNTL

SR734

Facility

Generates a report of the Facility Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Facilities, then select Reports, then select Facility Table

PRCSRUNCNTL

SR734A

Facility Component

Generates a report of the Facility Component Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Facilities, then select Reports, then select Facility Component

PRCSRUNCNTL

SR734B

Facility Characteristics

Generates a report of the Facility Characteristic Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Facilities, then select Reports, then select Facility Characteristic Table

PRCSRUNCNTL

SR735

Room Characteristic

Generates a report of the Room Characteristic Table.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Facilities, then select Reports, then select Room Characteristic Tbl.

PRCSRUNCNTL

SR739

Term Type

Lists, by setID, all the term types defined in your PeopleSoft system, including effective date and description.

Reporting Tool: Crystal

select Set Up SACR, then select Foundation Tables, then select Term Setup, then select Reports, then select Term Type Table

PRCSRUNCNTL

SR739A

Unit Conversion

Generates a report of the Unit Conversion Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Unit Conversion Table

PRCSRUNCNTL

SR740

Repeat Scheme

Generates a report of the Repeat Scheme Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Repeat Scheme Table

PRCSRUNCNTL

SR740A

Repeat Code

Generates a report of the Repeat Code Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Repeat Code Table

PRCSRUNCNTL

SR741

Class Notes Table

Generates a report of the Class Notes Table.

Reporting Tool: Crystal

select Curriculum Management, then select Schedule of Classes, then select Class Notes Table Report

PRCSRUNCNTL

SR742

Course Attribute

Generates a report of the Course Attribute Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Course Attribute Table Report

PRCSRUNCNTL

SR742A

Course Attribute Value

Generates a report of the Course Attribute Value Table.

Reporting Tool: Crystal

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Course Attribute Value Report

PRCSRUNCNTL

SR743

Global Notes

Generates a report of the Global Notes Table.

Reporting Tool: Crystal

select Curriculum Management, then select Schedule of Classes, then select Global Notes Table Report

PRCSRUNCNTL

SR744

Class Notes

Generates a report for Class Notes.

Reporting Tool: Crystal

select Curriculum Management, then select Schedule of Classes, then select Class Notes Report

PRCSRUNCNTL

SR775

Study List Report

Generates student study lists by term, academic career, and academic program or group.

Reporting Tool: Crystal

select Curriculum Management, then select Enrollment Summaries, then select Student Study List Report

RUNCTL_SRSTDYLST

SR776

Grade

Lists all data related to a student's career and term grades, including units taken, units earned, grading basis, official grade, and enrollment totals.

Reporting Tool: Crystal

select Curriculum Management, then select Grading, then select Student Grade Report

RUNCTL_SRGRDRPT

SR776P

Grade

Generates the Grade Report from Process button. Lists all data related to a student's career and term grades, including units taken, units earned, grading basis, official grade, and enrollment totals.

Reporting Tool: Crystal

select Records and Enrollment, then select Student Term Information, then select Student Grades

STDNT_GRADE_INQ

SR777

Transcript

A singular advisement report, or a singular transcript report. The transcript type you specify at runtime determines which format the system uses (advisement or transcript).

The advisement report is the degree audit report that reflects a student's progress towards graduation. This report is the core function of the Academic Advisement application.

The transcript report reflects a student's course work, organized chronologically or by term. This report is used primarily by the Student Records application.

Reporting Tool: Crystal

select Records and Enrollment, then select Transcripts, then select Transcript Request, then select Report Results

SA_REPORT_RESULTS

SR800CA

Class Attendance

Generates the Class Attendance Report. This is a useful tool for hard-copy attendance tracking.

Reporting Tool: Oracle BI Publisher

select Curriculum Management, then select Class Attendance, then select Attendance Roster by Class

CLASS_ATTENDANCE

SR802

Enrollment Verification

Generates an enrollment verification report for individual students.

Reporting Tool: Crystal

select Records and Enrollment, then select Enrollment Verifications, then select Enrollment Verification

ENRL_VER_REQUEST

SR803

Printing Enrollment Ver. - Bat

Generates the enrollment verification reports in batch. Each report prints in alphabetical order by the student's name (last name, first name) and displays data according to the criteria selected on the Enrollment Verification Req component.

Reporting Tool: Crystal

select Records and Enrollment, then select Enrollment Verifications, then select Enrollment Verification Print

RUNCTL_ENRL_VER

SR804

Print Errors for Enrl Ver Bat

Lists errors that the enrollment verification process encounters due to student's having negative service indicators.

Reporting Tool: Crystal

select Curriculum Management, then select Enrollment Verification, then select Enrollment Verification Print

RUNCTL_ENRL_VER

SR805

Graduation Report

Lists all current degree checkout status data for all students in your selected population, including ID, career, program, plan, subplan, degree, status, expected graduation term and completion term data. (SQR process, Crystal report)

select Records and Enrollment, then select Graduation, then select Graduation Report

RUNCTL_GRAD_RPT

SRCLSRST

Class Roster

Generates a report of students enrolled in a particular class, including name, grading basis, units taken, primary academic program, and enrollment status. If requested, this report also lists class permissions information.

Reporting Tool: SQR

select Curriculum Management, then select Class Roster, then select Class Roster

RUNCTL_SRCLASSRSTR

SRENRADV

Enrollment Advisement

Generates an Enrollment Advisement report.

Reporting Tool: SQR

select Curriculum Management, then select Enrollment Requirements, then select Enrollment Advisement Report

RUNCTL_SRENRADV

SREXSCHD

Exam Scheduling

Lists each course's scheduled exam time and facility.

Reporting Tool: SQR

select Curriculum Management, then select Schedule of Classes, then select Generate Exam Schedule

RUNCTL_SREXSCHD

SRGBEXPT

Grading Basis Exception

Displays active grade basis exception mapping rules and their details.

Reporting Tool: SQR

select Set Up SACR, then select Product Related, then select Student Records, then select Reports, then select Grade Basis Exception

RUNCTL_SRGBEXCPT

SRGRDLPS

Grade Lapse

Lists parameter information and enrollment request numbers for all lapsed grade processes.

Reporting Tool: SQR

select Curriculum Management, then select Grading, then select Grade Lapse

RUNCTL_SR_GRD_LPS

SRLMSEX

LMS Batch Extract

Lists high level information about a specific extract process. Detail such as setup values, run control parameters, output file formats, and total record counts referenced by a specific extract process are listed on the report. The report does NOT list the extracted data and is not to be confused with the actual extract file(s). To view the extracted data you must view the extract file itself.

Reporting Tool: SQR

select Curriculum Management, then select Learning Management Systems, then select LMS Batch Extract Process

RUNCTL_SRLMSEX3

SRNSLCEX

NSLC Extract File Creation

Generates a report for National Student Clearinghouse (NSLC). This report lists run variables, informational messages about the process run, and NSLC report totals.

Reporting Tool: SQR

select Records and Enrollment, then select Enrollment Reporting, then select NSLC Report

RUNCTL_SRNSLC

SRRSTRPT

Grade Roster

Generates a report of the grade roster that instructors can use to write their midterm or final grades, or administrators can use to print out hard copies of the final grades for classes.

Reporting Tool: SQR

select Curriculum Management, then select Grading, then select Print Grade Roster

RUNCTL_SRGRDROSTER

SRSPRMSN

Class Permission

Generates a report that lists the number of class permissions assigned for each class.

Reporting Tool: SQR

select Records and Enrollment, then select Term Processing, then select Class Permissions, then select Class Permissions

RUNCTL_SRSPRMSN

SRSTDNT2

Study List

Generates an individual student's study list by academic career and term.

Reporting Tool: SQR

select Records and Enrollment, then select Enrollment Summaries, then select Enrollment Summary

STDNT_ENRL_INQ

SRTCSTEV

Student Transfer Evaluation

Lists an individual's transfer credit record. The report is designed in an easy-to-read format intended to be distributed to prospects, applicants, students, recruiters, or advisors. They can see what classes transferred and to which equivalent classes. They can also view their internal and external GPAs.

Reporting Tool: SQR

select Records and Enrollment, then select Transfer Credit Evaluation, then select Transfer Evaluation Report

RUNCTL_SR_TRCR_RPT

SRTRMDF

Mid-Term Deficiency Summary

Lists students that have deficient mid term grades for the term you specify.

Reporting Tool: SQR

select Curriculum Management, then select Grading, then select Mid-Term Deficiency Report

RUNCTL_SRTRMDEFCNY

SRTRPRNT

Advisement Report or Transcript report

Generates advisement reports for a transcript request, or all transcripts for a transcript request. The transcript type you specify at runtime determines which format the system uses (advisement or transcript).

The advisement report is the degree audit report that reflects a student's progress towards graduation. This report is the core function of the Academic Advisement application.

The transcript report reflects a student's course work, organized chronologically or by term. This report is used primarily by the Student Records application.

Reporting Tool: SQR

select Records and Enrollment, then select Transcripts, then select Batch Transcripts, then select Transcript Print

RUNCTL_SRTRPRINT

SRWORKLD

Workload Copy and Recalc

Generates a report of part time and full time instructors that are over or under the allowed workload assignment.

Reporting Tool: SQR

select Curriculum Management, then select Roll Curriculum Data Forward, then select Copy/Update Workload Process

RUNCTL_WORKLD

SRWORKLD

Workload Copy and Update

Lists workload data for individuals who fall into one of six reporting categories.

Reporting Tool: SQR

select Curriculum Management, then select Roll Curriculum Data Forward, then select Update Classes w/Ctgl Changes

RUNCTL_WORKLD