EMPLOYEE_TAX Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

EMPLOYEE_TAX Table

Note: This table is no longer updated, following the retirement of the mainframe Personnel/Payroll system and the implementation Workday@Penn in July 2019.

Explanation
Contains information relating to employees' tax status.

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

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