CT_REPORT Table


			<< go back

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

CT_REPORT Table

Explanation
The CT_REPORT table contains Concur expense report header information.

Common Uses
Reviewing information about expense reports processed in Concur.

Primary Key

Indexed Data Elements

Related Tables

RPT_KEY

COUNTRY
CRN_KEY
CTRY_CODE
CTRY_SUB_CODE
EMP_KEY
FIRST_APPROVE_DATE
FIRST_SUBMIT_DATE
ITIN_KEY
LEDGER_KEY
PAID_DATE
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID
POL_KEY
REPORT_NAME
REPORT_PURPOSE
RPT_COST_OBJ_CNAC
RPT_COST_OBJ_CREF
RPT_COST_OBJ_FUND
RPT_COST_OBJ_ORG
RPT_COST_OBJ_PROGRAM
RPT_COST_OBJ_RESPORG
RPT_COST_OBJECT
RPT_EMPLOYEE_AFFILIATION
RPT_KEY
RPT_SCHOOL_CTR
SUBMIT_DATE
TYPE_OF_TRAVEL
USER_DEFINED_DATE

CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
COMP_PERSON (DWCOMP)
CT_ATTENDEE (DWGL)
CT_COUNTRY (DWGL)
CT_COUNTRY_SUBDIVISION (DWGL)
CT_CURRENCY (DWGL)
CT_EXPENSE_COMMENT (DWGL)
CT_JOURNAL (DWGL)
CT_PERSON (DWGL)
CT_POLICY (DWGL)
CT_REPORT_ENTRY (DWGL)
CT_TA_ITINERARY (DWGL)
CT_WORKFLOW_PROCESS_INSTANCE (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
FUND_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

Cautions

CT_REPORT contains expense report header information. For line-level detail, refer to CT_REPORT_ENTRY. To view summary report information as it was loaded to BEN Financials, refer to TEM_SAE_DETAIL.
Rows in CT_REPORT are visible based on access to PERSON_HOME_ORG, RPT_COST_OBJ_ORG, RPT_COST_OBJ_RESPORG.
The CT_REPORT table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_REPORT 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