Penn Computing

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

COMP_INCREASE_PAY_ADJUSTMENTS Table

Explanation
Contains salary increase adjutment records, created in the Spring 2010 modeling pilot and used in preparatory stages of the annual Salary Increase Program . There is one record per employee/role, for employees in centers participating in the modeling pilot.

Common Uses
To view, during the Salary Increase Program, salary increase adjustments entered in the modeling application.

Primary Key Indexed Data Elements Related Tables
COMP_INCREASE_PAY_ADJUSTMENT_ID
APPROVER_PENN_ID
COMP_PERSON_ROLE_ID
FINAL_APPROVER_PENN_ID
HOME_CENTER
HOME_ORG
JOB_CLASS
PENN_ID
RESPONSIBLE_CENTER
ROLE_CENTER
ROLE_ORG
COMP_JUSTIFICATION_LIST (DWCOMP)
COMP_PERSON (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
JOB_CLASS (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

  • COMP_INCREASE_PAY_ADJUSTMENTS should be used only in the course of the Salary Increase Program, to view pay adjustments planned by schools/centers participating in the Spring 2010 modeling pilot.
  • This table includes only rows for roles of employees in schools/centers participating in the Spring 2010 Salary Increase modeling pilot.
  • You can access a COMP_INCREASE_PAY_ADJUSTMENTS row only if you are authorized to view Salary Increase Program data in the Warehouse, and you are also authorized to access data for the employee's home center or organization.
  • The COMP_INCREASE_PAY_ADJUSTMENTS Table can be found in the DWCOMP schema.
COMP_INCREASE_PAY_ADJUSTMENTS 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