Advisor Campus Email

Report Field Name	EMAIL_ADDR This value is derived by a lookup using the Student Advisor table and matching the Emplid (Advisor ID) to the Emplid in the email addresses table.
Definition/Usage	The UConn email address of the student’s advisor.
Values
Example	John.A.Smith@uconn.edu wew24001@uconn.edu
Notes
Synonyms/References	https://uconn.atlassian.net/wiki/x/WID0QQY

Additional technical details can be found in the following expandable region, including the tables and foundation/lookups for this element in Student Admin and SADM.

Student Admin

Table	STDNT_ADVR_HIST, EMAIL_ADDRESSES
Column	ADVISOR_ID match to EMAIL_ADDRESSES.EMPLID where E_ADDR_TYPE=CAMP

Student Admin Foundation/Lookup

Table
Column

SADM

Table
Column