Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

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