Penn Computing

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

COUNTRY_CODE Table

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.

Primary Key Indexed Data Elements Related Tables

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

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