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

PAYROLL_EARNINGS Table

Note: This table is no longer updated, following the retirement of the mainframe Personnel/Payroll system and the implementation Workday@Penn in July 2019.

Explanation
Reference table for Earnings codes, containing codes and their descriptions.

Common Uses
Displaying the description of the Earnings code, rather than the EARNINGS_TYPE that appears in a related table. ("Don't show the codes in the report. Show the English instead.")

EARNINGS_TYPE

EARNINGS_TYPE

EMPLOYEE_DISTRIBUTION (DWADMIN)
EMPLOYEE_PAYMENT (DWADMIN)
PAR_EARNINGS (DWPAY)

Cautions

• Stores only the current values of earnings type codes, as defined in the Payroll system. This table is updated daily, Monday - Friday evenings.

• Earnings of the 'CTU' and 'CTX' types (representing 'CPUP Taxable Tuition' and 'CPUP Taxable Other') represent tax adjustments, and are not used for payments. Therefore, records with these earnings types will not be found in the EMPLOYEE_PAYMENT table.

• The PAYROLL_EARNINGS table can be found in the DWPAY schema.

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