Penn Computing

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

MAIL_CODE Table

Explanation
Contains translated addresses for each intramural mail code. There is one record per mail code.

Common Uses
Displaying the buidling name or address instead of (or in addition to) the campus mail code for an employee. ("Don't show the codes in the report. Show the English too.")

Primary Key Indexed Data Elements Related Tables

MAIL_CODE


MAIL_CODE

BUILDING


EMPLOYEE

EMPLOYEE_GENERAL

Cautions

  • The BUILDING and MAIL_CODE columns of this table are always populated. In most cases, the values designate a University building or street on campus. The CITY, STATE and ZIP_CODE columns are not always populated, and GROUP_CODE is not used at all.
MAIL_CODE 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