Penn Computing

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

IFFS_APPLICATION_DOCUMENT Table - Data Element Index

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




Data element Definition

APPLICATION_ID

Format NUMBER

Indexed? No

May be Null? No

The system ID of the related position application in the Interfolio system.

CREATION_DATE

Format DATE

Indexed? No

May be Null? No

The date on which the application document record was created in the Data Warehouse.

ID

Format NUMBER

Indexed? Yes

May be Null? No

The unique identifier for the application document record in the Interfolio system.

NAME

Format VARCHAR2(300)

Indexed? No

May be Null? No

The name of the document linked to the position application.

RECEIVED

Format DATE

Indexed? No

May be Null? Yes

The date on which the document was received and linked to the position application in Interfolio. Required documents which have not yet been received will have a record in this table, but no value in the Received column.

TYPE

Format VARCHAR2(300)

Indexed? No

May be Null? Yes

The type of the document linked to the position application, e.g. Cover Letter, C.V., Essay, Research Statement, Writing Sample.

 
IFFS_APPLICATION_DOCUMENT 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