Unused Course Detail window

This window is used to list the courses that were not used by compliance to satisfy CAPP requirements. Records are sorted by term, subject, course, and source. The data is display only, but you can navigate through the window to query on fields as needed. All fields are queryable.

Basic course data is displayed for each record including the grade, grade mode and repeat status. The window scrolls to display additional fields for hours, GPA, and transfer information.

The GPA related values are derived from the GPA for the unused course from the SHRGRDE table. This includes the combination of course, term, grade, grade mode, and level.
Registration attempted hours and credit hours for unused in-progress courses come from the SFRSTCR table.
Sequence numbers for the transfer institution, attendance period, and equivalence records come from the SHRTRCE table. These sequence numbers identify unused transfer courses.

Click on the Reject Reason button for the record or use Duplicate Record to open the Rejection Reason window and view the rejection reason for the course. The Reject Reason button is active when the rejection reason exists. The rejection reason is created when compliance is run. When the button is not active, the course was not used by CAPP, and no rejection reason was generated by compliance.

Fields	Descriptions
The following fields are in the Unused Course Data information.
Source	Source of the unused course. Values are R (Registration), T (Transfer History), or H (Institutional History).
Term	Term in which the unused course was offered. Use the Select button or Duplicate Record to view rejection reason details for the record.
Subject	Subject of the unused course.
Course	Course number of the unused course.
Credits	Credit hours associated with the unused course.
Grade	Grade assigned to the unused course.
Grading Mode	Grading mode for the unused course.
Level	Level of the unused course.
Campus	Campus of the unused course.
Repeat	Indicator that identifies how the GPA data for the unused course was applied for repeat processing. Valid values are E (Exclude), A (All), or I (Include).
Course Title	Title of the unused course.
CRN	CRN of the unused course, for institutional courses. The CRN is either assigned to the course when the section is created for the term or when the course is created on SHATCKN. The value comes from the SHRTCKN table.
The following fields are in the Unused Courses Hours, GPA, and Transfer information.
Attempted Hours	Hours attempted for the unused course, stored in academic history.
Passed Hours	Hours passed for the unused course, stored in academic history.
Earned Hours	Hours earned for the unused course, stored in academic history.
GPA Hours	Hours used for GPA calculation for the unused course, stored in academic history.
Quality Points	Quality points for the unused course, based on the grade in academic history.
GPA	Grade Point Average for the unused course, stored in academic history.
Transfer Institution	Sequence number of the transfer institution for a transferred unused course in academic history.
Transfer Attendance Period	Sequence number of the attendance period assigned to a transferred unused course in academic history.
Transfer Equivalence Sequence	Sequence number of the used transfer equivalent course.
Transfer Sequence Number	Sequence number of the transferred course record for the transfer institution and attendance period.
Registration Hours Attempted	Attempted hours in Registration for an unused in-progress course. Values come from SFRSTCR.
Registration Credit Hours	Credit hours assigned in Registration for an unused in-progress course. Values come from SFRSTCR.
Used	Displays Y for used courses or N for unused courses, based on the setting of the `SHRSAPP_TYPE_IND` column.

Mouse	Keyboard	Result
Reject Reason	Duplicate Record	Opens Rejection Reason window