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

EMPLOYEE_BENEFITS 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 benefits information relating to both retirement and health/welfare benefits.

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

EMPLOYEE_BENEFITS_PK

EXTRACT_DATE
HOME_DEPT_ORG
HOME_SCHOOL_CTR
PENN_ID
SSN

EMPLOYEE (DWADMIN)

Cautions

• Access to EMPLOYEE_BENEFITS 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_BENEFITS table does not keep history about an employee. Historical snapshots of employee information are available in the EMPLOYEE_BENEFITS_SNAP table.

• The EMPLOYEE_BENEFITS table can be found in the DWADMIN schema.

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