Penn Computing

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

EMPLOYEE_BENEFITS Table

Explanation
Contains benefits information relating to both retirement and health/welfare benefits.

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

Primary Key Indexed Data Elements Related Tables
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

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