COMP_PAY_DISTRIBUTION 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 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.
Questions about this page? Email us at da-staff@isc.upenn.edu
|
