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

CT_LOCATION Table

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

Common Uses
Displaying the location description, rather than code that appears in a related table.

LOC_KEY

LN_KEY
LOC_CODE
LOC_CTRY_CODE
LOC_CTRY_SUB_CODE
LOC_KEY

CT_COUNTRY (DWGL)
CT_CTRY_SUBDIVISION (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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