Penn Computing

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

COMP_PAY_DISTRIBUTION Table

Explanation
Contains Payroll distribution accounts and amounts for PennWorks Additonal Pay requests.

Common Uses
To determine the source(s) from which an additonal payment is to be paid for a specific employee, per the PennWorks system.

Primary Key Indexed Data Elements Related Tables
PAY_DISTRIBUTION_ID
COMP_PAY_PERSON_HOME_CENTER
COMP_PAY_PERSON_HOME_ORG
COMP_PAY_PERSON_ID
COMP_PAY_PERSON_PENN_ID
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)
PROGRAM_CODES (DWADMIN)

Cautions

  • Additional Pay distribution records, as stored in COMP_PAY_DISTRIBUTION, do not relate to role or job distributions established in PennWorks (stored in COMP_DISTRIBUTION) and subsequently processed by Payroll (and then stored in EMPLOYEE_DISTRIBUTION). Rather, COMP_PAY_DISTRIBUTION only houses amounts to be distributed for additional payments. Additional Pay distribution records are distinguished in COMP_PAY_DISTRIBUTION by the Comp_Pay_Person_ID and Distribution_COA_Number.
  • Distribution Account segments for records that have not yet been finalized may appear with 'X' values as placeholders.
  • You can access a COMP_PAY_DISTRIBUTION 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_DISTRIBUTION table can be found in the DWCOMP schema.
COMP_PAY_DISTRIBUTION 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