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

CT_ATTENDEE Table

Explanation
The CT_ATTENDEE table associates attendees with expense reports.

Common Uses
Reviewing attendees related to expenses.

ATN_KEY

ATN_KEY
ATN_TYPE_KEY
EMP_KEY
LAST_NAME
RPE_KEY
RPT_KEY

COMP_PERSON (DWCOMP)
CT_ATTENDEE_TYPE (DWGL)
CT_PERSON (DWGL)
CT_REPORT (DWGL)
CT_REPORT_ENTRY (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)

Cautions

• Not all attendees are members of the Penn Community; in those cases, EMP_KEY will be null and there will be no corresponding records in the CT_PERSON table.
• Since manually-entered attendee information is not validated on the expense entry form, individuals may appear in CT_ATTENDEE multiple times.
• The CT_ATTENDEE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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