Versions Compared

Old Version 1

changes.mady.by.user Patrick Ackerman

Saved on

compared with

New Version Current

changes.mady.by.user Patrick Ackerman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Panel

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