CT_PERSON Table


			<< go back

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

CT_PERSON Table

Explanation
The CT_PERSON table contains information about individuals (faculty, staff, students) stored in Concur.

Common Uses
Reviewing information stored in Concur about members of the Penn community.

Primary Key

Indexed Data Elements

Related Tables

EMP_KEY

CRN_KEY
CTRY_CODE
CTRY_SUB_CODE
EMP_KEY
FIRST_NAME
FULL_NAME
HOME_ORG
HOME_SCHOOL_CTR
LAST_NAME
PENN_ID
PERSON_AFFILIATION
PERSON_COST_OBJ_CNAC
PERSON_COST_OBJ_CREF
PERSON_COST_OBJ_FUND
PERSON_COST_OBJ_ORG
PERSON_COST_OBJ_PROGRAM
PERSON_COST_OBJ_RESPORG
PERSON_SCHOOL_CTR

CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
COMP_PERSON (DWCOMP)
CT_ATTENDEE (DWGL)
CT_AUTHORIZED_APPROVER (DWGL)
CT_CASH_ADVANCE (DWGL)
CT_COUNTRY (DWGL)
CT_COUNTRY_SUBDIVISION (DWGL)
CT_CURRENCY (DWGL)
CT_DELEGATION (DWGL)
CT_EXPENSE_COMMENT (DWGL)
CT_PERSON_ROLE_MAP (DWGL)
CT_REPORT (DWGL)
CT_TA_DAY (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_PERSON stores only basic information needed for processing in the Concur system. For authoritative or historical data about members of the Penn Community, refer to the data collection most appropriate to your needs.
Rows in CT_PERSON are visible to users based access to PERSON_HOME_ORG, PERSON_COST_OBJ_ORG or PERSON_COST_OBJ_RESPORG.
The CT_PERSON table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_PERSON 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