Get Student Information by eName (enrollment eligible) – NOTE: Replace the :ENAME variable with student eName

SELECT CSU_ID, FIRST_NAME, LAST_NAME,

STUDENT_CLASSIFICATION, STUDENT_MAJOR,

CASE WHEN PROPER_NAME_ADDRESS IS NULL THEN EMAIL_ADDRESS ELSE PROPER_NAME_ADDRESS END EMAIL,

CASE WHEN PHONE IS NULL THEN EMPLOYEE_PHONE ELSE PHONE END PHONE,

STUDENT_ENROLLED_INDICATION

FROM CSUG_DIRECTORY_PRIVACY

WHERE ENAME = :ENAME