| Data element |
Definition |
| ADDRESS
Indexed - yes
Format - varchar2(60)
May be null? no |
For employees with electronic mail accounts, the address to which email may be sent, as entered in the Faculty Information System (FIS). |
CREATE_DT
Indexed - no
Format - date
May be null - no |
The creation date of the record.
|
|
CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record.
|
| FASDA_ID
Indexed - no
Format - number
May be null? no
|
A unique system identifier assigned to each unique faculty member in the FIS_FACULTY table. This number is not used in other data collections, and should not be used for reporting. |
| ID
Indexed - yes (primary key)
Format - number
May be null? no |
A unique identifier of each email address record. |
| LAST_UPD
Indexed - no
Format - timestamp(6)
May be null? no
|
The date/time when the email address record was last updated. |
|
RESTRICT_CD
Indexed - no
Format - number(12)
May be null? yes |
Indicates whether the email address should be restricted from public view. |
TYPE_CD
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of email address. Use this to join to the FIS_EMAIL_TYPE_LOOKUP table on the MESSAGE_ID field. NAME_FRIENDLY is contains the email address type description. |
| UPD_DT
Indexed - no
Format - date
May be null? no
|
The date the address record was last updated. |
| UPD_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who last updated the record. |
