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