CU_BAR_SR_00077 - Real Estate Grad Students
There is new version of this query where Margo Weaker has requested to add more information about students. The version name is 'TAB_REALESTATE_NEW' which has not been copied to her yet. Once she confirm the report then it will be copied to her.
The excel file does include GPA, Sex, term,total,admit term, total units taken, current units taken and email address. Please see the kace ticket for history: https://helpdesk.baruch.cuny.edu/ ticket reference number: 37529
Query SQL
SELECT A.EMPLID, D.FIRST_NAME, D.LAST_NAME, A.ACAD_CAREER, A.ACAD_PROG, A.PROG_STATUS, B.ACAD_PLAN, D.EMAIL_ADDR
FROM PS_ACAD_PROG A, PS_ACAD_PLAN B, PS_STDNT_CAR_TERM C, PS_CU_BIO_VW D
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ACAD_PROG A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.ACAD_CAREER = A_ED.ACAD_CAREER
AND A.STDNT_CAR_NBR = A_ED.STDNT_CAR_NBR
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_ACAD_PROG A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.ACAD_CAREER = A_ES.ACAD_CAREER
AND A.STDNT_CAR_NBR = A_ES.STDNT_CAR_NBR
AND A.EFFDT = A_ES.EFFDT)
AND A.INSTITUTION = :1
AND A.ACAD_CAREER = 'GRAD'
AND A.PROG_STATUS = 'AC'
AND A.EMPLID = B.EMPLID
AND A.ACAD_CAREER = B.ACAD_CAREER
AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR
AND A.EFFSEQ = B.EFFSEQ
AND A.EFFDT = B.EFFDT
AND B.ACAD_PLAN IN ('RES-MBA','RESR-MS')
AND A.EMPLID = C.EMPLID
AND A.ACAD_CAREER = C.ACAD_CAREER
AND A.STDNT_CAR_NBR = C.STDNT_CAR_NBR
AND C.INSTITUTION = A.INSTITUTION
AND C.STRM = :2
AND A.EMPLID = D.EMPLID