Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_CTRY_CURRENCY_MAP Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_CTRY_CURRENCY_MAP Table

Explanation
CT_CTRY_CURRENCY_MAP contains records relating currency codes to the countries in which they are used.

Common Uses
Displaying the relationship between currencies and countries, as stored in Concur.

Primary Key Indexed Data Elements Related Tables
CRN_KEY
CTRY_CODE
CRN_KEY
CTRY_CODE
COUNTRY_CODES_MASTER (CCMAINT_ADMIN)
CT_COUNTRY (DWGL)
CT_CURRENCY (DWGL)

Cautions

  • The CT_CTRY_CURRENCY_MAP table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_CTRY_CURRENCY_MAP Table - Data Element Index   Tables and Data Elements   Travel & Expense 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