Penn Computing

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

COUNTRY_CODE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
COUNTRY

Indexed - no
Format - char (35)
May be null? yes		 The description that corresponds to the code for the employee's country of citizenship. Because the codes represent IRS tax-rate groupings (rather than geographical areas), there are some cases where one code stands for two countries with a political affiliation.

Examples: Japan (JA), Antigua and Barbuda (AC) 

Values:

Refer to the COUNTRY_CODES table for values.

COUNTRY_CODE

Indexed - yes
Format - char (2)
May be null? no

The 2-character IRS tax-rate grouping indicating the employee's country of citizenship. (Sometimes, two countries with a political affiliation share one Country_Code.

Examples: JA (Japan), AC (Antigua and Barbuda) 

Values:

Refer to the COUNTRY_CODES table for values.

COUNTRY_CODE Table   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