Penn Computing

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

COMP_PAY_PERSON_DEPENDENT Table

Explanation
Contains records associating employee dependents with PennWorks Additional Pay requests. There is one row for each dependent and pay request combination, although there may be multiple dependents per employee.

Common Uses
Retrieving information about dependents for particular employees, as related to particular Additional Pay requests.

Primary Key Indexed Data Elements Related Tables
COMP_PAY_PERSON_DEPENDENT_ID
COMP_PAY_PERSON_HOME_CENTER
COMP_PAY_PERSON_HOME_ORG
COMP_PAY_PERSON_ID
COMP_PAY_PERSON_PENN_ID
DEPENDENT_FIRST_NAME
DEPENDENT_LAST_NAME
COMP_PAY_REQUEST (DWCOMP)
COMP_PERSON (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)

ORG_CODES (DWADMIN)

Cautions

  • COMP_PAY_PERSON_DEPENDENT contains records associating PennWorks Additional Pay requests with Penn employees and their dependents. It contains very minimal information about those individuals, and should not be considered an authoritative source of data about employees' dependents.
  • Individual dependents may appear multiple times in COMP_PAY_PERSON_DEPENDENT, as associated with different Additional Pay requests over time.
  • The COMP_PAY_PERSON_DEPENDENT table can be found in the DWCOMP schema.
COMP_PAY_PERSON_DEPENDENT 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