Contains records associating employees with PennWorks Additonal Pay requests. There is one row for each employee and pay request combination.
Retrieving Additonal Pay requests associated with particular employees.
||Indexed Data Elements
- 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.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania