Penn Computing

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

PAYROLL_DATA_ELEMENT Table - Data Element Index

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



Data element Definition
ELEMENT_CODE

Indexed - yes
Format - varchar(4)
May be null? no

The 4-character code identifying a data element in the Payroll system.

Values:
Refer to the DWPAY.PAYROLL_DATA_ELEMENT table for values.
    
Source: #XDET-ELEM-NO
ELEMENT_DESCIPTION

Indexed - no
Format - varchar(15)
May be null? yes

The 15-character data element code description.

Values:
Refer to the DWPAY.PAYROLL_DATA_ELEMENT table for values.

Source: #XDET-ELEM-NAME


PAYROLL_DATA_ELEMENT 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