Used Course Detail window

This window is used to list the courses 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 used course from the SHRGRDE table. This includes the combination of course, term, grade, grade mode, and level.
Registration attempted hours and credit hours for used 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 used transfer courses.

Fields	Descriptions
The following fields are in the Used Course Data information.
Source	Source of the used course. Values are R (Registration), T (Transfer History), or H (Institutional History).
Term	Term in which the used course was offered.
Subject	Subject of the used course.
Course	Course number of the used course.
Credits	Credit hours associated with the used course.
Grade	Grade assigned to the used course.
Grading Mode	Grading mode for the used course.
Level	Level of the used course.
Campus	Campus of the used course.
Repeat	Indicator that identifies how the GPA data for the used course was applied for repeat processing. Valid values are E (Exclude), A (All), or I (Include).
Course Title	Title of the used course.
CRN	CRN of the used 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 Used Courses Hours, GPA, and Transfer information.
Attempted Hours	Hours attempted for the used course, stored in academic history.
Passed Hours	Hours passed for the used course, stored in academic history.
Earned Hours	Hours earned for the used course, stored in academic history.
GPA Hours	Hours used for GPA calculation for the used course, stored in academic history.
Quality Points	Quality points for the used course, based on the grade in academic history.
GPA	Grade Point Average for the used course, stored in academic history.
Transfer Institution	Sequence number of the transfer institution for a transferred used course in academic history.
Transfer Attendance Period	Sequence number of the attendance period assigned to a transferred used 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 a used in-progress course. Values come from SFRSTCR.
Registration Credit Hours	Credit hours assigned in Registration for a used 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.