IFRPT_FORM_CASE_SUMMARY_V Table
Explanation
Contains information supplied on the Interfolio Review, Promotion & Tenure (RPT) Case Summary Form related to Interfolio appointment, reappointment, and promotion cases.
Common Uses
Finding the supplemental information about an Interfolio RPT case, such as background information, the candidate's Administrative/Clinical, Teaching and Mentoring, Grants, Service, and other activities.
| Primary Key |
Indexed Data Elements |
Related Tables |
CASE_ID
|
CASE_ID
|
IFRPT_CASE (DWFAC)
|
Cautions
- IFRPT_FORM_CASE_SUMMARY_V contains supplemental information related to Interfolio appointment, reappointment, and promotion cases.
- Once the review and approval related to a case are complete in Interfolio, the most current information about faculty positions can be found in the DWHCM.HCM_POSITION table, with data about faculty appointments found in the DWHCM.HCM_ACAD_APPOINTMENT table. Each of these tables is updated nightly from Workday.
- IFRPT_FORM_CASE_SUMMARY_V includes only the last form submission for a given case.
- You can access an IFRPT_FORM_CASE_SUMMARY_V row only if you are authorized to access data for the organizational unit associated with the position associated with the application.
- The IFRPT_FORM_CASE_SUMMARY_V table can be found in the DWFAC schema.
Source
Interfolio Review, Promotion & Tenure (RPT), in use at Penn since July 2019.
Questions about this page? Email us at da-staff@isc.upenn.edu
|
