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

CT_TA_DAY Table

Explanation
The CT_TA_DAY table contains records of travel allowances associated with particular days for particular reports.

Common Uses
Reviewing travel allowances associated with particular days.

TA_DAY_KEY

DISPLAY_LN_KEY
EMP_KEY
ITIN_KEY
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID
TA_DAY_KEY

CT_LOCATION (DWGL)
CT_PERSON (DWGL)      
CT_TA_ITINERARY (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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