Penn Computing

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

COMP_PAY_STAGING Table

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.

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

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