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

COUNTRY_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
Lookup table for codes that identify the employee's country of citizenship. The COUNTRY_CODE table contains the 2-character Country_Code and the maximum 35-character Country. Example: AR (ARGENTINA). There is, roughly speaking, one row per country. Because the codes represent IRS tax-rate groupings, however (rather than geographical areas), there are some cases in which two countries with a political affiliation have been merged into one row.

Common Uses
Displaying the employee's country of citizenship, rather than the code that appears in a related table. ("Don't show the codes in the report. Show the English instead."). Citizenship is secured data.

COUNTRY_CODE

COUNTRY_CODE

EMPLOYEE

Cautions

• Keep in mind that the codes represent tax rate groupings, which may not map to distinct geographical areas in select cases.

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