• COMP_PERSON_FACCOMP_ID
• CURRENT_ACADEMIC_BASE
• CURRENT_ADMIN_STIPEND
• CURRENT_BASE_SUPPLEMENT
• CURRENT_FACULTY_SALARY
• CURRENT_STAFF_SALARY
• CURRENT_TOTAL_SALARY
• EXTRACT_DATE
• FISCAL_YEAR
• HOME_CENTER
• HOME_ORG
• NEW_ACADEMIC_BASE

• NEW_ADMIN_STIPEND
• NEW_BASE_SUPPLEMENT
• NEW_FACULTY_SALARY
• NEW_STAFF_SALARY
• NEW_TOTAL_SALARY
• PENN_ID
• PERC_CHANGE_ACADEMIC_BASE
• PERC_CHANGE_ADMIN_STIPEND
• PERC_CHANGE_BASE_SUPPLEMENT
• PERC_CHANGE_FACULTY_SALARY
• PERC_CHANGE_STAFF_SALARY

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.

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.

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.

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.

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

Example: 40 (School of Medicine)

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

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

Values:
Refer to the DWADMIN.ORG_CODES table for values.

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.