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

COMP_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 employees/roles as defined in PennWorks.There may be multiple rows per employee in effect at one time.

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

COMP_DISTRIBUTION_ID

COMP_PERSON_ROLE_ID
DISTRIBUTION_COA_CNAC
DISTRIBUTION_COA_CREF
DISTRIBUTION_COA_FUND
DISTRIBUTION_COA_NUMBER
DISTRIBUTION_COA_OBJECT
DISTRIBUTION_COA_ORG
DISTRIBUTION_COA_PROGRAM
DISTRIBUTION_COA_RESP_ORG
DISTRIBUTION_END_FISCAL_YEAR
DISTRIBUTION_END_YEAR
DISTRIBUTION_START_FISCAL_YEAR
DISTRIBUTION_START_YEAR
DISTRIBUTION_STATE
EARNINGS_TYPE
HOME_CENTER
HOME_ORG
PENN_ID
ROLE_CENTER
ROLE_ORG

CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
COMP_DISTRIBUTION_EXT
COMP_PERSON (DWCOMP)
COMP_PERSON_ADDRESS (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
COMP_ROLE_DIST_STATE_LOOKUP (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_DISTRIBUTION (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
FUND_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PAYROLL_EARNINGS (DWPAY)
PROGRAM_CODES (DWADMIN)

Cautions

• An employee may have several distribution records active at the same time. Distribution records are distinguished in COMP_DISTRIBUTION by the Comp_Person_Role_ID, Distribution_COA_Number, Distribution_Start_Date and Distribution_Stop_Date. Distributions from PennWorks are mapped to a maximum of eight distributions for each of the up to four job records for the employee in the mainframe Payroll system, where they are used for Payroll processing. (Once fed to the Payroll system, the resulting distribution records are extracted to the DWADMIN.EMPLOYEE_DISTRIBUTION table in the Data Warehouse.) Note: the EMPLOYEE_DISTRIBUTION table includes distribution history for employees who had Payroll records on or after July 1, 1996. For employees with Payroll records prior to October 2009, distribution data is available in the EMPLOYEE_DISTRIBUTION table only.

• PennWorks allows users to indicate a state for a distribution, as "Final", "Projected", or "Disabled." Records with a "Projected" state can act as placeholders for planning purposes, and will be managed solely within PennWorks. The "Final" state indicates the record is ready to be processed by PennWorks and, when appropriate, updated in Payroll. "Disabled" records will no longer be visible in PennWorks, but are retained in the COMP_DISTRIBUTION table for historical purposes. Users may select to delete records from PennWorks; these rows are retained in in the Data Warehouse for historical purposes with a state of 'X'.

• Refer to the COMP_DISTRIBUTION_EXT table for records of employee distributions from a source other than University of Pennsylvania Payroll system.

• Historical snapshots of distribution information are available in the COMP_DISTRIBUTION_SNAP table, beginning with the NOV-09 period.

• You can access a COMP_DISTRIBUTION row only if you are authorized to access data for the employee's home center or organization, the role center or organization, a current joint organization for the employee, the Distribution_COA_ORG, or the Distribution_COA_Resp_ORG.

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

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