Penn Computing

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

COMP_PERSON Table

Explanation
Contains most current available biographic/demographic data for each employee whose records are managed in PennWorks. The table includes employees who had Payroll records as of November 1, 2009, when PennWorks went live. There is one row per individual.

Common Uses
Retrieving biographic or demographic data on employees (for example, name, birth date, campus mail code, education level, emergency contact information, sex, marital status).

Primary Key Indexed Data Elements Related Tables
COMP_PERSON_ID
CAMPUS_MAIL_CODE
FIRST_NAME
HOME_CENTER
HOME_ORG
LAST_NAME
PAYROLL_NAME
PENN_ID
COMP_AFFILIATION_LIST (DWCOMP)
COMP_CHANGE_LOG (DWCOMP)
COMP_CITIZENSHIP_LOOKUP (DWCOMP)
COMP_COUNTRY_LIST (DWCOMP)
COMP_DISTRIBUTION (DWCOMP)
COMP_GENDER_LIST (DWCOMP)
COMP_LEAVE_REASON_LIST (DWCOMP)
COMP_MARITAL_STATUS_LIST (DWCOMP)
COMP_MILITARY_LIST (DWCOMP)
COMP_PERSON_ADDRESS (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
COMP_PERSON_ROLE_JOINT_ORG (DWCOMP)
COMP_PERSON_SALARY (DWCOMP)
COMP_PERSON_SALARY_SUMMARY (DWCOMP)
COMP_PUB_MAIL_CODE_LIST (DWCOMP)
COMP_SALARY_TYPE_LOOKUP (DWCOMP)
COMP_SEPARATION_REASON_LIST (DWCOMP)
COMP_VISA_LIST (DWCOMP)
COUNTRY_CODE (DWADMIN)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
MAIL_CODE (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

  • COMP_PERSON contains the latest available biographic/demographic data for the employees whose records are managed in PennWorks, which came into use on November 1, 2009. For individuals with Payroll records as of that date, matching biographic/demographic information appears in both DWCOMP.COMP_PERSON and DWADMIN.EMPLOYEE. (PennWorks data is fed to the mainframe Payroll system for Payroll processing. After that processing, the biographic/demographic data is fed from the Payroll system to the EMPLOYEE table.) Note: the EMPLOYEE table includes employees who had Payroll records on or after July 1, 1996. For employees with Payroll records prior to October 2009, biographic/demographic data is available in the EMPLOYEE table only.
  • The presence of a record in the COMP_PERSON Table does not imply the employee is active. Selection of "active employees" should be based on other criteria (for more information, see the documentation for the Employment_Status data element).
  • The following confidential columns in COMP_PERSON are restricted to users with access to the Home_ORG on the record: Affiliation_Code, Barg_Unit_Elig, Benefit_Base, Birth_Date, Country_of_Citizenship, Education_Field_of_Degree, Education_Level, Education_Level_Year, Emergency_Contact, Emergency_Contact_Phone, Emergency_Contact_Relationship, Exempt_Nonexempt, Full_Part_Time, Marital_Status, Military_Status, Original_Hire_Date, Pay_Status, Performance_Incentive_Eligible, Prior_Pay_Date, Publications_Mail_Code, Sex, Visa, Visa_Expiration_Date, Work_Phone1, Work_Phone2. Only individuals with access to the Home_ORG on the record, or a current Joint_ORG for the employee, will retrieve values in these columns, all other users will be able to view the columns, but will retrieve nulls for these elements.
  • Keep in mind that this is the latest information about an employee - the COMP_PERSON Table does not keep history about an employee. Historical snapshots of employee information are available in the COMP_PERSON_SNAP table, beginning with the NOV-09 period.
  • Penn_ID should be used to uniquely identify records in COMP_PERSON, and to join COMP_PERSON to other tables in the Salary Management collection. Comp_Person_ID, while it is the primary key for the COMP_PERSON table, is used for internal PennWorks purposes only, and should never be used to identify an individual.
  • The COMP_PERSON table can be found in the DWCOMP schema.
COMP_PERSON 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