| 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. |
