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

FIS_HOSP_AFFIL_ACTION Table

Note: This table is no longer updated, following the retirement of the Faculty Information System (FIS) and the implementation Interfolio@Penn and Workday@Penn in July 2019.

Explanation
This table contains references to individual hospitals associated with actions.

Common Uses
Displaying hospital associated with an individual action.

HOSPITAL_AFFIL_ID

HOSPITAL_AFFIL_ID

FIS_ACTION
FIS_HOSPITAL_LOOKUP

Cautions

• To find the hospital name associated with an action, join to FIS_HOSPITAL_LOOKUP using HOSPITAL_AFFIL_ID, and to FIS_ACTION using ACTION_ID.

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