Penn Computing

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

CT_AUTHORIZED_APPROVER Table

Explanation
The CT_AUTHORIZED_APPROVER table associates people and approval levels within Concur Expense.

Common Uses
Reviewing approvers established within Concur Expense.

Primary Key Indexed Data Elements Related Tables
AUTH_APPR_KEY
APPROVER_HOME_ORG
APPROVER_HOME_SCHOOL_CTR
APPROVER_PENN_ID
AUTH_APPR_KEY
EMP_KEY
HIER_NODE_KEY
SUBJECT_CODE
COMP_PERSON (DWCOMP)
CT_PERSON (DWGL)
CT_REPORT (DWGL)
CT_REPORT_ENTRY (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

  • The CT_AUTHORIZED_APPROVER table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_AUTHORIZED_APPROVER 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