Appendix: Student Records Reports

This appendix provides an overview of Student Records reports and enables you to:

Note. For samples of these reports, see the Portable Document Format (PDF) files published on CD-ROM with your documentation.

See Also

Enterprise PeopleTools PeopleBook: PeopleSoft Process Scheduler

Click to jump to top of pageClick to jump to parent topicStudent Records Reports: A-Z

This table lists the Student Records reports, sorted alphanumerically by report ID. The reports listed are Crystal and SQR reports. If you need more information about a report, refer to the report details at the end of this appendix.

Report ID and Report Name

Description

Navigation

Run Control Page

SR201

Schedule of Classes

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

Curriculum Management, Schedule of Classes, Print Class Schedule

RUNCTL_SRYSCHD

SR301

Course Catalog

Generates the Course Catalog report based on the selection criteria and report options you specify at run time. (SQR)

Curriculum Management, Course Catalog, Print Course Catalog

RUNCTL_SRYCATLG

SR704

Academic Level / Load Rule

Generates a report of the Level Load Rule Table. (Crystal)

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

PRCSRUNCNTL

SR704A

Academic Level

Generates a report of the Academic Level Table. (Crystal)

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

PRCSRUNCNTL

SR704B

Academic Load

Generates a report of the Academic Load Table. (Crystal)

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

PRCSRUNCNTL

SR705A

Grade Basis Exception Mapping Detail

Generates a report for Grade Basis mapping Detail. (Crystal)

Set Up SACR, Products Related, Stduent Records, Reports, Grade Basis Map Detail

PRCSRUNCNTL

SR706

Degree

Generates a report of the Degree Table. (Crystal)

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

PRCSRUNCNTL

SR711

Degree Honors

Generates a report of the Degree Honors Table. (Crystal)

Set Up SACR, Product Related, Student Records, Reports, 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. (Crystal)

Set Up SACR, Common Definitions, Reports, 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. (Crystal)

Set Up SACR, Common Definitions, Reports, 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. (Crystal)

Set Up SACR, Common Definitions, Reports, 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. (Crystal)

Set Up SACR, Product Related, Student Records, Reports, 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. (Crystal)

Set Up SACR, Product Related, Student Records, Reports, 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. (Crystal)

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

PRCSRUNCNTL

SR719

Exam Code

Generates a report for the Exam Code Table. (Crystal)

Curriculum Management, Schedule of Classes, Exam Code Table Report

PRCSRUNCNTL

SR720

Requirement Designation

Generates a report for Requirement Designation Table. (Crystal)

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

PRCSRUNCNTL

SR727

Instructor / Advisor

Generates a report for Instructor/Advisor Table. (Crystal)

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

PRCSRUNCNTL

SR727A

Instructor Advisor Role

Generates a report for Instructor Advisor Role Table. (Crystal)

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

PRCSRUNCNTL

SR733

Grading Scheme

Generates a report of the grading scheme table. (Crystal)

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

PRCSRUNCNTL

SR733A

Grading Basis

Generates a report of the grade basis table. (Crystal)

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

PRCSRUNCNTL

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.

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

PRCSRUNCNTL

SR733B

Grade Table

Generates a report of the Grade Table. (Crystal)

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

PRCSRUNCNTL

SR733C

Grade Basis Choice

Generates a report of the Grade Basis Choice Table. (Crystal)

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

PRCSRUNCNTL

SR734

Facility

Generates a report of the Facility Table. (Crystal)

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

PRCSRUNCNTL

SR734A

Facility Component

Generates a report of the Facility Component Table. (Crystal)

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

PRCSRUNCNTL

SR734B

Facility Characteristics

Generates a report of the Facility Characteristic Table. (Crystal)

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

PRCSRUNCNTL

SR735

Room Characteristic

Generates a report of the Room Characteristic Table. (Crystal)

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

PRCSRUNCNTL

SR739

Term Type

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

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

PRCSRUNCNTL

SR739A

Unit Conversion

Generates a report of the Unit Conversion Table. (Crystal)

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

PRCSRUNCNTL

SR740

Repeat Scheme

Generates a report of the Repeat Scheme Table. (Crystal)

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

PRCSRUNCNTL

SR740A

Repeat Code

Generates a report of the Repeat Code Table. (Crystal)

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

PRCSRUNCNTL

SR741

Class Notes Table

Generates a report of the Class Notes Table. (Crystal)

Curriculum Management, Schedule of Classes, Class Notes Table Report

PRCSRUNCNTL

SR742

Course Attribute

Generates a report of the Course Attribute Table. (Crystal)

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

PRCSRUNCNTL

SR742A

Course Attribute Value

Generates a report of the Course Attribute Value Table. (Crystal)

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

PRCSRUNCNTL

SR743

Global Notes

Generates a report of the Global Notes Table. (Crystal)

Curriculum Management, Schedule of Classes, Global Notes Table Report

PRCSRUNCNTL

SR744

Class Notes

Generates a report for Class Notes. (Crystal)

Curriculum Management, Schedule of Classes, Class Notes Report

PRCSRUNCNTL

SR750

External Transfer Rules Rules

Generates a report for External Transfer Rules table. (Crystal)

Records and Enrollment, Transfer Credit Rules, External Transfer Rules Report

PRCSRUNCNTL

SR750A

External Transfer Component

Generates a report for External Transfer Component table. (Crystal)

Records and Enrollment, Transfer Credit Rules, Transfer Component Report

PRCSRUNCNTL

SR750C

Transfer Equivalency Rules

Lists all the transfer equivalency rules that have been defined in your PeopleSoft Campus Solutions system for a given academic institution (as defined on the Course Transfer Rules page), including detailed information about each rule. The data for this report can also be viewed using the Course Transfer Rules component. (Crystal)

Records and Enrollment, Transfer Credit Rules, Transfer Rules by Org Report

RUNCTL_SR_TRCRRUL1

SR750D

Transfer Subject Areas

Lists all the component subject areas that have been defined in your PeopleSoft Campus Solutions system (on the Transfer Subject Area component), including detailed information about each component subject area. (Crystal)

Records and Enrollment, Transfer Credit Rules, Transfer Subject by Org Report

RUNCTL_SR_TRCRRUL1

SR775

Study List Report

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

Curriculum Management, Enrollment Summaries, 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. (Crystal)

Curriculum Management, Grading, 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. (Crystal)

Records and Enrollment, Student Term Information, Student Grades

STDNT_GRADE_INQ

SR777

Transcript

A singular advisement report, or a singular transcript report. The transcript type you specify at run time 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.

(Crystal)

Records and Enrollment, Transcripts, Transcript Request, Report Results

SA_REPORT_RESULTS

SRVETRPJ

Veterans Report Job

Lists all students within a specified academic institution and academic statistics period that are receiving Veterans benefits. (Crystal)

Records and Enrollment, Enrollment Reporting, Veterans Report

RUNCTL_SRVETRPT

SR800CA

Class Attendance

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

Curriculum Management, Class Attendance, Attendance Roster by Class

CLASS_ATTENDANCE

SR802

Enrollment Verification

Generates an enrollment verification report for individual students. (Crystal)

Curriculum Management, Enrollment Verification, 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. (Crystal)

Curriculum Management, Enrollment Verification, 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. (Crystal)

Curriculum Management, Enrollment Verification, 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)

Records and Enrollment, Graduation, Graduation Report

RUNCTL_GRAD_RPT, RUNCTL_GRAD_RPT2

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. (SQR)

Curriculum Management, Class Roster, Class Roster

RUNCTL_SRCLASSRSTR

SRENRADV

Enrollment Advisement

Generates an Enrollment Advisement report. (SQR)

Curriculum Management, Enrollment Requirements, Enrollment Advisement Report

RUNCTL_SRENRADV

SREXSCHD

Exam Scheduling

Lists each course’s scheduled exam time and facility. (SQR)

Curriculum Management, Schedule of Classes, Generate Exam Schedule

RUNCTL_SREXSCHD

SRGBEXPT

Grading Basis Exception

Displays active grade basis exception mapping rules and their details. (SQR)

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

RUNCTL_SRGBEXCPT

SRGRDLPS

Grade Lapse

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

Curriculum Management, Grading, 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. (SQR)

Curriculum Management, Learning Management Systems, 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. (SQR)

Records and Enrollment, Enrollment Reporting, 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. (SQR)

Curriculum Management, Grading, Print Grade Roster

RUNCTL_SRGRDROSTER

SRSPRMSN

Class Permission

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

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

RUNCTL_SRSPRMSN

SRSTDNT2

Study List

Generates an individual student’s study list by academic career and term. (SQR)

Records and Enrollment, Enrollment Summaries, 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. (SQR)

Records and Enrollment, Transfer Credit Evaluation, Transfer Evaluation Report

SRTC_RPT_DTL_RSLT,

RUNCTL_SR_TRCR_RPT

SRTRMDF

Mid-Term Deficiency Summary

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

Curriculum Management, Grading, 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 run time 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.

(SQR)

Records and Enrollment, Transcripts, Batch Transcripts, 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. (SQR)

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

RUNCTL_WORKLD

SRWORKLD

Workload Copy and Update

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

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

RUNCTL_WORKLD

Click to jump to top of pageClick to jump to parent topicStudent Records Reports: Selected Reports

This section provides detailed information about individual reports including important fields and tables accessed. The reports are listed alphanumerically by report ID.

Click to jump to top of pageClick to jump to parent topicSRLMSEX - LMS Batch Extract Report

LMS Institution Table Setup Values

Reports the address usage, address usage description, and phone type specified on the Academic Institution 3 page.

Run Control

Reports the user ID, run control ID, institution, term, file type, and extract mode as specified on the LMS Extract - Setup page for this unique extract event.

Selection Criteria

Reports the option selected on the LMS Extract - Criteria page for this unique extract event. If Filter or Class Number is selected, the corresponding detail appears.

Output Files

Reports the extract file format. If the Combine File check box is selected on the LMS Extract - Output page, then a list of the files selected for extract and combining appear. If the Combine File check box is cleared on the LMS Extract - Output page, then the individual files selected for extraction and their individual file names and location appear.

Messages

Reports a warning when the extract process is unable to locate data that is required by a particular LMS type. For example, when extracting data to Blackboard CourseInfo, all students or “members” must have an email address specified on the Electronic Addresses page.

Total Records Count

Reports the number of people, group, and member records written to the extract file.