Penn Computing

University of Pennsylvania
Penn Computing << go backback
PAYROLL_ACTION_CODE Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

PAYROLL_ACTION_CODE Table

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.")

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

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