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

COMP_PAY_REQUEST Table

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

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.

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