Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.")

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

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