Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_JOURNAL Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_JOURNAL Table

Explanation
The CT_JOURNAL table contains references to allocations, cash advances, reports and report entries used to build standard account extract journal entries.

Common Uses
Reviewing allocations, cash advances and expense reports related to journals.

Primary Key Indexed Data Elements Related Tables
JR_KEY
ACCOUNT_CODE
ACCOUNT_CODE_TYPE
ALLOC_KEY
CA_KEY
EXTRACT_CCT_KEY
JR_KEY
PAYEE_PAT_KEY
PAYER_PAT_KEY
RPE_KEY
RPJ_KEY
RPT_KEY
CT_ALLOCATION (DWGL)
CT_CASH_ADVANCE (DWGL)
CT_PAYMENT_TYPE (DWGL)
CT_REPORT (DWGL)
CT_REPORT_ENTRY (DWGL)
TEM_SAE_DETAIL (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania