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.

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