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

CT_TA_ITINERARY Table

Explanation
The CT_TA_ITINERARY table contains travel allowance itinerary information.

Common Uses
Reviewing travel allowance itinerary records.

ITIN_KEY

EMP_KEY
ITIN_KEY
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID
TAC_KEY

COMP_PERSON (DWCOMP)
CT_REPORT (DWGL)
CT_TA_DAY (DWGL)  
CT_TA_ITINERARY_ROW (DWGL)  
CT_TA_RATE (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWAMIN)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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