Penn Computing

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

COMP_INCREASE_FACCOMP_TEMPLATE Table - Data Element Index

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



Data element Definition
COMP_PERSON_FACCOMP_ID

Indexed - yes
Format - varchar2 (45)
May be null? no
Uniquely identifies a record in the COMP_INCREASE_FACCOMP_TEMPLATE table.
 
CURRENT_ACADEMIC_BASE

Indexed - no
Format - number (9,2)
May be null? yes

The Academic Base Salary currently active for the individual, for the fiscal year.

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.

 
CURRENT_ADMIN_STIPEND

Indexed - no
Format - number (9,2)
May be null? yes

The Administrative Stipend amount currently active for the individual, for the fiscal year.

The Administrative Stipend is salary paid for administrative appointments beyond regular teaching, research and service responsibilities. May include duties performed on an interim basis.

CURRENT_BASE_SUPPLEMENT

Indexed - no
Format - number (9,2)
May be null? yes

The Base Salary Supplement amount currently active for the individual, for the fiscal year.

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.

CURRENT_FACULTY_SALARY

Indexed - no
Format - number (9,2)
May be null? yes

The Faculty Salary amount currently active for the individual, for the fiscal year.

Faculty Salary is 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.

CURRENT_STAFF_SALARY

Indexed - no
Format - number (9,2)
May be null? yes

The Staff Salary amount currently active for the individual, for the fiscal year.

Staff Salary is 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).

CURRENT_TOTAL_SALARY

Indexed - no
Format - number (9,2)
May be null? yes
The total current salary amount for the individual for the fiscal year, resulting from the sum of Current_Academic_Base + Current_Admin_Stipend + Current_Base_Supplement + Current_Faculty_Salary + Current_Staff_Salary.
EXTRACT_DATE

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

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

Indexed - yes
Format - varchar2 (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 - varchar2 (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.
NEW_ACADEMIC_BASE

Indexed - no
Format - number (9,2)
May be null? yes
The Academic Base Salary planned for the individual.
NEW_ADMIN_STIPEND

Indexed - no
Format - number (9,2)
May be null? yes
The Administrative Stipend planned for the individual.
NEW_BASE_SUPPLEMENT

Indexed - no
Format - number (9,2)
May be null? yes
The Base Salary Supplement planned for the individual.
NEW_FACULTY_SALARY

Indexed - no
Format - number (9,2)
May be null? yes
The Faculty Salary planned for the individual.
NEW_STAFF_SALARY

Indexed - no
Format - number (9,2)
May be null? yes
The Staff Salary planned for the individual.
NEW_TOTAL_SALARY

Indexed - no
Format - number (9,2)
May be null? yes
The total planned salary amount for the individual for the fiscal year, resulting from the sum of New_Academic_Base + New_Admin_Stipend + New_Base_Supplement + New_Faculty_Salary + New_Staff_Salary.
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.

PERC_CHANGE_ACADEMIC_BASE

Indexed - no
Format - number (5,2)
May be null? yes
The percentage difference between the Current_Academic_Base and the New_Academic_Base.
PERC_CHANGE_ADMIN_STIPEND

Indexed - no
Format - number (5,2)
May be null? yes
The percentage difference between the Current_Admin_Stipend and the New_Admin_Stipend.
PERC_CHANGE_BASE_SUPPLEMENT

Indexed - no
Format - number (5,2)
May be null? yes
The percentage difference between the Current_Base_Supplement and the New_Base_Supplement.
PERC_CHANGE_FACULTY_SALARY

Indexed - no
Format - number (5,2)
May be null? yes
The percentage difference between the Current_Faculty_Salary and the New_Faculty_Salary.
PERC_CHANGE_STAFF_SALARY

Indexed - no
Format - number (5,2)
May be null? yes
The percentage difference between the Current_Staff_Salary and the New_Staff_Salary.

COMP_INCREASE_FACCOMP_TEMPLATE 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