Penn Computing

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

COMP_PAY_PERSON Table

Explanation
Contains records associating employees with PennWorks Additonal Pay requests. There is one row for each employee and pay request combination.

Common Uses
Retrieving Additonal Pay requests associated with particular employees.

Primary Key Indexed Data Elements Related Tables
COMP_PAY_PERSON_ID
COMP_ATTACHMENT_GROUP_ID
COMP_PAY_PERSON_HOME_CENTER
COMP_PAY_PERSON_HOME_ORG
COMP_PAY_PERSON_ID
COMP_PAY_PERSON_PENN_ID
COMP_PERSON_ID
COMP_ATTACHMENT (DWCOMP)
COMP_PAY_REQUEST (DWCOMP)
COMP_PERSON (DWCOMP)
COMP_PERSON_DEPENDENT (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)

ORG_CODES (DWADMIN)

Cautions

  • COMP_PAY_PERSON contains records associating PennWorks Addtional Pay requests with Penn employees. It does not contain employee biographic information; for that data, refer to DWCOMP.COMP_PERSON, which contains the latest available biographic/demographic data for the employees whose records are managed in PennWorks.
  • Penn_ID should be used to uniquely identify employees in COMP_PAY_PERSON, and to join COMP_PAY_PERSON to other tables in the Salary Management collection. COMP_PERSON_ID, while it is the primary key for the COMP_PERSON table, is used for internal PennWorks purposes only, and should never be used to identify an individual.
  • The COMP_PAY_PERSON table can be found in the DWCOMP schema.
COMP_PAY_PERSON 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