MAIL_CODE Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

MAIL_CODE Table

Note: This table is no longer updated, following the retirement of the mainframe Personnel/Payroll system and the implementation Workday@Penn in July 2019.

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.")

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