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

COMP_PAY_STAGING Table

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

Explanation
Contains Payroll distribution accounts and amounts for PennWorks Additional Pay requests in the state in which they were fed to Payroll for processing.

Common Uses
To view information about PennWorks Additional Pay requests as it was sent to Payroll for processing.

COMP_PAY_STAGE_ID

COMP_PAY_PERSON_HOME_CENTER
COMP_PAY_PERSON_HOME_ORG
COMP_PAY_PERSON_PENN_ID
COMP_PAY_REQUEST_ID
COMP_PERSON_ID
EARNINGS_TYPE
PAY_DISTRIBUTION_COA_CNAC
PAY_DISTRIBUTION_COA_CREF
PAY_DISTRIBUTION_COA_FUND
PAY_DISTRIBUTION_COA_NUMBER
PAY_DISTRIBUTION_COA_OBJECT
PAY_DISTRIBUTION_COA_ORG
PAY_DISTRIBUTION_COA_PROGRAM
PAY_DISTRIBUTION_COA_RESP_ORG

CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
COMP_PAY_PERSON (DWCOMP)
COMP_PAY_REQUEST (DWCOMP)
COMP_PERSON (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
FUND_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PARYOLL_EARNINGS (DWPAY)
PROGRAM_CODES (DWADMIN)

Cautions

• COMP_PAY_STAGING contains Additional Pay request records in the state in which they were readied for Payroll processing. To view the most current information for a request, consult the COMP_PAY_REQUEST table. To view routing history for the request, consult the COMP_PAY_ROUTING_HISTORY table.

• You can access a COMP_PAY_STAGING row only if you are authorized to access data for the employee's home center or organization, the Pay_Distribution_COA_ORG, or the Pay_Distribution_COA_Resp_ORG.

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

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