Penn Computing

University of Pennsylvania
Penn Computing << go backback
CREF_PI_MAPPING Table - Data Element Index   Tables and Data Elements   Space@Penn Home   Data Warehouse Home

CREF_PI_MAPPING Table

Explanation
Stores Center Reference Codes with related Principal Investigator (PI) information, as maintained by authorized users of the CREF_PI mapping application.

Common Uses
To associate rooms occupied by PIs with related accounting information.

Primary Key Indexed Data Elements Related Tables
CENTER_REF_CODE 
CNAC_CODE	  
PI_PENN_ID
CENTER_CODE 
CENTER_REF_CODE 
CNAC_CODE 
PI_HOME_DEPT_ORG 
PI_PENN_ID 
PI_PRI_ACAD_APPT_JOB_CLASS 
PI_PRI_ACAD_DEPT_ORG 
PRINCIPAL_INVESTIGATORS
ROOM_UTILIZATION

Cautions

  • Contains CREF to PI mapping data only for those schools that have chosen to maintain this data.
  • The PI attributes are loaded from the Data Warehouse Salary Management collection to the CREF_PI mapping application; the CREF attributes are loaded to the CREF_PI mapping application from the Data Warehouse General Ledger collection.
CREF_PI_MAPPING Table - Data Element Index   Tables and Data Elements   Space@Penn 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