Penn Computing

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

COMP_PAY_REQUEST Table

Explanation
Contains the information, including most recent status, about PennWorks Addtional Pay requests.

Common Uses
To find out the latest information about particular Additional Pay requets.

Primary Key Indexed Data Elements Related Tables
COMP_PAY_REQUEST_ID
ALLOWANCE_TYPE_ID
AWARD_TYPE_ID
COPIED_FROM_PAY_REQUEST_ID
EARNINGS_TYPE
EXTRA_SERVICES_CODE_ID
REQUESTER_HOME_CENTER
REQUESTER_HOME_ORG
REQUESTER_PENN_ID
REQUEST_STATUS
REQUEST_TYPE_ID
COMP_ATTACHMENT (DWCOMP)
COMP_EXT_DIST_SOURCE_LIST (DWCOMP)
COMP_PAY_ALLOWANCE_TYPE (DWCOMP)
COMP_PAY_AWARD_TYPE (DWCOMP)
COMP_PAY_DISTRIBUTION (DWCOMP)
COMP_PAY_EXTRA_SERVICES_LIST (DWCOMP)
COMP_PAY_STATUS_LOOKUP (DWCOMP)
COMP_PAY_TYPE_LOOKUP (DWCOMP)
COMP_PAY_PERSON (DWCOMP)
COMP_PAY_ROUTING_HISTORY (DWCOMP)
COMP_PAY_STAGING (DWCOMP)
COMP_PERSON (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)
PAYROLL_EARNINGS (DWPAY)

Cautions

  • This table contains the latest information about PennWorks Additonal Pay requests, with one row per request. To view routing history for the request, consult the COMP_PAY_ROUTING_HISTORY table. To view information about the request as it was sent to Payroll for processing, consult the COMP_PAY_STAGING table.
  • It is possible that an Additonal Pay Requester may not be a Penn employee. So long as the individual has a valid PennKey and is in Penn Community s/he can create an Additional Pay request. In such cases, the Requester_Home_Org and Requester_Home_Center columns will be null.
  • The COMP_PAY_REQUEST table can be found in the DWCOMP schema.
COMP_PAY_REQUEST 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