CT_COUNTRY Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_COUNTRY Table

Explanation
CT_COUNTRY is a reference table for country values used in Concur, containing codes and their descriptions.

Common Uses
Displaying the country name, rather than code that appears in a related table.

CTRY_CODE

COUNTRY_NAME
CTRY_CODE

COUNTRY_CODES_MASTER (CCMAINT_ADMIN)
CT_ATTENDEE (DWGL)
CT_COUNTRY_CURRENCY_MAP (DWGL)
CT_CTRY_SUBDIVISION (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

CT_COUNTRY Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home