Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_PERSON_SALARY_SUMMARY Table   Tables and Data Elements   Salary Management Home   Data Warehouse Home

COMP_PERSON_SALARY_SUMMARY Table - Data Element Index

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



Data element Definition
ACADEMIC_BASE_SALARY

Indexed - no
Format - number (10,3)
May be null? yes

Academic Base Salary is salary paid for regular, full-time academic duties of standing faculty (teaching, research, service) as derived by each school. As described in the Handbook for Faculty and Academic Administrators (section II .E.11), the Academic Base Salary cannot be decreased except for by express agreement or financial exigency. It does not include extra salary for administrative appointments, overload teaching, summer research, summer teaching and summer administrative appointments, and performance incentives or bonuses. While normally paid for a 9-month academic year, paid out in 12 equal amounts in a monthly paycheck, some schools pay an annualized base for regular academic duties performed over a 12-month period.

Note: With the exception of Lecturer C and clinician educators, non-standing faculty members do not have an Academic Base Salary. In addition, only faculty with a paid, non-guaranteed secondary appointment should have both Faculty Salary and Academic Base Salary.

ADMINISTRATIVE_STIPEND

Indexed - no
Format - number (10,3)
May be null? yes
Salary paid for administrative appointments beyond regular teaching, research and service responsibilities. May include duties performed on an interim basis.
BASE_SALARY_SUPPLEMENT

Indexed - no
Format - number (10,3)
May be null? yes

Salary in excess of Academic Base or Faculty Salary that is guaranteed for a defined term. This pay is often necessary for recruitment and retention but may be reduced or eliminated at the school's discretion, or in accordance with any written agreement between the school and the faculty member. The Base Salary Supplement does not include extra salary for administrative appointments, overload teaching, summer research, summer teaching and summer administrative appointments, and performance incentives or bonuses. The Base Salary Supplement is not included in calculations of summer ninths for summer research stipends, summer teaching stipends and overload teaching stipends.

Note: Only individuals with Academic Base Salary or Faculty Salary may have a Base Salary Supplement.

EXTRACT_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the COMP_PERSON_SALARY_SUMMARY record was loaded to the Data Warehouse.
 
FACULTY_SALARY

Indexed - no
Format - number (10,3)
May be null? yes

Salary normally paid for academic duties of non-standing faculty. It does not include extra salary for administrative appointments, overload teaching, summer research, summer teaching and summer administrative appointments, and performance incentives or bonuses.

Note: Only faculty with a paid, non-guaranteed secondary appointment should have both Faculty Salary and Academic Base Salary.

FISCAL_YEAR

Indexed - yes
Format - varchar2 (4)
May be null? yes
The fiscal year to which the compensation amount applies, for the individual.
HOME_CENTER

Indexed - yes
Format - varchar (2)
May be null? yes
A 2-digit number used to identify the school or center that owns the employee's record and is responsible for its maintenance. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

Example: 40 (School of Medicine)

Values:
Refer to the DWADMIN.ORG_CODES table, for values where 
Home_Center = Center_Code.
      
 
HOME_ORG

Indexed - yes
Format - varchar (4)
May be null? yes
The 4-digit number that represents the organization that owns the employee's 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.)

Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)

Values:

Refer to the DWADMIN.ORG_CODES table for values.
      
PENN_ID

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

The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.

 
SALARY_STATE

Indexed - yes
Format - varchar2 (1)
May be null? yes
Selected by the user to indicate the record is ready to be processed by the system if/when appropriate. Records with a state value of ‘P’ (projected) will remain in the PennWorks work area only. Users may select to delete records from PennWorks; these rows are retained in in the Data Warehouse for historical purposes with a state of 'X'.
Values:
Refer to the DWADMIN.ROLE_DIST_STATE_LOOKUP 
table for values.
    
STAFF_SALARY

Indexed - no
Format - number (10,3)
May be null? yes
Salary that is normally paid for staff member duties, for those faculty who hold staff positions as their primary job (e.g. Senior Research Investigators and Health System Clinicians).
TOTAL_SALARY

Indexed - no
Format - number (10,3)
May be null? yes
The total salary amount for the individual for the fiscal year, resulting from the sum of Academic_Base_Salary + Administrative_Stipend + Base_Salary_Supplement + Faculty_Salary + Staff_Salary.

COMP_PERSON_SALARY_SUMMARY Table   Tables and Data Elements   Salary Management 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