Select a Semester SQL: SELECT DISTINCT t.TextTerm + case when SUBSTRING(t.textterm,1,2) = 'FA' then ' (Fall Semester)' when SUBSTRING(t.textterm,1,2) = 'SP' then ' (Spring Semester)' when SUBSTRING(t.textterm,1,2) = 'SU' then ' (Summer Semester)' when SUBSTRING(t.textterm,1,4) = 'DCSP' then ' (Spring Semester)' when SUBSTRING(t.textterm,1,4) = 'DCFA' then ' (Fall Semester)' when SUBSTRING(t.textterm,1,4) = 'DCSU' then ' (Summer Semester)' else '' end as TextTerm, t.term, t.TermCalendarID, case when C.TermCalendarID is null then 0 else 1 end as Ord FROM TermCalendar t Inner JOIN Admin.dbo.EUIP e ON t.TermCalendarID = e.Num_1 AND e.AppID = 'CATALOG' Inner JOIN SROffer o ON t.TermCalendarID = o.TermCalendarID AND o.CampusID = ? Left Join EUCurrentSemesters_View C on C.TermCalendarID = O.TermCalendarID ORDER BY 4 Param(0): 3 SU-10 (Summer Semester) FA-10 (Fall Semester)
SQL: SELECT DISTINCT t.TextTerm + case when SUBSTRING(t.textterm,1,2) = 'FA' then ' (Fall Semester)' when SUBSTRING(t.textterm,1,2) = 'SP' then ' (Spring Semester)' when SUBSTRING(t.textterm,1,2) = 'SU' then ' (Summer Semester)' when SUBSTRING(t.textterm,1,4) = 'DCSP' then ' (Spring Semester)' when SUBSTRING(t.textterm,1,4) = 'DCFA' then ' (Fall Semester)' when SUBSTRING(t.textterm,1,4) = 'DCSU' then ' (Summer Semester)' else '' end as TextTerm, t.term, t.TermCalendarID, case when C.TermCalendarID is null then 0 else 1 end as Ord FROM TermCalendar t Inner JOIN Admin.dbo.EUIP e ON t.TermCalendarID = e.Num_1 AND e.AppID = 'CATALOG' Inner JOIN SROffer o ON t.TermCalendarID = o.TermCalendarID AND o.CampusID = ? Left Join EUCurrentSemesters_View C on C.TermCalendarID = O.TermCalendarID ORDER BY 4 Param(0): 3
Report Type Course Schedule List Closed Class List
Select a Department All Behavioral Sci Dept Business Dept Communications Dept DC - Business Administration Dept DC - Communication Dept DC - General Studies DC - Human Services Dept Education Dept General Studies Grad - Education Dept Grad - Organizational Leadership Dept Grad - Psychology Dept Grad - School Counseling Dept Humanities Dept Leadership and Service Dept Music Dept Physical Educ Dept Science and Technology Dept Social Science Dept Theology Dept
Select a Class Type All Lecture Lab Online Class
Order by Department, Course Date, Course Number Course Date, Department, Course Number Course Number
Reset