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

CT_CASH_ADVANCE Table

Explanation
The CT_CASH_ADVANCE table contains details related to cash advances.

Common Uses
Reviewing information about cash advances processed within Concur Expense.

CA_KEY

CA_KEY
CRN_KEY
EMP_KEY
HIER_NODE_KEY
PAT_KEY
PERSON_HOME_ORG
PERSON_HOME_SCHOOL_CTR
PERSON_PENN_ID
REQUEST_CRN_KEY
STAT_KEY

COMP_PERSON (DWCOMP)
CT_CASH_ADVANCE_COMMENT (DWGL)
CT_CASH_ADVANCE_ENTRY (DWGL)
CT_PERSON (DWGL)
CT_CURRENCY (DWGL)
CT_PAYMENT_TYPE (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

• Rows in CT_CASH_ADVANCE are visible to users based access to PERSON_HOME_ORG.
• The CT_CASH_ADVANCE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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