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

CT_REPORT_ENTRY Table

Explanation
The CT_REPORT_ENTRY table contains Concur expense report line entry information.

Common Uses
Reviewing line entry detail for expense reports processed in Concur.

RPE_KEY

AIR_TRAVEL_SERV_CODE
CCT_KEY
COUNTRY
CRN_KEY
ENTRY_COST_OBJECT
ENTRY_COST_OBJ_CNAC
ENTRY_COST_OBJ_CREF
ENTRY_COST_OBJ_FUND
ENTRY_COST_OBJ_ORG
ENTRY_COST_OBJ_PROGRAM
ENTRY_COST_OBJ_RESPORG
EXP_KEY
EXTRACT_CCT_KEY
FOREIGN_OR_DOMESTIC
FROM_LOCATION
IS_PERSONAL
LN_KEY
PARENT_RPE_KEY
PAT_KEY
RPE_KEY
RPT_ENTRY_DESCRIPTION
RPT_KEY
TA_DAY_KEY
TA_RB_KEY
TO_LOCATION
TRANSACTION_DATE
TRANSACTION_TYPE
TYPE_OF_TRAVEL
VENDOR_DESCRIPTION
VENDOR_NAME

CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
CT_ATTENDEE (DWGL)
CT_CASH_ADVANCE_ENTRY (DWGL)
CT_COUNTRY (DWGL)
CT_CREDIT_CARD_TRANSACTION (DWGL)
CT_CURRENCY (DWGL)
CT_EXPENSE_COMMENT (DWGL)
CT_EXPENSE_TYPE (DWGL)
CT_JOURNAL (DWGL)
CT_LOCATION (DWGL)
CT_PAYMENT_TYPE (DWGL)
CT_POLICY (DWGL)
CT_REPORT (DWGL)
CT_TA_DAY (DWGL)
FUND_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

Cautions

• CT_REPORT_ENTRY contains line-level expense report detail. For expense report header information, refer to CT_REPORT. When creating reports joining report-level and report entry-level data, beware summarizing report-level amounts to avoid inflated totals. To view summary report information as it was loaded to BEN Financials, refer to TEM_SAE_DETAIL.
• Note that PAR (Parent) lines are a summary of the itemized CHD (Child) charges, and the transaction amounts for these two types of transactions should not be combined.
• The CT_REPORT_ENTRY table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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