Versions Compared

Old Version 1

changes.mady.by.user Tabassum Lodhi

Saved on

compared with

New Version Current

changes.mady.by.user Tabassum Lodhi

Saved on

Key

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

 
 
SELECT C.LAST_NAME, C.FIRST_NAME, C.MIDDLE_NAME, A.EMPLID, D.ACAD_CAREER, C.PHONE, C.EMAIL_ADDR, D.SUBJECT, D.CATALOG_NBR, D.SESSION_CODE, D.CLASS_SECTION, D.DESCR, D.UNT_TAKEN, D.CRSE_GRADE_OFF,D.EMPLID,D.INSTITUTION,D.STRM,D.CLASS_NBR
FROM PS_STDNT_GRPS_HIST A, PS_TERM_TBL B, PS_CU_BIO_VW C, PS_CLASS_TBL_SE_VW D
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_STDNT_GRPS_HIST A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.STDNT_GROUP = A_ED.STDNT_GROUP
AND A_ED.EFFDT <= B.TERM_BEGIN_DT)
AND A.INSTITUTION = B.INSTITUTION
AND A.INSTITUTION = :1
AND A.STDNT_GROUP = :2
AND B.STRM = :3
AND A.EFF_STATUS = 'A'
AND A.EMPLID = C.EMPLID
AND A.EMPLID = D.EMPLID
AND A.INSTITUTION = D.INSTITUTION
AND D.ACAD_CAREER = B.ACAD_CAREER
AND D.STRM = B.STRM
AND D.STDNT_ENRL_STATUS = 'E'
AND substr ( D.CRSE_GRADE_OFF, 1, 1) = 'W'
ORDER BY 1, 2, 3