Graduating Students – Spring (Note: For Summer change spr to smr, and for Fall change spr to fal)

SELECT D.FIRST_NAME,D.LAST_NAME,D.EMAIL,

D.ADDR_1,D.ADDR_2,D.ADDR_3,D.CITY,D.STATE,D.NATION,D.ZIP

FROM CSUBAN.CSUS_COMMENCEMENT_SPR C,

CSUBAN.CSUG_GP_DEMO D

WHERE C.PERSON_UID = D.PIDM AND (D.CONFIDENTIALITY_IND <> ‘Y’)