Background and Use:
This data set was requested by Sherman Wong, Math, for use with the Webwork service. Data provided to Math department replaces EMPLID with AD ID and adds student email address.
See KACE ticket for request details
Results Sample
Query SQL:
SELECT A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.SESSION_CODE, A.CLASS_NBR, B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID,A.ACAD_CAREER,A.INSTITUTION,A.STRM
FROM PS_CLASS_TBL_SE_VW A, PS_CU_BIO_VW B
WHERE A.INSTITUTION = :1
AND A.STRM = :2
AND ( A.SUBJECT = :3
OR :3 IS NULL)
AND B.EMPLID = A.EMPLID
AND A.STDNT_ENRL_STATUS = 'E'
ORDER BY 1, 2, 4, 7, 8, 9