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

CT_REPORT_STATUS_AUDIT Table

Explanation
The CT_REPORT_STATUS_AUDIT table contains a log of expense report status and action changes.

Common Uses
Reviewing processing history for particular expense reports.

AUDIT_KEY

AUDIT_DATE
AUDIT_KEY
AUDIT_TYPE
EMP_KEY
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID
PROD_CODE
SUBJECT_PK_VALUE

CT_PERSON (DWGL)      
CT_REPORT (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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