| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was updated in the source. Source field: GOREMAL_ACTIVITY_DATE. |
| Display_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Source field: GOREMAL_DISP_WEB_IND |
| Email_Addr Indexed - no
Format - Varchar2(128)
May be Null? Y | Email address. Source field: GOREMAL_EMAIL_ADDRESS. |
| Email_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the type of email address. Students can have more than one type of email address, and they can have more than one email address of the same type. See Preferred_Ind.
Source field: GOREMAL_EMAL_CODE. Source validation table: GTVEMAL. Warehouse validation table: V_EMAIL. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal identification number. Source field: GOREMAL_PIDM |
| Preferred_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates this is the email address that is preferred for most university communications. When a report requires that just one email address be returned in the results, filter for Preferred_Ind = 'Y'.
Note that the email with Preferred_Ind = 'Y' is not the same as the email in the Penn Directory that the student has set as their preferred address for directory searches. In the warehouse ST_EMAIL table, the email address with Preferred_Ind = 'Y' is determined by the following rules:
- If the email address is active and has been flagged as the "Preferred" in Banner, then that is the one that will have the Preferred_Ind in this table set to 'Y'.
- If there is no preferred active one in Banner, then look for an active email address of type 'PEN'. If there is more than one active email address of type 'PEN' use the most recent one.
- If there is no active email of type 'PEN' then look for an active email address of type 'PERS'. If there is more than one active email address of type 'PERS' use the most recent one.
These rules insure that we get only one email address with the Preferred_Ind set to 'Y'.
Note that it is possible for a student to have no email addresses that meet the above criteria. In such cases, none of their email addresses will have the Preferred_Ind set to 'Y'.
Source field: GOREMAL_PREFERRED_IND, and related rules using GOREMAL_EMAL_CODE |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was refreshed in the warehouse |
| Status Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates whether the email is active or not. Source field: GOREMAL_STATUS_IND. |
| St_Email_Pk Indexed - yes
Format - Varchar2(154)
May be Null? N | internal warehouse primary key, based on to_char(PIDM), EMAL_CODE, and EMAIL_ADDRESS |
