Penn Computing

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

EMPLOYEE_TAX Table

Explanation
Contains information relating to employees' tax status.

Common Uses
To obtain tax-related information for individual employees.

Primary Key Indexed Data Elements Related Tables
EMPLOYEE_TAX_PK
EXTRACT_DATE
HOME_DEPT_ORG
HOME_SCHOOL_CTR
PENN_ID
SSN
EMPLOYEE (DWADMIN)

Cautions

  • Access to EMPLOYEE_TAX is restricted to select central organizations. Contact Human Resources if you need information from this table. Access to SSN is further restricted to specifically authorized individuals.
  • Keep in mind that this is the latest information about an employee - the EMPLOYEE_TAX table does not keep history about an employee. Historical snapshots (from January 2009 forward) of employee information are available in the EMPLOYEE_TAX_SNAP table.
  • The EMPLOYEE_TAX table can be found in the DWPAY schema.
EMPLOYEE_TAX 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