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

PAYROLL_DATA_ELEMENT 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 Payroll Data Element codes, containing codes and their descriptions.

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

ELEMENT_CODE

ELEMENT_CODE

PAR_DOLLAR_GTN_ADJUSTMENTS (DWPAY)
PAR_HOUR_ADJUSTMENTS (DWPAY)
PAYROLL_CHANGE_LOG (DWADMIN)

Cautions

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

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

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