Penn Computing

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

CREF_PI_MAPPING Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data Element Definition

CENTER_CODE

Indexed - yes
Format - char(2)
May be null? yes

The code of the school or center that corresponds to the first two characters in the CNAC_CODE.

CENTER_REF_CODE

Indexed - yes
Format - char(4)
May be null? no

The 4-character CENTER REFERENCE CODE uniquely defined by the school or center identified in the CNAC_CODE.

CENTER_REF_CODE is used to record information important to a school or center but inappropriate for any other segment of the Accounting Flexfield. No two center references will have the same code within a school or center. However, a given CENTER_REF_CODE will have different meanings to different schools or centers.

CENTER_REF_CODE is the seventh and last segment of the Accounting Flexfield.

CENTER_REF_DESC

Indexed - no
Format - varchar2(70)
May be null? yes

The name that corresponds to the CENTER_REF_CODE for the school or center. (The school or center is identified in the CNAC_CODE.)

A center reference is used to record information that is important to a school or center but inappropriate for any other segment of the Accounting Flexfield.

CENTER_REF_ENABLED

Indexed - no
Format - char(1)
May be null? yes

Indicates whether the CENTER_REF_CODE may be used in BEN Financials transactions.

CNAC_CODE

Indexed - yes
Format - char(3)
May be null? no

The 3-character Center Net Asset Class code.

The first two positions of the CNAC_CODE identify the specific school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). CNAC_CODE is the first segment of the Accounting Flexfield.

LAST_UPDATED_BY

Indexed - no
Format - number
May be null? yes

The unique ID for the BEN Financials user who assigned the CREF to the Penn ID.

LAST_UPDATED_BY_USERNAME

Indexed - no
Format - varchar2(200)
May be null? yes

The BEN username for the BEN Financials user who assigned the CREF to the Penn ID.

LAST_UPDATED_DATE

Indexed - no
Format - date
May be null? yes

The date when the CREF was assigned to the Penn ID.

PERSON_FLAG

Indexed - no
Format - char(1)
May be null? yes

Indicates (Y/N) whether the CREF is mapped to a person.

PI_EMPLOYMENT_DATE

Indexed - no
Format - date
May be null? yes

The PI's most recent date of hire by the home department

PI_HOME_DEPT_ORG

Indexed - yes
Format - char(4)
May be null? yes

The 4-digit number that represents the organization that owns the PI's Payroll record and is responsible for its maintenance. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)

PI_NAME

Indexed - no
Format - varchar2(50)
May be null? yes

The PI's full legal name, in uppercase, in the format: LASTNAME,FIRSTNAME MIDDLEINITIAL (Note that only a comma separates the last name from the first name. Blank space is not used in the separator.) This is the name used for Federal W-2 forms, for example. (See also Name_Flipped and Professional names.)

PI_PENN_ID

Indexed - yes
Format - char(8)
May be null? no

Penn ID number of the Principal Investigator.

PI_PRI_ACAD_APPT_JOB_CLASS

Indexed - yes
Format - char(6)
May be null? yes

The 6-digit job class code indicating the PI's primary academic appointment.

PI_PRI_ACAD_DEPT_ORG

Indexed - yes
Format - char(6)
May be null? yes

The 4-digit number that represents the Organization responsible for the PI's primary academic job appointment. Pri_Acad_Dept_Org may differ from the Home_Dept_Org.
 
CREF_PI_MAPPING Table   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