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.
Retrieving planned compensation amounts (e.g., academic base salary, base salary supplement, administrative salary, etc) for a faculty member.
||Indexed Data Elements
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.
Questions about this page? Email us at firstname.lastname@example.org