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

CT_EXPENSE_COMMENT Table

Explanation
The CT_EXPENSE_COMMENT table contains comments related to expense reports.

Common Uses
Reviewing comments associated with expense reports in Concur.

COMMENT_KEY

COMMENT_KEY
CREATED_BY_HOME_ORG
CREATED_BY_HOME_SCHOOL_CTR
CREATED_BY_PENN_ID
CREATED_FOR_HOME_ORG
CREATED_FOR_HOME_SCHOOL_CTR
CREATED_FOR_PENN_ID
RPE_KEY
RPT_KEY
STEP_INSTANCE_KEY

COMP_PERSON (DWCOMP)
CT_PERSON (DWGL)
CT_REPORT (DWGL)
CT_REPORT_ENTRY (DWGL)
CT_WO
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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