Reference table for Earnings codes, containing codes and their
Displaying the description of the Earnings code, rather than the EARNINGS_TYPE
in a related table. ("Don't show the codes in the report. Show the English
||Indexed Data Elements
- 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.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania