Penn Computing

University of Pennsylvania
Penn Computing << go backback
FIS_HOSP_AFFIL_ACTION Table - Data Element Index   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_HOSP_AFFIL_ACTION Table

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


Common Uses
Displaying hospital associated with an individual action.

Primary Key Indexed Data Elements Related Tables
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

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