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

CT_CTRY_SUBDIVISION Table

Explanation
CT_CTRY_SUBDIVISION is a reference table for country subdivision (i.e., states or cities) values used in Concur, containing codes and their descriptions.

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

CTRY_SUB_CODE

CTRY_CODE
CTRY_SUB_CODE

COUNTRY_CODES_MASTER (CCMAINT_ADMIN)
CT_COUNTRY (DWGL)
CT_COUNTRY_CURRENCY_MAP (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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