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

PAYROLL_ACTION_CODE 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 Action codes, containing codes and their descriptions.

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

ACTION_CODE

ACTION_CODE

EMPLOYEE (DWADMIN)
PAYROLL_CHANGE_LOG (DWADMIN)

Cautions

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

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

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