Penn Computing

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

V_EMAIL_TYPE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Activity_Date

Indexed - no
Format - Date
May be Null? N

The last date any part of this record was updated in the source. Source field: GTVEMAL_ACTIVITY_DATE

Email_Type_Code

Indexed - no
Format - Varchar2(4)
May be Null? N

Code for the type of email address.

Note that the 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'

Source field: GTVEMAL_CODE

Email_Type_Desc

Indexed - no
Format - Varchar2(60)
May be Null? Y

Text description of the Email Type code.

Source field: GTVEMAL_DESC

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

V_EMAIL_TYPE Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

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