Penn Computing

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

PAYROLL_DATA_ELEMENT Table

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

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

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