Penn Computing

University of Pennsylvania
Penn Computing << go backback
USER_LOAD Table    Tables and Data Elements   Faculty Home   Data Warehouse Home

USER_LOAD Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




Data element Definition

ACTIVE

Format VARCHAR2(1)

Indexed? No

May be Null? No

Indicates whether (T) or not (F) this faculty member is active in Interfolio.

CREATION_DATE

Format DATE

Indexed? No

May be Null? No

The date that this record was created.

EMAIL_ADDRESS

Format VARCHAR2(60)

Indexed? No

May be Null? No

The email address of the user.

FIRST_NAME

Format VARCHAR2(30)

Indexed? No

May be Null? No

The first name of the user.

ID

Format NUMBER

Indexed? Yes

May be Null? No

The unique system identifier for this record in the USER_LOAD table.

INTERFOLIO_ID

Format NUMBER

Indexed? No

May be Null? No

The unique identifier for the user in the Interfolio system.

INTERFOLIO_SERVICE

Format VARCHAR2(10)

Indexed? No

May be Null? No

The Interfolio service of which the indivdiual is a user. Eg.., FS (Faculty Search); RPT (Review, Promotion, and Tenure).

LAST_NAME

Format VARCHAR2(30)

Indexed? No

May be Null? No

The last name of the user.

LAST_UPDATE_DATE

Format DATE

Indexed? No

May be Null? No

The date that this record was last updated.

PENN_KEY

Format VARCHAR2(24)

Indexed? No

May be Null? No

The user's PennKey: the username required to authenticate an individual's identity to many of Penn's networked systems. For more information on PennKeys, refer to http://www.upenn.edu/computing/pennkey

 
USER_LOAD Table    Tables and Data Elements   Faculty Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania