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
Image Modified
Query SQL
Panel |
---|
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 |