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.
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.
||Indexed Data Elements
- Keep in mind that the codes represent tax rate groupings, which may not map to distinct geographical areas in select cases.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania