| Data element |
Definition |
| CAMPUS_MAIL_CODE
Indexed - yes
Format - varchar2(4)
May be null? yes |
The 4-digit University intramural mail code associated with the location where intramural mail is delivered, as initially entered into the Faculty Information System (FIS). Note: This is not necessarily the same as the U.S. Postal Service zip-code-plus-four extension.
Example: 6228 (WALNUT WEST) |
|
CITY
Indexed - no
Format - varchar2(25)
May be null? no |
The city associated with the address record, as entered into FIS. |
COUNTRY
Indexed - no
Format - varchar2(2)
May be null? no |
The country code associated with the address record, as entered into 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 address record. |
| LAST_UPD
Indexed - no
Format - timestamp(6)
May be null? no
|
The date/time when the address record was last updated. |
|
STATE
Indexed - no
Format - varchar2(2)
May be null? yes |
The 2-character U.S. Postal Service code that identifies the state associated with the address, as entered into FIS. |
STREET1
Indexed - no
Format - varchar2(30)
May be null? no |
The street address associated with the address record, as entered into FIS. |
STREET2
Indexed - no
Format - varchar2(25)
May be null? no |
Additional address information supplementing Street1, the street address associated with the address record, as entered into FIS. |
TYPE_CD
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of address. Use this to join to the FIS_ADDRESS_TYPE_LOOKUP table on the MESSAGE_ID field. NAME_FRIENDLY is contains the 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. |
| ZIP
Indexed - no
Format - varchar2(15)
May be null? yes |
The The 5- or 9-digit zip code associated with the address record, as entered into FIS. |
