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

COMP_PAY_ROUTING_HISTORY Table

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

Explanation
Contains the historical information about the routing of PennWorks Addtional Pay requests.

Common Uses
To view the routing history for particular Additional Pay requets.

COMP_PAY_ROUTING_HISTORY_ID

APPROVER_NAME
APPROVER_PENN_ID
COMP_PAY_REQUEST_ID

COMP_PAY_REQUEST (DWCOMP)
COMP_PAY_STAGING (DWCOMP)
COMP_PERSON (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

• This table contains historical routing information about PennWorks Additonal Pay requests, with one or more rows per request. To view the most current information for a request, consult the COMP_PAY_REQUEST table. To view information about the request as it was sent to Payroll for processing, consult the COMP_PAY_STAGING table.

• The COMP_PAY_ROUTING_HISTORY table can be found in the DWCOMP schema.

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