Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_EMAIL_TYPE column definitions . Pennant Student Records Home . Data Warehouse Home




This is a validation table, containing the values and descriptions for the codes that identify the type of email address.

Examples of email types: ADM = Admissions email address, PERS = Personal email address, BUS = Business email address, etc.


The warehouse V_EMAIL_TYPE table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source table is GENERAL_GTVEMAL.

Primary Key Indexed Data Elements Related Tables



Cautions and notes

  • Students can have multiple email addresses; each address has a type. Students will have one of their email addresses identified as the "Preferred" email; see the preferred indicator column in ST_EMAIL.
  • Email type of 'DIR' has a description of "Directory" but this value is no longer in use. It it for historical purposes only. Email addresses that come from the Penn Directory will have an email type of either 'PEN' or 'PERS'
  • PEN emails are only populated from the Penn directory. PERS emails can come from the directory or from the admissions systems.
  • Email addresses provided by the issuing school or department for a student in the directory are loaded into Banner as PEN. In addition, email addresses entered by a student in the directory that is like and can be verified by having a corresponding pennkey on their student record, will be loaded as a PEN email. If the student provided an email address like in the directory and it was neither matched by their department's provided email address nor matched to the student's pennkey, then this email will tbe sent to Banner as a PERS email.
V_EMAIL_TYPE column definitions . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania