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 screen in BEN Financials.

Common Uses
To associate rooms occupied by PIs with related accounting information. To find expenses for accounts associated with particular faculty members.

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 

CENTER_REF_CODES
PRINCIPAL_INVESTIGATORS
ROOM_UTILIZATION
Any table with COA_CREF

Cautions

• Contains CREF to PI mapping data only for those schools that have chosen to maintain this data.
• In 2015, BEN Financials became the source of the CREF_PI_MAPPING table, replacing the original standalone application created to link CREFs to Penn IDs.

CREF_PI_MAPPING Table - Data Element Index   Tables and Data Elements   Space@Penn Home   Data Warehouse Home