| Data element |
Definition |
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 phone number record. |
| LAST_UPD
Indexed - no
Format - timestamp(6)
May be null? no
|
The date/time when the phone number record was last updated. |
| NUM
Indexed - yes
Format - varchar2(20)
May be null? no |
The phone number (as related to the TYPE_CD) for the individual, as entered into FIS.
|
TYPE_CD
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of phone number. Use this to join to the FIS_PHONE_TYPE_LOOKUP table on the MESSAGE_ID field. NAME_FRIENDLY is contains the phone number 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. |
