IFRPT_FORM_REQUEST_V Table - Data Element Index   Tables and Data Elements   Faculty Home   Data Warehouse Home

IFRPT_FORM_REQUEST_V Table

Explanation
Contains information supplied on the Interfolio Review, Promotion & Tenure (RPT) Request Form related to Interfolio appointment, reappointment, and promotion cases.

Common Uses

Reviewing information from a Request Form associated with an RPT case.

CASE_ID    

CASE_ID

IFRPT_CASE (DWFAC)

• 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_REQUEST_V includes only the last form submission for a given case.
• You can access an IFRPT_FORM_REQUEST_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_REQUEST_V table can be found in the DWFAC schema.

Source

Interfolio Review, Promotion & Tenure (RPT), in use at Penn since July 2019.

IFRPT_FORM_REQUEST_V Table - Data Element Index   Tables and Data Elements   Faculty Home   Data Warehouse Home