User Tools

Site Tools


sasixp:invalid_course_number_in_course_history

This is an old revision of the document!


Invalid Course Number in Course History

The following query will locate courses that exist in Course History but do not exist in the Course file.

DISPLAY ACHS ACRS CrsTitle 1,Course UF 2,Course IF 1,Course <> 2,Course SORT 1,Course

Note: Link ACRS by clicking and draging the Course field from the ACHS column. Ensure you select the Show Empty Records and Show Inactive Records checkboxes. The UF stnads for unique and prints each course one time.

sasixp/invalid_course_number_in_course_history.1170427080.txt.gz · Last modified: 2007/02/06 08:25 (external edit)