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

COMP_PAY_PERSON Table

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

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.

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