COMP_PERSON_SALARY Table - Data Element Index  Tables and Data Elements   Salary Management Home   Data Warehouse Home

COMP_PERSON_SALARY Table

Note: This table is no longer updated, following the retirement of PennWorks and the implementation Workday@Penn in July 2019.

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.

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