Course Detail


SELECT A.*, decode(PRIM_INSTR_NAME, 'NAME NOT FOUND FOR PIDM: ', 'Staff', PRIM_INSTR_NAME) INST_NAME FROM CVTC_CRSE_SECT_NEW A, SSRMEET WHERE TERM_CODE_KEY like '%' AND SSRMEET_TERM_CODE like '%' AND SSRMEET_CRN like CRN_KEY AND SSRMEET_ROOM_CODE = '' AND SSRMEET_BLDG_CODE = '' AND ('' between SSRMEET_BEGIN_TIME and SSRMEET_END_TIME) ORDER BY PTRM_START_DATE;

SELECT slbevnt_crn, slbevnt_desc, e1.* FROM CVTC_CRSE_SECT_NEW, slbevnt, SSRMEET e1 where e1.ssrmeet_term_code = 'EVENT' and e1.ssrmeet_room_code = '' and e1.ssrmeet_bldg_code = '' AND (sysdate + -5) between SSRMEET_START_DATE and (SSRMEET_END_DATE+1) and slbevnt_crn = e1.ssrmeet_crn and term_code_key = 'EVENT' and crn_key = e1.ssrmeet_crn;
Course Title
(Click for Description)
Course Number CRN Start Date
End Date
Days Time #
Weeks
Credit Building/
Room
Instructor


Home | Welcome Center | Getting Started | Registration & Records | Programs & Courses | Services/Resources
Business & Industry | Alumni & Foundation | VISTA | Employment | Library | SIS | Search | Contact Us



620 W. Clairemont Ave. Eau Claire, WI  54701 USA
Phone: (715) 833-6200    Toll-free: 1-800-547-CVTC    Fax: (715) 833-6470

For web related questions and comments contact the Webmaster