Get Information for Registered Students

select b.csu_id ,b.first_name ,b.last_name,

a.STUDENT_CLASS, a.STUDENT_CLASS_DESC,

a.PRIMARY_MAJOR, a.PRIMARY_MAJOR_DESC,

b.email, b.telephone, a.CONTINUOUS_REG,

a.CREDITS_CE, a.CREDITS_RI, a.CREDITS_NON_CSU,

a.CREDITS_SI, a.CREDITS_OTHER, a.CREDITS_TOTAL

from csus_term_info_cur a

join csug_gp_demo b on a.PIDM = b.pidm

where b.confidentiality_ind <> ‘Y’

order by b.legal_name