|<< go back|
Contains student email addresses. Students can have multiple email addresses of different types, and also multiple email addresses for the same type.
Email addresses have a Status of A (Active) or I (Inactive). Old/obsolete email addresses are generally not deleted; they are maintained with an inactive status.
Only one email address can be assigned a Preferred_Ind = 'Y' at any given time, and it must be an active address. Generally, the source business rules will guarantee that the student's upenn.edu email address be their preferred email, for active students.
The warehouse ST_EMAIL table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The ODS source tables are UPENN_ODS.SATURN_SPRIDEN and UPENN_ODS.GENERAL_GOREMAL. In the online Pennant system, the data about students' email addresses can be viewed on the SPAIDEN form.
Cautions and notes
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania