Penn Computing

University of Pennsylvania
Penn Computing << go backback
PAYROLL_EARNINGS Table   Tables and Data Elements    Salary Management Home   Data Warehouse Home

PAYROLL_EARNINGS Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
EARNINGS_DESCRIPTION

Indexed - no
Format - varchar(25)
May be null? yes		 The 25-character earnings type description. 
Values:
Refer to the DWPAY.PAYROLL_EARNINGS table for values.
Source: #XERN-DESCRIPTION or XERN-DESC (if #XERN-DESCRIPTION is blank)
EARNINGS_TYPE

Indexed - yes
Format - char(3)
May be null? no		 A 3-character code indicating the type of earnings.

Examples: RMO (regular monthly pay); OT2 (overtime at double time)

Values:
Refer to the DWPAY.PAYROLL_EARNINGS table for values.
Source: #XERN-EARNINGS-TYPE

PAYROLL_EARNINGS Table   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