The Interfolio Data Collection is a subset of the University Data Warehouse containing data from the Interfolio Faculty Search (FS) and Interfolio Review, Promotion & Tenure (RPT) modules, in use since July 2019 by the Provost's Office and the schools for faculty recruitment. For more information about Interfolio, visit the Interfolio@Penn site.
Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.
Looking for a specific element or caution? Try the searching the collection documentation for particular keywords (search page will open in a new tab).
Faculty Search (FS) Tables and Views:
| IFFS_APPLICATION_DOCUMENT Table Elements |
IFFS_APPLICATION_TAG Table Elements |
| IFFS_APPLICATION_EEO_V Table Elements |
IFFS_APPLICATION_V Table Elements |
| IFFS_APPLICATION_FORM Table Elements |
IFFS_POSITION_COMMITTEE_V Table Elements |
| IFFS_APPLICATION_HOW_HEARD_V Table Elements |
IFFS_POSITION_V Table Elements |
Review, Promotion & Tenure (RPT) Tables and Views:
| IFRPT_CASE Table Elements |
IFRPT_FORM_EC_BY_CANDIDATE_V Table Elements |
| IFRPT_CASE_DOCUMENT Table Elements |
IFRPT_FORM_FACULTY_PENDING_V Table Elements |
| IFRPT_CASE_LOG Table Elements |
IFRPT_FORM_LARC_VOTE_V Table Elements |
| IFRPT_EXTERNAL_EVALUATION Table Elements |
IFRPT_FORM_PSC_MEMBER_V Table Elements |
| IFRPT_FORM Table Elements |
IFRPT_FORM_REQUEST_V Table Elements |
| IFRPT_FORM_AC_ADVISORY_VOTE_V Table Elements |
IFRPT_FORM_REVIEW_COMPLETION_V Table Elements |
| IFRPT_FORM_CASE_SUMMARY_V Table Elements |
IFRPT_FORM_SCHOOL_VOTE_V Table Elements |
| IFRPT_FORM_DEPT_VOTE_V Table Elements |
Other Interfolio Tables and Views:
| APPLICATION_PACKET Table Elements |
IF_UNIT_SCHOOL_V Table Elements |
| IF_UNIT Table Elements |
USER_LOAD Table Elements |
The Interfolio Faculty Search (FS) data collection is refreshed on a nightly basis with data from Interfolio. Tables in the Interfolio Faculty Search collection (available in the DWFAC schema in the Data Warehouse) contain records dating from the implementation of Interfolio Faculty Search in July 2019.
The Interfolio BusinessObjects universe provides access to the Faculty Search (FS) and Review, Promotion & Tenure (RPT) tables, and also includes access to HCM_PERSON and common reference tables.
There is no formal training for the Interfolio Faculty Search data collection. You may wish to visit the Interfolio@Penn site for additional information about Interfolio@Penn and related resources.
Those who wish to access the Interfolio data must submit the Faculty Data Warehouse Access Request eForm.
Access to the Interfolio data collection is linked to access to Academic Units in the Human Capital Management (HCM) data collection in the Warehouse. Individuals with access to Academic Units in the HCM collection may view records about Interfolio faculty search (FS) or review/promotion/tenure (RPT) activities related to those same units. Records are secured by organization, using the ORG code related to Workday Academic Unit, which is linked to the Interfolio organizational unit. If those ORG fall within the organizations to which user has been granted access, then s/he can see the row. Select views of vote information and other similarly-secured data require additional administrative-level access. Additional security policies apply to more sensitive data such as Race/Ethnicity and, Military/Disability.
Releasing Data Outside the University
The only two offices that may disclose faculty data outside the University are the Office of the Provost and Institutional Research & Analysis. If you do not work for those offices and you receive a request for data to be sent outside the University, refer the requester to the Office of the Provost.
Releasing Data Within the University
Within the University, faculty data may be disclosed only if it is needed to do the business of the University, and only to those who need to know the information in order to do their jobs. If you are not sure whether to fulfill a request for faculty data, contact the Office of the Provost.
Query Results
If you save your query results in Excel, pdf, or any other local file type, you must see to it that any sensitive data stored on your peronal computer is safeguarded through physical security, access control software, or encryption. When a computer is left signed to an account, it is easy for someone to gain unauthorized access. Either sign off from your account before you leave your computer or restrict access by some other means (physical security or access control software).
For more information on security and privacy, contact the Office of Information Security.
If you have a question or comment about the Interfolio Faculty Search data or data documentation, or have a suggestion for revising the documentation, please contact Enterprise Information & Analytics. For documentation published on the Web, please specify the URL for the documentation that needs to be updated.