Penn Computing

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

CT_ALLOCATION Table

Explanation
The CT_ALLOCATION table contains records of expense report allocations.

Common Uses
Reviewing allocations related to expense reports; reporting on allocations by chart of accounts segment.

Primary Key Indexed Data Elements Related Tables
ALLOC_KEY
ACCOUNT_OBJ_CODE1
ACCOUNT_OBJ_CODE2
ALLOC_KEY
ALLOCATION_COST_OBJ_BC
ALLOCATION_COST_OBJ_CNAC
ALLOCATION_COST_OBJ_CREF
ALLOCATION_COST_OBJ_FUND
ALLOCATION_COST_OBJ_ORG
ALLOCATION_COST_OBJ_PROGRAM
ALLOCATION_COST_OBJ_RESPORG
ALLOCATION_COST_OBJECT
ALLOCATION_SCHOOL_CTR
RPE_KEY
CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
CT_REPORT_ENTRY (DWGL)
FUND_CODES (DWADMIN)
OBJECT_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

Cautions

  • Rows in CT_ALLOCATION are visible to users based access to ALLOCATION_COST_OBJ_ORG or ALLOCATION_COST_OBJ_RESPORG.
  • The CT_ALLOCATION table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_ALLOCATION 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