Penn Computing

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

COMP_PERSON_ADDRESS Table

Explanation
Provides home mailing addresses for employees. Each record has an ADDRESS_TYPE.

Common Uses
Retrieving the current or permanent (if available) addresses for employees. Selecting employees by geographic location.

Primary Key Indexed Data Elements Related Tables
ADDRESS_TYPE
COMP_PERSON_ID
CITY
HOME_CENTER
HOME_ORG
PENN_ID
STATE
COMP_DISTRIBUTION (DWCOMP)
COMP_PERSON (DWCOMP)
COMP_PERSON_LONG_ADDRESS (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
COMP_PERSON_ROLE_JOINT_ORG (DWCOMP)
COMP_PERSON_SALARY (DWCOMP)
COMP_PERSON_SALARY_SUMMARY (DWCOMP)
COMP_STATE_LIST (DWCOMP)
COUNTRY_CODE (DWADMIN)
EMPLOYEE (DWADMIN)
EMPLOYEE_ADDRESS (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

  • COMP_PERSON_ADDRESS contains the latest available address 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 address information appears in both DWCOMP.COMP_PERSON_ADDRESS and DWADMIN.EMPLOYEE_ADDRESS. (PennWorks data is fed to the mainframe Payroll system for Payroll processing. After that processing, the address data is fed from the Payroll system to the EMPLOYEE_ADDRESS table.) Note: the EMPLOYEE_ADDRESS 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_ADDRESS table only.
  • The current address is "current" only in the sense that it is what PennWorks listed as the current address in the most recent record available for that employee. It is not necessarily true that this employee's record even exists in the PennWorks system any more. Use Employment_Status in the COMP_PERSON table to select desired employees.
  • Permanent addresses (ADDRESS_TYPE = 'P') are usually used for employees whose permanent address differs from their current one (e.g., students, foreign residents). Although permanent addresses may also be available for other employees who have updated this information themselves, or asked their Business Administrator to do so, there is no requirement that the field be populated, and so some employees may only have a current address (ADDRESS_TYPE = 'C') available.
  • A similar table, COMP_PERSON_LONG_ADDRESS, stores larger residence and permanent addresses needed for tax compliance and other purposes. COMP_PERSON_LONG_ADDRESS also includes work addresses, and is the only table in which work addresses are stored in the Warehouse.
  • You can access a COMP_PERSON_ADDRESS row only if you are authorized to access data for the employee's home center or organization, or a current joint organization for the employee.
  • For on-campus contact information (such as mail code and work phone), refer to the COMP_PERSON table.
  • The COMP_PERSON_ADDRESS table can be found in the DWCOMP schema.
COMP_PERSON_ADDRESS 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