Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_PERSON_SALARY Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

COMP_PERSON_SALARY Table

Explanation
Contains faculty compensation records, by compensation category and date range. Faculty members may have multiple rows in effect at one time or with overlapping dates, but for different compensation categories.

Common Uses
Retrieving planned compensation amounts (e.g., academic base salary, base salary supplement, administrative salary, etc) for a faculty member.

Primary Key Indexed Data Elements Related Tables
COMP_PERSON_SALARY_ID
HOME_CENTER
HOME_ORG
PENN_ID
SALARY_END_DATE
SALARY_END_FISCAL_YEAR
SALARY_END_YEAR
SALARY_START_DATE
SALARY_START_FISCAL_YEAR
SALARY_START_YEAR
SALARY_TYPE
COMP_CATEGORY_LOOKUP (DWCOMP)
COMP_PERSON (DWCOMP)
COMP_PERSON_SALARY_SUMMARY (DWCOMP)
ORG_CODES (DWADMIN)

Cautions

  • Faculty compensation records represent a faculty member's salary agreement. In addition to Academic Base, users may track prospective faculty compensation amounts including Base Salary Supplement, Faculty Salary, Administrative Stipends and Staff Salary. Other irregularly paid components of faculty compensation such as Bonuses and Honoraria, will be tracked only via actual payments.

  • The amounts stored in COMP_PERSON_SALARY are those that were planned to be paid to the faculty member, for the given category and dates, at the time the record was entered into PennWorks. These amounts are not directly related to given roles or distributions, and may differ from actual payments that occurred.

  • PennWorks allows users to indicate a state for a salary record, as "Final", "Projected", or "Disabled." Records with a "Projected" state can act as placeholders for planning purposes, and will be managed solely within PennWorks. The "Final" state indicates the record is ready to be processed by PennWorks. "Disabled" records will no longer be visible in PennWorks, but are retained in the COMP_PERSON_SALARY table for historical purposes.
  • Historical snapshots of salary information are available in the COMP_PERSON_SALARY_SNAP table, beginning with the NOV-09 period.
  • You can access a COMP_PERSON_SALARY row only if you are authorized to access data for the employee's home center or organization, or a current joint organization for the employee.
  • The COMP_PERSON_SALARY table can be found in the DWCOMP schema.
COMP_PERSON_SALARY Table - Data Element Index   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